How to measure "queries per second"?

mysql query-optimization
Silver Light picture Silver Light · Jan 19, 2011 · Viewed 51.6k times · Source

In literature SQL query efficiency is often measured in "queries pre second" (QPS). How those measures are made, considering that I have a database with production data at my hands? Is there a MySQL tool that can to this?

Answer

shantanuo picture shantanuo · Jan 20, 2011 
 # mysqladmin status

Uptime: 587  Threads: 121  Questions: 3456  Slow queries: 0  Opens: 152  Flush tables: 1  Open tables: 64  Queries per second avg: 5.888

Related questions

mysql select from n last rows

I have a table with index (autoincrement) and integer value. The table is millions of rows long. How can I search if a certain number appear in the last n rows of the table most efficiently?

Read More
JOIN queries vs multiple queries

Are JOIN queries faster than several queries? (You run your main query, and then you run many other SELECTs based on the results from your main query) I'm asking because JOINing them would complicate A LOT the design of my …

Read More
How to do the Recursive SELECT query in MySQL?

I got a following table: col1 | col2 | col3 -----+------+------- 1 | a | 5 5 | d | 3 3 | k | 7 6 | o | 2 2 | 0 | 8 If a user searches for "1", the program will look at the col1 that has "1" then it will get a value in col3 "5", then the program …

Read More