MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Kevin Hunter Date:January 9 2008 12:05am
Subject:Re: Performance problem - MySQL at 99.9% CPU
View as plain text  
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
Thread
Performance problem - MySQL at 99.9% CPUGunnar R.2 Jan
  • Re: Performance problem - MySQL at 99.9% CPUBaron Schwartz2 Jan
  • Re: Performance problem - MySQL at 99.9% CPUAdy Wicaksono2 Jan
    • Re: Performance problem - MySQL at 99.9% CPUGunnar R.3 Jan
  • Re: Performance problem - MySQL at 99.9% CPUPer Jessen2 Jan
    • RE: Performance problem - MySQL at 99.9% CPUEric Frazier2 Jan
  • RE: Performance problem - MySQL at 99.9% CPUAndrew Braithwaite2 Jan
    • RE: Performance problem - MySQL at 99.9% CPUGunnar R.3 Jan
      • Re: Performance problem - MySQL at 99.9% CPUErik Giberti4 Jan
        • Re: Performance problem - MySQL at 99.9% CPUGunnar R.8 Jan
        • Re: Performance problem - MySQL at 99.9% CPUGunnar R.8 Jan
          • Re: Performance problem - MySQL at 99.9% CPUKevin Hunter8 Jan
          • Re: Performance problem - MySQL at 99.9% CPUErik Giberti9 Jan
Re: Performance problem - MySQL at 99.9% CPUKevin Hunter9 Jan