How InnoDB handles REDO logging
Xaprb (Baron) recently blogged about how InnoDB performs a checkpoint , I thought it might be useful to explain another important mechanism that affects both response time and throughput – The transaction log.
Ewen FortuneEwen has extensive background in networking and is MySQL Cluster certified. He is a former Percona employee.
Why audit logging with triggers in MySQL is bad for replication
Recently I was tasked with investigating slippage between master and slave in a standard replication setup. The client was using Maatkit’s mk-table-checksum to check his slave data was indeed a fair copy of that of the master.
Finding what Created_tmp_disk_tables with log_slow_filter
Whilst working with a client recently I noticed a large number of temporary tables being created on disk.
|
1 2 3 4 5 |
show global status like 'Created_tmp%' | Created_tmp_disk_tables | 91970 | | Created_tmp_files | 19624 | | Created_tmp_tables | 1617031 | |