Massive CPU load with mysql log?

Foxhound

• February 16, 2014 07:01

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: 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

  • February 16, 2014 23:39

  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: 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.

  0
• 

  cPanelMichael

  • February 17, 2014 16:13

  Hello :) Try running the following command when MySQL is using excessive CPU: 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.

  0
• 

  Foxhound

  • February 17, 2014 20:15

  Thanks, that is some usefull info! Much to learn but I will get there at some point :)

  0

Please sign in to leave a comment.