The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Massive CPU load with mysql log?

Discussion in 'General Discussion' started by Foxhound, Feb 16, 2014.

  1. Foxhound

    Foxhound Member

    Joined:
    Sep 17, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    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.
     
  2. Foxhound

    Foxhound Member

    Joined:
    Sep 17, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    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.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  4. Foxhound

    Foxhound Member

    Joined:
    Sep 17, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thanks, that is some usefull info!
    Much to learn but I will get there at some point :)
     
Loading...

Share This Page