ситуация.
Сер под нагрузкой.
Есть большая база в mysql со структурой innodb.
Вес базы не маленький 15гиг.
Если отключить mysql , то сервер зависнет из-за большой активности к mysql.
Не пойму почему.
Код: Выделить всё
mysql Ver 14.14 Distrib 5.5.39, for FreeBSD10.0 (amd64) using 6.3
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.Код: Выделить всё
# apachectl -v
Server version: Apache/2.2.29 (FreeBSD)
Server built: Sep 23 2014 09:56:50Код: Выделить всё
# cat /var/db/mysql/my.cnf | egrep -v '#|^$'
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld_safe]
socket = /tmp/mysql.sock
[mysqld]
user = mysql
socket = /tmp/mysql.sock
port = 3306
tmpdir = /tmp
event_scheduler = on
character-set-client-handshake=utf8
character_set_server=utf8
low_priority_updates = 1
skip-external-locking
skip-name-resolve
max_allowed_packet = 1073741824
max_connections = 100000
back_log = 5000
max_join_size = 50000000
max_sort_length = 1024
thread_cache_size = 16384
thread_concurrency = 18
query_cache_limit = 10G
query_cache_min_res_unit = 128
query_cache_size = 127M
query_cache_type = 1
interactive_timeout = 15
net_read_timeout = 60
net_write_timeout = 60
wait_timeout = 60
key_buffer_size = 19200000000
key_cache_division_limit = 70
max_heap_table_size = 34399738360
tmp_table_size = 34399738360
myisam_sort_buffer_size = 25600000000
net_buffer_length = 1048576
read_buffer_size = 2000000000
read_rnd_buffer_size = 2147483647
sort_buffer_size = 200000000
table_open_cache = 524288
innodb_additional_mem_pool_size = 2000000000
innodb_buffer_pool_size = 102G
innodb_buffer_pool_instances = 102
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_thread_concurrency = 20
innodb_flush_log_at_trx_commit = 0
innodb_log_buffer_size = 8000000
innodb_log_file_size = 200000000
log-queries-not-using-indexes
slow-query-log = 1
slow-query-log-file = /var/mysql/log/mysql-slow.log
thread_stack = 20M
myisam-recover-options = BACKUP
max_user_connections = 50000
max_connect_errors = 100
open_files_limit = 1158586
connect_timeout = 60
expire_logs_days = 2
max_binlog_size = 100M
innodb_thread_concurrency = 20
innodb_flush_method = O_DIRECT
innodb_thread_sleep_delay = 10000
[mysqldump]
quick
quote-names
[mysql]
[isamchk]
key_buffer = 16M
