Mysql Cache while HotCopy runs

[Daxwells]

Hi,

What I am looking for is if MySQL has the ability to cache Transactions while the database is locked (i.e. doing a Mysqlhotcopy or possible starting replication) whether in a buffer or possibly temporary table and then to commit this data to the database once the tables are unlocked.

Obviously it would be better if the buffers were able to be defined at differing sizes.

Thanks for any help you may offer.

Dax

 

[Bastien]

http://dev.mysql.com/doc/mysql/en/mysqlbinlog.html

talks about logging the activity while starting up replication.

MysqlHotCopy only works on ISAM or MyISAM tables so transactions are not a concern (since they don't support transactions)



Bastien

Cat, the other other white meat