Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
 Post subject: Mysql High CPU Usage
PostPosted: Fri May 27, 2011 4:51 pm 
Offline
Senior Newbie

Joined: Thu Sep 23, 2010 2:59 pm
Posts: 12
Hello,
My Mysql uses too much CPU (130%).

7.12 (1 min) 7.20 (5 mins) 7.51 (15 mins)

and sometime higher than these values.

is there any way to optimize Mysql to decrease this load?

Thanks


Top
   
 Post subject:
PostPosted: Fri May 27, 2011 5:08 pm 
Offline
Junior Member

Joined: Fri May 27, 2011 5:01 pm
Posts: 20
Not entirely sure about how to lower the load, but here are some suggestions from the library for Memory.
http://library.linode.com/troubleshooting/memory-networking


Top
   
 Post subject:
PostPosted: Fri May 27, 2011 5:44 pm 
Offline
Senior Member
User avatar

Joined: Tue May 26, 2009 3:29 pm
Posts: 1691
Location: Montreal, QC
The number one thing is to make sure that your database schema is efficient and correctly indexed. Indexing can make orders of magnitude improvements in performance, depending on table sizes.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group