Send 'MySQL Processes List' with PT_LOAD
Posted: 01 Aug 2018, 16:51
Hi CSF/Way to the Web Limited ,
The report send with Apache Status, PS -aux, netstats sended during overload it's really useful for diagnostic.
Sometime we view something like this:
I would be great to have the list of MySQL query during overload, possible ?
best regards,
Quentin
The report send with Apache Status, PS -aux, netstats sended during overload it's really useful for diagnostic.
Sometime we view something like this:
Code: Select all
mysql 31172 8.9 8.7 5326744 2859216 ? Ssl Jul18 1774:17 /usr/sbin/mysqld
Code: Select all
if [-f /root/.my.cnf ]; then
mysql -e "SHOW FULL PROCESSLIST"
fi
Quentin