|List:||General Discussion||« Previous MessageNext Message »|
|From:||Michael Widenius||Date:||November 28 1999 12:42pm|
|Subject:||Re: mysql is a pain in the ass|
|View as plain text|
>>>>> "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.