The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
38 views

How do you record & replay mySQL queries for performance analysis?

We would like to record a real workload (i.e. the queries run against the database) so that we can replay the same (web application) workload against a clone of the database with different mySQL ...
0
votes
1answer
73 views

How can I measure the number of IOPs for a certain query

I need to estimate the max IOPs for a certain MySQL DB (one that does not exist yet). The OS is Linux and the DB is MySQL 5.1.x (though I don't think the DB brand is important for the asked topic) ...
0
votes
0answers
26 views

How to handle too many instances of multiple tables?

If there is a table accessed by multiple DB threads ( for example 100) at a time then how many instances of that table will be opened? If I run show open tables and see that in_use column value of a ...