Re: mysql is a pain in the ass

[Michael Widenius]

>>>>> "Matthias" == Matthias Urlichs <smurf@stripped> writes:

Matthias> Hi,
Matthias> Mike Wexler:
>> I've been having similar problems where adhoc queries acquire a lock and 
>> cause simple/tuned queries to take minutes instead of fractions of a 
>> second. Do other SQL servers have a solution to this problem?

Matthias> Other SQL servers can do locks on single rows. Mysql has to lock the
Matthias> whole table. :-(

Matthias> This probably should be added to the "TODO sometime" list.

Matthias> With a shared-memory server like mysqld, the overhead should be
> negligible...

Actually this isn't not true.  Introducing row locks will also affect
a lot of other things (like dirty reads) and the general performance
could easily be more than 2 times worse for a wide range of queries.

(See also my previous mail about this topic)

Regards,
Monty

PS: Sorry for the late reply;  I am still trying to catch up with the
    mails that piled up during my vacation.