0
votes
2answers
53 views

MySQLD is using 175% of the cpu

On one of the servers, I have mysqld running as slave DB. The CPU usage is 175% at the moment used by mysqld. Here are the results of SHOW PROCESSLIST; ...
0
votes
0answers
66 views

high mysqld cpu usage after moving to new server

Just moved to a new (more powerful) server with only one website running on it, no changes on the website, but now I got a horrible high CPU load and I can't find out why. top: top - 22:54:08 up 1 ...
0
votes
0answers
80 views

High Mysql CPU usage + high amount of queries

My Root Server is currently warning me that the cpu usage by mysql services is approximatelly higher than 300 % (quad-core) Also the mysql tracking tells me that there are ~2,000 queries per second. ...
0
votes
0answers
54 views

Mysqld high CPU load

I have a lindode 8192. web server is Nginx my cpu usage is between 90% and 500% with minimal traffic. (sometimes none) the culprit is mysqld. i've enabled slow query log and that is empty. ...
0
votes
0answers
179 views

MySQL service takes a lor of CPU (780%)

I have a web server with MySQL and apache2. Server running a blog engine and normally it works fine. Yesterday (this is the second time) MySQL takes high CPU usage (790%) and the server hangs. The ...
0
votes
0answers
172 views

CPU usage rises to 100% in a few minutes on Tomcat web sever

I have an web app running on Tomcat 7 server. The rest of the configuration is: Intel i7 3930 32GB RAM 2x2TB HDD 20TB Bandwidth Debian 6 mysql 5.5.9 I'm using Ganglia for monitoring the load. ...
2
votes
1answer
419 views

Should CPU usage be so low while memory usage is high on heavy mysql server?

I'm using ubuntu server 12.04 x64. The server receives a lot of requests to mysql through apache web server (it's light interface). From mysql stats I see there is approx 250 queries / second from 8 ...
0
votes
1answer
33 views

MySQL Process Big

Ok, so I don't know if this is a repeat question so I'm sorry if it is (I couldn't find anything like it after searching =/) My server seems to be running what seems to me a larger than normal mysql ...
2
votes
1answer
1k views

Why does a mysql query, that requires copying to tmp table, randomly sometimes consume 100% CPU during several seconds?

I have some crazy SQL queries in my PHP scripts which badly need some optimization. However the question is NOT about how to optimize them. These queries have a lot of "join"s and some bizarre "order ...
0
votes
1answer
197 views

CPU load steadily increasing and MySQL 1.5 GB open deleted file in temp directory

I have a CentOS server that is running cPanel (shared hosting server), I have had troubles with MySQL before and I spent some time configuring and tuning it, until finally the load dropped (from ...
0
votes
1answer
60 views

High mysql throughput / cpu utilization

Once in a while, our server starts lagging. It always start around 6:00 ( GMT + 1) in the morning and ends around 3 till 4 hours later. We have munin installed and we see a peak in CPU utilization ...
2
votes
1answer
247 views

My sql consuming as much as 60% cpu time on start

I'm running a Wordpress installation on an Amazon Ec2 micro instance(linux ami). Using the default configuration Apache kept using up all the memory and shutting down mysql rendering wordpress ...
0
votes
2answers
292 views

Monitoring Redis and mysql server for memory and cpu usage

I want to compare the memory and cpu usage of the the redis-server and the mysql-server. I have used a profiler to get the client data but I would also like to know what is going on on the servers ...
0
votes
0answers
223 views

High CPU usage after adding field to table with 5million rows

LAMP server: Fedora Core release 6 Using phpMyAdmin, I have added a new field to a database table. The datatype is int with a default of 0. This table has approx 5 million rows. Since I submitted ...
0
votes
3answers
706 views

Mysql full text search cause high usage CPU

We built a news site. Every day we will input tens of thousands data from web api. In order to provide a precision search service, our table use MyISAM, build fulltext index (title, content, date). ...
1
vote
1answer
287 views

random high cpu load on linux box

It was all working fine couple of days ago (never jumped above 3.0). But now, the load average for 1 minute jumps well above 10, may hit 20, and then goes back to 5-6, maybe 3. The htop shows me ...
1
vote
1answer
512 views

400% CPU usage for MySQL? What? What should I do?

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 19857 mysql 20 0 514m 47m 3404 S 386 9.7 4511:45 mysqld 15659 www-data 20 0 205m 11m 4856 S 7 2.3 0:00.67 ...
2
votes
2answers
158 views

What does this command do on Linux? It is eating my CPU.

I have a VPS and I am hosting a game site on it. Recently my CPU went to 3000% and memory is going near full. When I checked the processes I found this process eating the CPU: Pid-1571 (Trace) ...
0
votes
1answer
359 views

Scalability problem (Tornado). Can't figure it out, holding up launch

Thanks guys, any ideas/insight are appreciated b/c this is driving me crazy. Problem: Only about 3 or 4 users can use the server simultaneously before app grinds to a halt. Currently we see massive ...
0
votes
2answers
382 views

Linux: CPU usage artificially capped somehow?

This is the CPU usage graph of a server: It seems that the CPU usage reached a hard limit at 24. This is a 32-core server so it should be able to go beyond 24 with ease. But that's not the case. ...
0
votes
4answers
957 views

MySQL server CPU usage shot up for no apparent reason. Any idea why?

I have a server dedicated to MySQL. In the middle of the night its CPU usage just shot up for no apparent reason. Here're the graphs: As you can see CPU usage just shot up at Fri 3:30am. Most of ...
3
votes
2answers
1k views

Dual Quad Core Xeon CPU but still high load

I have a dedicated server with following specs: Two Intel Xeon-Harpertown 5430-Quadcore[2.66 Ghz] 4GB DDRII RAM 500GB SATAII HD CentOS 5.5 64-bit Problem is that even with such specs MySQL still ...
1
vote
1answer
1k views

High MySQL CPU usage but no heavy query

When I run "top" command on my Linux it shows that MySQL is taking 400%-500% CPU usage. But when I run "watch mysqladmin pr" command to see a list of queries being run by MySQL then it shows just 2, 3 ...
0
votes
2answers
1k views

Low Cpu Usage in MySQL

I have one dedicated server on Amazon EC2, running mysql5 in a custom ami based on alestic debian lenny, in a small instance. Small Instance (default)* 1.7 GB memory 1 EC2 Compute Unit (1 virtual ...