# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the # *** default location during install, and will be replaced if you # *** upgrade to a newer version of MySQL. [mysqld] # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. innodb_buffer_pool_size = 600M #(Mysql数据缓存大小,根据自己内存大小跟需求调整) # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # These are commonly set, remove the # and set as required. basedir = C:\Program Files\mysql57 #(Mysql目录路径) datadir = C:\Program Files\mysql57\data #(Mysql库路径,默认是跟根录下data文件夹,注意这个路径改了的话一定要把原data目录下的文件复制过去,不然会报1067错误) character-set-server=utf8 #(服务器默认字符,跟上面保持一致) port = 3306 #(Mysql使用端口,默认3306) server_id = 11 # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M (Join操作使用内存) # sort_buffer_size = 2M (排序使用内存) # read_rnd_buffer_size = 2M (随机读取数据缓冲区使用内存)(以上三条根据自己的情况设置) sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码(独立后台)...苏ICP备2024110244号-2 苏公网安备32050702011978号 增值电信业务经营许可证编号:苏B2-20251499 | Copyright 2018 - 2025 源码网商城 (www.ymwmall.com) 版权所有