• mysql innodb ini


    # For advice on how to change settings please see
    # http://dev.mysql.com/doc/refman/5.6/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 = 128M
    # Uncomment the following if you are using InnoDB tables
    #innodb数据库数据文件目录
    innodb_data_home_dir=D:/java/mysql5.6.20win32/innodbdata
    #:max:2000M #数据文件名称及大小
    innodb_data_file_path=ibdata2:100M:autoextend
    innodb_log_group_home_dir=D:/java/mysql5.6.20win32/innodbdata
    # You can set .._buffer_pool_size up to 50 - 80 %
    # of RAM but beware of setting memory usage too high
    #缓冲池的大小,一般设置为主存的50%-80%
    innodb_buffer_pool_size = 20M
    # Set .._log_file_size to 25 % of buffer pool size
    #日志文件的大小,一般设置为主存的25%
    innodb_log_file_size = 200M
    innodb_log_buffer_size = 8M
    #事务
    innodb_flush_log_at_trx_commit = 1
    #秒
    innodb_lock_wait_timeout = 50
    # 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 = .....


    # 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
    #绑定IPv4和3306端口
    bind-address = 0.0.0.0
    port = 3306

    # 设置mysql的安装目录
    basedir=D:/java/mysql5.6.20win32

    # 设置mysql数据库的数据的存放目录
    datadir=D:/java/mysql5.6.20win32/data

    # 允许最大连接数
    max_connections=200

    default-storage-engine=innodb
    innodb_flush_method=normal

  • 相关阅读:
    课堂作业1(出题)
    微信小程序开发1
    asp.net实现通用水晶报表
    JS实现网络拓扑图
    注册与登录 接口与模板
    cookies and session
    Django路由及get请求post请求
    简析JavaScript事件冒泡机制
    屏蔽运营商流量球分析及解决方法
    使用github搭建个人主页
  • 原文地址:https://www.cnblogs.com/javaleon/p/4029214.html
Copyright © 2020-2023  润新知