47 lines
766 B
INI
47 lines
766 B
INI
[mysqld]
|
||
basedir=.
|
||
datadir=./data
|
||
port=40000
|
||
|
||
skip-log-bin
|
||
skip-log-error
|
||
skip-general-log
|
||
skip-slow-query-log
|
||
general-log=0
|
||
slow-query-log=0
|
||
log-error=OFF
|
||
general-log-file=OFF
|
||
slow-query-log-file=OFF
|
||
|
||
[mysqld]
|
||
basedir=.
|
||
datadir=./data
|
||
port=40000
|
||
|
||
# 日志配置(保持关闭)
|
||
skip-log-bin
|
||
skip-log-error
|
||
skip-general-log
|
||
skip-slow-query-log
|
||
general-log=0
|
||
slow-query-log=0
|
||
log-error=OFF
|
||
|
||
# InnoDB配置(关键调整)
|
||
innodb_buffer_pool_size = 20M
|
||
innodb_log_buffer_size = 2M
|
||
innodb_sort_buffer_size = 2M
|
||
|
||
# 缓冲区配置(适当增加性能)
|
||
sort_buffer_size = 256K
|
||
read_buffer_size = 128K
|
||
read_rnd_buffer_size = 128K
|
||
join_buffer_size = 128K
|
||
tmp_table_size = 1M
|
||
max_heap_table_size = 1M
|
||
|
||
# 性能模式(根据MySQL版本)
|
||
performance_schema = OFF
|
||
|
||
|