开发者

how to reset all mysql stats?

开发者 https://www.devze.com 2023-02-06 21:56 出处:网络
I can\'t seem to find a 开发者_开发技巧way to reset all the mysql stats (that show in the \'Stats\' page in phpmyadmin)

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


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.


do a restart of database will reset all stats

PS : stat meant for cumulative results

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号