technical skills grow

Responsive Ads Here

Friday, April 8, 2022

How to configure MY.CNF file in MySQL

 [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

No comments:

Post a Comment

Powered by Blogger.

Labels

Contact Form

Name

Email *

Message *

Search This Blog

Blog Archive

Ad Code

Responsive Advertisement

Recent Posts