forum.lissyara.su

Код: Выделить всё

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