Category MySQL 8.0

MySQL & UUIDs

More and more people are using UUID’s to identify records in their database. As you already know, for MySQL’s storage engine (InnoDB) the primary key is very important ! (for performance, memory and disk space). See the following links: …

Dynamic InnoDB Redo Log

Since 8.0.30, you have the possibility to modify the InnoDB Redo Log Capacity online. An undersized Redo Log Capacity is problematic and lead to performance issues. However, it’s not recommended to oversize the Redo Log either. Redo Log files consume…