From surenkid, 10 Months ago, written in INI.
Embed
  1. auto_increment_increment=1
  2. auto_increment_offset=1
  3. back_log=200
  4. binlog_checksum=NONE
  5. binlog_format=MIXED
  6. binlog_row_image=FULL
  7. block_encryption_mode=aes-128-ecb
  8. character_set_server=utf8
  9. concurrent_insert=AUTO
  10. connect_timeout=10
  11. default_week_format=0
  12. delay_key_write=ON
  13. delayed_insert_limit=100
  14. delayed_insert_timeout=300
  15. delayed_queue_size=1000
  16. div_precision_increment=4
  17. eq_range_index_dive_limit=10
  18. event_scheduler=OFF
  19. explicit_defaults_for_timestamp=OFF
  20. ft_min_word_len=4
  21. ft_query_expansion_limit=20
  22. group_concat_max_len=10240
  23. init_connect=
  24. innodb_adaptive_hash_index=ON
  25. innodb_autoinc_lock_mode=1
  26. innodb_concurrency_tickets=5000
  27. innodb_flush_log_at_trx_commit=2
  28. innodb_ft_enable_stopword=ON
  29. innodb_ft_max_token_size=84
  30. innodb_ft_min_token_size=3
  31. innodb_ft_server_stopword_table=
  32. innodb_ft_user_stopword_table=
  33. innodb_large_prefix=OFF
  34. innodb_lock_wait_timeout=7200
  35. innodb_max_dirty_pages_pct=75
  36. innodb_old_blocks_pct=37
  37. innodb_old_blocks_time=1000
  38. innodb_online_alter_log_max_size=134217728
  39. innodb_open_files=1024
  40. innodb_print_all_deadlocks=OFF
  41. innodb_purge_batch_size=300
  42. innodb_purge_threads=1
  43. innodb_read_ahead_threshold=56
  44. innodb_read_io_threads=12
  45. innodb_rollback_on_timeout=OFF
  46. innodb_stats_method=nulls_equal
  47. innodb_stats_on_metadata=OFF
  48. innodb_stats_sample_pages=8
  49. innodb_stats_transient_sample_pages=8
  50. innodb_strict_mode=ON
  51. innodb_table_locks=ON
  52. innodb_thread_concurrency=0
  53. innodb_thread_sleep_delay=10000
  54. innodb_write_io_threads=12
  55. interactive_timeout=60
  56. key_cache_age_threshold=300
  57. key_cache_block_size=1024
  58. key_cache_division_limit=100
  59. lock_wait_timeout=31536000
  60. log_queries_not_using_indexes=OFF
  61. long_query_time=5.000000
  62. low_priority_updates=OFF
  63. lower_case_table_names=0
  64. max_allowed_packet=1073741824
  65. max_connect_errors=999999999
  66. max_connections=1000
  67. max_length_for_sort_data=1024
  68. max_prepared_stmt_count=16382
  69. max_user_connections=0
  70. myisam_sort_buffer_size=8388608
  71. net_read_timeout=30
  72. net_retry_count=10
  73. net_write_timeout=60
  74. open_files_limit=102400
  75. performance_schema=OFF
  76. query_alloc_block_size=8192
  77. query_cache_limit=1048576
  78. query_cache_size=0
  79. query_cache_type=OFF
  80. query_cache_wlock_invalidate=OFF
  81. query_prealloc_size=8192
  82. slow_launch_time=2
  83. sql_auto_is_null=OFF
  84. sql_mode=NO_ENGINE_SUBSTITUTION
  85. sql_safe_updates=OFF
  86. sync_binlog=0
  87. table_definition_cache=768
  88. table_open_cache=512
  89. table_open_cache_instances=1
  90. thread_cache_size=512
  91. time_zone=SYSTEM
  92. tmp_table_size=1073741824
  93. tx_isolation=REPEATABLE-READ
  94. wait_timeout=60