mysql配置问题

Lejess 2017-12-16 04:59:35
MySQL的bin目录下没有my-default.ini和my.ini(都没有),影响使用吗,或者说 那个文件是干嘛的
...全文
235 5 打赏 收藏 转发到动态 举报
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
aabbabababaa 2018-01-02
  • 打赏
  • 举报
回复
配置文件,没有还能用?
gaojizhong 2017-12-20
  • 打赏
  • 举报
回复
# 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 # sort_buffer_size = 2M # read_rnd_buffer_size = 2M sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES # lower_case_table_names = 1 主要使用的就是红色的这句话
gaojizhong 2017-12-20
  • 打赏
  • 举报
回复
里面什么都不用设置就可以使用
gaojizhong 2017-12-20
  • 打赏
  • 举报
回复
详细信息参考下面网址: http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html 具体内容如下:主要是数据库的通用设置 [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 = 128M # 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 = ..... # datadir = ..... # port = ..... # server_id = ..... # socket = ..... # 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.r advice on how to change settings please see
夜鹰 2017-12-18
  • 打赏
  • 举报
回复
参考:http://bbs.csdn.net/topics/390340540

4,164

社区成员

发帖
与我相关
我的任务
社区描述
Windows专区 一般软件使用
社区管理员
  • 一般软件使用社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧