zl0j
Newbie | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору
Операционка CentOS 6, достали переодические тормоза (с интервалом в несколько минут, длительностью от нескольких секунд до секунд 30), сервер как будто зависает, в top вижу такую картину:
Код: top - 12:27:11 up 18:13, 1 user, load average: 1.98, 1.68, 1.69
Tasks: 252 total, 1 running, 251 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 1.3%sy, 0.0%ni, 77.2%id, 21.5%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 16243480k total, 13631692k used, 2611788k free, 291364k buffers
Swap: 33553328k total, 41340k used, 33511988k free, 8752380k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1199 root 20 0 0 0 0 D 9.0 0.0 4:26.43 flush-9:2
536 root 20 0 0 0 0 D 6.0 0.0 2:27.12 jbd2/md2-8
470 root 20 0 0 0 0 D 4.7 0.0 2:35.53 md2_raid1
42 root 20 0 0 0 0 S 0.3 0.0 0:03.26 events/7
30842 root 20 0 15156 1484 1008 R 0.3 0.0 0:11.67 top
1 root 20 0 19228 1328 1128 S 0.0 0.0 0:00.90 init
2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd
... |
Уже поотключал логи, оптимизировал запросы и т.п. - не помогает ничего, пока система не висит - всё работает быстро загрузка в среднем 0.8
Ничего особенного на сервере нет, связка nginx+Apache (включен только error log) и mysql с таблицами в innodb (правда базы в общей сложности на 2.9 гига в файле на 4.2 гига).
Конфиг mysql:
Код:
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set = utf8
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 64M
max_allowed_packet = 1000M
table_open_cache = 4096
sort_buffer_size = 50M
read_buffer_size = 256K
read_rnd_buffer_size = 16M
join_buffer_size = 1M
net_buffer_length = 2K
thread_stack = 128K
max_connections = 300
wait_timeout = 14400
interactive_timeout = 14400
thread_cache_size = 16
table_cache = 100000
max_heap_table_size = 256M
query_cache_size = 512M
query_cache_limit = 64M
tmp_table_size = 1500M
#log-slow-queries=/tmp/slow_queries.log
#long_query_time=15
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (using the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
server-id = 1
character-set-server = utf8
# Uncomment the following if you want to log updates
#log-bin=mysql-bin
# binary logging format - mixed recommended
#binlog_format=mixed
# Causes updates to non-transactional engines using statement format to be
# written directly to binary log. Before using this option make sure that
# there are no dependencies between transactional and non-transactional
# tables such as in the statement INSERT INTO t_myisam SELECT * FROM
# t_innodb; otherwise, slaves may diverge from the master.
#binlog_direct_non_transactional_updates=TRUE
# Uncomment the following if you are using InnoDB tables
#skip-myisam
#innodb_data_home_dir = /var/lib/mysql
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 8G
innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 512M
innodb_log_buffer_size = 16M
innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
innodb_thread_concurrency = 16
[mysqldump]
quick
max_allowed_packet = 16M
default-character-set = utf8
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
default-character-set = utf8
[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
interactive-timeout
|
|
Всего записей: 7 | Зарегистр. 24-08-2013 | Отправлено: 14:45 24-08-2013 | Исправлено: zl0j, 14:47 24-08-2013 |
|
