PUSDN - JaneYork
    https://www.pusdn.com

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

    配置二：（用于比对）

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

    部分截图如下：
    image.png
    image.png
    image.png
    image.png
    image.png