您的当前位置:首页正文

MySQL8.0 优化

来源:华佗健康网

参考

SSD IO优化

innodb_log_compressed_pages
If redo logs are on non-rotational storage, consider disabling this option to reduce logging. See Disable logging of compressed pages.

When using the InnoDB table compression feature, images of re-compressed pages are written to the redo log when changes are made to compressed data. This behavior is controlled by innodb_log_compressed_pages, which is enabled by default to prevent corruption that can occur if a different version of the zlib compression algorithm is used during recovery. If you are certain that the zlib version will not change, disable innodb_log_compressed_pages to reduce redo log generation for workloads that modify compressed data.
差不多的意思。。关了试试。。

转载于:https://www.cnblogs.com/Coye/p/9914121.html

因篇幅问题不能全部显示,请点此查看更多更全内容