MySQL Forums
Forum List  »  Performance

Re: MySQL High CPU Usage
Posted by: Rick James
Date: January 07, 2014 06:55PM

These are important:
long_query_time (<= 10) -- suggest 2
table_cache (> 64) -- suggest 200

Let's see some of the queries in the slowlog. About 2/hour are taking longer than 10 seconds. This _may_ indicate need for revising INDEXes and/or SELECTs.

In the long run, InnoDB is advised.
http://mysql.rjweb.org/doc.php/myisam2innodb

SHOW VARIABLES LIKE 'query_cache_size';
If that is more than 50M, then that could be causing the problem.

Options: ReplyQuote


Subject
Views
Written By
Posted
7404
January 02, 2014 04:33AM
2920
January 02, 2014 08:02AM
2566
January 03, 2014 12:58AM
2417
January 07, 2014 05:23AM
Re: MySQL High CPU Usage
2142
January 07, 2014 06:55PM
1735
January 08, 2014 04:21AM
1567
January 02, 2014 01:26PM
1613
January 03, 2014 01:05AM
1620
January 03, 2014 11:11AM
1840
January 07, 2014 05:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.