Comments - MariaDB keeps crashing on some wordpress posts

9 years, 6 months ago Guillaume Lefranc

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.

 
9 years, 6 months ago Guillaume Lefranc

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

 
9 years, 5 months ago Nuno Carapito

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

 
9 years, 5 months ago Guillaume Lefranc

Do you run anything else than MariaDB on this server? Can you also put the output of syslog with the out of memory killer?

 
9 years, 5 months ago Nuno Carapito

I have httpd server only.

How can I see that? What's the command?

 
9 years, 5 months ago Ian Gilfillan

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.

 
9 years, 3 months ago Ian Gilfillan

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!

 
9 years, 5 months ago Nuno Carapito

http://i.gyazo.com/76a33045f8b7cdbe1fdba2af4d889af3.png

This happened when I used "Mysqld_safe". Maybe config file is wrong?

 
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.