Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.13, 10.0(EOL), 10.1(EOL)
-
None
-
CentOS 6.5 64-bit, Intel(R) Core(TM) i7-3930K CPU @ 3.20GHz, 64 GB DDR3 1333 MHz, 2x 240 GB SSD in S/W RAID1
-
10.0.25
Description
Hello,
I found out that my MariaDB server is using my CPU 100% non-stop !
It's completely idle:
MariaDB [(none)]> show processlist;
|
+--------+-----------------+-----------------+-----------------+---------+------+-------+------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+--------+-----------------+-----------------+-----------------+---------+------+-------+------------------+----------+
|
| 12 | powerdns | localhost:24535 | powerdns | Sleep | 9 | | NULL | 0.000 |
|
| 13 | powerdns | localhost:24537 | powerdns | Sleep | 9 | | NULL | 0.000 |
|
| 14 | powerdns | localhost:24538 | powerdns | Sleep | 10 | | NULL | 0.000 |
|
| 39 | powerdns | localhost:24594 | powerdns | Sleep | 16 | | NULL | 0.000 |
|
| 594049 | msbkm_superocen | localhost | msbkm_superocen | Sleep | 125 | | NULL | 0.000 |
|
| 594252 | root | localhost | NULL | Query | 0 | init | show processlist | 0.000 |
|
+--------+-----------------+-----------------+-----------------+---------+------+-------+------------------+----------+
|
6 rows in set (0.00 sec)
|
My config is:
#
|
# This group is read both both by the client and the server
|
# use it for options that affect everything
|
#
|
[client-server]
|
|
|
#
|
# include all files from the config directory
|
#
|
!includedir /etc/my.cnf.d
|
|
|
[root@static ~]# cat /etc/my.cnf.d/server.cnf
|
[mysqld]
|
#skip-networking
|
#bind-address = 0.0.0.0
|
#server-id=1
|
#log-bin = mysql-bin
|
#skip-name-resolve
|
#skip-grant-tables
|
datadir=/var/lib/mysql
|
tmpdir=/dev/shm
|
socket=/var/lib/mysql/mysql.sock
|
user=mysql
|
#log_warnings=2
|
skip-external-locking
|
query_cache_limit=8M
|
query_cache_size=8M
|
query_cache_type=1
|
max_connections=1000
|
max_user_connections=50
|
max_connect_errors=5000
|
open_files_limit = 1024000
|
thread_handling = pool-of-threads
|
thread_cache_size=8
|
key_cache_segments=8
|
key_buffer=8M
|
innodb-buffer-pool-instances=12
|
innodb_buffer_pool_size = 8M
|
innodb_thread_concurrency=12
|
innodb_log_file_size=64M
|
innodb_log_buffer_size = 8M
|
innodb_lock_wait_timeout = 100
|
innodb_flush_log_at_trx_commit = 2
|
innodb_support_xa=0
|
innodb_read_io_threads = 8
|
innodb_write_io_threads = 8
|
innodb_max_dirty_pages_pct = 90
|
innodb_file_per_table=1
|
innodb_use_native_aio=1
|
innodb_doublewrite=1
|
innodb_use_fallocate=1
|
innodb_use_atomic_writes=0
|
innodb_flush_method = O_DIRECT
|
innodb_file_format=barracuda
|
innodb_lru_scan_depth=2000
|
innodb_io_capacity=400
|
innodb_io_capacity_max=1000
|
sync_binlog=0
|
join_buffer_size=1M
|
max_allowed_packet=32M
|
table_open_cache=1024
|
table_cache=32k
|
sort_buffer_size=1M
|
read_buffer_size=1M
|
read_rnd_buffer_size=1M
|
tmp_table_size=2M
|
max_heap_table_size=1M
|
long_query_time=2
|
thread_concurrency=12
|
myisam_sort_buffer_size=1M
|
max_write_lock_count = 1
|
default-storage-engine=MyISAM
|
|
|
[mysqld_safe]
|
log-error=/var/log/mysqld.log
|
pid-file=/var/run/mysqld/mysqld.pid
|
plugin-load=archive=ha_archive.so;blackhole=ha_blackhole.so
|
open_files_limit = 1024000
|
|
|
[mysqldump]
|
quick
|
max_allowed_packet=16M
|
top - 16:10:32 up 26 days, 15:28, 1 user, load average: 1.13, 1.19, 1.24
|
Tasks: 302 total, 1 running, 297 sleeping, 0 stopped, 4 zombie
|
Cpu(s): 10.5%us, 0.2%sy, 0.0%ni, 89.2%id, 0.1%wa, 0.0%hi, 0.0%si, 0.0%st
|
Mem: 65580984k total, 64516740k used, 1064244k free, 4138816k buffers
|
Swap: 2097084k total, 44924k used, 2052160k free, 51518372k cached
|
|
|
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
|
19647 mysql 20 0 2050m 943m 10m S 101.4 1.5 2558:12 mysqld
|
|
|
[root@static ~]# mysql -V
|
mysql Ver 15.1 Distrib 10.0.14-MariaDB, for Linux (x86_64) using readline 5.1
|
