mysql 参数设置
原网站 http://blog.itpub.net/7728585/viewspace-2157988/
如果是 sata 硬盘
innodb_io_capacity=200 (https://blog.csdn.net/kadwf123/article/details/82083020)
innodb_max_dirty_pages_pct=75 (默认值 75 https://www.mytecdb.com/blogDetail.php?id=112)
原网站 http://blog.itpub.net/7728585/viewspace-2157988/
如果是 sata 硬盘
innodb_io_capacity=200 (https://blog.csdn.net/kadwf123/article/details/82083020)
innodb_max_dirty_pages_pct=75 (默认值 75 https://www.mytecdb.com/blogDetail.php?id=112)