MySql Import speed(Was mysql version OSX)

[Mike Matthews]

Correct, nothing new going in and the import has finished, it got faster and faster.

Thanks

Mike


 


On 20 Dec 2010, at 21:25, David Swain wrote:

> Yes, but Mike's initial statement was "I want to import a customers current dump file, so I can look and see if I want to use the data and move it to our systems". It doesn't appear that any transactions are planned. Import speed is improved, especially for large tables, because non-unique indexes can be disabled during the import (or execution of the script with INSERT statements, as is the case here) with MyISAM, but not with InnoDB (although mysqldump, the program that created the "export" of the script puts in those directives by default regardless of the storage engine used with each table). So while your statement is somewhat true, especially with version 5.5 where tremendous performance enhancements have been made with InnoDB, MyISAM would still be the preferred storage engine for import. Concurrent inserts into a MyISAM table that is not fragmented are also non-locking.
> 
> But moot points all around, since the process is well under way and Mike did not know any of this before launching the script execution. No transactions in sight!
> 
> Regards,
> 
> David
> 
> On Dec 20, 2010, at 4:00 PM, 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
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com