Archive for the ‘dba shortcuts’ Category

How to SHOW PROCESSLIST Every .5 Seconds

Январь 9th, 2010
Yes, it has been a while since I last posted, so we'll see how this year goes...Just the other evening I came across something that I should have done much sooner. Run SHOW PROCESSLIST every second without hitting "ENTER" repetitively.The Setup1) Create a temporary user with a non-sensitive password on localhost with SUPER privs. Yes, this crazy, but I did say *temporary*, right? mysql> GRANT
PlanetMySQL Voting: Vote UP / Vote DOWN
 

Posted in dba shortcuts, mysql, SHOW PROCESSLIST

Комментарии отключены