Last active
May 27, 2023 05:51
-
-
Save kmvan/0c33a8178f94f2bfc922ef9570321b4c to your computer and use it in GitHub Desktop.
Revisions
-
kmvan revised this gist
May 27, 2023 . 1 changed file with 2 additions and 0 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,4 +1,6 @@ ############### # 88CPUs 128GB ############### # MariaDB Configuration File # Server -
May 27, 2023 . 1 changed file with 103 additions and 25 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,27 +1,105 @@ # 88CPUs 128GB # MariaDB Configuration File # Server [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Logging log_error=/var/log/mysql/error.log general_log=0 general_log_file=/var/log/mysql/mysql.log # MyISAM key_buffer_size = 256M myisam_sort_buffer_size = 128M myisam_max_sort_file_size = 10G myisam_repair_threads = 4 # InnoDB innodb_buffer_pool_size = 96G innodb_log_file_size = 4G innodb_log_buffer_size = 512M innodb_file_per_table = 1 innodb_open_files = 5000 innodb_io_capacity = 2000 innodb_io_capacity_max = 4000 innodb_flush_method = O_DIRECT # Connection max_connections = 2000 max_allowed_packet = 512M wait_timeout = 28800 interactive_timeout = 28800 # Query Cache (Disabled) query_cache_type = 0 query_cache_size = 0 # Performance thread_cache_size = 100 tmp_table_size = 256M max_heap_table_size = 256M join_buffer_size = 16M read_buffer_size = 16M read_rnd_buffer_size = 8M sort_buffer_size = 32M # Other character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci ######### # 4CPUs 16G ######### # MariaDB Configuration File # Server [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Logging log_error=/var/log/mysql/error.log general_log=0 general_log_file=/var/log/mysql/mysql.log # MyISAM key_buffer_size = 256M myisam_sort_buffer_size = 128M myisam_max_sort_file_size = 10G myisam_repair_threads = 4 # InnoDB innodb_buffer_pool_size = 8G innodb_log_file_size = 2G innodb_log_buffer_size = 256M innodb_file_per_table = 1 innodb_open_files = 2000 innodb_io_capacity = 500 innodb_io_capacity_max = 1000 innodb_flush_method = O_DIRECT # Connection max_connections = 200 max_allowed_packet = 64M wait_timeout = 28800 interactive_timeout = 28800 # Query Cache (Disabled) query_cache_type = 0 query_cache_size = 0 # Performance thread_cache_size = 100 tmp_table_size = 64M max_heap_table_size = 64M join_buffer_size = 4M read_buffer_size = 4M read_rnd_buffer_size = 2M sort_buffer_size = 8M # Other character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci -
Jan 1, 2022 .There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,27 @@ # large memory # [mysqld] innodb_buffer_pool_size = 4096M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 innodb_log_buffer_size = 512M innodb_log_file_size = 2048M innodb_max_dirty_pages_pct = 90 innodb_read_io_threads = 32 innodb_write_io_threads = 32 key_buffer_size = 1024M max_allowed_packet = 10G max_connect_errors = 100 max_connections = 500 myisam_sort_buffer_size = 256M net_buffer_length = 4K open_files_limit = 65535 performance_schema_max_table_instances = 400 query_cache_size = 512M read_buffer_size = 16M read_rnd_buffer_size = 256K skip-external-locking sort_buffer_size = 16M table_definition_cache = 400 table_open_cache = 4096 thread_cache_size = 512 tmp_table_size = 512M