From: Perrin Harkins
Date: December 15 2009 4:57pm
Subject: Re: How to not lock anything?
List-Archive: http://lists.mysql.com/mysql/219780
Message-Id: <66887a3d0912150857t7e17d498y5690f1bf090a8b6c@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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. =A0The 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