Linked Questions
21 questions linked to/from MySQL InnoDB crash post-mortem
6
votes
2
answers
8k
views
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 ...
- 163
1
vote
1
answer
3k
views
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 ...
- 167
1
vote
2
answers
185
views
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/...
- 136
0
votes
1
answer
568
views
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 ...
- 1
0
votes
1
answer
575
views
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] ...
0
votes
0
answers
519
views
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 ...
- 121
0
votes
0
answers
274
views
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 ...
- 243
0
votes
0
answers
36
views
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)...
Shivanand
0
votes
0
answers
34
views
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 ...
- 1
0
votes
0
answers
29
views
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:...
Arthur Chaykovski
0
votes
0
answers
23
views
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 ...
- 133
40
votes
1
answer
56k
views
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 ...
- 503
5
votes
2
answers
30k
views
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 ...
- 201
2
votes
2
answers
5k
views
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 ...
- 113
-1
votes
1
answer
4k
views
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 ...
- 101