Hi,
But upon checking all my tables are InnoDB and no table is on MyISAM.
Is it possible that the entire database is on MyISAM?
We have tried using mysqldump with --single-transaction parameter it works well without locking any table and we can still execute writes to the tables. How can we achieve this in percona?
Thanks in advance.