Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 2

Displaying posts with tag: GLOBAL_STATUS (reset)

Update: Find Query Per certain Seconds
+2 Vote Up -0Vote Down
In my old post there is a bug when run in MySQL 5.1.30 and old, because the status variable Queries was added in MySQL 5.1.31. So i change to choose between Queries and Questions status variables, and I think the Queries represent more accurate result. http://forge.mysql.com/tools/tool.php?id=217 By the way: # Queries The number of statements executed by the server. This variable includes
Find Query Per certain Seconds
+0 Vote Up -0Vote Down
Do you need to find qps for peak hours not avg qps through mysql life. The MySQL 5.1 offers new GLOBAL_STATUS information schema tables. These can be used to report certain performance metrics, such as the number of queries processed per certain seconds, NOT overall avg queries per second, Its good to know how much qps in peak hours. http://forge.mysql.com/tools/tool.php?id=217
Showing entries 1 to 2

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.