Re: Need help with my.cnf

[Partha Dutta]

I see that you have a lot of Select_Scans which are full table scans. It may be that you are not hitting your indexes properly. You should run your queries through an explain plan to see what indexes (if any) they are using. The key_buffer_size does not look like its being totally used, so increasing it would not necessarily help.

One other thing you can do is to add this param to your my.cnf file: log-queries-not-using-indexes
This will allow MySQL to write out those queries that aren;t using indexes to your slow query log. It might help you isolate your problem.

Partha Dutta