21 questions linked to/from MySQL InnoDB crash post-mortem
MySQL v5.7 shutting down automatically [duplicate]
Every 5~ days MySQL just shuts down. I turned on error and general logging and I haven't found anything that would suggest why it's happening. The MySQL server was installed from a generic binary and ...
MySQL memory usage slowly increasing then crash - what's causing this? [duplicate]
So I have a Server that's constantly receiving 30k clicks/day. However, in the meantime does certain insert/update/select cronjobs as well. My server has 4CPUs, 8GM RAM. Using MySQL 5.7.18 + PHP. I ...
mysql55 spontaneous malfunction [duplicate]
MySQL runs fine for weeks or days, and then suddenly and without any user action, all attempts to connect begin failing. This is /var/log/mysqld.log: 160916 14:42:01 [Note] /usr/libexec/mysql55/...
Error: MariaDB server is down randomly [duplicate]
Hope someone can provide some ideas... I have 4 Wordpress websites running on the server. 2 are live sites and 2 are staging sites. Since last week I updated one of Wordpress site to the latest ...
Mysql on Ubuntu crashing periodically [duplicate]
I have a problem with Mysql on my ubuntu server. it is restarting periodically about 4-5 times a day . Here is the logs that I found in /var/log/mysql/error.log: 2021-02-23T08:35:08.249856Z 18 [Note] ...
54M InnoDB keeps shutting down unexpectedly [duplicate]
I have a mariadb server running several databases with very small load. From time to time, when I have 20+ users browsing one of the wordpress websites i have, the daemon just shuts down with the ...
MySQL stops unexpectedly on CentOS 6.5 with WHM/Cpanel after migrating server with transfer tool [duplicate]
I recently moved my entire websites from a dedicated CentOS5 server to a CentOS 6.5 on Amazon EC2 with the same cPanel/WHM version. WHM 11.44.1 (build 19) However after angry calls from clients I ...
MYSQL Server is getting restarted multiple times every 2-3 days [duplicate]
Mysql Server is getting restarted saying below errors. It will be grateful if someone can help me to solve this. 2017-10-04 17:07:43 3402 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 1048548 bytes)...
MARIADB-10.3.14 VM OOM KILLED AND TUNING [duplicate]
DEDICATED VM FOR MARIADB - CENTOS 7.7 \\ 16VCPU/250G - JBOD DISKS/NO SSD. OS PARTITION AND DATABASE ARE ON DIFFERENT FILESYSTEM. Span of every two weeks, Kernel OOM happens. Reducing ...
Mysql craches ! InnoDB [duplicate]
The full mysql error log, the VPS craches almost every day! I need to add more info but I can't so this is the only info I have : 131117 20:08:47 [Note] Plugin 'FEDERATED' is disabled. 131117 20:08:...
MySQL oomkiller crashes after backup [duplicate]
I am using percona and the backups run successfully. However after the backup is done and sometimes during the backup MySQL is crashing and I am not certain where to start. Running show engine ...
intermittent MySQL crashes with error "Fatal error: cannot allocate memory for the buffer pool"
Added on edit, 2013-05-29: Because this is a long question and discussion, here's a short summary of the question and the solution. I had problems running MySQL and Apache on a small Linux server (1 ...
MySQL crashes randomly with "Database was not shut down normally" message in log
I am having an issue where, for no apparent reason, my MySQL server crashes and has to restart. Essentially, the error log has entries like this: 131128 12:16:35 mysqld_safe Number of processes ...
MySQL crash/restart during mysqldump
General: Standalone MySQL-5.5.43 in OpenVZ on ProxMox-3.4-6/102d4547 (Debian, 2.6.32-39-pve). Container uses 18Gb of RAM and 100Gb of disk. This container runs this service more than a year. There's ...
mysql tried to restart itself 3 or more times, but it failed finally
it happended the second time, could be the same reason cause it. mysql tried to restart itself 3 or more times, but it failed finally. here is mysql log 130706 09:43:27 mysqld_safe Number of ...