MySQL8.0 優化

參考

https://dev.mysql.com/doc/refman/8.0/en/insert-optimization.html

https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-bulk-data-loading.html

SSD IO優化

https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-diskio.html

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