zl程序教程

您现在的位置是:首页 >  数据库

当前栏目

MySQL 配置文件参数详解

mysql配置文件 详解 参数
2023-09-14 09:13:13 时间

MySQL 配置文件参数详解

  • innodb_log_buffer_size=1M
The size of the buffer InnoDB uses for buffering log data. As soon as  it is full, 
InnoDB will have to flush it to disk. As it is flushed once per second anyway,
 it does not make sense to have it very large (even with long transactions).

不管怎样,因为log是每秒钟刷写一次,所以将其设置成很大是没有意义的(即使有一个很长的事务)