mysql/mariadb配置优化

最新推荐文章于 2024-05-19 03:18:57 发布

mrtuzi

最新推荐文章于 2024-05-19 03:18:57 发布

阅读量321

点赞数 3

文章标签： mysql mariadb 性能优化

本文链接：https://blog.csdn.net/mrtuzi/article/details/137087337

版权

[client]
port=3360
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[mysqld]
port=3360
server_id=1
event_scheduler=ON
character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
init_connect='SET NAMES utf8mb4'
skip-character-set-client-handshake=true
default-storage-engine=InnoDB
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
interactive_timeout=120
wait_timeout=120
log_warnings=1
slow_query_log=0
long_query_time=2
local-infile=0
skip-external-locking
max_connections=1000
key_buffer_size=64M
sort_buffer_size=512kb
read_buffer_size=1M
join_buffer_size=2M
read_rnd_buffer_size=4M
max_allowed_packet=16M
table_open_cache=256
tmp_table_size=64M
max_heap_table_size=64M
thread_cache_size=16
myisam_max_sort_file_size=64G
myisam_sort_buffer_size=32M
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size=20M
sort_buffer_size=20M
read_buffer_size=2M
write_buffer_size=2M
[mysqlhotcopy]
interactive-timeout
[mysqld_safe]
open-files-limit=2048