Re: Mysqldump and read lock

2004-12-13 Thread Gleb Paharenko
Hello. Usually clients are blocked with insert or update statements until table became unlocked. Their threads just sleep and then continue execution (but they can got an error if query doesn't return for a long time). INSERT queries are not buffered in that sense you've ment, unlike they are INSE

Mysqldump and read lock

2004-12-09 Thread olivier . maurice
Hi all, Looking for a way to automate backup I was thinking of scheduling mysqldump on a daily base. It want to use the read lock, but I am not really sure about the consequences of this. Does putting a read lock on the files can cause loss of data? It is no problem pausing the flow of incoming