## 控制每次写脏页到磁盘的页数,默认是200 show global status like '%dblwr%';
### 如果dblwr_pages_written/dblwr_writes < 64 则说明主机的io还没有成为瓶颈,可以考虑增大这个参数,可以缩短恢复的时间
innodb_io_capacity=500
mysql.cnt_it.sock@(none)> show global status like '%dblwr%';
+----------------------------+-----------+
| Variable_name | Value |
+----------------------------+-----------+
| Innodb_dblwr_pages_written | 509181077 |
| Innodb_dblwr_writes | 12873289 |
+----------------------------+-----------+
## 观察到本机的binlog cache 用到了磁盘缓存,需要调大尺寸 show global status like '%binlog%'
binlog_cache_size=2M
mysql.cnt_it.sock@(none)> show global status like '%binlog%';
+----------------------------+----------+
| Variable_name | Value |
+----------------------------+----------+
| Binlog_cache_disk_use | 42257 | ## 用到了磁盘的临时文件,有兴趣的同学,可以去翻翻源代码,
| Binlog_cache_use | 15027296 | 看看里面是怎么写的
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use | 12 |
| Com_binlog | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
+----------------------------+----------+
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/133735/viewspace-707960/,如需转载,请注明出处,否则将追究法律责任。