mysql my.conf配置

Big_V686

于 2023-04-13 13:45:36 发布

阅读量294

点赞数 1

文章标签： mysql 数据库 java

本文链接：https://blog.csdn.net/big_v686/article/details/130128667

版权

需自己创建logs/error.log

[client]
port=3306
socket=/app/topwellsoft/mysqldata/mysql.sock

#basic########################
[mysqld]
port=3306
user=root
datadir=/app/topwellsoft/mysqldata/
tmpdir=/app/topwellsoft/mysqldata/tmp
socket=/app/topwellsoft/mysqldata/mysql.sock
skip-external-locking
skip-name-resolve
default-storage-engine=INNODB
character-set-server=utf8

 
slow_query_log=1
slow_query_log_file=/app/topwellsoft/mysqldata/logs/mysql.slow
long_query_time=2
 
log-error=/app/topwellsoft/mysqldata/logs/error.log
#per_thread_buffers##########

max_connections=2000
max_user_connections=1000
max_connect_errors=10000

 
#InnoDB############
innodb_data_home_dir=/app/topwellsoft/mysqldata

innodb_buffer_pool_size=6G
innodb_lock_wait_timeout=10


innodb_flush_method=O_DIRECT
innodb_file_per_table=1
transaction_isolation=READ-COMMITTED

[mysqldump]
quick
max_allowed_packet=128M

[mysql]
no-auto-rehash