Fwd: Issue with locking and INSERT DELAYED

2007-05-15 Thread Michael Dykman
If there are no holes in the data structure storing the MyISAM data, this concurrency is possible but as soon as any real-world maintenance kicks in, those holes will exists and the rules kick in: on MyISAM you may have 1 writer OR many readers. a write operation will wait for ongoing read

Re: Fwd: Issue with locking and INSERT DELAYED

2007-05-15 Thread mos
If your client has the bucks and you need the speed, why not use a MySQL cluster which has row locks and transactions? Mike At 11:39 AM 5/15/2007, you wrote: If there are no holes in the data structure storing the MyISAM data, this concurrency is possible but as soon as any real-world