If you have binary logging enabled on your MySQL server (i.e. the log-bin parameter is set in the config file), then you may notice a bulk of large files in the MySQL data directory over time. Generally you only need to enable this binary logging if your server is acting as a relication master or if you need the ability to do point in time recovery from your latest backup. » Read more: Purge MySQL Binary Logs periodically
‘mysql’ topic list
Purge MySQL Binary Logs periodically
March 9th, 2010Tips for Rebuilding MySQL Replication
November 27th, 2009Let’s keep this post smart. It’s intended to help you rebuild a crashed MySQL replication. We assume that bin-log has been enabled at the master side.
Basically what you need to do is to retrival a snapshot of your master database. It covers three types of information, a snapshot of your current mysql database, and master log file name and its running position when this snapshot created. » Read more: Tips for Rebuilding MySQL Replication
Repair MySQL Replication by SQL_SLAVE_SKIP_COUNTER
September 11th, 2009If you set up MySQL replication, you probably have ever faced this problem. there are invalid MySQL queries which cause the replication not to work anymore. Here I’ll explain how you can repair the replication on MySQL slave without rebuilding the whole repication environment. There are two steps here: » Read more: Repair MySQL Replication by SQL_SLAVE_SKIP_COUNTER
MPB: InnoDB vs MyISAM vs Falcon
September 11th, 2009MySQLPerformanceBlog has issue “Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM. » Read more: MPB: InnoDB vs MyISAM vs Falcon
Falcon Storage Engine Design Review
September 8th, 2009Now as new MySQL Storage engine – Falcon is public I can write down my thought about its design, which I previously should have kept private as I partially got them while working for MySQL. » Read more: Falcon Storage Engine Design Review