tuning

How to view MySql running resources

If your server’s mysql always in high resources or down, I suggest you use this command to trace out which database that eat up your MySql resource /usr/bin/mysqladmin proc stat /usr/bin/watch -n 5 ‘mysqladmin proc stat’ Every 5.0s: mysqladmin proc stat Sat Aug 28 02:05:06 2010 +——+———-+———–+—-+———+——+——-+——————+ |  Id  |   User   | Host …

How to view MySql running resources Read More »