[client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] # # * Basic Settings # 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 skip-external-locking skip-networking skip-name-resolve innodb_file_per_table innodb_log_file_size=128M innodb_buffer_pool_size=1024M innodb_buffer_pool_instances=1 key_buffer_size = 4M # Commented out, since incompatible with MySQL 8.0 #query_cache_type = 1 #query_cache_size = 32M tmp_table_size = 32M max_heap_table_size = 32M max_allowed_packet = 4M table_open_cache = 64 # Per thread: sort_buffer_size = 512K read_buffer_size = 512K myisam_sort_buffer_size = 2M thread_cache_size = 8 max-connections = 128 log-error = /var/lib/mysql/error.log # Disable binary logging: disable_log_bin #log-bin #log = /tmp/mysql-query.log #server-id = 1 #slow-query-log=1 #slow-query-log-file=/tmp/slow-query.log #long_query_time = 2 #log-queries-not-using-indexes