oom emails must include mysql processlist
There are cases where mysql will use a very large amount of ram memory, causing the server to enter an out of memory state. This is usually because of a user. And while this could be mitigated via other means, it has other drawbacks.
When an OOM event occurs, cpanel will send alerts via chkservd which have some information, such as the top processes based on memory usage but it does not also include a show processlist from mysql in order for the admin to be able to debug this faster and understand which user was causing this spike in memory usage.
I suggest that you alter this checkservd email template and add the output of :
mysql -te "show full processlist"
I believe this should be very easy for cpanel to implement, and will probably help a lot of people debug such situations faster.
Replies have been locked on this page!