mysql 高性能--定制版

最新推荐文章于 2019-11-04 10:28:28 发布

原创最新推荐文章于 2019-11-04 10:28:28 发布 · 396 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #buffer #query #concurrency #cache #file

本文详细介绍了MySQL服务器的各项配置参数，包括端口设置、字符集、存储引擎、缓存大小等，并提供了详细的日志记录配置，有助于优化MySQL性能及故障排查。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[client]

port=3306

[mysql]

default-character-set=utf8

[mysqld]

port=3306

basedir="C:/Program Files/MySQL/MySQL Server 5.5/"

datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.5/Data/"

character-set-server=utf8

default-storage-engine=INNODB

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

max_connections=1024

query_cache_size=512

table_cache=512

tmp_table_size=512M

thread_cache_size=128

myisam_max_sort_file_size=100G

myisam_sort_buffer_size=512M

key_buffer_size=512M

read_buffer_size=512K

read_rnd_buffer_size=512K

sort_buffer_size=512K

innodb_additional_mem_pool_size=512M

innodb_flush_log_at_trx_commit=1

innodb_log_buffer_size=4096K

innodb_buffer_pool_size=512M

# do not modify log value , server can not start
innodb_log_file_size=170M

innodb_thread_concurrency=16

#-----------------log-------------
#all logs
log="D:/logs/mysql/mylog.log"

#error log
log-warnings=1
log_output=FILE
log-error="D:/logs/mysql/error.log"

#query log
slow_query_log=1
long_query_time=2
slow_query_log_file="D:/logs/mysql/slowquery.log"
#log-slow-queries="D:/logs/mysql/slowquery.log"

#recoerd queries that without index
log-queries-not-using-indexes="D:/logs/mysql/nouseindex.log"