Writers do block readers. Just at the row level vs the table level of MyISAM. It's just much less likely for writers to block readers.
keith On Tue, Dec 15, 2009 at 11:57 AM, Perrin Harkins <per...@elem.com> wrote: > On Mon, Dec 14, 2009 at 8:32 PM, D. Dante Lorenso <da...@lorenso.com> > wrote: > > I have an "items" table that is heavily updated with 40 million records > > every 1 or 2 days and I need all those items indexed so they can be > > searched. The problem that I'm having is that the table is constantly > > locked because an insert or delete is being performed. > > > > I am playing with InnoDB vs MyIsam and have been trying to figure out how > to > > get the best performance. > > Problem solved: use InnoDB. Writers don't block readers and vice versa. > > - Perrin > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=bmur...@paragon-cs.com > > -- Chief Training Officer Paragon Consulting Services 850-637-3877
