[client] port=3306 socket=/var/run/mysqld/mysqld.sock [mysqld_safe] socket=/var/run/mysqld/mysqld.sock nice=0 [mysqld] user=mysql pid-file=/var/run/mysqld/mysqld.pid socket=/var/run/mysqld/mysqld.sock bind-address=127.0.0.1 port=3306 #log=/var/log/mysql/mysql.log log-error=/var/log/mysql/mysql-err.log slow_query_log_file=/var/log/mysql/mysql-slow.log slow_query_log=1 long_query_time=1 performance_schema=on basedir=/usr datadir=/var/lib/mysql tmpdir=/var/cache/mysql/tmpdir lc-messages-dir=/usr/share/mysql old_passwords=0 skip-name-resolve=1 sql-mode=NO_AUTO_CREATE_USER key_buffer_size=800M max_allowed_packet=256M thread_stack=4M thread_cache_size=80 max_connections=320 max_connect_errors=100 table_cache=64M join_buffer_size=1M query_cache_type=1 query_cache_limit=16M query_cache_size=64M tmp_table_size=64M max_heap_table_size=64M table_open_cache=16M open_files_limit=64K innodb innodb_file_per_table=1 innodb_buffer_pool_size=1599M innodb_log_buffer_size=128M innodb_log_file_size=256M innodb_flush_log_at_trx_commit=1 innodb_flush_method=O_DSYNC flush=1 delay_key_write=ALL myisam-recover-options=BACKUP,FORCE ft_min_word_len=3 skip-secure-auth event_scheduler=ON [mysqldump] quick quote-names single-transaction max_allowed_packet=64M [mysql] no-auto-rehash