Reduce server load

KateH · Jan 11, 2015

We have a VPS with 4 CPUs and we are currently running at 23.75 (and it has been even higher). We off and on get database connection errors on our site. We have tried many things suggested by our host: optimizing MySQL, optimizing Wordpress, killing leech protect, etc. I am not sure if I can even remember everything. We need help.

load average: 31.90, 37.32, 37.56

I am not very skilled at this and am trying my best.

- - - Updated - - -

More information:

Code:

top - 01:36:55 up  3:47,  1 user,  load average: 31.90, 37.32, 37.56
Tasks: 239 total,  48 running, 191 sleeping,   0 stopped,   0 zombie
Cpu(s): 92.9%us,  7.1%sy,  0.0%ni,  0.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   8059408k total,  5481240k used,  2578168k free,   166296k buffers
Swap:  4194300k total,        0k used,  4194300k free,  1610860k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND           
29791 csftlorg  20   0  159m  39m 8744 R 29.1  0.5   2:06.66 php                
29964 csftlorg  20   0  163m  43m 8808 R 29.1  0.6   1:31.76 php                
 5628 mysql     20   0 2834m 477m 6484 S 14.6  6.1  28:41.16 mysqld             
29784 csftlorg  20   0  166m  47m 8824 R 14.6  0.6   1:43.83 php                
29789 csftlorg  20   0  163m  43m 8804 R 14.6  0.6   1:39.95 php                
29828 csftlorg  20   0  167m  48m 9464 R 14.6  0.6   1:44.77 php                
29834 csftlorg  20   0  167m  48m 9520 R 14.6  0.6   1:28.05 php                
29910 csftlorg  20   0  147m  27m 8548 R 14.6  0.4   1:48.36 php                
29912 csftlorg  20   0  164m  44m 8580 R 14.6  0.6   1:52.26 php                
29920 csftlorg  20   0  165m  45m 8524 R 14.6  0.6   1:36.87 php

secureconfig · Jan 11, 2015

hello ,

what is your php handler ?
install htop and paste a photo of it when its running :
yum install htop
(you need enable epel)

Good Luck.

Infopro · Jan 12, 2015

KateH said:

We have a VPS with 4 CPUs and we are currently running at 23.75 (and it has been even higher). We off and on get database connection errors on our site. We have tried many things suggested by our host: optimizing MySQL, optimizing Wordpress, killing leech protect, etc. I am not sure if I can even remember everything. We need help.

load average: 31.90, 37.32, 37.56

I am not very skilled at this and am trying my best.

- - - Updated - - -

More information:

Code:

top - 01:36:55 up  3:47,  1 user,  load average: 31.90, 37.32, 37.56
Tasks: 239 total,  48 running, 191 sleeping,   0 stopped,   0 zombie
Cpu(s): 92.9%us,  7.1%sy,  0.0%ni,  0.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   8059408k total,  5481240k used,  2578168k free,   166296k buffers
Swap:  4194300k total,        0k used,  4194300k free,  1610860k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND           
29791 csftlorg  20   0  159m  39m 8744 R 29.1  0.5   2:06.66 php                
29964 csftlorg  20   0  163m  43m 8808 R 29.1  0.6   1:31.76 php                
 5628 mysql     20   0 2834m 477m 6484 S 14.6  6.1  28:41.16 mysqld             
29784 csftlorg  20   0  166m  47m 8824 R 14.6  0.6   1:43.83 php                
29789 csftlorg  20   0  163m  43m 8804 R 14.6  0.6   1:39.95 php                
29828 csftlorg  20   0  167m  48m 9464 R 14.6  0.6   1:44.77 php                
29834 csftlorg  20   0  167m  48m 9520 R 14.6  0.6   1:28.05 php                
29910 csftlorg  20   0  147m  27m 8548 R 14.6  0.4   1:48.36 php                
29912 csftlorg  20   0  164m  44m 8580 R 14.6  0.6   1:52.26 php                
29920 csftlorg  20   0  165m  45m 8524 R 14.6  0.6   1:36.87 php

Is that site fully up to date and secure? Does this user have any customized (or otherwise) addons installed? You might start there. Disable any addons and see what happens with load.

KateH · Jan 12, 2015

PHP Handler:

Code:

Default PHP Version (.php files)	5
PHP 5 Handler	fcgi
 	 
Apache suEXEC	on
Apache Ruid2	off

mageshm · Jan 12, 2015

@ KateH,

Try top c or htop and check the command section (It will give a exact path of file) which file exactly taking load. In the above output it shows only php and we can't figure out the root causes of issues.

KateH · Jan 12, 2015

mageshm said:
@ KateH,

Try top c or htop and check the command section (It will give a exact path of file) which file exactly taking load. In the above output it shows only php and we can't figure out the root causes of issues.

I will try. I was trying to figure out htop today.

I also have this mysql log:

Code:

[email protected] [~]# sudo cat /var/lib/mysql/server.csftl.org.err
140814 08:41:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140814  8:41:11 [Note] Plugin 'FEDERATED' is disabled.
140814  8:41:11 InnoDB: The InnoDB memory heap is disabled
140814  8:41:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140814  8:41:11 InnoDB: Compressed tables use zlib 1.2.3
140814  8:41:11 InnoDB: Using Linux native AIO
140814  8:41:11 InnoDB: Initializing buffer pool, size = 128.0M
140814  8:41:11 InnoDB: Completed initialization of buffer pool
140814  8:41:11 InnoDB: highest supported file format is Barracuda.
140814  8:41:13  InnoDB: Waiting for the background threads to start
140814  8:41:14 InnoDB: 5.5.37 started; log sequence number 24601796
140814  8:41:14 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140814  8:41:14 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
140814  8:41:14 [Note] Server socket created on IP: '0.0.0.0'.
140814  8:41:14 [Note] Event Scheduler: Loaded 0 events
140814  8:41:14 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.37-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
140814  8:41:20 [Note] /usr/sbin/mysqld: Normal shutdown

140814  8:41:20 [Note] Event Scheduler: Purging the queue. 0 events
140814  8:41:20  InnoDB: Starting shutdown...
140814  8:41:21  InnoDB: Shutdown completed; log sequence number 24601874
140814  8:41:21 [Note] /usr/sbin/mysqld: Shutdown complete

140814 08:41:21 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
140814 08:41:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140814  8:41:21 [Note] Plugin 'FEDERATED' is disabled.
140814  8:41:21 InnoDB: The InnoDB memory heap is disabled
140814  8:41:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140814  8:41:21 InnoDB: Compressed tables use zlib 1.2.3
140814  8:41:21 InnoDB: Using Linux native AIO
140814  8:41:21 InnoDB: Initializing buffer pool, size = 128.0M
140814  8:41:21 InnoDB: Completed initialization of buffer pool
140814  8:41:22 InnoDB: highest supported file format is Barracuda.
140814  8:41:22  InnoDB: Waiting for the background threads to start
140814  8:41:23 InnoDB: 5.5.37 started; log sequence number 24601874
140814  8:41:23 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140814  8:41:23 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
140814  8:41:23 [Note] Server socket created on IP: '0.0.0.0'.
140814  8:41:23 [Note] Event Scheduler: Loaded 0 events
140814  8:41:23 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.37-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
140814 08:41:25 mysqld_safe A mysqld process already exists
140815  7:08:58 [Warning] IP address '61.147.103.160' could not be resolved: Name or service not known
140815 19:42:44 [Warning] IP address '218.6.173.36' could not be resolved: Name or service not known
140816  2:48:37 [Warning] IP address '61.160.195.52' could not be resolved: Name or service not known
140816  6:12:27 [Warning] IP address '180.225.203.220' could not be resolved: Name or service not known
140821  4:45:43 [Warning] IP address '121.40.81.183' could not be resolved: Name or service not known
140822  0:38:54 [Warning] IP address '222.186.10.186' could not be resolved: Name or service not known
140823  1:09:28 [Warning] IP address '118.123.246.140' could not be resolved: Name or service not known
140825  2:15:05 [Warning] IP address '61.147.103.110' could not be resolved: Name or service not known
140825 10:03:29 [Warning] IP address '58.215.176.172' could not be resolved: Name or service not known
140827 14:58:17 [Warning] IP address '61.191.217.249' could not be resolved: Name or service not known
140830 10:55:56 [Warning] IP address '115.47.9.141' could not be resolved: Name or service not known
140830 14:14:21 [Warning] IP address '76.164.228.43' could not be resolved: Name or service not known
140830 16:48:27 [Warning] IP address '115.230.126.174' could not be resolved: Name or service not known
140830 16:54:00 [Warning] IP address '94.100.31.178' has been resolved to the host name '178.31.100.94.in-addr.arpa', which resembles IPv4-address itself.
140831 17:02:20 [Warning] IP address '89.248.166.153' could not be resolved: Name or service not known
140902  1:37:46 [Warning] IP address '14.17.88.35' could not be resolved: Name or service not known
140902 22:44:18 [Warning] IP address '124.156.241.11' could not be resolved: Name or service not known
140904  2:38:24 [Warning] IP address '122.0.114.139' could not be resolved: Name or service not known
140905  3:10:51 [Warning] IP address '124.52.215.244' could not be resolved: Name or service not known
140905 11:34:44 [Warning] IP address '113.204.104.162' could not be resolved: Name or service not known
140906  3:23:50 [Warning] IP address '123.131.52.102' could not be resolved: Name or service not known
140906  6:15:08 [Warning] IP address '221.123.151.60' could not be resolved: Name or service not known
140907 20:38:40 [Warning] IP address '23.244.84.87' has been resolved to the host name '87.84-244-23.rdns.scalabledns.com', which resembles IPv4-address itself.
140908 17:13:05 [Warning] IP address '113.106.98.9' could not be resolved: Name or service not known
140910  1:12:10 [Warning] IP address '222.186.24.10' could not be resolved: Name or service not known
140912 22:27:48 [Warning] IP address '222.186.42.168' could not be resolved: Name or service not known
140913  0:26:13 [Warning] IP address '87.255.38.184' could not be resolved: Name or service not known
140913  6:30:18 [Warning] IP address '117.21.191.18' could not be resolved: Name or service not known
140915  1:05:17 [Warning] IP address '61.176.212.13' could not be resolved: Name or service not known
140916 22:41:49 [Warning] IP address '61.160.213.5' could not be resolved: Name or service not known
140924  2:55:42 [Warning] IP address '117.22.78.72' could not be resolved: Name or service not known
140924 15:30:18 [Warning] IP address '118.123.119.72' could not be resolved: Name or service not known
140925 11:17:43 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:17:56 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:18:07 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:18:15 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:18:25 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:18:36 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:18:41 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:18:51 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:19:02 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:19:10 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:19:16 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:19:26 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:19:36 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:19:45 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:19:56 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:20:06 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:20:12 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:20:22 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:20:32 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:20:42 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:20:51 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:21:01 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140926  3:58:19 [Warning] IP address '118.123.15.72' could not be resolved: Name or service not known
140926  9:00:04 [Warning] IP address '222.186.56.9' could not be resolved: Name or service not known
140927 17:05:50 [Warning] IP address '104.194.20.26' could not be resolved: Temporary failure in name resolution
140929  2:15:20 [Warning] IP address '118.186.71.77' could not be resolved: Temporary failure in name resolution
140930 18:30:13 [Warning] IP address '117.22.196.210' could not be resolved: Name or service not known
141001 15:00:13 [Warning] IP address '117.21.227.237' could not be resolved: Name or service not known
141004 12:52:48 [Warning] IP address '219.129.237.109' could not be resolved: Name or service not known
141006 18:46:03 [Warning] IP address '222.186.59.192' could not be resolved: Name or service not known
141006 21:48:34 [Warning] IP address '202.129.165.21' could not be resolved: Name or service not known
141007  9:09:09 [Warning] IP address '222.180.162.17' could not be resolved: Temporary failure in name resolution
141007 11:24:16 [Warning] IP address '61.132.91.227' could not be resolved: Name or service not known
141007 18:00:55 [Warning] IP address '222.186.10.134' could not be resolved: Name or service not known
141008  8:41:05 [Warning] IP address '210.212.98.234' could not be resolved: Name or service not known
141008 18:49:14 [Warning] IP address '118.193.161.40' could not be resolved: Name or service not known
141008 20:26:04 [Warning] IP address '122.224.34.160' could not be resolved: Name or service not known
141009  6:30:13 [Warning] IP address '117.21.220.253' could not be resolved: Name or service not known
141011  9:32:46 [Warning] IP address '115.231.81.35' could not be resolved: Name or service not known
141011 13:52:02 [Warning] IP address '116.255.152.250' could not be resolved: Temporary failure in name resolution
141011 18:49:07 [Warning] IP address '60.173.9.184' could not be resolved: Name or service not known
141012  5:21:42 [Warning] IP address '104.194.20.27' could not be resolved: Temporary failure in name resolution
141012 14:25:30 [Warning] IP address '58.220.238.219' could not be resolved: Name or service not known
141013 14:16:50 [Warning] IP address '122.227.228.41' could not be resolved: Name or service not known
141014 12:15:25 [Warning] IP address '116.255.170.177' could not be resolved: Temporary failure in name resolution
141015  1:57:46 [Warning] IP address '112.125.126.228' could not be resolved: Name or service not known
141015  6:35:49 [Warning] IP address '96.44.150.196' could not be resolved: Name or service not known
141015  8:19:18 [Warning] IP address '104.194.6.11' could not be resolved: Temporary failure in name resolution
141016 10:28:07 [Warning] IP address '61.136.93.10' has been resolved to the host name '10.93.136.61.ha.cnc', which resembles IPv4-address itself.
141016 16:56:59 [Warning] IP address '104.194.6.11' could not be resolved: Temporary failure in name resolution
141017  0:37:20 [Warning] IP address '104.194.20.90' could not be resolved: Name or service not known
141017  6:37:55 [Warning] IP address '122.224.19.201' could not be resolved: Name or service not known
141019  2:47:46 [Warning] IP address '117.21.173.36' could not be resolved: Name or service not known
141020  2:52:10 [Warning] IP address '61.147.103.83' could not be resolved: Name or service not known
141020  4:37:29 [Warning] IP address '103.30.79.225' could not be resolved: Temporary failure in name resolution
141022 12:36:18 [Warning] IP address '203.86.9.5' could not be resolved: Name or service not known
141027 16:49:05 [Warning] IP address '107.150.52.82' could not be resolved: Name or service not known
141028  7:47:02 [Warning] IP address '107.150.52.83' could not be resolved: Name or service not known
141028 11:21:54 [Warning] IP address '178.150.145.4' has been resolved to the host name '4.145.150.178.triolan.net', which resembles IPv4-address itself.
141028 20:33:50 [Warning] IP address '104.194.20.83' could not be resolved: Name or service not known
141028 21:07:13 [Warning] IP address '58.215.188.130' could not be resolved: Name or service not known
141029 14:24:38 [Warning] IP address '159.224.57.168' has been resolved to the host name '168.57.224.159.triolan.net', which resembles IPv4-address itself.
141103  0:47:47 [Warning] IP address '122.226.102.27' could not be resolved: Name or service not known
141105 19:32:16 [Warning] IP address '119.10.6.211' could not be resolved: Name or service not known
141106  8:45:47 [Warning] IP address '122.226.102.37' could not be resolved: Name or service not known
141107  3:57:26 [Warning] IP address '124.173.70.114' could not be resolved: Name or service not known
141107  8:29:27 [Warning] IP address '60.190.223.251' could not be resolved: Name or service not known
141107 23:53:22 [Warning] IP address '111.39.44.231' could not be resolved: Name or service not known
141108 11:17:31 [Warning] IP address '118.26.201.55' could not be resolved: Name or service not known
141110  6:48:44 [Warning] IP address '115.230.124.4' could not be resolved: Name or service not known
141110 21:35:06 [Warning] IP address '182.254.209.246' could not be resolved: Name or service not known
141111  9:17:32 [Warning] IP address '58.30.20.147' could not be resolved: Name or service not known
141111 11:29:49 [Warning] IP address '117.21.191.195' could not be resolved: Name or service not known
141111 17:44:01 [Warning] IP address '23.19.193.234' has been resolved to the host name '23.19.193.234.rdns.as15003.net', which resembles IPv4-address itself.
141112 17:02:12 [Warning] IP address '122.224.186.190' could not be resolved: Name or service not known
141112 23:16:08 [Warning] IP address '122.224.4.188' could not be resolved: Name or service not known
141113  7:46:09 [Note] /usr/sbin/mysqld: Normal shutdown

141113  7:46:09 [Note] Event Scheduler: Purging the queue. 0 events
141113  7:46:11 [Warning] /usr/sbin/mysqld: Forcing close of thread 17150109  user: 'leechprotect'

141113  7:46:12  InnoDB: Starting shutdown...
141113  7:46:13  InnoDB: Shutdown completed; log sequence number 68758070
141113  7:46:13 [Note] /usr/sbin/mysqld: Shutdown complete

141113 07:46:13 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
141113 07:46:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141113  7:46:30 [Note] Plugin 'FEDERATED' is disabled.
141113  7:46:30 InnoDB: The InnoDB memory heap is disabled
141113  7:46:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141113  7:46:30 InnoDB: Compressed tables use zlib 1.2.3
141113  7:46:30 InnoDB: Using Linux native AIO
141113  7:46:30 InnoDB: Initializing buffer pool, size = 128.0M
141113  7:46:30 InnoDB: Completed initialization of buffer pool
141113  7:46:30 InnoDB: highest supported file format is Barracuda.
141113  7:46:31  InnoDB: Waiting for the background threads to start
141113  7:46:32 InnoDB: 5.5.40 started; log sequence number 68758070
141113  7:46:32 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141113  7:46:32 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141113  7:46:32 [Note] Server socket created on IP: '0.0.0.0'.
141113  7:46:32 [Note] Event Scheduler: Loaded 0 events
141113  7:46:32 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.40-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
141113  7:46:39 [Note] /usr/sbin/mysqld: Normal shutdown

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

141113 07:46:40 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
141113 07:46:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141113  7:46:40 [Note] Plugin 'FEDERATED' is disabled.
141113  7:46:40 InnoDB: The InnoDB memory heap is disabled
141113  7:46:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141113  7:46:40 InnoDB: Compressed tables use zlib 1.2.3
141113  7:46:40 InnoDB: Using Linux native AIO
141113  7:46:40 InnoDB: Initializing buffer pool, size = 128.0M
141113  7:46:40 InnoDB: Completed initialization of buffer pool
141113  7:46:40 InnoDB: highest supported file format is Barracuda.
141113  7:46:41  InnoDB: Waiting for the background threads to start
141113  7:46:42 InnoDB: 5.5.40 started; log sequence number 68758174
141113  7:46:42 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141113  7:46:42 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141113  7:46:42 [Note] Server socket created on IP: '0.0.0.0'.
141113  7:46:42 [Note] Event Scheduler: Loaded 0 events
141113  7:46:42 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.40-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
141113 07:46:52 mysqld_safe A mysqld process already exists
141113 14:32:06 [Warning] IP address '182.254.209.246' could not be resolved: Name or service not known
141113 23:20:31 [Warning] IP address '58.220.238.219' could not be resolved: Name or service not known
141114  2:54:32 [Warning] IP address '122.226.102.37' could not be resolved: Name or service not known
141114  7:05:49 [Warning] IP address '118.193.169.30' could not be resolved: Name or service not known
141114 15:55:29 [Warning] IP address '119.44.222.197' could not be resolved: Name or service not known
141114 23:47:01 [Warning] IP address '58.218.201.17' could not be resolved: Name or service not known
141115  2:49:08 [Warning] IP address '122.226.102.27' could not be resolved: Name or service not known
141115  4:21:36 [Warning] IP address '23.19.193.234' has been resolved to the host name '23.19.193.234.rdns.as15003.net', which resembles IPv4-address itself.
141115 10:13:06 [Warning] IP address '117.21.226.189' could not be resolved: Name or service not known
141115 16:16:05 [Warning] IP address '104.194.20.83' could not be resolved: Name or service not known
141116  2:38:45 [Warning] IP address '61.160.223.71' could not be resolved: Name or service not known
141117  8:24:02 [Warning] IP address '107.150.52.84' could not be resolved: Name or service not known
141117 17:59:05 [Warning] IP address '50.117.116.126' could not be resolved: Name or service not known
141117 18:27:11 [Warning] IP address '122.225.102.186' could not be resolved: Name or service not known
141118 20:42:58 [Warning] IP address '27.54.255.244' could not be resolved: Name or service not known
141120  3:01:07 [Warning] IP address '222.73.254.108' could not be resolved: Name or service not known
141122 21:22:51 [Warning] IP address '203.86.9.5' could not be resolved: Name or service not known
141124  2:12:31 [Note] /usr/sbin/mysqld: Normal shutdown

141124  2:12:31 [Note] Event Scheduler: Purging the queue. 0 events
141124  2:12:33 [Warning] /usr/sbin/mysqld: Forcing close of thread 2569929  user: 'eximstats'

141124  2:12:33 [Warning] /usr/sbin/mysqld: Forcing close of thread 2565929  user: 'leechprotect'

141124  2:12:33  InnoDB: Starting shutdown...
141124  2:12:35  InnoDB: Shutdown completed; log sequence number 77069631
141124  2:12:35 [Note] /usr/sbin/mysqld: Shutdown complete

141124 02:12:35 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
141124 02:12:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141124  2:12:37 [Note] Plugin 'FEDERATED' is disabled.
141124  2:12:37 InnoDB: The InnoDB memory heap is disabled
141124  2:12:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141124  2:12:37 InnoDB: Compressed tables use zlib 1.2.3
141124  2:12:37 InnoDB: Using Linux native AIO
141124  2:12:37 InnoDB: Initializing buffer pool, size = 128.0M
141124  2:12:37 InnoDB: Completed initialization of buffer pool
141124  2:12:37 InnoDB: highest supported file format is Barracuda.
141124  2:12:37  InnoDB: Waiting for the background threads to start
141124  2:12:38 InnoDB: 5.5.40 started; log sequence number 77069631
141124  2:12:38 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141124  2:12:38 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141124  2:12:38 [Note] Server socket created on IP: '0.0.0.0'.
141124  2:12:39 [Note] Event Scheduler: Loaded 0 events
141124  2:12:39 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.40-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
141124  6:22:26 [Warning] IP address '104.194.19.65' could not be resolved: Temporary failure in name resolution
141124  9:14:05 [Warning] IP address '69.147.255.34' has been resolved to the host name '69.147.255.34.rdns.ubiquityservers.com', which resembles IPv4-address itself.
141124 23:23:12 [Warning] IP address '77.29.49.110' could not be resolved: Name or service not known
141125 11:08:15 [Warning] IP address '122.227.228.41' could not be resolved: Name or service not known
141125 20:32:25 [Warning] IP address '182.254.210.91' could not be resolved: Name or service not known
141127  0:20:37 [Warning] IP address '210.212.98.235' could not be resolved: Name or service not known
141127  3:58:21 [Warning] IP address '124.239.208.22' could not be resolved: Name or service not known
141127 13:45:58 [Warning] IP address '119.1.193.215' could not be resolved: Name or service not known
141127 14:27:02 [Warning] IP address '210.209.71.127' could not be resolved: Name or service not known
141127 15:26:15 [Warning] IP address '104.194.19.65' could not be resolved: Temporary failure in name resolution
141127 21:26:32 [Warning] IP address '122.226.102.27' could not be resolved: Name or service not known
141128  7:24:23 [Warning] IP address '198.44.248.213' could not be resolved: Name or service not known
141128 14:24:37 [Warning] IP address '71.40.14.124' could not be resolved: Name or service not known
141128 22:35:06 [Warning] IP address '117.21.226.189' could not be resolved: Name or service not known
141129 17:24:34 [Warning] IP address '61.147.107.66' could not be resolved: Name or service not known
141130 14:31:55 [Warning] IP address '118.244.184.97' could not be resolved: Name or service not known
141130 19:02:04 [Warning] IP address '183.136.205.38' could not be resolved: Name or service not known
141201  4:04:40 [Warning] IP address '221.229.162.78' could not be resolved: Name or service not known
141201 20:56:30 [Warning] IP address '104.194.19.65' could not be resolved: Temporary failure in name resolution
141202 15:25:25 [Warning] IP address '122.0.74.239' could not be resolved: Name or service not known
141203 18:07:37 [Warning] IP address '124.130.133.70' could not be resolved: Name or service not known
141205  4:16:22 [Warning] IP address '171.13.14.11' could not be resolved: Name or service not known
141205  7:22:45 [Warning] IP address '183.136.205.22' could not be resolved: Temporary failure in name resolution
141205  8:36:41 [Warning] IP address '171.13.14.55' could not be resolved: Name or service not known
141206  9:35:12 [Note] /usr/sbin/mysqld: Normal shutdown

141206  9:35:12 [Note] Event Scheduler: Purging the queue. 0 events
141206  9:35:14 [Warning] /usr/sbin/mysqld: Forcing close of thread 5690892  user: 'leechprotect'

141206  9:35:14 [Warning] /usr/sbin/mysqld: Forcing close of thread 5613009  user: 'eximstats'

141206  9:35:15  InnoDB: Starting shutdown...
141206  9:35:44  InnoDB: Shutdown completed; log sequence number 83844661
141206  9:35:45 [Note] /usr/sbin/mysqld: Shutdown complete

141206 09:35:53 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
141206 10:01:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141206 10:01:28 [Note] Plugin 'FEDERATED' is disabled.
141206 10:01:28 InnoDB: The InnoDB memory heap is disabled
141206 10:01:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141206 10:01:28 InnoDB: Compressed tables use zlib 1.2.3
141206 10:01:28 InnoDB: Using Linux native AIO
141206 10:01:28 InnoDB: Initializing buffer pool, size = 128.0M
141206 10:01:28 InnoDB: Completed initialization of buffer pool
141206 10:01:28 InnoDB: highest supported file format is Barracuda.
141206 10:01:30  InnoDB: Waiting for the background threads to start
141206 10:01:31 InnoDB: 5.5.40 started; log sequence number 83844661
141206 10:01:31 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141206 10:01:31 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141206 10:01:31 [Note] Server socket created on IP: '0.0.0.0'.
141206 10:01:31 [Note] Event Scheduler: Loaded 0 events
141206 10:01:31 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.40-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
141206 17:53:20 [Warning] IP address '122.226.102.27' could not be resolved: Name or service not known
141208  3:34:33 [Warning] IP address '183.136.205.38' could not be resolved: Name or service not known
141208 14:49:10 [Warning] IP address '58.218.204.120' could not be resolved: Name or service not known
141209  4:37:53 [Warning] IP address '61.147.107.66' could not be resolved: Name or service not known
141210 16:15:56 [Warning] IP address '117.22.196.39' could not be resolved: Name or service not known
141212 17:00:44 [Warning] IP address '58.220.238.219' could not be resolved: Name or service not known
141213  6:22:51 [Warning] IP address '210.212.98.235' could not be resolved: Name or service not known
141213 11:04:18 [Warning] IP address '159.224.57.168' has been resolved to the host name '168.57.224.159.triolan.net', which resembles IPv4-address itself.
141213 19:44:19 [Warning] IP address '60.169.78.136' could not be resolved: Name or service not known
141213 22:11:34 [Warning] IP address '118.220.226.98' could not be resolved: Name or service not known
141214 12:36:20 [Warning] IP address '122.10.112.23' could not be resolved: Name or service not known
141215 16:26:50 [Warning] IP address '114.113.55.141' could not be resolved: Name or service not known
141216  9:19:22 [Warning] IP address '117.21.226.189' could not be resolved: Name or service not known
141216 19:20:10 [Warning] IP address '58.30.208.148' could not be resolved: Name or service not known
141217 20:22:55 [Warning] IP address '61.147.70.66' could not be resolved: Name or service not known
141218  9:27:59 [Note] /usr/sbin/mysqld: Normal shutdown

141218  9:27:59 [Note] Event Scheduler: Purging the queue. 0 events
141218  9:28:01 [Warning] /usr/sbin/mysqld: Forcing close of thread 2458198  user: 'leechprotect'

141218  9:28:01 [Warning] /usr/sbin/mysqld: Forcing close of thread 2452826  user: 'eximstats'

141218  9:28:02  InnoDB: Starting shutdown...
141218  9:29:17  InnoDB: Shutdown completed; log sequence number 93159079
141218  9:29:17 [Note] /usr/sbin/mysqld: Shutdown complete

141218 09:29:27 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
141218 10:06:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141218 10:06:16 [Note] Plugin 'FEDERATED' is disabled.
141218 10:06:16 InnoDB: The InnoDB memory heap is disabled
141218 10:06:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141218 10:06:16 InnoDB: Compressed tables use zlib 1.2.3
141218 10:06:16 InnoDB: Using Linux native AIO
141218 10:06:17 InnoDB: Initializing buffer pool, size = 128.0M
141218 10:06:17 InnoDB: Completed initialization of buffer pool
141218 10:06:17 InnoDB: highest supported file format is Barracuda.
141218 10:06:18  InnoDB: Waiting for the background threads to start
141218 10:06:19 InnoDB: 5.5.40 started; log sequence number 93159079
141218 10:06:19 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141218 10:06:19 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141218 10:06:19 [Note] Server socket created on IP: '0.0.0.0'.
141218 10:06:20 [Note] Event Scheduler: Loaded 0 events
141218 10:06:20 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.40-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
141218 10:42:19 [Warning] IP address '49.204.119.113' has been resolved to the host name '113.119.204.49-ras.beamtele.net', which resembles IPv4-address itself.
141218 16:04:33 [Warning] IP address '61.147.107.66' could not be resolved: Name or service not known
141218 16:19:08 [Warning] IP address '122.226.102.104' could not be resolved: Name or service not known
141218 16:24:55 [Warning] IP address '159.224.57.168' has been resolved to the host name '168.57.224.159.triolan.net', which resembles IPv4-address itself.
141218 16:56:09 [Warning] IP address '58.20.54.248' could not be resolved: Name or service not known
141219  6:01:11 [Warning] IP address '117.25.148.126' could not be resolved: Name or service not known
141220 21:09:53 [Warning] IP address '118.26.241.222' could not be resolved: Name or service not known
141220 23:18:26 [Warning] IP address '60.19.64.90' could not be resolved: Name or service not known
141221 11:16:39 [Warning] IP address '210.212.98.235' could not be resolved: Name or service not known
141222  5:01:54 [Warning] IP address '222.186.56.82' could not be resolved: Name or service not known
141222  6:39:47 [Warning] IP address '202.104.16.122' could not be resolved: Name or service not known
141223  4:48:10 [Warning] IP address '122.226.102.10' could not be resolved: Name or service not known
141223 20:02:50 [Warning] IP address '211.157.162.43' could not be resolved: Name or service not known
141224  7:43:27 [Warning] IP address '183.61.171.52' could not be resolved: Name or service not known
141224  9:50:16 [Warning] IP address '222.186.34.86' could not be resolved: Name or service not known
141224 13:35:33 [Warning] IP address '121.22.79.35' could not be resolved: Name or service not known
141224 23:06:25 [Warning] IP address '118.193.176.77' could not be resolved: Name or service not known
141224 23:24:01 [Warning] IP address '222.186.34.11' could not be resolved: Name or service not known
141226 11:59:12 [Warning] IP address '117.34.110.35' could not be resolved: Name or service not known
141226 12:38:23 [Warning] IP address '122.227.228.41' could not be resolved: Name or service not known
141226 16:42:32 [Warning] IP address '222.186.56.99' could not be resolved: Name or service not known
141228 22:26:15 [Warning] IP address '202.103.218.166' could not be resolved: Name or service not known
141229  4:30:58 [Warning] IP address '61.240.144.64' could not be resolved: Temporary failure in name resolution
141229 13:27:14 [Warning] IP address '114.215.113.155' could not be resolved: Name or service not known
141229 15:00:10 [Warning] IP address '115.231.222.82' could not be resolved: Name or service not known
150101  2:07:28 [Warning] IP address '180.143.40.165' could not be resolved: Name or service not known
150101  5:39:12 [Warning] IP address '222.186.21.96' could not be resolved: Name or service not known
150101  7:14:30 [Warning] IP address '101.219.255.254' could not be resolved: Name or service not known
150101 13:54:38 [Warning] IP address '122.114.39.206' could not be resolved: Name or service not known
150103 14:04:51 [Warning] IP address '61.147.103.160' could not be resolved: Name or service not known
150103 20:17:30 [Warning] IP address '61.147.103.161' could not be resolved: Name or service not known
150104  1:23:21 [Warning] IP address '182.254.210.147' could not be resolved: Name or service not known
150104 23:50:29 [Warning] IP address '182.254.209.246' could not be resolved: Name or service not known
150105  8:09:54 [Warning] IP address '61.147.103.189' could not be resolved: Name or service not known
150105 15:20:01 [Warning] IP address '60.8.36.142' could not be resolved: Name or service not known
150105 19:47:38 [Warning] IP address '59.46.0.72' has been resolved to the host name '72.0.46.59.broad.sy.ln.dynamic.163data.com.cn', which resembles IPv4-address itself.
150106  9:47:07 [Warning] IP address '218.92.188.226' could not be resolved: Name or service not known
150108  1:36:29 [Warning] IP address '222.186.15.72' could not be resolved: Name or service not known
150108 15:02:40 [Warning] IP address '107.150.52.84' could not be resolved: Name or service not known
150108 19:16:51 [Warning] IP address '221.204.27.12' has been resolved to the host name '12.27.204.221.adsl-pool.sx.cn', which resembles IPv4-address itself.
150108 21:33:23 [Warning] IP address '146.148.219.194' could not be resolved: Name or service not known
150109  0:33:30 [Note] /usr/sbin/mysqld: Normal shutdown

150109  0:33:30 [Note] Event Scheduler: Purging the queue. 0 events
150109  0:33:32 [Warning] /usr/sbin/mysqld: Forcing close of thread 6331409  user: 'leechprotect'

150109  0:33:32  InnoDB: Starting shutdown...
150109  0:33:34  InnoDB: Shutdown completed; log sequence number 99055231
150109  0:33:34 [Note] /usr/sbin/mysqld: Shutdown complete

150109 00:33:34 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
150109 00:33:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-01-09 00:33:53 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-01-09 00:33:53 12468 [Note] Plugin 'FEDERATED' is disabled.
2015-01-09 00:33:53 12468 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-09 00:33:53 12468 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-09 00:33:53 12468 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-09 00:33:53 12468 [Note] InnoDB: Memory barrier is not used
2015-01-09 00:33:53 12468 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-09 00:33:53 12468 [Note] InnoDB: Using Linux native AIO
2015-01-09 00:33:53 12468 [Note] InnoDB: Using CPU crc32 instructions
2015-01-09 00:33:53 12468 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-09 00:33:53 12468 [Note] InnoDB: Completed initialization of buffer pool
2015-01-09 00:33:53 12468 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-09 00:33:54 12468 [Warning] InnoDB: Resizing redo log from 2*320 to 2*3072 pages, LSN=99055231
2015-01-09 00:33:54 12468 [Warning] InnoDB: Starting to delete and rewrite log files.
2015-01-09 00:33:54 12468 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2015-01-09 00:33:54 12468 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2015-01-09 00:33:54 12468 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2015-01-09 00:33:54 12468 [Warning] InnoDB: New log files created, LSN=99055231
2015-01-09 00:33:54 12468 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-09 00:33:54 12468 [Note] InnoDB: Creating tablespace and datafile system tables.
2015-01-09 00:33:54 12468 [Note] InnoDB: Tablespace and datafile system tables created.
2015-01-09 00:33:54 12468 [Note] InnoDB: Waiting for purge to start
2015-01-09 00:33:54 12468 [Note] InnoDB: 5.6.21 started; log sequence number 99055231
2015-01-09 00:33:54 12468 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 312adf90-9797-11e4-a4b0-fa163e2a693a.
2015-01-09 00:33:54 12468 [Note] Server hostname (bind-address): '*'; port: 3306
2015-01-09 00:33:54 12468 [Note] IPv6 is available.
2015-01-09 00:33:54 12468 [Note]   - '::' resolves to '::';
2015-01-09 00:33:54 12468 [Note] Server socket created on IP: '::'.
2015-01-09 00:33:55 12468 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50540, now running 50621. Please use mysql_upgrade to fix this error.
2015-01-09 00:33:55 12468 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50540, now running 50621. Please use mysql_upgrade to fix this error.
2015-01-09 00:33:55 12468 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50540, now running 50621. Please use mysql_upgrade to fix this error.
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50540, now running 50621. Please use mysql_upgrade to fix this error.
2015-01-09 00:33:55 12468 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50540, now running 50621. Please use mysql_upgrade to fix this error.
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50540, now running 50621. Please use mysql_upgrade to fix this error.
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2015-01-09 00:33:55 12468 [Note] Event Scheduler: Loaded 0 events
2015-01-09 00:33:55 12468 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.21'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
150109 00:34:09 mysqld_safe A mysqld process already exists
2015-01-09 00:50:13 12468 [Warning] IP address '122.226.102.10' could not be resolved: Name or service not known
2015-01-09 01:19:14 12468 [Warning] Host name 'rdns-23-236-64-8.aoyouhost.com' could not be resolved: Name or service not known
2015-01-09 03:09:43 12468 [Warning] IP address '61.147.103.161' could not be resolved: Name or service not known
2015-01-09 03:50:16 12468 [Warning] IP address '202.103.218.166' could not be resolved: Name or service not known
2015-01-09 10:12:09 12468 [Warning] Host name 'hn.kd.ny.adsl' could not be resolved: Name or service not known
2015-01-09 13:14:16 12468 [Warning] Host name 'appscan01.sitelock.com' could not be resolved: Name or service not known
2015-01-09 15:11:54 12468 [Warning] IP address '210.212.98.235' could not be resolved: Name or service not known
2015-01-09 17:07:20 12468 [Warning] IP address '61.147.107.66' could not be resolved: Name or service not known
2015-01-09 20:47:35 12468 [Warning] IP address '222.186.21.96' could not be resolved: Name or service not known
2015-01-09 23:06:04 12468 [Warning] IP address '183.136.214.96' could not be resolved: Name or service not known
2015-01-10 08:12:22 12468 [Warning] IP address '115.28.33.118' could not be resolved: Name or service not known
2015-01-11 00:17:18 12468 [Warning] IP address '221.204.27.12' has been resolved to the host name '12.27.204.221.adsl-pool.sx.cn', which resembles IPv4-address itself.
2015-01-11 10:37:19 12468 [Warning] Host name 'hn.kd.ny.adsl' could not be resolved: Name or service not known
2015-01-11 21:49:18 12468 [Note] /usr/sbin/mysqld: Normal shutdown

2015-01-11 21:49:18 12468 [Note] Giving 6 client threads a chance to die gracefully
2015-01-11 21:49:18 12468 [Note] Event Scheduler: Purging the queue. 0 events
2015-01-11 21:49:18 12468 [Note] Shutting down slave threads
2015-01-11 21:49:20 12468 [Note] Forcefully disconnecting 2 remaining clients
2015-01-11 21:49:20 12468 [Warning] /usr/sbin/mysqld: Forcing close of thread 861660  user: 'leechprotect'

2015-01-11 21:49:20 12468 [Warning] /usr/sbin/mysqld: Forcing close of thread 875282  user: 'eximstats'

2015-01-11 21:49:20 12468 [Note] Binlog end
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'partition'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'ARCHIVE'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_METRICS'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_CMP'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_TRX'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'InnoDB'
2015-01-11 21:49:21 12468 [Note] InnoDB: FTS optimize thread exiting.
2015-01-11 21:49:21 12468 [Note] InnoDB: Starting shutdown...
2015-01-11 21:49:23 12468 [Note] InnoDB: Shutdown completed; log sequence number 100125081
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'BLACKHOLE'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'MRG_MYISAM'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'CSV'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'MEMORY'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'MyISAM'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'sha256_password'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'mysql_old_password'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'mysql_native_password'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'binlog'
2015-01-11 21:49:23 12468 [Note] /usr/sbin/mysqld: Shutdown complete

150111 21:49:23 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
150111 21:50:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-01-11 21:50:24 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-01-11 21:50:24 5628 [Note] Plugin 'FEDERATED' is disabled.
2015-01-11 21:50:24 5628 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-11 21:50:24 5628 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-11 21:50:24 5628 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-11 21:50:24 5628 [Note] InnoDB: Memory barrier is not used
2015-01-11 21:50:24 5628 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-11 21:50:24 5628 [Note] InnoDB: Using Linux native AIO
2015-01-11 21:50:24 5628 [Note] InnoDB: Using CPU crc32 instructions
2015-01-11 21:50:24 5628 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-11 21:50:24 5628 [Note] InnoDB: Completed initialization of buffer pool
2015-01-11 21:50:25 5628 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-11 21:50:26 5628 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-11 21:50:27 5628 [Note] InnoDB: Waiting for purge to start
2015-01-11 21:50:27 5628 [Note] InnoDB: 5.6.21 started; log sequence number 100125081
2015-01-11 21:50:27 5628 [Note] Server hostname (bind-address): '*'; port: 3306
2015-01-11 21:50:27 5628 [Note] IPv6 is available.
2015-01-11 21:50:27 5628 [Note]   - '::' resolves to '::';
2015-01-11 21:50:27 5628 [Note] Server socket created on IP: '::'.
2015-01-11 21:50:27 5628 [Note] Event Scheduler: Loaded 0 events
2015-01-11 21:50:27 5628 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.21'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2015-01-11 23:17:03 5628 [Warning] IP address '222.186.21.96' could not be resolved: Name or service not known
2015-01-12 20:23:13 5628 [Warning] IP address '61.160.211.74' could not be resolved: Name or service not known
2015-01-12 21:03:38 5628 [Warning] IP address '198.44.249.18' could not be resolved: Name or service not known
2015-01-13 01:03:28 5628 [Warning] IP address '122.226.102.10' could not be resolved: Name or service not known
[email protected] [~]#

KateH · Jan 12, 2015

top c

Code:

top - 05:50:55 up 1 day,  8:01,  1 user,  load average: 3.48, 5.22, 7.80
Tasks: 223 total,   3 running, 209 sleeping,  11 stopped,   0 zombie
Cpu(s): 45.9%us,  8.1%sy,  0.0%ni, 45.9%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   8059408k total,  7016384k used,  1043024k free,   384216k buffers
Swap:  4194300k total,     8380k used,  4185920k free,  3487680k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                              
10972 csftlorg  20   0  164m  44m 8580 R 86.4  0.6   1:06.33 /usr/bin/php                                                                          
11757 csftlorg  20   0  165m  45m 8520 R 86.4  0.6   1:15.09 /usr/bin/php                                                                          
 5628 mysql     20   0 2835m 485m 7084 S 32.4  6.2 191:33.49 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql
13207 root      20   0 13260 1252  868 R 10.8  0.0   0:00.12 top c                                                                                 
    1 root      20   0 19356 1400 1168 S  0.0  0.0   0:01.86 /sbin/init                                                                            
    2 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kthreadd]                                                                            
    3 root      RT   0     0    0    0 S  0.0  0.0   0:00.32 [migration/0]                                                                         
    4 root      20   0     0    0    0 S  0.0  0.0   0:00.29 [ksoftirqd/0]                                                                         
    5 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 [stopper/0]                                                                           
    6 root      RT   0     0    0    0 S  0.0  0.0   0:00.22 [watchdog/0]                                                                          
    7 root      RT   0     0    0    0 S  0.0  0.0   0:00.19 [migration/1]                                                                         
    8 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 [stopper/1]                                                                           
    9 root      20   0     0    0    0 S  0.0  0.0   0:00.33 [ksoftirqd/1]                                                                         
   10 root      RT   0     0    0    0 S  0.0  0.0   0:00.12 [watchdog/1]                                                                          
   11 root      RT   0     0    0    0 S  0.0  0.0   0:00.40 [migration/2]                                                                         
   12 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 [stopper/2]                                                                           
   13 root      20   0     0    0    0 S  0.0  0.0   0:00.32 [ksoftirqd/2]                                                                         
   14 root      RT   0     0    0    0 S  0.0  0.0   0:00.11 [watchdog/2]

- - - Updated - - -

I also have a mysql log:

Code:

140814 08:41:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140814  8:41:11 [Note] Plugin 'FEDERATED' is disabled.
140814  8:41:11 InnoDB: The InnoDB memory heap is disabled
140814  8:41:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140814  8:41:11 InnoDB: Compressed tables use zlib 1.2.3
140814  8:41:11 InnoDB: Using Linux native AIO
140814  8:41:11 InnoDB: Initializing buffer pool, size = 128.0M
140814  8:41:11 InnoDB: Completed initialization of buffer pool
140814  8:41:11 InnoDB: highest supported file format is Barracuda.
140814  8:41:13  InnoDB: Waiting for the background threads to start
140814  8:41:14 InnoDB: 5.5.37 started; log sequence number 24601796
140814  8:41:14 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140814  8:41:14 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
140814  8:41:14 [Note] Server socket created on IP: '0.0.0.0'.
140814  8:41:14 [Note] Event Scheduler: Loaded 0 events
140814  8:41:14 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.37-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
140814  8:41:20 [Note] /usr/sbin/mysqld: Normal shutdown

140814  8:41:20 [Note] Event Scheduler: Purging the queue. 0 events
140814  8:41:20  InnoDB: Starting shutdown...
140814  8:41:21  InnoDB: Shutdown completed; log sequence number 24601874
140814  8:41:21 [Note] /usr/sbin/mysqld: Shutdown complete

140814 08:41:21 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
140814 08:41:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140814  8:41:21 [Note] Plugin 'FEDERATED' is disabled.
140814  8:41:21 InnoDB: The InnoDB memory heap is disabled
140814  8:41:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140814  8:41:21 InnoDB: Compressed tables use zlib 1.2.3
140814  8:41:21 InnoDB: Using Linux native AIO
140814  8:41:21 InnoDB: Initializing buffer pool, size = 128.0M
140814  8:41:21 InnoDB: Completed initialization of buffer pool
140814  8:41:22 InnoDB: highest supported file format is Barracuda.
140814  8:41:22  InnoDB: Waiting for the background threads to start
140814  8:41:23 InnoDB: 5.5.37 started; log sequence number 24601874
140814  8:41:23 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140814  8:41:23 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
140814  8:41:23 [Note] Server socket created on IP: '0.0.0.0'.
140814  8:41:23 [Note] Event Scheduler: Loaded 0 events
140814  8:41:23 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.37-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
140814 08:41:25 mysqld_safe A mysqld process already exists
140815  7:08:58 [Warning] IP address '61.147.103.160' could not be resolved: Name or service not known
140815 19:42:44 [Warning] IP address '218.6.173.36' could not be resolved: Name or service not known
140816  2:48:37 [Warning] IP address '61.160.195.52' could not be resolved: Name or service not known
140816  6:12:27 [Warning] IP address '180.225.203.220' could not be resolved: Name or service not known
140821  4:45:43 [Warning] IP address '121.40.81.183' could not be resolved: Name or service not known
140822  0:38:54 [Warning] IP address '222.186.10.186' could not be resolved: Name or service not known
140823  1:09:28 [Warning] IP address '118.123.246.140' could not be resolved: Name or service not known
140825  2:15:05 [Warning] IP address '61.147.103.110' could not be resolved: Name or service not known
140825 10:03:29 [Warning] IP address '58.215.176.172' could not be resolved: Name or service not known
140827 14:58:17 [Warning] IP address '61.191.217.249' could not be resolved: Name or service not known
140830 10:55:56 [Warning] IP address '115.47.9.141' could not be resolved: Name or service not known
140830 14:14:21 [Warning] IP address '76.164.228.43' could not be resolved: Name or service not known
140830 16:48:27 [Warning] IP address '115.230.126.174' could not be resolved: Name or service not known
140830 16:54:00 [Warning] IP address '94.100.31.178' has been resolved to the host name '178.31.100.94.in-addr.arpa', which resembles IPv4-address itself.
140831 17:02:20 [Warning] IP address '89.248.166.153' could not be resolved: Name or service not known
140902  1:37:46 [Warning] IP address '14.17.88.35' could not be resolved: Name or service not known
140902 22:44:18 [Warning] IP address '124.156.241.11' could not be resolved: Name or service not known
140904  2:38:24 [Warning] IP address '122.0.114.139' could not be resolved: Name or service not known
140905  3:10:51 [Warning] IP address '124.52.215.244' could not be resolved: Name or service not known
140905 11:34:44 [Warning] IP address '113.204.104.162' could not be resolved: Name or service not known
140906  3:23:50 [Warning] IP address '123.131.52.102' could not be resolved: Name or service not known
140906  6:15:08 [Warning] IP address '221.123.151.60' could not be resolved: Name or service not known
140907 20:38:40 [Warning] IP address '23.244.84.87' has been resolved to the host name '87.84-244-23.rdns.scalabledns.com', which resembles IPv4-address itself.
140908 17:13:05 [Warning] IP address '113.106.98.9' could not be resolved: Name or service not known
140910  1:12:10 [Warning] IP address '222.186.24.10' could not be resolved: Name or service not known
140912 22:27:48 [Warning] IP address '222.186.42.168' could not be resolved: Name or service not known
140913  0:26:13 [Warning] IP address '87.255.38.184' could not be resolved: Name or service not known
140913  6:30:18 [Warning] IP address '117.21.191.18' could not be resolved: Name or service not known
140915  1:05:17 [Warning] IP address '61.176.212.13' could not be resolved: Name or service not known
140916 22:41:49 [Warning] IP address '61.160.213.5' could not be resolved: Name or service not known
140924  2:55:42 [Warning] IP address '117.22.78.72' could not be resolved: Name or service not known
140924 15:30:18 [Warning] IP address '118.123.119.72' could not be resolved: Name or service not known
140925 11:17:43 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:17:56 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:18:07 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:18:15 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:18:25 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:18:36 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:18:41 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:18:51 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:19:02 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:19:10 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:19:16 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:19:26 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:19:36 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:19:45 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:19:56 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:20:06 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:20:12 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:20:22 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:20:32 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:20:42 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:20:51 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140925 11:21:01 [Warning] IP address '104.194.25.131' could not be resolved: Temporary failure in name resolution
140926  3:58:19 [Warning] IP address '118.123.15.72' could not be resolved: Name or service not known
140926  9:00:04 [Warning] IP address '222.186.56.9' could not be resolved: Name or service not known
140927 17:05:50 [Warning] IP address '104.194.20.26' could not be resolved: Temporary failure in name resolution
140929  2:15:20 [Warning] IP address '118.186.71.77' could not be resolved: Temporary failure in name resolution
140930 18:30:13 [Warning] IP address '117.22.196.210' could not be resolved: Name or service not known
141001 15:00:13 [Warning] IP address '117.21.227.237' could not be resolved: Name or service not known
141004 12:52:48 [Warning] IP address '219.129.237.109' could not be resolved: Name or service not known
141006 18:46:03 [Warning] IP address '222.186.59.192' could not be resolved: Name or service not known
141006 21:48:34 [Warning] IP address '202.129.165.21' could not be resolved: Name or service not known
141007  9:09:09 [Warning] IP address '222.180.162.17' could not be resolved: Temporary failure in name resolution
141007 11:24:16 [Warning] IP address '61.132.91.227' could not be resolved: Name or service not known
141007 18:00:55 [Warning] IP address '222.186.10.134' could not be resolved: Name or service not known
141008  8:41:05 [Warning] IP address '210.212.98.234' could not be resolved: Name or service not known
141008 18:49:14 [Warning] IP address '118.193.161.40' could not be resolved: Name or service not known
141008 20:26:04 [Warning] IP address '122.224.34.160' could not be resolved: Name or service not known
141009  6:30:13 [Warning] IP address '117.21.220.253' could not be resolved: Name or service not known
141011  9:32:46 [Warning] IP address '115.231.81.35' could not be resolved: Name or service not known
141011 13:52:02 [Warning] IP address '116.255.152.250' could not be resolved: Temporary failure in name resolution
141011 18:49:07 [Warning] IP address '60.173.9.184' could not be resolved: Name or service not known
141012  5:21:42 [Warning] IP address '104.194.20.27' could not be resolved: Temporary failure in name resolution
141012 14:25:30 [Warning] IP address '58.220.238.219' could not be resolved: Name or service not known
141013 14:16:50 [Warning] IP address '122.227.228.41' could not be resolved: Name or service not known
141014 12:15:25 [Warning] IP address '116.255.170.177' could not be resolved: Temporary failure in name resolution
141015  1:57:46 [Warning] IP address '112.125.126.228' could not be resolved: Name or service not known
141015  6:35:49 [Warning] IP address '96.44.150.196' could not be resolved: Name or service not known
141015  8:19:18 [Warning] IP address '104.194.6.11' could not be resolved: Temporary failure in name resolution
141016 10:28:07 [Warning] IP address '61.136.93.10' has been resolved to the host name '10.93.136.61.ha.cnc', which resembles IPv4-address itself.
141016 16:56:59 [Warning] IP address '104.194.6.11' could not be resolved: Temporary failure in name resolution
141017  0:37:20 [Warning] IP address '104.194.20.90' could not be resolved: Name or service not known
141017  6:37:55 [Warning] IP address '122.224.19.201' could not be resolved: Name or service not known
141019  2:47:46 [Warning] IP address '117.21.173.36' could not be resolved: Name or service not known
141020  2:52:10 [Warning] IP address '61.147.103.83' could not be resolved: Name or service not known
141020  4:37:29 [Warning] IP address '103.30.79.225' could not be resolved: Temporary failure in name resolution
141022 12:36:18 [Warning] IP address '203.86.9.5' could not be resolved: Name or service not known
141027 16:49:05 [Warning] IP address '107.150.52.82' could not be resolved: Name or service not known
141028  7:47:02 [Warning] IP address '107.150.52.83' could not be resolved: Name or service not known
141028 11:21:54 [Warning] IP address '178.150.145.4' has been resolved to the host name '4.145.150.178.triolan.net', which resembles IPv4-address itself.
141028 20:33:50 [Warning] IP address '104.194.20.83' could not be resolved: Name or service not known
141028 21:07:13 [Warning] IP address '58.215.188.130' could not be resolved: Name or service not known
141029 14:24:38 [Warning] IP address '159.224.57.168' has been resolved to the host name '168.57.224.159.triolan.net', which resembles IPv4-address itself.
141103  0:47:47 [Warning] IP address '122.226.102.27' could not be resolved: Name or service not known
141105 19:32:16 [Warning] IP address '119.10.6.211' could not be resolved: Name or service not known
141106  8:45:47 [Warning] IP address '122.226.102.37' could not be resolved: Name or service not known
141107  3:57:26 [Warning] IP address '124.173.70.114' could not be resolved: Name or service not known
141107  8:29:27 [Warning] IP address '60.190.223.251' could not be resolved: Name or service not known
141107 23:53:22 [Warning] IP address '111.39.44.231' could not be resolved: Name or service not known
141108 11:17:31 [Warning] IP address '118.26.201.55' could not be resolved: Name or service not known
141110  6:48:44 [Warning] IP address '115.230.124.4' could not be resolved: Name or service not known
141110 21:35:06 [Warning] IP address '182.254.209.246' could not be resolved: Name or service not known
141111  9:17:32 [Warning] IP address '58.30.20.147' could not be resolved: Name or service not known
141111 11:29:49 [Warning] IP address '117.21.191.195' could not be resolved: Name or service not known
141111 17:44:01 [Warning] IP address '23.19.193.234' has been resolved to the host name '23.19.193.234.rdns.as15003.net', which resembles IPv4-address itself.
141112 17:02:12 [Warning] IP address '122.224.186.190' could not be resolved: Name or service not known
141112 23:16:08 [Warning] IP address '122.224.4.188' could not be resolved: Name or service not known
141113  7:46:09 [Note] /usr/sbin/mysqld: Normal shutdown

- - - Updated - - -

continued mysql log:

Code:

141113  7:46:09 [Note] Event Scheduler: Purging the queue. 0 events
141113  7:46:11 [Warning] /usr/sbin/mysqld: Forcing close of thread 17150109  user: 'leechprotect'

141113  7:46:12  InnoDB: Starting shutdown...
141113  7:46:13  InnoDB: Shutdown completed; log sequence number 68758070
141113  7:46:13 [Note] /usr/sbin/mysqld: Shutdown complete

141113 07:46:13 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
141113 07:46:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141113  7:46:30 [Note] Plugin 'FEDERATED' is disabled.
141113  7:46:30 InnoDB: The InnoDB memory heap is disabled
141113  7:46:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141113  7:46:30 InnoDB: Compressed tables use zlib 1.2.3
141113  7:46:30 InnoDB: Using Linux native AIO
141113  7:46:30 InnoDB: Initializing buffer pool, size = 128.0M
141113  7:46:30 InnoDB: Completed initialization of buffer pool
141113  7:46:30 InnoDB: highest supported file format is Barracuda.
141113  7:46:31  InnoDB: Waiting for the background threads to start
141113  7:46:32 InnoDB: 5.5.40 started; log sequence number 68758070
141113  7:46:32 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141113  7:46:32 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141113  7:46:32 [Note] Server socket created on IP: '0.0.0.0'.
141113  7:46:32 [Note] Event Scheduler: Loaded 0 events
141113  7:46:32 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.40-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
141113  7:46:39 [Note] /usr/sbin/mysqld: Normal shutdown

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

141113 07:46:40 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
141113 07:46:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141113  7:46:40 [Note] Plugin 'FEDERATED' is disabled.
141113  7:46:40 InnoDB: The InnoDB memory heap is disabled
141113  7:46:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141113  7:46:40 InnoDB: Compressed tables use zlib 1.2.3
141113  7:46:40 InnoDB: Using Linux native AIO
141113  7:46:40 InnoDB: Initializing buffer pool, size = 128.0M
141113  7:46:40 InnoDB: Completed initialization of buffer pool
141113  7:46:40 InnoDB: highest supported file format is Barracuda.
141113  7:46:41  InnoDB: Waiting for the background threads to start
141113  7:46:42 InnoDB: 5.5.40 started; log sequence number 68758174
141113  7:46:42 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141113  7:46:42 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141113  7:46:42 [Note] Server socket created on IP: '0.0.0.0'.
141113  7:46:42 [Note] Event Scheduler: Loaded 0 events
141113  7:46:42 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.40-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
141113 07:46:52 mysqld_safe A mysqld process already exists
141113 14:32:06 [Warning] IP address '182.254.209.246' could not be resolved: Name or service not known
141113 23:20:31 [Warning] IP address '58.220.238.219' could not be resolved: Name or service not known
141114  2:54:32 [Warning] IP address '122.226.102.37' could not be resolved: Name or service not known
141114  7:05:49 [Warning] IP address '118.193.169.30' could not be resolved: Name or service not known
141114 15:55:29 [Warning] IP address '119.44.222.197' could not be resolved: Name or service not known
141114 23:47:01 [Warning] IP address '58.218.201.17' could not be resolved: Name or service not known
141115  2:49:08 [Warning] IP address '122.226.102.27' could not be resolved: Name or service not known
141115  4:21:36 [Warning] IP address '23.19.193.234' has been resolved to the host name '23.19.193.234.rdns.as15003.net', which resembles IPv4-address itself.
141115 10:13:06 [Warning] IP address '117.21.226.189' could not be resolved: Name or service not known
141115 16:16:05 [Warning] IP address '104.194.20.83' could not be resolved: Name or service not known
141116  2:38:45 [Warning] IP address '61.160.223.71' could not be resolved: Name or service not known
141117  8:24:02 [Warning] IP address '107.150.52.84' could not be resolved: Name or service not known
141117 17:59:05 [Warning] IP address '50.117.116.126' could not be resolved: Name or service not known
141117 18:27:11 [Warning] IP address '122.225.102.186' could not be resolved: Name or service not known
141118 20:42:58 [Warning] IP address '27.54.255.244' could not be resolved: Name or service not known
141120  3:01:07 [Warning] IP address '222.73.254.108' could not be resolved: Name or service not known
141122 21:22:51 [Warning] IP address '203.86.9.5' could not be resolved: Name or service not known
141124  2:12:31 [Note] /usr/sbin/mysqld: Normal shutdown

141124  2:12:31 [Note] Event Scheduler: Purging the queue. 0 events
141124  2:12:33 [Warning] /usr/sbin/mysqld: Forcing close of thread 2569929  user: 'eximstats'

141124  2:12:33 [Warning] /usr/sbin/mysqld: Forcing close of thread 2565929  user: 'leechprotect'

141124  2:12:33  InnoDB: Starting shutdown...
141124  2:12:35  InnoDB: Shutdown completed; log sequence number 77069631
141124  2:12:35 [Note] /usr/sbin/mysqld: Shutdown complete

141124 02:12:35 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
141124 02:12:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141124  2:12:37 [Note] Plugin 'FEDERATED' is disabled.
141124  2:12:37 InnoDB: The InnoDB memory heap is disabled
141124  2:12:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141124  2:12:37 InnoDB: Compressed tables use zlib 1.2.3
141124  2:12:37 InnoDB: Using Linux native AIO
141124  2:12:37 InnoDB: Initializing buffer pool, size = 128.0M
141124  2:12:37 InnoDB: Completed initialization of buffer pool
141124  2:12:37 InnoDB: highest supported file format is Barracuda.
141124  2:12:37  InnoDB: Waiting for the background threads to start
141124  2:12:38 InnoDB: 5.5.40 started; log sequence number 77069631
141124  2:12:38 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141124  2:12:38 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141124  2:12:38 [Note] Server socket created on IP: '0.0.0.0'.
141124  2:12:39 [Note] Event Scheduler: Loaded 0 events
141124  2:12:39 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.40-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
141124  6:22:26 [Warning] IP address '104.194.19.65' could not be resolved: Temporary failure in name resolution
141124  9:14:05 [Warning] IP address '69.147.255.34' has been resolved to the host name '69.147.255.34.rdns.ubiquityservers.com', which resembles IPv4-address itself.
141124 23:23:12 [Warning] IP address '77.29.49.110' could not be resolved: Name or service not known
141125 11:08:15 [Warning] IP address '122.227.228.41' could not be resolved: Name or service not known
141125 20:32:25 [Warning] IP address '182.254.210.91' could not be resolved: Name or service not known
141127  0:20:37 [Warning] IP address '210.212.98.235' could not be resolved: Name or service not known
141127  3:58:21 [Warning] IP address '124.239.208.22' could not be resolved: Name or service not known
141127 13:45:58 [Warning] IP address '119.1.193.215' could not be resolved: Name or service not known
141127 14:27:02 [Warning] IP address '210.209.71.127' could not be resolved: Name or service not known
141127 15:26:15 [Warning] IP address '104.194.19.65' could not be resolved: Temporary failure in name resolution
141127 21:26:32 [Warning] IP address '122.226.102.27' could not be resolved: Name or service not known
141128  7:24:23 [Warning] IP address '198.44.248.213' could not be resolved: Name or service not known
141128 14:24:37 [Warning] IP address '71.40.14.124' could not be resolved: Name or service not known
141128 22:35:06 [Warning] IP address '117.21.226.189' could not be resolved: Name or service not known
141129 17:24:34 [Warning] IP address '61.147.107.66' could not be resolved: Name or service not known
141130 14:31:55 [Warning] IP address '118.244.184.97' could not be resolved: Name or service not known
141130 19:02:04 [Warning] IP address '183.136.205.38' could not be resolved: Name or service not known
141201  4:04:40 [Warning] IP address '221.229.162.78' could not be resolved: Name or service not known
141201 20:56:30 [Warning] IP address '104.194.19.65' could not be resolved: Temporary failure in name resolution
141202 15:25:25 [Warning] IP address '122.0.74.239' could not be resolved: Name or service not known
141203 18:07:37 [Warning] IP address '124.130.133.70' could not be resolved: Name or service not known
141205  4:16:22 [Warning] IP address '171.13.14.11' could not be resolved: Name or service not known
141205  7:22:45 [Warning] IP address '183.136.205.22' could not be resolved: Temporary failure in name resolution
141205  8:36:41 [Warning] IP address '171.13.14.55' could not be resolved: Name or service not known
141206  9:35:12 [Note] /usr/sbin/mysqld: Normal shutdown

141206  9:35:12 [Note] Event Scheduler: Purging the queue. 0 events
141206  9:35:14 [Warning] /usr/sbin/mysqld: Forcing close of thread 5690892  user: 'leechprotect'

141206  9:35:14 [Warning] /usr/sbin/mysqld: Forcing close of thread 5613009  user: 'eximstats'

141206  9:35:15  InnoDB: Starting shutdown...
141206  9:35:44  InnoDB: Shutdown completed; log sequence number 83844661
141206  9:35:45 [Note] /usr/sbin/mysqld: Shutdown complete

141206 09:35:53 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
141206 10:01:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141206 10:01:28 [Note] Plugin 'FEDERATED' is disabled.
141206 10:01:28 InnoDB: The InnoDB memory heap is disabled
141206 10:01:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141206 10:01:28 InnoDB: Compressed tables use zlib 1.2.3
141206 10:01:28 InnoDB: Using Linux native AIO
141206 10:01:28 InnoDB: Initializing buffer pool, size = 128.0M
141206 10:01:28 InnoDB: Completed initialization of buffer pool
141206 10:01:28 InnoDB: highest supported file format is Barracuda.
141206 10:01:30  InnoDB: Waiting for the background threads to start
141206 10:01:31 InnoDB: 5.5.40 started; log sequence number 83844661
141206 10:01:31 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141206 10:01:31 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141206 10:01:31 [Note] Server socket created on IP: '0.0.0.0'.
141206 10:01:31 [Note] Event Scheduler: Loaded 0 events
141206 10:01:31 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.40-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
141206 17:53:20 [Warning] IP address '122.226.102.27' could not be resolved: Name or service not known
141208  3:34:33 [Warning] IP address '183.136.205.38' could not be resolved: Name or service not known
141208 14:49:10 [Warning] IP address '58.218.204.120' could not be resolved: Name or service not known
141209  4:37:53 [Warning] IP address '61.147.107.66' could not be resolved: Name or service not known
141210 16:15:56 [Warning] IP address '117.22.196.39' could not be resolved: Name or service not known
141212 17:00:44 [Warning] IP address '58.220.238.219' could not be resolved: Name or service not known
141213  6:22:51 [Warning] IP address '210.212.98.235' could not be resolved: Name or service not known
141213 11:04:18 [Warning] IP address '159.224.57.168' has been resolved to the host name '168.57.224.159.triolan.net', which resembles IPv4-address itself.
141213 19:44:19 [Warning] IP address '60.169.78.136' could not be resolved: Name or service not known
141213 22:11:34 [Warning] IP address '118.220.226.98' could not be resolved: Name or service not known
141214 12:36:20 [Warning] IP address '122.10.112.23' could not be resolved: Name or service not known
141215 16:26:50 [Warning] IP address '114.113.55.141' could not be resolved: Name or service not known
141216  9:19:22 [Warning] IP address '117.21.226.189' could not be resolved: Name or service not known
141216 19:20:10 [Warning] IP address '58.30.208.148' could not be resolved: Name or service not known
141217 20:22:55 [Warning] IP address '61.147.70.66' could not be resolved: Name or service not known
141218  9:27:59 [Note] /usr/sbin/mysqld: Normal shutdown

141218  9:27:59 [Note] Event Scheduler: Purging the queue. 0 events
141218  9:28:01 [Warning] /usr/sbin/mysqld: Forcing close of thread 2458198  user: 'leechprotect'

141218  9:28:01 [Warning] /usr/sbin/mysqld: Forcing close of thread 2452826  user: 'eximstats'

141218  9:28:02  InnoDB: Starting shutdown...
141218  9:29:17  InnoDB: Shutdown completed; log sequence number 93159079
141218  9:29:17 [Note] /usr/sbin/mysqld: Shutdown complete

141218 09:29:27 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
141218 10:06:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141218 10:06:16 [Note] Plugin 'FEDERATED' is disabled.
141218 10:06:16 InnoDB: The InnoDB memory heap is disabled
141218 10:06:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141218 10:06:16 InnoDB: Compressed tables use zlib 1.2.3
141218 10:06:16 InnoDB: Using Linux native AIO
141218 10:06:17 InnoDB: Initializing buffer pool, size = 128.0M
141218 10:06:17 InnoDB: Completed initialization of buffer pool
141218 10:06:17 InnoDB: highest supported file format is Barracuda.
141218 10:06:18  InnoDB: Waiting for the background threads to start
141218 10:06:19 InnoDB: 5.5.40 started; log sequence number 93159079
141218 10:06:19 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141218 10:06:19 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141218 10:06:19 [Note] Server socket created on IP: '0.0.0.0'.
141218 10:06:20 [Note] Event Scheduler: Loaded 0 events
141218 10:06:20 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.40-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
141218 10:42:19 [Warning] IP address '49.204.119.113' has been resolved to the host name '113.119.204.49-ras.beamtele.net', which resembles IPv4-address itself.
141218 16:04:33 [Warning] IP address '61.147.107.66' could not be resolved: Name or service not known
141218 16:19:08 [Warning] IP address '122.226.102.104' could not be resolved: Name or service not known
141218 16:24:55 [Warning] IP address '159.224.57.168' has been resolved to the host name '168.57.224.159.triolan.net', which resembles IPv4-address itself.
141218 16:56:09 [Warning] IP address '58.20.54.248' could not be resolved: Name or service not known
141219  6:01:11 [Warning] IP address '117.25.148.126' could not be resolved: Name or service not known
141220 21:09:53 [Warning] IP address '118.26.241.222' could not be resolved: Name or service not known
141220 23:18:26 [Warning] IP address '60.19.64.90' could not be resolved: Name or service not known
141221 11:16:39 [Warning] IP address '210.212.98.235' could not be resolved: Name or service not known
141222  5:01:54 [Warning] IP address '222.186.56.82' could not be resolved: Name or service not known
141222  6:39:47 [Warning] IP address '202.104.16.122' could not be resolved: Name or service not known
141223  4:48:10 [Warning] IP address '122.226.102.10' could not be resolved: Name or service not known
141223 20:02:50 [Warning] IP address '211.157.162.43' could not be resolved: Name or service not known
141224  7:43:27 [Warning] IP address '183.61.171.52' could not be resolved: Name or service not known
141224  9:50:16 [Warning] IP address '222.186.34.86' could not be resolved: Name or service not known
141224 13:35:33 [Warning] IP address '121.22.79.35' could not be resolved: Name or service not known
141224 23:06:25 [Warning] IP address '118.193.176.77' could not be resolved: Name or service not known
141224 23:24:01 [Warning] IP address '222.186.34.11' could not be resolved: Name or service not known
141226 11:59:12 [Warning] IP address '117.34.110.35' could not be resolved: Name or service not known
141226 12:38:23 [Warning] IP address '122.227.228.41' could not be resolved: Name or service not known
141226 16:42:32 [Warning] IP address '222.186.56.99' could not be resolved: Name or service not known
141228 22:26:15 [Warning] IP address '202.103.218.166' could not be resolved: Name or service not known
141229  4:30:58 [Warning] IP address '61.240.144.64' could not be resolved: Temporary failure in name resolution
141229 13:27:14 [Warning] IP address '114.215.113.155' could not be resolved: Name or service not known
141229 15:00:10 [Warning] IP address '115.231.222.82' could not be resolved: Name or service not known
150101  2:07:28 [Warning] IP address '180.143.40.165' could not be resolved: Name or service not known
150101  5:39:12 [Warning] IP address '222.186.21.96' could not be resolved: Name or service not known
150101  7:14:30 [Warning] IP address '101.219.255.254' could not be resolved: Name or service not known
150101 13:54:38 [Warning] IP address '122.114.39.206' could not be resolved: Name or service not known
150103 14:04:51 [Warning] IP address '61.147.103.160' could not be resolved: Name or service not known
150103 20:17:30 [Warning] IP address '61.147.103.161' could not be resolved: Name or service not known
150104  1:23:21 [Warning] IP address '182.254.210.147' could not be resolved: Name or service not known
150104 23:50:29 [Warning] IP address '182.254.209.246' could not be resolved: Name or service not known
150105  8:09:54 [Warning] IP address '61.147.103.189' could not be resolved: Name or service not known
150105 15:20:01 [Warning] IP address '60.8.36.142' could not be resolved: Name or service not known
150105 19:47:38 [Warning] IP address '59.46.0.72' has been resolved to the host name '72.0.46.59.broad.sy.ln.dynamic.163data.com.cn', which resembles IPv4-address itself.
150106  9:47:07 [Warning] IP address '218.92.188.226' could not be resolved: Name or service not known
150108  1:36:29 [Warning] IP address '222.186.15.72' could not be resolved: Name or service not known
150108 15:02:40 [Warning] IP address '107.150.52.84' could not be resolved: Name or service not known
150108 19:16:51 [Warning] IP address '221.204.27.12' has been resolved to the host name '12.27.204.221.adsl-pool.sx.cn', which resembles IPv4-address itself.
150108 21:33:23 [Warning] IP address '146.148.219.194' could not be resolved: Name or service not known
150109  0:33:30 [Note] /usr/sbin/mysqld: Normal shutdown

150109  0:33:30 [Note] Event Scheduler: Purging the queue. 0 events
150109  0:33:32 [Warning] /usr/sbin/mysqld: Forcing close of thread 6331409  user: 'leechprotect'

150109  0:33:32  InnoDB: Starting shutdown...
150109  0:33:34  InnoDB: Shutdown completed; log sequence number 99055231
150109  0:33:34 [Note] /usr/sbin/mysqld: Shutdown complete

150109 00:33:34 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
150109 00:33:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-01-09 00:33:53 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-01-09 00:33:53 12468 [Note] Plugin 'FEDERATED' is disabled.
2015-01-09 00:33:53 12468 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-09 00:33:53 12468 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-09 00:33:53 12468 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-09 00:33:53 12468 [Note] InnoDB: Memory barrier is not used
2015-01-09 00:33:53 12468 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-09 00:33:53 12468 [Note] InnoDB: Using Linux native AIO
2015-01-09 00:33:53 12468 [Note] InnoDB: Using CPU crc32 instructions
2015-01-09 00:33:53 12468 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-09 00:33:53 12468 [Note] InnoDB: Completed initialization of buffer pool
2015-01-09 00:33:53 12468 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-09 00:33:54 12468 [Warning] InnoDB: Resizing redo log from 2*320 to 2*3072 pages, LSN=99055231
2015-01-09 00:33:54 12468 [Warning] InnoDB: Starting to delete and rewrite log files.
2015-01-09 00:33:54 12468 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2015-01-09 00:33:54 12468 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2015-01-09 00:33:54 12468 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2015-01-09 00:33:54 12468 [Warning] InnoDB: New log files created, LSN=99055231
2015-01-09 00:33:54 12468 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-09 00:33:54 12468 [Note] InnoDB: Creating tablespace and datafile system tables.
2015-01-09 00:33:54 12468 [Note] InnoDB: Tablespace and datafile system tables created.
2015-01-09 00:33:54 12468 [Note] InnoDB: Waiting for purge to start
2015-01-09 00:33:54 12468 [Note] InnoDB: 5.6.21 started; log sequence number 99055231
2015-01-09 00:33:54 12468 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 312adf90-9797-11e4-a4b0-fa163e2a693a.
2015-01-09 00:33:54 12468 [Note] Server hostname (bind-address): '*'; port: 3306
2015-01-09 00:33:54 12468 [Note] IPv6 is available.
2015-01-09 00:33:54 12468 [Note]   - '::' resolves to '::';
2015-01-09 00:33:54 12468 [Note] Server socket created on IP: '::'.
2015-01-09 00:33:55 12468 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50540, now running 50621. Please use mysql_upgrade to fix this error.
2015-01-09 00:33:55 12468 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50540, now running 50621. Please use mysql_upgrade to fix this error.
2015-01-09 00:33:55 12468 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50540, now running 50621. Please use mysql_upgrade to fix this error.
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50540, now running 50621. Please use mysql_upgrade to fix this error.
2015-01-09 00:33:55 12468 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50540, now running 50621. Please use mysql_upgrade to fix this error.
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50540, now running 50621. Please use mysql_upgrade to fix this error.
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2015-01-09 00:33:55 12468 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2015-01-09 00:33:55 12468 [Note] Event Scheduler: Loaded 0 events
2015-01-09 00:33:55 12468 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.21'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
150109 00:34:09 mysqld_safe A mysqld process already exists
2015-01-09 00:50:13 12468 [Warning] IP address '122.226.102.10' could not be resolved: Name or service not known
2015-01-09 01:19:14 12468 [Warning] Host name 'rdns-23-236-64-8.aoyouhost.com' could not be resolved: Name or service not known
2015-01-09 03:09:43 12468 [Warning] IP address '61.147.103.161' could not be resolved: Name or service not known
2015-01-09 03:50:16 12468 [Warning] IP address '202.103.218.166' could not be resolved: Name or service not known
2015-01-09 10:12:09 12468 [Warning] Host name 'hn.kd.ny.adsl' could not be resolved: Name or service not known
2015-01-09 13:14:16 12468 [Warning] Host name 'appscan01.sitelock.com' could not be resolved: Name or service not known
2015-01-09 15:11:54 12468 [Warning] IP address '210.212.98.235' could not be resolved: Name or service not known
2015-01-09 17:07:20 12468 [Warning] IP address '61.147.107.66' could not be resolved: Name or service not known
2015-01-09 20:47:35 12468 [Warning] IP address '222.186.21.96' could not be resolved: Name or service not known
2015-01-09 23:06:04 12468 [Warning] IP address '183.136.214.96' could not be resolved: Name or service not known
2015-01-10 08:12:22 12468 [Warning] IP address '115.28.33.118' could not be resolved: Name or service not known
2015-01-11 00:17:18 12468 [Warning] IP address '221.204.27.12' has been resolved to the host name '12.27.204.221.adsl-pool.sx.cn', which resembles IPv4-address itself.
2015-01-11 10:37:19 12468 [Warning] Host name 'hn.kd.ny.adsl' could not be resolved: Name or service not known
2015-01-11 21:49:18 12468 [Note] /usr/sbin/mysqld: Normal shutdown

2015-01-11 21:49:18 12468 [Note] Giving 6 client threads a chance to die gracefully
2015-01-11 21:49:18 12468 [Note] Event Scheduler: Purging the queue. 0 events
2015-01-11 21:49:18 12468 [Note] Shutting down slave threads
2015-01-11 21:49:20 12468 [Note] Forcefully disconnecting 2 remaining clients
2015-01-11 21:49:20 12468 [Warning] /usr/sbin/mysqld: Forcing close of thread 861660  user: 'leechprotect'

2015-01-11 21:49:20 12468 [Warning] /usr/sbin/mysqld: Forcing close of thread 875282  user: 'eximstats'

2015-01-11 21:49:20 12468 [Note] Binlog end
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'partition'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'ARCHIVE'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_METRICS'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_CMP'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'INNODB_TRX'
2015-01-11 21:49:21 12468 [Note] Shutting down plugin 'InnoDB'
2015-01-11 21:49:21 12468 [Note] InnoDB: FTS optimize thread exiting.
2015-01-11 21:49:21 12468 [Note] InnoDB: Starting shutdown...
2015-01-11 21:49:23 12468 [Note] InnoDB: Shutdown completed; log sequence number 100125081
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'BLACKHOLE'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'MRG_MYISAM'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'CSV'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'MEMORY'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'MyISAM'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'sha256_password'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'mysql_old_password'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'mysql_native_password'
2015-01-11 21:49:23 12468 [Note] Shutting down plugin 'binlog'
2015-01-11 21:49:23 12468 [Note] /usr/sbin/mysqld: Shutdown complete

150111 21:49:23 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
150111 21:50:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-01-11 21:50:24 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-01-11 21:50:24 5628 [Note] Plugin 'FEDERATED' is disabled.
2015-01-11 21:50:24 5628 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-11 21:50:24 5628 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-11 21:50:24 5628 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-11 21:50:24 5628 [Note] InnoDB: Memory barrier is not used
2015-01-11 21:50:24 5628 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-11 21:50:24 5628 [Note] InnoDB: Using Linux native AIO
2015-01-11 21:50:24 5628 [Note] InnoDB: Using CPU crc32 instructions
2015-01-11 21:50:24 5628 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-11 21:50:24 5628 [Note] InnoDB: Completed initialization of buffer pool
2015-01-11 21:50:25 5628 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-11 21:50:26 5628 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-11 21:50:27 5628 [Note] InnoDB: Waiting for purge to start
2015-01-11 21:50:27 5628 [Note] InnoDB: 5.6.21 started; log sequence number 100125081
2015-01-11 21:50:27 5628 [Note] Server hostname (bind-address): '*'; port: 3306
2015-01-11 21:50:27 5628 [Note] IPv6 is available.
2015-01-11 21:50:27 5628 [Note]   - '::' resolves to '::';
2015-01-11 21:50:27 5628 [Note] Server socket created on IP: '::'.
2015-01-11 21:50:27 5628 [Note] Event Scheduler: Loaded 0 events
2015-01-11 21:50:27 5628 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.21'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2015-01-11 23:17:03 5628 [Warning] IP address '222.186.21.96' could not be resolved: Name or service not known
2015-01-12 20:23:13 5628 [Warning] IP address '61.160.211.74' could not be resolved: Name or service not known
2015-01-12 21:03:38 5628 [Warning] IP address '198.44.249.18' could not be resolved: Name or service not known
2015-01-13 01:03:28 5628 [Warning] IP address '122.226.102.10' could not be resolved: Name or service not known

Thread starter	Similar threads	Forum	Replies	Date
U	Help - optimize mysqltunner to reduce high cpu usage	Workarounds and Optimization	5	Nov 14, 2016
H	Optitmize MySQL Configuration to reduce CPU usage	Workarounds and Optimization	3	Sep 14, 2016
W	rsync - reduce server load on receiving end	Workarounds and Optimization	3	Aug 5, 2012
R	Reduce CPhulk From Eating Many Of Server Resource	Workarounds and Optimization	1	May 18, 2011
	Will moving Mysql to another server reduce load?	Workarounds and Optimization	3	Jan 17, 2011

Search

Search

Reduce server load

KateH

Registered

secureconfig

Member

Infopro

Well-Known Member

KateH

Registered

mageshm

Well-Known Member

KateH

Registered

KateH

Registered