Turn off InnoDB Redo Log

[jrchamp]

As of MySQL 8.0.21, it is possible to turn off the InnoDB Redo Log using this SQL: ALTER INSTANCE DISABLE INNODB REDO_LOG

I noticed a significant reduction in unnecessary disk writes when running tests this way. It is documented as being helpful load databases quickly, which is exactly what we want for test suites, especially because we're not worried about potential loss of important data.

I have no idea how to implement this as part of this action, but the equivalent command line could be:

echo 'ALTER INSTANCE DISABLE INNODB REDO_LOG' | mysql -h 127.0.0.1 -u test -p test