100% RAM and Swapping
Having recently converted our cPanel servers from MySQL to MariaDB we're having issues with MariaDB using 100% of a servers RAM and swap when a customer optimises a table.
This doesn't happen under normal circumstances and only when an optimize is run. Any ideas what's cause this?
The servers have 16GB RAM and use the following my.cnf: http://paste2.org/P3cZzBHN
Using MariaDB 5.5.30
Any help would be appreciated
Answer Answered by Brian Evans in this comment.
There was a bug with 5.5.30 specifically that could take up all resources and in some cases invoke OOM-killer on the server process.
Upgrade to 5.5.31 and see if it fixes your issue