Mysqld Eat's all the CPU
Hey folks,
I've got a php script which is inserting some data from a txt file into a table, however we dont seem to get very far as mysqld takes nearly all the CPU and we insert perhaps 1 or 2 records per second.
top - 11:10:12 up 35 min, 1 user, load average: 1.30, 0.82, 0.64
Tasks: 78 total, 3 running, 74 sleeping, 0 stopped, 1 zombie
Cpu(s): 97.7% user, 2.3% system, 0.0% nice, 0.0% idle
Mem: 1017268k total, 720712k used, 296556k free, 25996k buffers
Swap: 1831400k total, 0k used, 1831400k free, 556944k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
4011 mysql 18 0 11516 11m 1928 R 99.7 1.1 0:07.83 mysqld
3937 root 10 0 976 976 776 R 0.7 0.1 0:00.24 top
986 cpuser 9 0 1888 1888 1724 R 0.0 0.2 0:00.27 sshd
root@server143 [/usr/local/lib]# mysql --version
mysql Ver 12.22 Distrib 4.0.25, for pc-linux-gnu (i686)
mysql> status;
--------------
mysql Ver 12.22 Distrib 4.0.25, for pc-linux-gnu (i686)
Connection id: 29
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Server version: 4.0.25-standard
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 4 min 47 sec
Threads: 3 Questions: 1793 Slow queries: 0 Opens: 17 Flush tables: 1 Open tables: 11 Queries per second avg: 6.247
--------------
mysql>
Anyone know why this might be happening?
many thanks
|