开发者

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


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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜