Linked Questions

1
vote
2answers
114 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/...
0
votes
1answer
718 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 ...
3
votes
2answers
422 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 ...
0
votes
0answers
417 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 ...
0
votes
0answers
92 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 ...
0
votes
0answers
26 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:...
0
votes
0answers
23 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)...
40
votes
1answer
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 ...
5
votes
2answers
24k 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 ...
-1
votes
1answer
3k 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 ...
1
vote
2answers
2k 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 ...
1
vote
2answers
2k views

mysqld is terminated because the system is low on memory; what to do?

I did recently a site migration; during that I had to erase all plugins and the reinstalling only the minimum as the site was causing the server to crash (A Vps with 1gb of ram), the most problematic ...
-1
votes
2answers
1k views

Mariadb minimum CPU requirements (Edit: Still crashing, new question with log linked)

EDIT3: Read-write splitting seems the answer as pointed by out the user dbdemon in the linked question. Internal MariaDB error code: 1927 ('Connection was killed') EDIT2: https://drupal....
2
votes
2answers
835 views

MySQL Optimization suggestions for E3-1246 with 16GB RAM

My server load is a bit high when many users are on and i'f like to know if i can get better results by tweaking mysql settings, this is a dedicated server and it seems that problems start when 500 ...
0
votes
1answer
361 views

How database buffer pool work?

For example we have 2 scenarios: Scenario 1:- We have very small buffer pool size of 100MB. My query data is 500MB. Does the system keep 500MB query data in RAM such that a new ...

15 30 50 per page