[mysqld] datadir=/opt/mysql/data socket=/opt/mysql/data/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 max_allowed_packet=800M max_connection=40 default-character-set=cp1251 query_cache_size=100M table_cache=256 tmp_table_size=103M key_buffer_size=10M thread_cache_size=5 innodb_additional_mem_pool_size=300M innodb_buffer_pool_size=1G innodb_log_file_size=60M innodb_thread_concurrency=4 innodb_data_file_path=ibdata1:100M:autoextend [mysqld_safe] log-error=/var/log/mysqld1.log pid-file=/var/run/mysqld/mysqld1.pid