how to reset all mysql stats?

mysql phpmyadmin mysql-management
Sherif Buzz picture Sherif Buzz · Jan 24, 2011 · Viewed 11.7k times · Source

I can't seem to find a way to reset all the mysql stats (that show in the 'Stats' page in phpmyadmin)

I can reset the Server Traffic section but everything else doesn't get reset (InnoDB stats, handler stats, etc).

Answer

Jan picture Jan · Jan 24, 2011

This is a very old feature request, that is still not implemented: http://bugs.mysql.com/bug.php?id=22875

You can use the "FLUSH STATUS;" command as described in http://dev.mysql.com/doc/refman/5.0/en/flush.html but it will only reset session stats, not the global stats.

Related questions

How to drop all table in MySQL?

I don't want to drop database, because I'm not hosting the website on my own machine, drop the database will require create it again,and many settings. Is there a command in MySQL that can be used to delete all …

Read More
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I installed LAMP on Ubuntu 12.04 LTS (Precise Pangolin) and then set root password on phpMyAdmin. I forgot the password and now I am unable to login. When I try to change password through terminal I get: ERROR 2002 (HY000): Can't connect …

Read More
Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More