[root@localhost bin]# mysql -uroot -proot Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 20046 Server version: 5.5.56-MariaDB MariaDB Server Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> show full processlist; +-------+-----------------+---------------------+------+---------+------+-----------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +-------+-----------------+---------------------+------+---------+------+-----------------------------+-----------------------+----------+ | 1 | event_scheduler | localhost | NULL | Daemon | 435 | Waiting for next activation | NULL | 0.000 | | 18421 | root | 10.153.49.103:54693 | plat | Sleep | 664 | | NULL | 0.000 | | 19581 | root | 10.88.44.132:61197 | NULL | Sleep | 3568 | | NULL | 0.000 | | 19738 | root | localhost:55688 | plat | Sleep | 19 | | NULL | 0.000 | | 19739 | root | localhost:55689 | plat | Sleep | 19 | | NULL | 0.000 | | 19790 | root | localhost:55704 | plat | Sleep | 19 | | NULL | 0.000 | | 19908 | root | localhost:55719 | plat | Sleep | 19 | | NULL | 0.000 | | 19909 | root | localhost:55720 | plat | Sleep | 19 | | NULL | 0.000 | | 19930 | root | 10.153.49.103:61645 | plat | Sleep | 27 | | NULL | 0.000 | | 19967 | root | 10.153.49.103:61748 | plat | Sleep | 27 | | NULL | 0.000 | | 19983 | root | localhost:55729 | plat | Sleep | 19 | | NULL | 0.000 | | 19984 | root | localhost:55730 | plat | Sleep | 19 | | NULL | 0.000 | | 19985 | root | localhost:55731 | plat | Sleep | 19 | | NULL | 0.000 | | 19986 | root | localhost:55732 | plat | Sleep | 19 | | NULL | 0.000 | | 20006 | root | 10.153.49.103:61891 | plat | Sleep | 0 | | NULL | 0.000 | | 20029 | root | 10.153.49.103:62025 | plat | Sleep | 0 | | NULL | 0.000 | | 20044 | root | localhost:55741 | plat | Sleep | 1 | | NULL | 0.000 | | 20046 | root | localhost | NULL | Query | 0 | NULL | show full processlist | 0.000 | +-------+-----------------+---------------------+------+---------+------+-----------------------------+-----------------------+----------+ 18 rows in set (0.00 sec) MariaDB [(none)]> show full processlist; +-------+-----------------+---------------------+------+---------+------+-----------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +-------+-----------------+---------------------+------+---------+------+-----------------------------+-----------------------+----------+ | 1 | event_scheduler | localhost | NULL | Daemon | 159 | Waiting for next activation | NULL | 0.000 | | 18421 | root | 10.153.49.103:54693 | plat | Sleep | 988 | | NULL | 0.000 | | 19581 | root | 10.88.44.132:61197 | NULL | Sleep | 3892 | | NULL | 0.000 | | 19738 | root | localhost:55688 | plat | Sleep | 43 | | NULL | 0.000 | | 19739 | root | localhost:55689 | plat | Sleep | 43 | | NULL | 0.000 | | 19790 | root | localhost:55704 | plat | Sleep | 43 | | NULL | 0.000 | | 19908 | root | localhost:55719 | plat | Sleep | 43 | | NULL | 0.000 | | 19909 | root | localhost:55720 | plat | Sleep | 43 | | NULL | 0.000 | | 19930 | root | 10.153.49.103:61645 | plat | Sleep | 51 | | NULL | 0.000 | | 19967 | root | 10.153.49.103:61748 | plat | Sleep | 51 | | NULL | 0.000 | | 19983 | root | localhost:55729 | plat | Sleep | 43 | | NULL | 0.000 | | 19984 | root | localhost:55730 | plat | Sleep | 43 | | NULL | 0.000 | | 19985 | root | localhost:55731 | plat | Sleep | 43 | | NULL | 0.000 | | 19986 | root | localhost:55732 | plat | Sleep | 2 | | NULL | 0.000 | | 20006 | root | 10.153.49.103:61891 | plat | Sleep | 17 | | NULL | 0.000 | | 20029 | root | 10.153.49.103:62025 | plat | Sleep | 18 | | NULL | 0.000 | | 20044 | root | localhost:55741 | plat | Sleep | 43 | | NULL | 0.000 | | 20046 | root | localhost | NULL | Query | 0 | NULL | show full processlist | 0.000 | +-------+-----------------+---------------------+------+---------+------+-----------------------------+-----------------------+----------+ 18 rows in set (0.01 sec) MariaDB [(none)]> Ctrl-C -- exit! Aborted You have new mail in /var/spool/mail/root [root@localhost bin]# top top - 01:52:48 up 82 days, 8:16, 5 users, load average: 246.70, 246.91, 246.91 Tasks: 240 total, 1 running, 239 sleeping, 0 stopped, 0 zombie Cpu(s): 36.6%us, 0.2%sy, 0.0%ni, 63.2%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 16267212k total, 16100152k used, 167060k free, 81580k buffers Swap: 8388600k total, 1088788k used, 7299812k free, 895092k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 481 mysql 20 0 1705m 463m 6080 S 672.8 2.9 16729:47 mysqld 28121 root 20 0 17.9g 8.9g 7124 S 1.3 57.4 66:06.93 java 1 root 20 0 19324 968 748 S 0.0 0.0 2:23.22 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:10.15 migration/0 4 root 20 0 0 0 0 S 0.0 0.0 0:38.93 ksoftirqd/0 5 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0 6 root RT 0 0 0 0 S 0.0 0.0 0:05.11 watchdog/0 7 root RT 0 0 0 0 S 0.0 0.0 0:09.21 migration/1 8 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/1 9 root 20 0 0 0 0 S 0.0 0.0 0:52.78 ksoftirqd/1 10 root RT 0 0 0 0 S 0.0 0.0 0:04.59 watchdog/1 11 root RT 0 0 0 0 S 0.0 0.0 0:08.73 migration/2 12 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/2 13 root 20 0 0 0 0 S 0.0 0.0 0:46.71 ksoftirqd/2 14 root RT 0 0 0 0 S 0.0 0.0 0:03.87 watchdog/2 15 root RT 0 0 0 0 S 0.0 0.0 0:08.60 migration/3 16 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/3 17 root 20 0 0 0 0 S 0.0 0.0 0:37.18 ksoftirqd/3 18 root RT 0 0 0 0 S 0.0 0.0 0:03.72 watchdog/3 19 root RT 0 0 0 0 S 0.0 0.0 0:09.80 migration/4 20 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/4 21 root 20 0 0 0 0 S 0.0 0.0 0:46.54 ksoftirqd/4 22 root RT 0 0 0 0 S 0.0 0.0 0:03.96 watchdog/4 23 root RT 0 0 0 0 S 0.0 0.0 0:08.48 migration/5 24 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/5 25 root 20 0 0 0 0 S 0.0 0.0 0:35.15 ksoftirqd/5 26 root RT 0 0 0 0 S 0.0 0.0 0:03.63 watchdog/5 27 root RT 0 0 0 0 S 0.0 0.0 0:08.37 migration/6 28 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/6 29 root 20 0 0 0 0 S 0.0 0.0 0:45.04 ksoftirqd/6 30 root RT 0 0 0 0 S 0.0 0.0 0:03.69 watchdog/6 31 root RT 0 0 0 0 S 0.0 0.0 0:10.05 migration/7 32 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/7 33 root 20 0 0 0 0 S 0.0 0.0 0:35.46 ksoftirqd/7 34 root RT 0 0 0 0 S 0.0 0.0 0:03.97 watchdog/7 35 root 20 0 0 0 0 S 0.0 0.0 2:32.05 events/0 36 root 20 0 0 0 0 S 0.0 0.0 2:22.09 events/1 37 root 20 0 0 0 0 S 0.0 0.0 2:29.98 events/2 38 root 20 0 0 0 0 S 0.0 0.0 2:32.21 events/3 top - 01:52:51 up 82 days, 8:16, 5 users, load average: 246.72, 246.91, 246.91 Tasks: 240 total, 1 running, 239 sleeping, 0 stopped, 0 zombie Cpu(s): 99.7%us, 0.2%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 16267212k total, 16099168k used, 168044k free, 81584k buffers Swap: 8388600k total, 1088788k used, 7299812k free, 895112k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 481 mysql 20 0 1705m 462m 6080 S 797.9 2.9 16730:11 mysqld 19534 root 20 0 6349m 1.8g 22m S 1.0 11.9 36:12.63 java 28121 root 20 0 17.9g 8.9g 7124 S 0.7 57.4 66:06.95 java 14657 root 20 0 6343m 1.6g 6532 S 0.3 10.2 4:31.30 java 20143 root 20 0 15136 1324 920 R 0.3 0.0 0:00.01 top 1 root 20 0 19324 968 748 S 0.0 0.0 2:23.22 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:10.15 migration/0 4 root 20 0 0 0 0 S 0.0 0.0 0:38.93 ksoftirqd/0 5 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0 6 root RT 0 0 0 0 S 0.0 0.0 0:05.11 watchdog/0 7 root RT 0 0 0 0 S 0.0 0.0 0:09.21 migration/1 8 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/1 9 root 20 0 0 0 0 S 0.0 0.0 0:52.78 ksoftirqd/1 10 root RT 0 0 0 0 S 0.0 0.0 0:04.59 watchdog/1 11 root RT 0 0 0 0 S 0.0 0.0 0:08.73 migration/2 12 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/2 13 root 20 0 0 0 0 S 0.0 0.0 0:46.71 ksoftirqd/2 14 root RT 0 0 0 0 S 0.0 0.0 0:03.87 watchdog/2 15 root RT 0 0 0 0 S 0.0 0.0 0:08.60 migration/3 16 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/3 17 root 20 0 0 0 0 S 0.0 0.0 0:37.18 ksoftirqd/3 18 root RT 0 0 0 0 S 0.0 0.0 0:03.72 watchdog/3 19 root RT 0 0 0 0 S 0.0 0.0 0:09.80 migration/4 20 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/4 21 root 20 0 0 0 0 S 0.0 0.0 0:46.54 ksoftirqd/4 22 root RT 0 0 0 0 S 0.0 0.0 0:03.96 watchdog/4 23 root RT 0 0 0 0 S 0.0 0.0 0:08.48 migration/5 24 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/5 25 root 20 0 0 0 0 S 0.0 0.0 0:35.15 ksoftirqd/5 26 root RT 0 0 0 0 S 0.0 0.0 0:03.63 watchdog/5 27 root RT 0 0 0 0 S 0.0 0.0 0:08.37 migration/6 28 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/6 29 root 20 0 0 0 0 S 0.0 0.0 0:45.04 ksoftirqd/6 30 root RT 0 0 0 0 S 0.0 0.0 0:03.69 watchdog/6 31 root RT 0 0 0 0 S 0.0 0.0 0:10.05 migration/7 32 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/7 33 root 20 0 0 0 0 S 0.0 0.0 0:35.46 ksoftirqd/7 34 root RT 0 0 0 0 S 0.0 0.0 0:03.97 watchdog/7 35 root 20 0 0 0 0 S 0.0 0.0 2:32.05 events/0 36 root 20 0 0 0 0 S 0.0 0.0 2:22.09 events/1 [root@localhost bin]# lsb_release -a LSB Version: :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch Distributor ID: CentOS Description: CentOS release 6.5 (Final) Release: 6.5 Codename: Final