Currently, I use mysqldump to backup several large MySQL databases amounting to millions of rows of data. During the dump process, tables get locked for reading. 99% of the time, this system works just fine.

Ever so often (perhaps every 50-100 dumps), a read lock will hang on a table …