Hi Dan, ----- Original Message ----- From: "dan orlic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 2:30 PM Subject: mysql dump speed
> I have a bit of an issue with mysqldumps and inserting it back into > mysql. > > Granted, I have 1 table that has over 1Million entries, but generating > these tables takes about 3 hours with a java app. > But when I do a mysql -u root -p < <the mysql dump.dmp> it is taking > about 28 hours to complete the load. > > Can anyone tell me what is taking so long? Any thoughts as how to speed > it up? Thanks in advance. Was the dump done using the --opt option with mysqldump? This should make reloading faster. What options *were* used? How is your application doing INSERTs? LOCK TABLES and/or multi-line INSERT statements? Is it a MyISAM table? If it's InnoDB, I think you'll need to do the INSERTs in one transaction to get more speed. Maybe your app does this and mysqldump isn't. Just some thoughts. :-) Hope that helps. Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]