最近安装了一个打单软件,貌似要调用mysql,每次出现这个进程都很卡
找到了my.ini
内容如下:
[client]
port=3318
default-character-set=utf8
[mysqld]
port=3318
bind-address=127.0.0.1
character_set_server=utf8
default-storage-engine=INNODB
basedir=d:/Program Files/ShopEx/Taodali4.0/Data/db
datadir=d:/Program Files/ShopEx/Taodali4.0/Data/db/data
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
max_connections=200
innodb_file_per_table=1
expire-logs-days = 31
log-bin=mysql-bin
binlog_format=ROW
query_cache_size=0
#table_cache=256
tmp_table_size=34M
thread_cache_size=8
#*** MyISAM Specific options
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=32M
key_buffer_size=55M
read_rnd_buffer_size=256K
sort_buffer_size=256K
#innodb_additional_mem_pool_size=3M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=2M
innodb_buffer_pool_size=64M
innodb_log_file_size=20M
innodb_thread_concurrency=20
求教大人怎么优化好,谢谢~