Mysql reigns CPU! :)

One of my boxes is being pushed hardly by MySQL (or i think it is mysql) Checking the process list, i can see only a 15-20 queries doing normally. But the load goes on crazy. Averagely 10, and sometimes 35-40. It's also using from swap..

I have tried alternatively optimizing for both mysql and httpd from my logic and also from their official sites, but that did not work out. So i guess something is not going well, maybe a corruption or attack (can not last for that long? netstat seems ok)

Do you have something coming to your mind that i can not think, just share with me, my brain stopped working Mysql reigns CPU! :))

Box is celeron 1.0 ghz, 512 mb RAM.


From "top"

---
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
1829 mysql 9 0 18036 17M 1992 S 78.4 3.5 1:00 0 mysqld
1036 root 10 0 12716 12M 12476 S 18.7 2.4 1:43 0 httpd
---


From my.cnf

---
key_buffer = 256M
wait_timeout = 9
max_connections = 79
connect_timeout = 15
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 4M
read_buffer_size = 1M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_type=1
query_cache_limit=1M
query_cache_size= 1M
thread_concurrency = 8
---


From httpd.conf

---
Timeout 300
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 8
MaxClients 150
MaxRequestsPerChild 100
---

 

 

 

 

Top