NealC
Well-known member
I've been investigating a slower than desired site and made a few changes. This evening I was learning about setting innodb_file_size and the logs for MySQL 8.0.30 on Ubuntu Server 22.04 pointed me to the fact it's now deprecated and we should now use innodb_redo_log_capacity. I set this new property to 4G and my site is so much faster. If you're not aware of this change in MySQL server I suggest researching it. Here is an article that may be of interest in my google research learning about it.
mydbops.wordpress.com
![mydbops.wordpress.com](/community/proxy.php?image=https%3A%2F%2Fmydbops.files.wordpress.com%2F2022%2F09%2Fmydbops_innodb_online_resize.jpg%3Fw%3D1200&hash=7e32ace40a718c6f4e327aa73f20b917&return_error=1)
Dynamic InnoDB Redo log Resize MySQL 8.0.30
Tired of downtimes and planning to resize your redo log files in MySQL ( InnoDB)? Here we can find a smile on our faces! The latest release of MySQL 8.0.30 ( 2022-07-26 ) has added the Onlin…
![mydbops.wordpress.com](/community/proxy.php?image=https%3A%2F%2Fmydbops.files.wordpress.com%2F2018%2F04%2Fcropped-facebookfinal_symbol.png%3Fw%3D32&hash=66f97c89cf91077939dde3f71a01c40a&return_error=1)