1.

For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by ______________(a) –multiple-transaction(b) –single-transaction(c) –double-transaction(d) –no-transactionI have been asked this question in examination.The doubt is from Database Maintenance, Backups and Replication in chapter MySQL Administration of MySQL

Answer»

Right answer is (b) –single-transaction

Explanation: For InnoDB tables it is possible to perform an ONLINE backup that TAKES no locks on tables using the OPTION ‘–single-transaction’ to ‘mysqldump’. The ‘mysqldump’ can MAKE backups.



Discussion

No Comment Found

Related InterviewSolutions