Re: mysql is a pain in the ass

[Michael Widenius]

>>>>> "Raul" == Raul Miller <raul@stripped> writes:

Raul> On Wed, Nov 03, 1999 at 04:10:43PM +0200, sinisa@stripped wrote:
>> The current framework of mysql is streamlined towards the fastest
>> execution of individual commands. Therefore design should also take
>> into account it's many strong point and those very few, minor not so
>> great points ;O) 
>> 
>> That means, beside other things, that with these table lockup's you
>> should normalize your table maximally. It should be at least fourth
>> form or Boyce/Codd normal form. Then waits, will be much smaller.

Raul> This has been done (at least for that database design -- the
Raul> database is being redesigned, but that's another issue).

>> Regarding your query, as it does not lock any tables, you should
>> ponder into it's intricacies and speed it up.

Raul> In mysql, all selects lock tables against inserts, updates, etc.

Hi!

Not really;  You can still perform INSERT DELAYED on the locked
select.

Within about 2 MySQL releases (1 month ?) we should also have
concurrent INSERT + SELECTS running for MyISAM tables + concurrent
SELECT + insert/update/delete for the new transaction safe tables.

Regards,
Monty