Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [client]
- socket=/var/lib/mysql/mysql.sock
- [mysqld]
- local-infile=0
- ignore-db-dir=lost+found
- character-set-server=utf8
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- bind-address=0.0.0.0
- sql-mode=""
- port=56731
- # optimized my.cnf for MariaDB 5.5.x
- # by eva2000
- # vbtechsupport.com
- skip-name-resolve=1
- # InnoDB Settings
- default_storage_engine = InnoDB
- innodb_buffer_pool_instances = 4 # Use 1 instance per 1GB of InnoDB pool size
- innodb_buffer_pool_size = 4G # Use up to 70-80% of RAM & optionally check if /proc/sys/vm/swappiness is set to 0
- innodb_file_per_table = 1
- innodb_flush_log_at_trx_commit = 0
- innodb_flush_method = O_DIRECT
- innodb_log_buffer_size = 16M
- innodb_log_file_size = 512M
- innodb_stats_on_metadata = 0
- innodb_file_per_table=1
- innodb_temp_data_file_path = ibtmp1:64M:autoextend:max:20G # Control the maximum size for the ibtmp1 file
- innodb_thread_concurrency = 1 # Optional: Set to the number of CPUs on your system (minus 1 or 2) to better
- # contain CPU usage. E.g. if your system has 8 CPUs, try 6 or 7 and check
- # the overall load produced by MySQL/MariaDB.
- innodb_read_io_threads = 64
- innodb_write_io_threads = 64
- # MyISAM Settings
- query_cache_limit = 256k # UPD
- query_cache_size = 0 # UPD
- query_cache_min_res_unit = 2k
- query_cache_type = 0
- performance_schema = ON
- key_buffer_size = 5M # UPD
- low_priority_updates = 1
- concurrent_insert = 2
- # Connection Settings
- max_connections = 700 # UPD
- back_log = 512
- thread_cache_size = 96
- thread_stack = 192K
- interactive_timeout = 180
- wait_timeout = 180
- # Buffer Settings
- join_buffer_size = 512k # UPD
- read_buffer_size = 512k # UPD
- read_rnd_buffer_size = 1024k # UPD
- sort_buffer_size = 8M # UPD
- # Table Settings
- # In systemd managed systems like Ubuntu 16.04 or CentOS 7, you need to perform an extra action for table_open_cache & open_files_limit
- # to be overriden (also see comment next to open_files_limit).
- # E.g. for MySQL 5.7, please check: https://dev.mysql.com/doc/refman/5.7/en/using-systemd.html
- # and for MariaDB check: https://mariadb.com/kb/en/library/systemd/
- table_definition_cache = 10000 # UPD
- table_open_cache = 10000 # UPD
- open_files_limit = 60000 # UPD - This can be 2x to 3x the table_open_cache value or match the system's
- # open files limit usually set in /etc/sysctl.conf or /etc/security/limits.conf
- # In systemd managed systems this limit must also be set in:
- # /etc/systemd/system/mysqld.service.d/override.conf (for MySQL 5.7+) and
- # /etc/systemd/system/mariadb.service.d/override.conf (for MariaDB)
- max_heap_table_size = 256M
- tmp_table_size = 256M
- table_cache = 2000
- # Search Settings
- ft_min_word_len = 3 # Minimum length of words to be indexed for search results
- # Logging
- #log_error = /var/lib/mysql/mysql_error.log
- #log_queries_not_using_indexes = 1
- #long_query_time = 5
- #slow_query_log = 0 # Disabled for production
- #slow_query_log_file = /var/lib/mysql/mysql_slow.log
- [mysqldump]
- # Variable reference
- # For MySQL 5.7: https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
- # For MariaDB: https://mariadb.com/kb/en/library/mysqldump/
- quick
- quote_names
- max_allowed_packet = 256M
- thread_concurrency=30 # from 10 to allow more concurrency
- expire_logs_days=5 # from 0 for limited historical logs
- key_cache_age_threshold=64800 # from 300 seconds discard to RD again
- key_cache_division_limit=50 # for HOT and WARM usage boundary
- key_cache_block_size=16384 # from 1024 to age out larger size
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
