Re: How to not lock anything?

[Perrin Harkins]

On Mon, Dec 14, 2009 at 8:32 PM, D. Dante Lorenso <dante@stripped> 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