On Mon, Dec 14, 2009 at 8:32 PM, D. Dante Lorenso <[email protected]> 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/[email protected]
