Re: SELECT Intensive mysql running slow. Avg 2 second response time

[Muni Bajpai]

Toasty,

Thanks. Well actually let me rephrase the query itself does not take more than 2 seconds but there are locks on the table where the SELECT waits for the lock release takes more than 2 seconds

Also in the case that there is no lock contention visible by mtop. I see that the web page with no DB queries loads in less than a second while the one with DB queries takes about 3 seconds. The DB queries are through the php db class.

On an average there are selects happening 95% of the time and updates the rest.

vmstat shows that all the memory is buffered and the CPU load is never higher than 25%.

Thanks

Muni