Massive CPU load with mysql log?

Foxhound

Member
Sep 17, 2013
13
0
1
cPanel Access Level
Root Administrator
I am having a big issue with my server since thursday evening. It started out of the blue and as far as I know nothing was changed when the issue started.

I am getting a massive CPU load caused by mysql.
In WHM --> Process manager I can see this:
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.err --open-files-limit=102400 --pid-file=/var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid

The load on the CPU is 150 - 300 which in turn makes the load on my server massive. It should be max 8 I think but my server has a load of 20 - 60 constantly making my websites slow as hell.

In "top c" I see the exact same thing, same process eating up all my cpu power.


I really have no clue what to do. I have been googling since friday morning trying to figure out what is causing this but I am simply stuck and I am close to giving up all together.
I read topics here where people say you need to check mysql for errors, so I did check the host-ipxxxxx.xxxxxxxx.com.err log but I am not sure if even indicates a problem. Here are the last 300 entries:

Code:
130415 21:24:21  InnoDB: Completed initialization of buffer pool
130415 21:24:21  InnoDB: Started; log sequence number 0 102699240
130415 21:24:21 [Note] Event Scheduler: Loaded 0 events
130415 21:24:21 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.68-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130415 21:24:22 [Note] /usr/sbin/mysqld: Normal shutdown

130415 21:24:22 [Note] Event Scheduler: Purging the queue. 0 events
130415 21:24:22  InnoDB: Starting shutdown...
130415 21:24:26  InnoDB: Shutdown completed; log sequence number 0 102699240
130415 21:24:26 [Note] /usr/sbin/mysqld: Shutdown complete

130415 21:24:26 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
130415 21:24:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130415 21:24:26 [Note] Plugin 'FEDERATED' is disabled.
130415 21:24:26  InnoDB: Initializing buffer pool, size = 8.0M
130415 21:24:26  InnoDB: Completed initialization of buffer pool
130415 21:24:26  InnoDB: Started; log sequence number 0 102699240
130415 21:24:26 [Note] Event Scheduler: Loaded 0 events
130415 21:24:26 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.68-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130611  0:34:03 [Note] /usr/sbin/mysqld: Normal shutdown

130611  0:34:03 [Note] Event Scheduler: Purging the queue. 0 events
130611  0:34:06  InnoDB: Starting shutdown...
130611  0:34:09  InnoDB: Shutdown completed; log sequence number 0 110521735
130611  0:34:09 [Note] /usr/sbin/mysqld: Shutdown complete

130611 00:34:10 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
130611 00:34:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130611  0:34:26 [Note] Plugin 'FEDERATED' is disabled.
130611  0:34:26  InnoDB: Initializing buffer pool, size = 8.0M
130611  0:34:26  InnoDB: Completed initialization of buffer pool
130611  0:34:27  InnoDB: Started; log sequence number 0 110521735
130611  0:34:27 [Note] Event Scheduler: Loaded 0 events
130611  0:34:27 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.69-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130611  0:34:32 [Note] /usr/sbin/mysqld: Normal shutdown

130611  0:34:32 [Note] Event Scheduler: Purging the queue. 0 events
130611  0:34:34  InnoDB: Starting shutdown...
130611  0:34:37  InnoDB: Shutdown completed; log sequence number 0 110521735
130611  0:34:37 [Note] /usr/sbin/mysqld: Shutdown complete

130611 00:34:37 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
130611 00:34:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130611  0:34:38 [Note] Plugin 'FEDERATED' is disabled.
130611  0:34:38  InnoDB: Initializing buffer pool, size = 8.0M
130611  0:34:38  InnoDB: Completed initialization of buffer pool
130611  0:34:38  InnoDB: Started; log sequence number 0 110521735
130611  0:34:38 [Note] Event Scheduler: Loaded 0 events
130611  0:34:38 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.69-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130617 13:38:10 [Note] /usr/sbin/mysqld: Normal shutdown

130617 13:38:10 [Note] Event Scheduler: Purging the queue. 0 events
130617 13:38:11  InnoDB: Starting shutdown...
130617 13:38:16  InnoDB: Shutdown completed; log sequence number 0 111815530
130617 13:38:16 [Note] /usr/sbin/mysqld: Shutdown complete

130617 13:38:18 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
130617 13:38:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130617 13:38:27 [Note] Plugin 'FEDERATED' is disabled.
130617 13:38:27  InnoDB: Initializing buffer pool, size = 8.0M
130617 13:38:27  InnoDB: Completed initialization of buffer pool
130617 13:38:28  InnoDB: Started; log sequence number 0 111815530
130617 13:38:28 [Note] Event Scheduler: Loaded 0 events
130617 13:38:28 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.69-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130618  7:46:38 [Note] /usr/sbin/mysqld: Normal shutdown

130618  7:46:38 [Note] Event Scheduler: Purging the queue. 0 events
130618  7:46:40  InnoDB: Starting shutdown...
130618  7:46:43  InnoDB: Shutdown completed; log sequence number 0 111868771
130618  7:46:43 [Note] /usr/sbin/mysqld: Shutdown complete

130618 07:46:43 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
130618 07:46:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130618  7:46:44 [Note] Plugin 'FEDERATED' is disabled.
130618  7:46:44  InnoDB: Initializing buffer pool, size = 8.0M
130618  7:46:44  InnoDB: Completed initialization of buffer pool
130618  7:46:45  InnoDB: Started; log sequence number 0 111868771
130618  7:46:45 [ERROR] /usr/sbin/mysqld: unknown variable 'max_connextions=500'
130618  7:46:45 [ERROR] Aborting

130618  7:46:45  InnoDB: Starting shutdown...
130618  7:46:50  InnoDB: Shutdown completed; log sequence number 0 111868771
130618  7:46:50 [Note] /usr/sbin/mysqld: Shutdown complete

130618 07:46:50 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
130618 07:47:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130618  7:47:01 [Note] Plugin 'FEDERATED' is disabled.
130618  7:47:01  InnoDB: Initializing buffer pool, size = 8.0M
130618  7:47:01  InnoDB: Completed initialization of buffer pool
130618  7:47:01  InnoDB: Started; log sequence number 0 111868771
130618  7:47:01 [ERROR] /usr/sbin/mysqld: unknown variable 'max_connextions=500'
130618  7:47:01 [ERROR] Aborting

130618  7:47:01  InnoDB: Starting shutdown...
130618  7:47:06  InnoDB: Shutdown completed; log sequence number 0 111868771
130618  7:47:06 [Note] /usr/sbin/mysqld: Shutdown complete

130618 07:47:06 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
130618 07:47:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130618  7:47:27 [Note] Plugin 'FEDERATED' is disabled.
130618  7:47:27  InnoDB: Initializing buffer pool, size = 8.0M
130618  7:47:27  InnoDB: Completed initialization of buffer pool
130618  7:47:27  InnoDB: Started; log sequence number 0 111868771
130618  7:47:27 [Note] Event Scheduler: Loaded 0 events
130618  7:47:27 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.69-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130618 07:59:00 mysqld_safe A mysqld process already exists
130618 08:00:43 mysqld_safe A mysqld process already exists
130618  8:04:53 [Note] /usr/sbin/mysqld: Normal shutdown

130618  8:04:53 [Note] Event Scheduler: Purging the queue. 0 events
130618  8:04:55  InnoDB: Starting shutdown...
130618  8:04:58  InnoDB: Shutdown completed; log sequence number 0 111871192
130618  8:04:58 [Note] /usr/sbin/mysqld: Shutdown complete

130618 08:04:58 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
130618 08:04:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130618  8:04:58 [Note] Plugin 'FEDERATED' is disabled.
130618  8:04:58  InnoDB: Initializing buffer pool, size = 8.0M
130618  8:04:58  InnoDB: Completed initialization of buffer pool
130618  8:04:59  InnoDB: Started; log sequence number 0 111871192
130618  8:04:59 [Note] Event Scheduler: Loaded 0 events
130618  8:04:59 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.69-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130701 21:21:48 [Note] /usr/sbin/mysqld: Normal shutdown

130701 21:21:48 [Note] Event Scheduler: Purging the queue. 0 events
130701 21:21:48  InnoDB: Starting shutdown...
130701 21:21:51  InnoDB: Shutdown completed; log sequence number 0 112956364
130701 21:21:51 [Note] /usr/sbin/mysqld: Shutdown complete

130701 21:21:51 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
130701 21:22:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130701 21:22:11 [Note] Plugin 'FEDERATED' is disabled.
130701 21:22:11  InnoDB: Initializing buffer pool, size = 8.0M
130701 21:22:11  InnoDB: Completed initialization of buffer pool
130701 21:22:11  InnoDB: Started; log sequence number 0 112956364
130701 21:22:11 [Note] Event Scheduler: Loaded 0 events
130701 21:22:11 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.70-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130701 21:22:22 [Note] /usr/sbin/mysqld: Normal shutdown

130701 21:22:22 [Note] Event Scheduler: Purging the queue. 0 events
130701 21:22:24  InnoDB: Starting shutdown...
130701 21:22:26  InnoDB: Shutdown completed; log sequence number 0 112956364
130701 21:22:26 [Note] /usr/sbin/mysqld: Shutdown complete

130701 21:22:26 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
130701 21:22:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130701 21:22:27 [Note] Plugin 'FEDERATED' is disabled.
130701 21:22:27  InnoDB: Initializing buffer pool, size = 8.0M
130701 21:22:27  InnoDB: Completed initialization of buffer pool
130701 21:22:27  InnoDB: Started; log sequence number 0 112956364
130701 21:22:27 [Note] Event Scheduler: Loaded 0 events
130701 21:22:27 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.70-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130905 12:50:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130905 12:50:22 [Note] Plugin 'FEDERATED' is disabled.
130905 12:50:23  InnoDB: Initializing buffer pool, size = 8.0M
130905 12:50:23  InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130905 12:50:24  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130905 12:50:34  InnoDB: Started; log sequence number 0 125688110
130905 12:50:35 [Note] Event Scheduler: Loaded 0 events
130905 12:50:35 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.70-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130916  7:01:47 [Note] /usr/sbin/mysqld: Normal shutdown

130916  7:01:47 [Note] Event Scheduler: Purging the queue. 0 events
130916  7:01:48  InnoDB: Starting shutdown...
130916  7:01:56  InnoDB: Shutdown completed; log sequence number 0 127533099
130916  7:01:56 [Note] /usr/sbin/mysqld: Shutdown complete

130916 07:01:58 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
130916 07:09:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130916  7:09:44 [Note] Plugin 'FEDERATED' is disabled.
130916  7:09:45  InnoDB: Initializing buffer pool, size = 8.0M
130916  7:09:45  InnoDB: Completed initialization of buffer pool
130916  7:09:47  InnoDB: Started; log sequence number 0 127533099
130916  7:09:49 [Note] Event Scheduler: Loaded 0 events
130916  7:09:49 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.70-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
131218 22:17:43 [Note] /usr/sbin/mysqld: Normal shutdown

131218 22:17:43 [Note] Event Scheduler: Purging the queue. 0 events
131218 22:17:45  InnoDB: Starting shutdown...
131218 22:17:46  InnoDB: Shutdown completed; log sequence number 0 151287865
131218 22:17:46 [Note] /usr/sbin/mysqld: Shutdown complete

131218 22:17:47 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
131218 22:18:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131218 22:18:06 [Note] Plugin 'FEDERATED' is disabled.
131218 22:18:06  InnoDB: Initializing buffer pool, size = 8.0M
131218 22:18:06  InnoDB: Completed initialization of buffer pool
131218 22:18:06  InnoDB: Started; log sequence number 0 151287865
131218 22:18:06 [Note] Event Scheduler: Loaded 0 events
131218 22:18:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.72-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPLv2)
131218 22:18:13 [Note] /usr/sbin/mysqld: Normal shutdown

131218 22:18:13 [Note] Event Scheduler: Purging the queue. 0 events
131218 22:18:15  InnoDB: Starting shutdown...
131218 22:18:17  InnoDB: Shutdown completed; log sequence number 0 151287865
131218 22:18:17 [Note] /usr/sbin/mysqld: Shutdown complete

131218 22:18:17 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
131218 22:18:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131218 22:18:18 [Note] Plugin 'FEDERATED' is disabled.
131218 22:18:18  InnoDB: Initializing buffer pool, size = 8.0M
131218 22:18:18  InnoDB: Completed initialization of buffer pool
131218 22:18:18  InnoDB: Started; log sequence number 0 151287865
131218 22:18:18 [Note] Event Scheduler: Loaded 0 events
131218 22:18:18 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.72-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPLv2)
140105  8:42:06 [Note] /usr/sbin/mysqld: Normal shutdown

140105  8:42:06 [Note] Event Scheduler: Purging the queue. 0 events
140105  8:42:08  InnoDB: Starting shutdown...
140105  8:42:10  InnoDB: Shutdown completed; log sequence number 0 166276640
140105  8:42:10 [Note] /usr/sbin/mysqld: Shutdown complete

140105 08:42:10 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
140105 08:42:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140105  8:42:12 [Note] Plugin 'FEDERATED' is disabled.
140105  8:42:12  InnoDB: Initializing buffer pool, size = 8.0M
140105  8:42:12  InnoDB: Completed initialization of buffer pool
140105  8:42:12  InnoDB: Started; log sequence number 0 166276640
140105  8:42:12 [Note] Event Scheduler: Loaded 0 events
140105  8:42:12 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.72-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPLv2)
140123 16:04:57 [ERROR] /usr/sbin/mysqld: Sort aborted
140215 17:01:07 [Note] /usr/sbin/mysqld: Normal shutdown

140215 17:01:07 [ERROR] /usr/sbin/mysqld: Sort aborted
140215 17:01:07 [Note] Event Scheduler: Purging the queue. 0 events
140215 17:01:07 [ERROR] /usr/sbin/mysqld: Sort aborted
140215 17:01:10  InnoDB: Starting shutdown...
140215 17:01:12  InnoDB: Shutdown completed; log sequence number 0 166436071
140215 17:01:12 [Note] /usr/sbin/mysqld: Shutdown complete

140215 17:01:13 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
140215 17:04:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140215 17:04:14 [Note] Plugin 'FEDERATED' is disabled.
140215 17:04:14  InnoDB: Initializing buffer pool, size = 8.0M
140215 17:04:14  InnoDB: Completed initialization of buffer pool
140215 17:04:17  InnoDB: Started; log sequence number 0 166436071
140215 17:04:19 [Note] Event Scheduler: Loaded 0 events
140215 17:04:19 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.72-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPLv2)
140216  0:52:15 [Note] /usr/sbin/mysqld: Normal shutdown

140216  0:52:15 [Note] Event Scheduler: Purging the queue. 0 events
140216  0:52:17  InnoDB: Starting shutdown...
140216  0:52:20  InnoDB: Shutdown completed; log sequence number 0 166436120
140216  0:52:20 [Note] /usr/sbin/mysqld: Shutdown complete

140216 00:52:20 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
140216 00:52:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140216  0:52:21 [Note] Plugin 'FEDERATED' is disabled.
140216  0:52:21  InnoDB: Initializing buffer pool, size = 8.0M
140216  0:52:21  InnoDB: Completed initialization of buffer pool
140216  0:52:21  InnoDB: Started; log sequence number 0 166436120
140216  0:52:21 [Note] Event Scheduler: Loaded 0 events
140216  0:52:21 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.72-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPLv2)
140216 01:18:32 mysqld_safe Number of processes running now: 0
140216 01:18:32 mysqld_safe mysqld restarted
140216  1:18:32 [Note] Plugin 'FEDERATED' is disabled.
140216  1:18:32  InnoDB: Initializing buffer pool, size = 8.0M
140216  1:18:32  InnoDB: Completed initialization of buffer pool
140216  1:18:32  InnoDB: Started; log sequence number 0 166436120
140216  1:18:32 [Note] Event Scheduler: Loaded 0 events
140216  1:18:32 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.72-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPLv2)
140216 12:29:14 [Note] /usr/sbin/mysqld: Normal shutdown

140216 12:29:14 [Note] Event Scheduler: Purging the queue. 0 events
140216 12:29:16  InnoDB: Starting shutdown...
140216 12:29:19  InnoDB: Shutdown completed; log sequence number 0 166436130
140216 12:29:19 [Note] /usr/sbin/mysqld: Shutdown complete

140216 12:29:19 mysqld_safe mysqld from pid file /var/lib/mysql/host-ipxxxxx.xxxxxxxx.com.pid ended
140216 12:29:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140216 12:29:21 [Note] Plugin 'FEDERATED' is disabled.
140216 12:29:21  InnoDB: Initializing buffer pool, size = 8.0M
140216 12:29:21  InnoDB: Completed initialization of buffer pool
140216 12:29:22  InnoDB: Started; log sequence number 0 166436130
140216 12:29:22 [Note] Event Scheduler: Loaded 0 events
140216 12:29:22 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.72-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPLv2)

I also read you should check slow queries, but the logs people refer to for me do not exist and I am not sure what to do with it.

restarting mysql does not help
restarting the server does not help
killing that process does not help
I increased the open-files limit as some people suggested, which also did not help
........

I am very new to all this server administrating but I am eager to learn so if anyone is able to help me how to handle this issue I would very much appreciate it.
 

Foxhound

Member
Sep 17, 2013
13
0
1
cPanel Access Level
Root Administrator
Hmmm, ok. If nobody can help me, is there someone who could help me tweak mysql?
I read you should not use the mysqltunner anymore so I guess now its down to experience?

My server is still having a way to high load eventhough I completely removed it from public access (port 80).
I am not sure which kind of data is required for anyone to be able to help. So in case you feel like helping out feel free to let me know which data could be usefull for me to post here.


This is the output of top atm:
Code:
top - 00:38:14 up 1 day,  7:35,  2 users,  load average: 9.64, 7.11, 7.19
Mem:   8165416k total,  8119980k used,    45436k free,   116056k buffers
Swap: 10217332k total,   146616k used, 10070716k free,  7186716k cached
The server has the following specs:
- Intel Core i7-920
- 8GB Memory
- 2x 750GB 7200rpm Hard Disk
- CentOS 5.x x64


Nobody is on my website (when I copied the above top info) except me (normally we have 700 - 1500 visitors every 15 minutes).

I really hope someone can give me some pointers cause right now I am pretty much stuck.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,268
463
Hello :)

Try running the following command when MySQL is using excessive CPU:

Code:
mysqladmin processlist
This should alert you to which database is contributing the most to the usage. Also, this thread might be of help to you:

Troubleshooting High Load On Linux Servers

Thank you.