MySql Import speed(Was mysql version OSX)

[Mike Matthews]

Thanks Clifford,

All good intel, I'll read up the basic difference between these two in the morning.  Right now, I just want the the data back and so I can read it, I don't expect to want to add to it.

As I said, the DB came from a turnkey linux system called BigRedBox, and yes, it was a big red box that did all of your small office stuff.  But now it has gone wrong and the email system won't open the DB, maybe because it is too big.  But they need some of the data back, etc.

Mike


 


On 20 Dec 2010, at 21:00, CLIFFORD ILKAY wrote:

> On 12/20/2010 02:22 PM, David Swain wrote:
>> I agree that MyISAM is much
>> faster to import (or INSERT) into (for many reasons), so taking a
>> little time to update that script to make all those tables MyISAM
>> tables should pay off big benefits.
> 
> One caveat with MyISAM tables is that it only supports table locks vs. row locks with InnoDB. If you expect that a given table will have a "significant" number of inserts, you should opt for InnoDB. I think the benefits of InnoDB outweigh any speed advantage of MyISAM, if such exists and I've seen benchmarks by credible people to suggest that it doesn't.
> -- 
> Regards,
> 
> Clifford Ilkay
> Dinamis
> 1419-3266 Yonge St.
> Toronto, ON
> Canada  M4N 3P6
> 
> <http://dinamis.com>
> +1 416-410-3326
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com