Comments - MariaDB keeps crashing on some wordpress posts
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
For some reason there is no crash trace in your logs, so a possible reason might be that mysqld is killed by the kernel because of Out Of Memory conditions. Check the output of dmesg to see if anything appears. If it is the case try reducing memory usage of mariadb by lowering innodb buffer pool size and key buffer size.
http://i.gyazo.com/f1c3f22539968d2b00b3c66d776c1ff1.png
This means that its Out of memory, right?
That's correct. I advise to do as I suggested earlier i.e. reduce mysqld memory usage. You can refer to the following blog post for pointers: http://www.tocker.ca/2014/03/10/configuring-mysql-to-use-minimal-memory.html
This is my /etc/my.cnf file.
http://i.gyazo.com/7f556e4f75f647679148fa0e857f35b4.png
Still crashed today due to Lack of memory. Is there anything else I need to change?
This is my memory :
http://i.gyazo.com/6bcbcd4f9523363c9a5a0ae9ac2b7bc6.png
Do you run anything else than MariaDB on this server? Can you also put the output of syslog with the out of memory killer?
I have httpd server only.
How can I see that? What's the command?
Search for the syslog file on your distribution - see http://stackoverflow.com/questions/6074362/how-to-check-syslog-in-bash for some common locations. Look in the log for what's happening around the time of the crashes.
Only got this logs:
http://i.gyazo.com/7eef4ff1318e7c430eea79546948eced.png
The message one says :
http://i.gyazo.com/f48949ebc60372e0453b08df7e28513e.png
Those aren't really helpful in solving your problem. If you're running multiple things on your server, and the server runs out of memory, it will choose a process to kill in order to free enough resources. You need to find which process(es) are using the memory, and make sure they don't exceed the available memory. You've already got MariaDB set to fairly minimal settings, so there's not much more you can do there. You need to look at minimizing Apache's memory usage as well, making sure no other processes are using up memory, and/or simply add more RAM. This isn't the best place to ask for help with Apache configuration or with general Linux help, so if you're still struggling, try asking on some forums more dedicated to those issues. Good luck!
http://i.gyazo.com/76a33045f8b7cdbe1fdba2af4d889af3.png
This happened when I used "Mysqld_safe". Maybe config file is wrong?