How can I get my mysqld-swamped CPU under control?

Posted by Shay Guy on Ask Ubuntu See other posts from Ask Ubuntu or by Shay Guy
Published on 2012-07-01T03:09:33Z Indexed on 2012/07/01 3:23 UTC
Read the original article Hit count: 260

Filed under:

mysql

|

cpu-load

I was AFK for about 24 hours and came back to find gnome-system-monitor saying all four CPU cores on my laptop were running at full throttle. mysqld is taking up more than one full core; when I tried to end the process, it restarted with a new PID. Then there's ksoftirqd/0-3, which apparently has something to do with interrupts, but I can't tell from Google what I'm supposed to do with those four particular processes. They're taking up a quarter or more of my processor cycles. Then there's Chrome, but I can probably handle that on my own -- how do I cool down the other processes giving me problems?

© Ask Ubuntu or respective owner

Related posts about mysql

How to remove MySQL completely with config and library files on ubuntu 12.04 gnome 3.0

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I tried everything till now: sudo apt-get remove mysql-server mysql-client mysql-common sudo apt-get purge mysql-server mysql-client mysql-common sudo apt-get autoremove and even more commands... But whenever I am trying to locate mysql. I get a no. of files related to mysql command: shell>>… >>> More
mysql: Cannot load from mysql.proc. The table is probably corrupted

as seen on Server Fault - Search for 'Server Fault'
Mysql was started: /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700 but when I'm trying to do something: ERROR 1548 (HY000) at line 1: Cannot… >>> More
Why is there a /etc/init.d/mysql file on this Slackware machine? How could it have gotten there?

as seen on Server Fault - Search for 'Server Fault'
A client of my IT-consulting service owns a web-development shop. He's been having problems with a Slackware 12.0 server running MySQL 5.0.67. The machine was set up by the client's sysadmin, who left on bad terms. My client no longer employs a sysadmin. As far as I can tell, the only copy of MySQL… >>> More
mysql: Bind on unix socket: Permission denied

as seen on Server Fault - Search for 'Server Fault'
Can't start mysql with: sudo /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700 120222 13:40:48 mysqld_safe Starting mysqld daemon with databases… >>> More
MySQL – Learning MySQL Online in 6 Hours – MySQL Fundamentals in 320 Minutes

as seen on SQL Authority - Search for 'SQL Authority'
MySQL is one of the most popular database language and I have been recently working with it a lot. Data have no barrier and every database have their own place. I have been working with MySQL for quite a while and just like SQL Server, I often find lots of people asking me if I have a tutorial which… >>> More

Related posts about cpu-load

Webalizer causing high CPU load

as seen on Server Fault - Search for 'Server Fault'
We use webalizer to generate reports on our Apache access logs - it is useful in conjunction with Google Analytics. The problem is that webalizer uses ALOT of CPU when running. If I run top I can see two perl processes with 90% CPU - this slows down the machine and therefore the website for our users… >>> More
Will An External Audio Interface Reduce CPU Load?

as seen on Super User - Search for 'Super User'
I am considering buying a very-low-latency audio interface like this one. One question is if it will reduce CPU load (I'm at about 60%+ and my Macbook has 2.4ghz and 4gigs ram) during intensive audio processing. If the answer is "yes," how will it compare to a different, cheaper firewire audio interface… >>> More
mysqld causes high CPU load

as seen on Server Fault - Search for 'Server Fault'
My mysqld goes to use 99.9% of CPU for variable time (between 2 - 20 minutes), and then goes back to normal 0.1% - 5%. Checked processlist: all is normal, 1 to 20 inserts or updates that last 2 to 5 sec, and about 20 process that are in Sleep Mode (maybe because the scripts don't close the mysql… >>> More
Simulate steady CPU load

as seen on Stack Overflow - Search for 'Stack Overflow'
How could I generate stedy CPU load in C#, lower than 100% for a certain time? I would also like to be able to change the load amount after a certain period of time. >>> More
Simulate steady CPU load and spikes

as seen on Stack Overflow - Search for 'Stack Overflow'
How could I generate steady CPU load in C#, lower than 100% for a certain time? I would also like to be able to change the load amount after a certain period of time. How do you recommend to generate usage spikes for a very short time? >>> More