Skip navigation links

Browse

Ask the Librarian

Note the above only searches this section, for site searches use the overall search function. Help: Searching, Tag Searching

The MySQL Librarian collects the best of the web when it comes to MySQL! If you have something to add to the Librarian, please do so. Help us keep it current and relevant to the MySQL Community!

Browser Tools

  • Bookmarklet: Add to Librarian
    Drag link above to your browser (Firefox/Safari) toolbar to add URLs to the MySQL Librarian from anywhere.

Profile

Top Voted (Last Month)

  1. Does MySQL support Julian Dates? Vote!
Showing entries 1 to 2

Tags Filter: GLOBAL_STATUS (reset)

Articles
Add to Favourites +1 Vote Up -1Vote Down
posted by Mohammad Lahlouh on Thu 01 Oct 2009 08:19 UTC
Tags:
(edit) database, MySQL Forge, GLOBAL_STATUS, mysql, performance
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.

Report link

Articles
Add to Favourites +3 Vote Up -0Vote Down
posted by Mohammad Lahlouh on Tue 04 Aug 2009 14:11 UTC
Tags:
(edit) performance, monitoring, GLOBAL_STATUS, queries per second, qps, administration
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.

Report link

Showing entries 1 to 2