MySql Query Checker Tool

[phpfreek]

hi,

I want to test my web site for the query load checking. Basically mine is a dynamic site where there is lots of traffic.

I want to check my query with multiple requests at same time to see how it is affecting my server and how mysqld service is behaving?

I have rectified all the things for my query however still some time my mysql service reaches 99% load under high traffic which leads to server crash.

So if I can check my query with heavy traffic, then only I ll be able to find actual problem.

Even if u have to buy a software, that is fine if the objective is achieved.

Please help me out for the same.

Mark.

[allaboutgeo]

Did you use EXPLAIN to know about your query (dev.mysql.com/doc/refman/5.0/en/explain.html)? Is your database well indexed?