Backing Huge InnoDB Table never ends...
Hi everybody,
I was backing up a huge InnoDB table with mysqldump. It was taking about an hour, but since a week i have to cancel the script because it loads heavily the server and it seems to never end (the more i waited was 6 hours and it was causing big problems to the server applications).
I think this can be because of InnoDB multiversioning. Maybe when the table reaches a critical size, the system degrades when trying to do a full scan.
I was trying to LOCK the innodb table during the full scan to avoid multiversioning CPU load, but i'm not use to deal with locks and was not able to lock the table. It seems the only option is --lock-all-tables, but i cannot do this because of application architectural.
Has someone a fast solution? In some months i'm going to test two alternatives: InnoDB Hot Backup and Replication, but now i need a temporary solution in the mid time.
Thanks a lot,
Manuel Cameselle.
Subject
Views
Written By
Posted
Backing Huge InnoDB Table never ends...
3093
December 05, 2005 03:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.