MySQL Forums
Forum List  »  Backup

mysqldump for 764000 myisam tables
Posted by: AI Rumman
Date: February 14, 2011 12:55AM

I am running Mysql 5.1 DB for Wordpress Application with Hyperdb plugin enabled.
I have 93000 blogs and for this I have 93000*8(tables per blog) = 764000 tables (MyISAM) in the DB.
I created a backup script to take backup each blog separately and its working fine. But the problem is about timing. Mysqldump is taking almost 2/3 seconds per blog and most of the time are consumed by "SHOW TABLES LIKE" to get the actual tables name (*get_actual_table_name funciton at source code). I changed it for query from INFORMATION_SCHEMA rather that SHOW TABLES and now each log is taking maximum 1 second.

I want to know if you guyes have any other good idea for this huge DB (300GB) backup so that I can go with the default source code.

Options: ReplyQuote

Written By
mysqldump for 764000 myisam tables
February 14, 2011 12:55AM
February 16, 2011 08:02PM
February 16, 2011 11:17PM

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.