Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how to reset all mysql stats?

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).

like image 417
Sherif Buzz Avatar asked Jan 24 '11 09:01

Sherif Buzz


1 Answers

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.

like image 111
Jan Avatar answered Sep 19 '22 01:09

Jan