MySQL Compressed Binary Logs
On a busy server, the binary logs can end up being one of the largest contributors …
Performance
Apress Blog: MySQL Performance Tuning Best Practices
To celebrate the publishing of my new book MySQL 8 Query Performance Tuning, the Apress team …
Apress Blog: MySQL Performance Tuning Best Practices Read more →
MySQL 8.0.20: Index-Level Optimizer Hints
MySQL introduced optimizer hints in version 5.7 and greatly extended the feature in MySQL 8. One …
New Book: MySQL 8 Query Performance Tuning
I have over the last few years been fortunate to have two books published through Apress, …
Connector/Python C Extension Prepared Statement Support
MySQL Connector/Python 8 made the C Extension the default for the platform/Python version combinations supporting it. …
Connector/Python C Extension Prepared Statement Support Read more →
More Statistics for Slow Queries: log_slow_extra
The slow query log is the trusted old method of recording slow query, so the database …
More Statistics for Slow Queries: log_slow_extra Read more →
Install MySQL Enteprise Monitor (MEM) 3.0 Using Limited Resources
MySQL Enterprise Monitor (MEM) is the monitoring solution offered as part of MySQL Enterprise Edition and …
Install MySQL Enteprise Monitor (MEM) 3.0 Using Limited Resources Read more →