Questions tagged [mysql]
MySQL is an open-source database owned by Oracle. ServerFault topics include how to run the server. For more MySQL specific questions like backup/restore/recovery/configuration, dba.stackexchange.com is probably a better home.
8,735
questions
0
votes
0
answers
7
views
mysql threads connected more than processlist and established connectios
Recently we have been facing an issue with MySQL. We use Percona MySQL 8.0.21 and set max_connectios to 7000. Sometimes in peak times, we reach 7000 connections and when we run show status like '...
- 33
0
votes
0
answers
26
views
Permissions error in directories used by Docker and application I am developing
I have run a docker container mysql from my own application development on C#, and configured data persistence to this path:
C:\ProgramData\Persistence\data\mysql
When i start everything goes well ...
0
votes
0
answers
7
views
Cannot create an open stack instance
I configure my environment with 2 controller 3 computer nodes in an OpenStack Wallaby Ubuntu 20.04.5 environment, and eventually I can't create an instance with an error when creating an instance on ...
- 1
0
votes
0
answers
22
views
fail2ban iptables REJECT rules not working [duplicate]
I managed to setup fail2ban and monitor my mysql database logs because I am being brute force attacked through my database login. the database is in a docker container and fail2ban is on the host ...
0
votes
1
answer
5k
views
Getting a SQLSTATE[HY000] [2002] Connection refused in PHP Apache Docker container using mariadb, if connected via Dockerfile's CMD (PHP CLI works)
I'm trying to run a Docker container based on:
PHP 8.1
Apache 2.4
MariaDB (latest official docker image)
It all starts up without any issue; but I'm unable to connect with the Docker Container's DB ...
CommunityBot
- 1
0
votes
0
answers
14
views
Entuity (monitoring SW) databse backup
If anyone is using quite obscure monitoring system named Entuity, I'm trying to find a good way of extending its database.
Currently the system is using MySQL database. For some reason its setup to ...
- 93
0
votes
0
answers
15
views
Enabling FIPS mode in MySQL Server 8.036+ on Windows
I'd like to enable the FIPS mode of my MySQL 8.0.36 community server instance running on Windows. I know the ssl_fips_mode option has been deprecated as of MySQL 8.0.34 but it should still work in ...
- 1
4
votes
1
answer
7k
views
MariaDB using much more memory than it should
We are using MariaDB 10.3.32 on a Ubuntu 20.04.4 machine with 6 GB of memory, about 20 applications running on it. Databases are all InnoDB.
Even with mostly default settings (see on the bottom), ...
CommunityBot
- 1
0
votes
2
answers
49
views
Wordpress and MySQL on same EC2 instance, different subnets. One public one Private
My goal is to have a single EC2 instance containing both WordPress and its MySQL database on same VPC and have the WordPress available on the public subnet and MySQL on the private subnet. The purpose ...
- 36.8k
1
vote
1
answer
38
views
Mysql Stuck at "Server shutdown in progress" state
My MySQL was not responsive and I tried restarting the MySql server. Now for more than 2 hrs, it's stuck at the "Server shutdown in progress" stage. I need to bring the service back as soon ...
- 22.4k
1
vote
1
answer
1k
views
mysqld[1108] [Warning] Aborted connection 7466 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1'
I am running Ubuntu Server 20.04. It is a LEMP server running Mariadb. When I run the command sudo service mariadb status I get the following warnings:
Jul 28 00:18:59 mail.example.com mysqld[1108]: ...
- 121
-1
votes
0
answers
27
views
Monitoring MySQL on alma linux server 2 AWS instance
I've been facing some issues with my website lately, particularly with the MySQL database, and I'm looking for some advice on how to effectively monitor and troubleshoot it. My website, hosted on an ...
- 7
2
votes
1
answer
5k
views
Backing up a single database with mariabackup?
I've been working on redoing our database backup routines, and have looked into mariabackup as mysqldump doesn't cut it anymore given the size of our schemas. We have multiple schemas that need to be ...
CommunityBot
- 1
1
vote
1
answer
20k
views
MySQL fails to start [InnoDB Repair]
After inspecting the log files I see that some of the databases have errors.
2017-05-16 08:52:48 7fc0cb8abb00 InnoDB: Assertion failure in thread 140466025315072 in file ha_innodb.cc line 21990
...
- 103
0
votes
1
answer
5k
views
Can't connect to mysql docker when using phpmyadmin docker
I'm just getting started in docker and maybe I'm starting of a little big but I found an article that explained out to get a coldfusion install (run by commandbox) up with mysql. This docker compose ...
CommunityBot
- 1
1
vote
0
answers
72
views
Upgrading mysql - can not start server 8.0.35 => 8.0.36
After upgrading mysql the server can not start?
Upgrade
apt update && apt upgrade
8.0.35 => 8.0.36
OS: Debian bookworm
error
Tablespace 123588, name 'sys/sys_config', file './sys/...
- 2,085
0
votes
1
answer
2k
views
How do you upgrade mysql 4 to 5?
Ok so im fairly new to this and i know some of you will point my to mysql page but im having a hard time finding specific and explicit directions on saying "To upgrade..do this..do that..done" and ...
0
votes
2
answers
762
views
Ansible - community.mysql python module errors
I am trying to use Ansibles community msql modules to setup an external database. However, I get the following error message when I try to create a database:
failed: [target] (item=db_name) => {&...
- 21
0
votes
1
answer
4k
views
How to fix MySQL 8 replication error 1062 after system reboot?
after a system reboot my replication stopped suddenly. So I'm trying to bring the slave back to the most current state.
To do this I create a dump from the master's database and import it on the slave,...
CommunityBot
- 1
0
votes
0
answers
33
views
What causes SSD write timeout over 120 seconds?
system:CentOS Linux release 7.6.1810 (Core)
kernel:Linux l-db11.tj.cn5 3.10.0-957.10.1.el7.x86_64 #1 SMP Mon Mar 18 15:06:45 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
SSD:Dera
cpu: 24 core
memory: 128G
...
0
votes
3
answers
6k
views
MySQL 200% CPU Usage
in my server MySQL taking more than 200% CPU usage. I'm running java war file in tomcat server that uses hibernate JPA to perform MySQL operation I did slowSQLQuerylogs also but there is nothing that ...
CommunityBot
- 1
0
votes
1
answer
33
views
Loading data with new lines into MySQL fails [closed]
I'm loading data into a MySQL database. It is a shared calendar that is used with the baikal calendar.
I dumped the DB, and vim checked it and I can see recent events.
When I load the data into MySQL ...
- 36.8k
0
votes
1
answer
185
views
How can I disable SSL (TLS) in MySQL 8.0.36+?
If I use tls-version='' in the config file, I'm getting the following warnings in the log:
[Warning] [MY-013595] [Server] Failed to initialize TLS for channel: mysql_main. See below for the ...
- 292
0
votes
1
answer
4k
views
APT/DPKG is broken - Unable to remove mysql-server-core-5.5
I want to completely remove any packages related to mysql on my server.
But I seems unable to achieve that task. APT seems unable to understand that mysql-server is not installed on the server. Is it ...
CommunityBot
- 1
-1
votes
0
answers
8
views
Table of 4 columns "definition is too large" [migrated]
I'm trying to optimize a large(4M rows) and busy table of mine. It's currently
CREATE TABLE `person_search` (
`token` CHAR(63), -- each word of the person's name
`person_id` BIGINT(20) ...
- 29
12
votes
3
answers
30k
views
Restart mysql replication after sql_error
I have two mysql servers, one master and one slave.
Someone went on to the slave and created a table, then subsequently went on to the master and created the same table. Of course this DDL statement ...
- 101
0
votes
2
answers
3k
views
MySQL 8.0.20 via SSH
DBeaver 7.1.0 on Windows 10 trying to connect to MySQL 8.0.20 on Ubuntu 20.04 using SSH.
I also tried other Windows MySQL GUI clients, with the identical results, which leads me to believe the problem ...
- 101
1
vote
1
answer
5k
views
MySql 8 crashing on loop without specific errors and with enough memory
I'm running Ubuntu 20.04.03 with Mysql 8.0.27.
I have reinstalled LAMP from scratch several times and at the moment I only have 3 WordPress sites but I have tested only 1 and only 2 sites as well. ...
CommunityBot
- 1
8
votes
4
answers
17k
views
How to do mysql_secure_installation via ansible playbook?
I managed to install Apache Mysql/Mariadb and PHP using playbook. How can I do mysql_secure_installation using ansible?
I am a beginner in Ansible. I want to set a new password to MySQL server and ...
0
votes
3
answers
174
views
Upgrade mysql 5.6 to 8 not working on AWS Linux based EC2
I am working with EC2 for MySQL DB. The OS of EC2 is AWS Linux-based Ubuntu. The current version of MySQL is 5.6.50. I am going to upgrade it to 8.0. I tried to upgrade it with this command: sudo yum ...
- 51
1
vote
1
answer
106
views
Low performance with mariabd and zabbix
I am having performance problems, with a mariadb database that I use for a Zabbix server, the MySQLTuner 2.5.3 error analyzer finds the following: could you advise me what values to set and in what ...
- 94
8
votes
2
answers
40k
views
DRBD Not syncing between my nodes
Some version info:
Operating system is Ubuntu 11.10, on EC2, kernel is 3.0.0-16-virtual and the application info is:
Version: 8.3.11 (api:88)
GIT-hash: 0de839cee13a4160eed6037c4bddd066645e23c5 build ...
- 14.1k
-1
votes
1
answer
93
views
Mysql Error 1045 Access Denied: Using Password: FALSE
I'm using MySQL v8.0.35 with django and python. A website is used to access the database with both the website and database hosted on AWS.
When the website tries to access the database in any way, it ...
- 1
3
votes
1
answer
11k
views
Recover mysql database innodb 'table doesn't exist'
Our server crashed last week and we lost a lot of information. We were able to recover .frm files for the tables, ib_logfile0, ib_logfile1 and ibdata1 but no .ibd.
I've tried the innodb-force-...
CommunityBot
- 1
66
votes
12
answers
226k
views
MySQL keeps crashing: InnoDB: Unable to lock ./ibdata1, error: 11
I have a simple webserver (Debian 6.0 x86, DirectAdmin with 1 GB of memory and still 10 GB free space, mySQl version 5.5.9), however the mySQL server keeps crashing and I need to kill all mySQL ...
- 103
3
votes
3
answers
13k
views
Percona MySQL unable to start - ERROR! The server quit without updating PID file
BACKGROUND:
I installed Percona Server on a fresh Centos 6.4 minimal. Prior to this, I have never installed MySQL (though I'm not sure if Centos 6.4 minimal came with MySQL?)
Anyway, here are the ...
- 1
1
vote
0
answers
32
views
Python Flask application + MySQL DB -> needing advice for the infra in AWS when latency is at stake
I have a Python Flask application and a MySQL DB with which the app connects to. The app provides RESTful APIs.
There are around 10 pairs of (Flask and MySQL DB)s. Each pair has a unique url and ...
- 111
0
votes
1
answer
6k
views
Zabbix Performance (history syncer 100%)
Since November 2018 we have performance problems with Zabbix 3.4.10.
Since this time, we made tuning for tcp connections, tuning in the OS (CentOS 6.9), tuning in the MariaDB conf, tuning in the ...
CommunityBot
- 1
1
vote
1
answer
10k
views
MySQL [ERROR] Can't start server: can't create PID file: No such fie or directory
I'm having trouble starting mysql and mysqld.
Output of sudo service mysql start command is mysql : Unrecognized service
Same way output of sudo service mysqld start is nothing
When I tried sudo ...
CommunityBot
- 1
0
votes
1
answer
71
views
Why does MySQL server not respect bind_address?
Background
I'm setting up a MySQL server. Its configuration file (my.cnf) does not have the bind_address option. As I understand from its documentation, its value defaults to *, which should make the ...
- 10.3k
15
votes
5
answers
105k
views
MySQL process goes over 100% of CPU usage
I'm experiencing some problems with my LAMP server. Recently everything became very slow, even though visitor count on my websites didn't change to much. When I run top command, it says that MySQL ...
CommunityBot
- 1
1
vote
0
answers
41
views
Using Clone for addInstance on MySQL Innodb Cluster uses 100% Memory
When trying to add a new node to a MySQL Innodb cluster using Cluster.addInstance() and selecting the Clone option, within 2 or 3 minutes the donor nodes memory usages hits 100% on a server with 36Gb ...
- 11
0
votes
1
answer
289
views
MySQL errors after reinstalling
At first, I wanted to reinstall MySQL to repair
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) problem with command apt-get purge mysql-server,...
0
votes
1
answer
6k
views
monitoring/troubleshooting aws rds high cpu usage
I have an RDS instance running and it uses an average of 20-30% cpu utilization. Last night it spiked up to 80% for a few minutes and I am trying to figure out why. Error logs show nothing, and I have ...
CommunityBot
- 1
31
votes
6
answers
330k
views
MySQL (MariaDB) Not Starting [closed]
I am running Arch Linux 4.8.4-1 on a 64bit installation. I installed MariaDB via pacman. When I try to start it with systemctl start mysqld, it gives me
Job for mariadb.service failed because the ...
- 3
0
votes
3
answers
6k
views
Error during installation MySQL 8.0 on Debian 10
I am trying to install MySQL on Debian 10, I'm doing everything according to instuction but I get error shown below. Can somebody help me solve this probem ?
matt@debian:~$ sudo apt install mysql-...
- 11
2
votes
3
answers
404
views
MariaDB using more memory than expected
We're running MariaDB server 10.6.16 from the RPM repository https://mirror.mariadb.org/yum/10.6/rhel9-amd64/ on a AlmaLinux 9.3 system with 48 GiB memory (no swap space) and 32 CPU cores. We're ...
- 545
12
votes
3
answers
47k
views
How to copy user privileges with MySQL?
I have a MySQL installation with many databases and users that I need to migrate to a new MySQL installation. I can use phpMyAdmin to export then import the databases/tables, but I don't know of ...
- 16.7k
0
votes
0
answers
44
views
Mysql client using reverse DNS instead of IPv4 address when connecting to remote db [duplicate]
I have a server on Hetzner. When using the MySQL client to connect to a remote db from cli of that server, it returns the error:
Access denied for user 'user'@'static.x.x.x.x.clients.your-server.de' (...
- 1
0
votes
0
answers
65
views
MySQL `SELECT` query does not return the newest data
There are 3 servers: nginx server, fastapi server and mysql server.
nginx server: web page on /admin/
fastapi server: api page on /api/select/
mysql server: stores the data (mysql version 8.3.0)
/...
