项目使用过程中会有卡慢的情况,修改MySql配置文件(C:\ProgramData\MySQL\MySQL Server 5.7\my.ini)给MySql更多内存空间:
key_buffer_size=32M
query_cache_size=64M
tmp_table_size=64M
innodb_buffer_pool_size=1024M
innodb_additional_mem_pool_size=16M
innodb_log_buffer_size=8M
max_connections=500
sort_buffer_size=2M
read_buffer_size=2M