Questions tagged [mysqlhotcopy]
2 questions
2
votes
2 answers
Does mysqlhotcopy block SELECT statements from different clients?
I would like to create a backup of different MyISAM tables on a server using mysqlhotcopy. These tables are about 6GB in size. I would like to know, does mysqlhotcopy block users from SELECTing (reading) data from the tables while taking the…
Tim
- 21
- 1
2
votes
1 answer
Why is mysqlhotcopy slower compared to rsync?
My understanding is mysqlhotcopy works very similar to rsync.
In one of our servers backing the database file using rsync takes about 15 minutes for 50GB data.
Backing up the same data using mysqlhotcopy takes about 30 minutes.
How come mysqlhotcopy…
Haluk
- 619
- 3
- 12
- 22