September 22, 2008

Fighting MySQL Replication Lag

Posted by peter |

The problem of MySQL Replication unable to catch up is quite common in MySQL world and in fact I already wrote about it. There are many aspects of managing mysql replication lag such as using proper hardware and configuring it properly. In this post I will just look at couple of query design mistakes which result in low hanging fruit troubleshooting MySQL Replication Lag
[read more...]

Posted by peter @ 9:16 pm :: production, replication :: 4 comments
Print This Post Print This Post book mark Fighting MySQL Replication Lag in del.icio.usdel.icio.us :: submit Fighting MySQL Replication Lag to digg.comdigg

Finding what Created_tmp_disk_tables with log_slow_filter

Posted by Ewen |

Whilst working with a client recently I noticed a large number of temporary tables being created on disk.

show global status like 'Created_tmp%'

| Created_tmp_disk_tables | 91970 |
| Created_tmp_files | 19624 |
| Created_tmp_tables | 1617031 |

[read more...]

Posted by Ewen @ 8:16 am :: production :: 3 comments
Print This Post Print This Post book mark Finding what Created_tmp_disk_tables with log_slow_filter in del.icio.usdel.icio.us :: submit Finding what Created_tmp_disk_tables with log_slow_filter to digg.comdigg