View All Products
Compute
Storage
Networking
Databases
Services
Developer Tools
Industries
Pricing
Community
Engage With Us
Community ▶ Questions ▶ Mysql High CPU Usage
Log in to Ask a Question

Mysql High CPU Usage

development

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

2 Replies

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" target="_blank">](http://library.linode.com/troubleshooti … networking">http://library.linode.com/troubleshooting/memory-networking](

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.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Log in to Reply
Community Code of Conduct