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