LINUX.ORG.RU

Сообщения lumenok

 

Проблема с производительностью дисковой подсистемы.

Добрый день, имеем

Total DISK READ :       0.00 B/s | Total DISK WRITE :    1794.15 K/s
Actual DISK READ:       0.00 B/s | Actual DISK WRITE:       2.27 M/s
  TID  PRIO  USER     DISK READ  DISK WRITE  SWAPIN     IO>    COMMAND                                                                                    
  406 be/3 root        0.00 B/s    3.57 K/s  0.00 % 40.46 % [jbd2/sda3-8]
11926 be/4 mysql       0.00 B/s  399.49 K/s  0.00 %  5.28 % mysqld --basedir=/usr --datadir=/var/lib/mysql~t=100000 --pid-file=/var/run/mariadb/mysqld.pid
11911 be/4 mysql       0.00 B/s  413.76 K/s  0.00 %  3.91 % mysqld --basedir=/usr --datadir=/var/lib/mysql~t=100000 --pid-file=/var/run/mariadb/mysqld.pid
11916 be/4 mysql       0.00 B/s  114.14 K/s  0.00 %  2.05 % mysqld --basedir=/usr --datadir=/var/lib/mysql~t=100000 --pid-file=/var/run/mariadb/mysqld.pid
11906 be/4 mysql       0.00 B/s   85.61 K/s  0.00 %  1.80 % mysqld --basedir=/usr --datadir=/var/lib/mysql~t=100000 --pid-file=/var/run/mariadb/mysqld.pid
11786 be/4 mysql       0.00 B/s  128.41 K/s  0.00 %  1.65 % mysqld --basedir=/usr --datadir=/var/lib/mysql~t=100000 --pid-file=/var/run/mariadb/mysqld.pid
11920 be/4 mysql       0.00 B/s  199.75 K/s  0.00 %  1.65 % mysqld --basedir=/usr --datadir=/var/lib/mysql~t=100000 --pid-file=/var/run/mariadb/mysqld.pid
11692 be/4 mysql       0.00 B/s   57.07 K/s  0.00 %  1.27 % mysqld --basedir=/usr --datadir=/var/lib/mysql~t=100000 --pid-file=/var/run/mariadb/mysqld.pid
11756 be/4 mysql       0.00 B/s  171.21 K/s  0.00 %  1.24 % mysqld --basedir=/usr --datadir=/var/lib/mysql~t=100000 --pid-file=/var/run/mariadb/mysqld.pid
11173 be/4 mysql       0.00 B/s   57.07 K/s  0.00 %  0.85 % mysqld --basedir=/usr --datadir=/var/lib/mysql~t=100000 --pid-file=/var/run/mariadb/mysqld.pid
11923 be/4 mysql       0.00 B/s   57.07 K/s  0.00 %  0.74 % mysqld --basedir=/usr --datadir=/var/lib/mysql~t=100000 --pid-file=/var/run/mariadb/mysqld.pid
11908 be/4 mysql       0.00 B/s   28.54 K/s  0.00 %  0.73 % mysqld --basedir=/usr --datadir=/var/lib/mysql~t=100000 --pid-file=/var/run/mariadb/mysqld.pid
11927 be/4 mysql       0.00 B/s   28.54 K/s  0.00 %  0.53 % mysqld --basedir=/usr --datadir=/var/lib/mysql~t=100000 --pid-file=/var/run/mariadb/mysqld.pid
11934 be/4 mysql       0.00 B/s    3.57 K/s  0.00 %  0.19 % mysqld --basedir=/usr --datadir=/var/lib/mysql~t=10


Zabbix сервер, место на диске есть, более 500 гигабайт свободно
/dev/sda3 on / type ext4 (rw,noatime,nodiratime,data=ordered)
База большая 380 гигов, куда посмотреть.

cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
innodb_use_native_aio=1
skip-log-bin
#datadir=/mnt/mysql
# socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
default_storage_engine=InnoDB
innodb_file_per_table = 1
#
tmpdir=/mytmp
#
# network
connect_timeout = 60
wait_timeout = 28800
max_connections = 2048
max_allowed_packet = 64M
max_connect_errors = 1000

# limits
tmp_table_size = 512M
max_heap_table_size = 256M
table_cache = 512

# logs
# log_error = /var/log/mysql-error.log
slow_query_log_file = /var/log/mariadb/mysql-slow.log
slow_query_log = 1
long_query_time = 20
#log-bin=mysql-bin
#log-bin=/var/lib/mysql_innodblog/mysql-bin
log-bin = /var/backups/mysql/mysql_innodblog/mysql-bin
log-bin-index = /var/backups/mysql/mysql_innodblog/mysql-bin.index

join_buffer_size=2048k
read_buffer_size=256k
read_rnd_buffer_size=256k

# innodb
default_storage_engine=InnoDB
innodb_file_per_table = 1
innodb_status_file = 1
innodb_additional_mem_pool_size = 128M
innodb_buffer_pool_size = 24G
innodb_buffer_pool_instances = 24
innodb_flush_method = O_DIRECT
innodb_io_capacity = 2000
innodb_flush_log_at_trx_commit = 2
innodb_support_xa = 0
innodb_log_buffer_size = 1024M
## innodb_data_file_path  = ibdata1:128M;ibdata2:128M:autoextend:max:4096M

# experimental
innodb_stats_update_need_lock = 0

# other stuff
event_scheduler = 1
query_cache_type = 0
query_cache_size = 536870912
join_buffer_size=1M
query_cache_limit=2M
sort_buffer_size=2M
read_buffer_size=2M
read_rnd_buffer_size=4M
key_buffer = 256M
key_buffer_size=64M
open_files_limit = 100000
thread_cache_size = 4

[mysqld_safe]
# log-error=/var/log/mysqld.log
pid-file=/var/run/mariadb/mysqld.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d


Диски быстрые в 10 RAID, 600 gb 10000rpm, raid показывает что все норм с дисками и самим контроллером.

 , , ,

lumenok
()

RSS подписка на новые темы