MySQL default my.cnf концигурация

Далее приведена конфигурация MySQL сервера файлом: /etc/my.cnf по принятым стандартам для хоста с 1Gb оперативной памяти: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 query_cache_limit=1M query_cache_size=23M query_cache_type=1 max_connections=1000 max_user_connections=300 interactive_timeout=100 wait_timeout=100 connect_timeout=10 thread_cache_size=128 key_buffer=64M join_buffer_size=1M max_allowed_packet=32M table_cache=1024 sort_buffer_size=1M read_buffer_size=1M read_rnd_buffer_size=768K max_connect_errors=10 thread_concurrency=4 # Disabling symbolic-links is recommended to prevent assorted security risks; # to do so, uncomment this line: # symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [client] socket=/var/lib/mysql/mysql.sock Read more…