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.
Did you use EXPLAIN to know about your query (dev.mysql.com/doc/refman/5.0/en/explain.html)? Is your database well indexed?