habibzain Follow Just husband, father and enthusiastic men about System Administration. Love to write short article about it. Perhaps can help and be useful for others.

Home » MySQL » MySQL Export Show Processlist

MySQL Export Show Processlist

January 29, 2020 13 sec read

Sometime, as sysadmin we need export “Show Processlist;” in mysql prompt mode. This easiest method mysql export show processlist.

As usual, for showing processlist we just type “show processlist;” in mysql. But for analyzed and troubleshooting time query we need to export it to another file.

 mysql -u root -p -e "show processlist" > /srv/name-file-export.txt

Just it, is very simple right? 🙂

habibzain Follow Just husband, father and enthusiastic men about System Administration. Love to write short article about it. Perhaps can help and be useful for others.