8
votes
3answers
2k views

Do InnoDB tables got locked during mysqldump when mixed with MyISAM?

I'm looking for a backup solution for my mysql servers and I need as less downtime as possible. I have the following: MySQL servers they are not replicated each server stands for its own This ...
2
votes
2answers
644 views

which is faster mysqldump/restore or alter table?

I have InnoDB databases and they are using the same ibdata file, the size of this ibdata is around 250G. now i have one of those DBs around 100G. My manager asked me to move this DB to another server ...
0
votes
2answers
645 views

mysqldump, myisam, and read local

When mysqldump is run with --lock-tables against a database using MyISAM tables, the documentation states that each table is locked with READ LOCAL. As I understand it, READ LOCAL allows for ...