1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
| [client]
port = 3306 socket = /tmp/mysql.sock
[mysqld] binlog_cache_size = 64K thread_stack = 256K join_buffer_size = 1024K query_cache_type = 0 max_heap_table_size = 16M port = 3306 socket = /tmp/mysql.sock datadir = /www/server/data default_storage_engine = InnoDB performance_schema_max_table_instances = 100 table_definition_cache = 100 skip-external-locking key_buffer_size = 8M max_allowed_packet = 4M table_open_cache = 64 sort_buffer_size = 256K net_buffer_length = 2K read_buffer_size = 128K read_rnd_buffer_size = 256K myisam_sort_buffer_size = 2M thread_cache_size = 16 query_cache_size = 0 tmp_table_size = 8M sql-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
explicit_defaults_for_timestamp = true
max_connections = 50 max_connect_errors = 10 open_files_limit = 4096
log-bin=mysql-bin binlog_format=row server-id = 1 expire_logs_days = 3 slow_query_log=0 slow-query-log-file=/www/server/data/mysql-slow.log long_query_time=3
innodb_data_home_dir = /www/server/data innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /www/server/data innodb_buffer_pool_size = 16M innodb_log_file_size = 2M innodb_log_buffer_size = 4M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 10 innodb_max_dirty_pages_pct = 75 innodb_read_io_threads = 1 innodb_write_io_threads = 1
[mysqldump] quick max_allowed_packet = 16M
[mysql] no-auto-rehash
[myisamchk] key_buffer_size = 8M sort_buffer_size = 8M read_buffer = 1M write_buffer = 1M
[mysqlhotcopy] interactive-timeout
|