Showing entries 1 to 2
Displaying posts with tag: GLOBAL_STATUS (reset)
Oct
01
2009
Update: Find Query Per certain Seconds
Posted by Mohammad Lahlouh on Thu 01 Oct 2009 08:17 UTC
Tags:

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

Jul
30
2009
Find Query Per certain Seconds
Posted by Mohammad Lahlouh on Thu 30 Jul 2009 14:32 UTC
Tags:

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