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

[Toa Sty]

Hi Muni,

You say you have an average 2 second response time? If that's actually query processing time you're much more likely to decrease this value through query tuning rather than my.cnf settings, especially if you're reasonably well setup to begin with. How do you measure this 2 seconds?

Looking at your config, your key_buffer seems quite small, but your key_cache hit ratio is pretty good so I wouldn't worry about it.

Also, you seem to indicate that you've had 0 slow queries, and yet your long_query_time is set to 2, so that suggests that you've never had a query taking >2 secs?

Can you explain a little more what is you'd like to speed up? (Any info from vmstat (or windows equivalent) would be useful too. (i.e. are you using lots of CPU/disk/etc?))

Toasty

-----------------------------------------
email: 'toasty'*3 at gmail