1. [client]
    2. port=3306
    3. socket=/tmp/mysql.sock
    4. [mysql]
    5. prompt="\u@db \R:\m:\s [\d]>"
    6. no-auto-rehash
    7. [mysqld]
    8. user=mysql
    9. port=3306
    10. basedir=/usr/local/mysql
    11. datadir=/data/mysql/
    12. socket=/tmp/mysql.sock
    13. character-set-server=utf8mb4
    14. skip_name_resolve=1
    15. open_files_limit=65535
    16. back_log=1024
    17. max_connections=512
    18. max_connect_errors=1000000
    19. table_open_cache=1024
    20. table_definition_cache=1024
    21. table_open_cache_instances=64
    22. thread_stack=512K
    23. external-locking=FALSE
    24. max_allowed_packet=32M
    25. sort_buffer_size=4M
    26. join_buffer_size=4M
    27. thread_cache_size=768
    28. query_cache_size=0
    29. query_cache_type=0
    30. interactive_timeout=600
    31. wait_timeout=600
    32. tmp_table_size=32M
    33. max_heap_table_size=32M
    34. slow_query_log=1
    35. slow_query_log_file=/data/mysql/error.log
    36. log-error=/data/mysql/error.log
    37. long_query_time=0.5
    38. server-id=3306100
    39. log-bin=/data/mysql/mysql-binlog
    40. sync_binlog=1
    41. binlog_cache_size=4M
    42. max_binlog_cache_size=1G
    43. max_binlog_size=1G
    44. expire_logs_days=7
    45. master_info_repository=TABLE
    46. relay_log_info_repository=TABLE
    47. gtid_mode=on
    48. enforce_gtid_consistency=1
    49. log_slave_updates
    50. binlog_format=row
    51. relay_log_recovery=1
    52. relay-log-purge=1
    53. key_buffer_size=32M
    54. read_buffer_size=8M
    55. read_rnd_buffer_size=4M
    56. bulk_insert_buffer_size=64M
    58. lock_wait_timeout=3600
    59. explicit_defaults_for_timestamp=1
    60. innodb_thread_concurrency=0
    61. innodb_sync_spin_loops=100
    62. innodb_spin_wait_delay=30
    63. transaction_isolation=REPEATABLE-READ
    64. innodb_buffer_pool_size=1024M
    65. innodb_buffer_pool_instances=8
    66. innodb_buffer_pool_load_at_startup=1
    67. innodb_buffer_pool_dump_at_shutdown=1
    68. innodb_data_file_path=ibdata1:1G:autoextend
    69. innodb_flush_log_at_trx_commit=1
    70. innodb_log_buffer_size=32M
    71. innodb_log_file_size=2G
    72. innodb_log_files_in_group=2
    73. innodb_io_capacity=2000
    74. innodb_io_capacity_max=4000
    75. innodb_flush_neighbors=0
    76. innodb_write_io_threads=8
    77. innodb_read_io_threads=8
    78. innodb_purge_threads=4
    79. innodb_page_cleaners=4
    80. innodb_open_files=65535
    81. innodb_max_dirty_pages_pct=50
    82. innodb_flush_method=O_DIRECT
    83. innodb_lru_scan_depth=4000
    84. innodb_checksum_algorithm=crc32
    85. innodb_lock_wait_timeout=10
    86. innodb_rollback_on_timeout=1
    87. innodb_print_all_deadlocks=1
    88. innodb_file_per_table=1
    89. innodb_online_alter_log_max_size=4G
    90. internal_tmp_disk_storage_engine=InnoDB
    91. innodb_stats_on_metadata=0
    92. innodb_status_file=1
    93. innodb_status_output=0
    94. innodb_status_output_locks=0
    95. performance_schema=1
    96. performance_schema_instrument='%=on'
    97. innodb_monitor_enable="module_innodb"
    98. innodb_monitor_enable="module_server"
    99. innodb_monitor_enable="module_dml"
    100. innodb_monitor_enable="module_ddl"
    101. innodb_monitor_enable="module_trx"
    102. innodb_monitor_enable="module_os"
    103. innodb_monitor_enable="module_purge"
    104. innodb_monitor_enable="module_log"
    105. innodb_monitor_enable="module_lock"
    106. innodb_monitor_enable="module_buffer"
    107. innodb_monitor_enable="module_index"
    108. innodb_monitor_enable="module_ibuf_system"
    109. innodb_monitor_enable="module_buffer_page"
    110. innodb_monitor_enable="module_adaptive_hash"
    111. [mysqldump]
    112. quick
    113. max_allowed_packet=32M