At 3:51p -0500 onGunnar R. wrote, On 01/08/2008 03:51 PM:
That tool tells me 100% of the data is read from memory, not a byte from
disk... would there still be any point in getting more memory?
Any suggestions to where to go from here?
I dunno. My hunch is that could do some query optimization. Have you
checked the index usage on your queries? Although MySQL's internal
planner is pretty weak for anything more complex than simple statements,
there are some excellent tools available to help you tune your queries.
http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html
A quick google with these keywords "mysql index hints query profiler"
seemed to provide a good jumping off point.
HTH,
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
