[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#pid-file=/db/mysql/mysql.pid
innodb_file_per_table=1
innodb_flush_method=O_DIRECT
innodb_buffer_pool_size=16G
innodb_log_buffer_size=32M
#bulk_insert_buffer_size=1G
lower_case_table_name=1
#sort_buffer_size=2048M
#read_rnd_buffer_size=512M
#read_buffer_size=256M
#max_heap_table_size=2048M
#tmp_table_size=2048M
#max_tmp_tables=100
max_allowed_packet=512M
wait_timeout=300
interactive_timeout=300
#key_buffer_size=4096M
#key_buffer_size=2048M
#thread_stack=1024K
#thread_cache_size=1024M
#query_cache_type = 1
#query_cache_limit = 6M
#query_cache_min_res_unit = 6M
#query_cache_size = 96M
max_connections=300
#long_query_time=5
#slow_query_log=1
#slow_query_log_file=/tmp/mysqlSlowQuery.log
#
##
## include all files from the config directory
##
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
!includedir /etc/my.cnf.d
Friday, April 8, 2022
How to configure MY.CNF file in MySQL
Subscribe to:
Post Comments (Atom)
Powered by Blogger.
No comments:
Post a Comment