MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Re: INSERT INTO tLocalFileIDs SELECT .... behaviour
Posted by: Ingo Strüwing
Date: February 13, 2006 05:53AM

See http://dev.mysql.com/doc/refman/5.0/en/concurrent-inserts.html and http://dev.mysql.com/doc/refman/5.0/en/insert.html

MyISAM tables use concurrent insert automatically unless it is disabled.
In your case it might be best to disable it by using INSERT HIGH_PRIORITY ...

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
INSERT INTO tLocalFileIDs SELECT .... behaviour
2629
David Stevenson
February 13, 2006 04:10AM
Re: INSERT INTO tLocalFileIDs SELECT .... behaviour
1753
Ingo Strüwing
February 13, 2006 05:53AM


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.