MySQL Forums
Forum List  »  Backup

Backing Huge InnoDB Table never ends...
Posted by: Manuel Cameselle
Date: December 05, 2005 03:08AM

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.

Options: ReplyQuote

Written By
Backing Huge InnoDB Table never ends...
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.