# my.cnf file [mysqld_safe] log-error=/var/log/mysql/mysql.err pid-file=/var/run/mysqld/mysqld.pid [mysqldump] quick max_allowed_packet = 128M [mysqld_multi] mysqladmin = /usr/bin/mysqladmin user = mysql_admin password = mysqlshut log = /var/log/mysql/mysqld_multi.log [mysqld] # DEV mysqladmin = /usr/bin/mysqladmin general_log = on general_log_file = /var/log/mysql/mysqldev.log lc_messages_dir = /usr/share/mysql-8.0/english user = mysql pid-file = /var/run/mysql/mysqldev.pid socket = /var/run/mysql/mysqldev.sock port = 3306 log-error = /var/log/mysql/mysqldev.log basedir = /sb/nanuqdb/dbdev datadir = /sb/nanuqdb/dbdev tmpdir = /sb/nanuqdb/dbdev_tmp sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' low_priority_updates = 1 character_set_server = utf8 collation_server = utf8_general_ci sort_buffer_size = 10M max_connections = 400 max_allowed_packet = 128M table_open_cache = 500 query_cache_size = 32M #thread_cache = 10 tmp_table_size = 50M wait_timeout = 7200 # MyIsam #key_buffer=2G # INNODB Settings innodb_data_home_dir=/sb/nanuqdb/dbdev innodb_data_file_path=ibdata1:10G;ibdata2:500G;ibdata3:500G;ibdata4:750G;ibdata5:300G:autoextend:max:750G innodb_file_per_table=0 # Memory innodb_buffer_pool_size = 48G innodb_buffer_pool_instances = 8 #innodb_additional_mem_pool_size = 20M # Log # Set the log file size to about 25% of the buffer pool size (max log size is 4GB) innodb_log_file_size = 128M innodb_log_files_in_group = 4 innodb_log_buffer_size = 32M innodb_flush_log_at_trx_commit = 2 # Performance settings innodb_io_capacity = 150 innodb_write_io_threads = 5 innodb_read_io_threads = 5 innodb_adaptive_flushing = 1 innodb_purge_threads = 1 innodb_flush_method = O_DSYNC