Page 1 of 1

Add SHOW FULL PROCESSLIST to LFD Alert

Posted: 19 Dec 2011, 01:18
by fkatzenb
For the 'High 5 minute load average alert' email notification, can you add the SHOW FULL PROCESSLIST from MySQL?

Thanks!
Frank

Re: Add SHOW FULL PROCESSLIST to LFD Alert

Posted: 27 Dec 2011, 09:44
by chirpy
You can add that yourself using PT_USER_ACTION.

Re: Add SHOW FULL PROCESSLIST to LFD Alert

Posted: 16 Jan 2012, 18:22
by SoftDux
How exactly does one do it, chirpy?

Re: Add SHOW FULL PROCESSLIST to LFD Alert

Posted: 26 Jan 2012, 10:22
by chirpy
You need to create a script that issues the command that you want and then add the path to that script into that option as explained in csf.conf.