• 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

  • 相关阅读:
    2019第二周作业
    求最大值及其下标
    查找整数
    2018秋季学习总结
    抓老鼠 亏了还是赚了
    币值转换
    打印沙漏
    从文本中找出url,并附上链接。
    手机端点击输入框页面会放大
    <dl>、<dt>和<dd>标记的用法
  • 原文地址:https://www.cnblogs.com/javaleon/p/4029214.html
Copyright © 2020-2023  润新知