0
votes
0answers
52 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
1answer
407 views

CentOS 5: is %wa too high or optimal?

i have question about waiting for HDD. I'm not sure what is optimal %wa. Server running browser game, i know that there is a lot hdd writing but im not sure what is optimal %wa. Server running 8 ...
1
vote
1answer
244 views

TIME column in TOP command for mysql

When I run top on my database server I get that mysqld has been running for 4:00.51 and it continues to go up. I assume this means that one process with mysql has been running this long from other ...
-1
votes
3answers
115 views

How to solve memory issues in Linux

How to get details of a process that is taking RAM. From top command i have found that Mysql is taking too much ram how can i know why Mysql is taking too much ram far from usual behavior? Is there ...
1
vote
1answer
483 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 ...
1
vote
3answers
150 views

Odd MySQL zombie task

It seems to me like there's always 1 task in SQL that runs on my server at work and my personal stuff that gets "stuck" and keeps running forever. PID USER PR NI VIRT RES SHR S %CPU %MEM ...
4
votes
5answers
420 views

Give me my KILL-power when something goes wrong

We've had it a few times now. Suddenly our production server won't respond because a process is in an infinite loop, or the MySQL server stops serving new requests because one query is blocking ...
0
votes
1answer
265 views

[Unix]How do I know this particular mysql process belong to what process on `show processlist`

As stated on question's title, I ran into situations and I need to check something. Here's the condition. When I do top, I see mysql process with ID, say 1234. But, when I execute show processlist ...
1
vote
3answers
88 views

Why one process is taking so many resources

My website is being very slow or non-responsive. A quick look at the top command shows me something like this: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 1709 mysql 20 ...