[mysql] disable-auto-rehash [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 port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql skip-external-locking bind-address = 0.0.0.0 key_buffer_size = 16M max_allowed_packet = 1G thread_stack = 192K thread_cache_size = 8 query_cache_type = 0 #query_cache_limit = 1M #query_cache_size = 16M slow_launch_time=1 innodb_buffer_pool_size = 1G innodb_file_per_table open-files-limit=10000 log_error = /var/log/mysql/error.log long_query_time=1 slow_query_log=on slow_query_log_file=/var/log/mysql/mysql-slow-queries.log # do not enable general_log on production since it logs everything! general_log=off general_log_file=/var/log/mysql/general.log innodb_flush_log_at_trx_commit=0