What is considered a high slow query time?

12-21-2009, 03:06 PM

Hello All,

I just wrote my own MySQL slow query log parser in bash for OS X Server. However, I don't really know what is considered a high slow query time. I have roughly 1900 slow queries over the past 2 months that have a query_time range from 20 to 700.

Comment

All of these queries are mostly loading 1 query per web page and some are taking any where from 20 to 700 seconds. There is obviously a problem here, I just need to do a little more research. Since these are pretty simple searches I would suppose that anything over 5 seconds would be considered a high slow query time for my application.