maria-discuss team mailing list archive
Mailing list archive
New Question: Maria 10.0.15 high CPU/disk usage without queries
A new question has been asked in "MariaDB Community" by artemkuchin. Please answer it at http://mariadb.com/kb/en/maria-10015-high-cpudisk-usage-without-queries/ as the person asking the question may not be subscribed to the mailing list.
I just migrated the server from mysql 5.5 to mariadb 10.0.15
It is a web hosting server with about 100 sites on different platforms. So, there are about 100 databases. Most tables myisam, some innodb (mostly joomla 3)
Before with mysql CPU load was less than 10%, disk uses by mysqld was also not very high.
No, with top and top -mio i see pretty high numbers. mysqld takes from 20 to 30% cpu and 80-100% disk
It is xeon 4 cores+HT (8 cores seen by OS) with 32GB ram, 2 3TB SATA disks in software mirror.
os is FreeBSD 10.1 stable
I tried using thread of pools, one thread per connection - all the same
The weird think what i show processlist i ass about 20 haning connection without any question. This is is normal,
some sites leave connections for a while (mod_perl, php) the weirdness is that thare no queies while 20-30% load of CPU.
What is mariddb doing?
thread_cache_size = 45
init-connect='SET NAMES cp1251'
default-storage-engine = MyISAM
max_allowed_packet = 50M
key_buffer_size = 512M
table_open_cache = 32768
query_cache_size = 256M
query_cache_limit = 32M
# PER THREAD
read_buffer_size = 2M
# PER REQUEST
sort_buffer_size = 32M
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 128M
server-id = 1
innodb_data_home_dir = /hosts/MYSQLDB
innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
innodb_log_group_home_dir = /hosts/MYSQLDB
innodb_buffer_pool_size = 384M
innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 3
innodb_lock_wait_timeout = 50
To view or answer this question please visit: http://mariadb.com/kb/en/maria-10015-high-cpudisk-usage-without-queries/