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.

Thread
mysql is a pain in the assMark O. Davis26 Oct
  • Re: mysql is a pain in the assEd Carp26 Oct
  • Re: mysql is a pain in the assLindsay Davies26 Oct
  • Re: mysql is a pain in the assfooler26 Oct
  • Re: mysql is a pain in the assBogdan Paduraru26 Oct
  • RE: mysql is a pain in the assDavid Moreno S.26 Oct
  • Re: mysql is a pain in the assJeremy Cole26 Oct
  • Re: mysql is a pain in the assMark Russell26 Oct
  • Re: mysql is a pain in the assMark Russell26 Oct
  • Re: mysql is a pain in the assRuben I Safir26 Oct
  • Re: mysql is a pain in the assRuben I Safir26 Oct
  • Re: mysql is a pain in the assTonu Samuel26 Oct
  • Re: mysql is a pain in the ass(Paul D. Smith)26 Oct
  • Re: mysql is a pain in the assfooler27 Oct
  • Re: mysql is a pain in the assfooler27 Oct
    • Re: mysql is a pain in the assEd Carp27 Oct
  • Re: mysql is a pain in the assfooler27 Oct
  • Re: mysql is a pain in the assfooler27 Oct
    • Re: mysql is a pain in the assEd Carp27 Oct
      • Re: mysql is a pain in the assfooler27 Oct
        • RE: mysql is a pain in the assOzlinx)27 Oct
        • Re: mysql is a pain in the assEd Carp27 Oct
          • Re: mysql is a pain in the assRuben Safir27 Oct
      • Re: mysql is a pain in the assJay J27 Oct
      • Re: mysql is a pain in the assTonu Samuel27 Oct
        • Re: mysql is a pain in the assDan Nelson27 Oct
        • Re: mysql is a pain in the assDan Nelson27 Oct
      • Re: mysql is a pain in the assfooler27 Oct
        • Re: mysql is a pain in the assJani Tolonen27 Oct
          • Priorities on the TODO list [was Re: mysql is a pain in the ass]Bob Kline27 Oct
            • MySQL and ZendStephen J. Taranto27 Oct
              • Re: MySQL and Zend(Sean McKenna)28 Oct
        • Full commercial products vs. open source [was Re: mysql is a painin the ass]Bob Kline27 Oct
        • RE: mysql is a pain in the assOzlinx)28 Oct
      • Re: mysql is a pain in the assJay J27 Oct
      • Re: mysql is a pain in the assTonu Samuel27 Oct
      • Re: mysql is a pain in the assTonu Samuel27 Oct
      • Re: mysql is a pain in the assfooler27 Oct
        • Re: mysql is a pain in the assBob Kline27 Oct
        • Re: mysql is a pain in the assRuben Safir27 Oct
        • Re: mysql is a pain in the assMike Schwartz28 Oct
          • Re: mysql is a pain in the assJani Tolonen28 Oct
            • Re: mysql is a pain in the assMike Schwartz29 Oct
              • Re: mysql is a pain in the assFrederik Lindberg29 Oct
                • Re: mysql is a pain in the assMike Schwartz29 Oct
                  • Re: mysql is a pain in the assFrederik Lindberg29 Oct
                    • Re: mysql is a pain in the assMichael Widenius14 Nov
                      • LIKE '%foo%' (was: mysql is a ...)Frederik Lindberg14 Nov
                  • Re: mysql is a pain in the assMichael Widenius14 Nov
                    • Re: mysql is a pain in the assBob Kline14 Nov
      • Re: mysql is a pain in the assTonu Samuel28 Oct
      • Re: mysql is a pain in the assfooler29 Oct
        • Hardware vs Software and the speedJani Tolonen29 Oct
      • Re: Hardware vs Software and the speedfooler29 Oct
        • Re: Hardware vs Software and the speedJani Tolonen29 Oct
      • Re: mysql is a pain in the asssasha29 Oct
      • Re: Hardware vs Software and the speedfooler30 Oct
        • Re: Hardware vs Software and the speedJani Tolonen1 Nov
      • Re: mysql is a pain in the assDuncan Kinder30 Oct
  • Re: mysql is a pain in the assSabat27 Oct
  • Re: mysql is a pain in the ass(Paul D. Smith)27 Oct
Re: mysql is a pain in the assOzlinx)26 Oct
RE: mysql is a pain in the assJohn Foley26 Oct
  • RE: mysql is a pain in the assBob Kline26 Oct
  • mysql GUI ClientBronco26 Oct
    • Re: mysql GUI Clientjurban26 Oct
Re: Hardware vs Software and the speedfooler30 Oct
  • Re: Hardware vs Software and the speedsinisa30 Oct
Re: mysql is a pain in the assJoseph R. Junkin30 Oct
  • Re: mysql is a pain in the assLarry Rufo30 Oct
    • Re: mysql is a pain in the assBlain Nelson1 Nov
  • Re: mysql is a pain in the assMike Schwartz1 Nov
Re: Hardware vs Software and the speedEd Carp1 Nov
Re: mysql is a pain in the assEd Carp1 Nov
  • Re: mysql is a pain in the assLarry Rufo2 Nov
Re: mysql is a pain in the assDejan Lekic1 Nov
Re: mysql is a pain in the assRaul Miller1 Nov
  • Re: mysql is a pain in the asssinisa2 Nov
    • Re: mysql is a pain in the assMatthias Urlichs2 Nov
    • Re: mysql is a pain in the assRaul Miller2 Nov
      • Re: mysql is a pain in the assPatrick Greenwell2 Nov
        • Re: mysql is a pain in the assRaul Miller2 Nov
          • Re: mysql is a pain in the asssinisa3 Nov
            • Re: mysql is a pain in the assRaul Miller3 Nov
              • Re: mysql is a pain in the asssinisa4 Nov
                • Re: mysql is a pain in the assRaul Miller4 Nov
              • Re: mysql is a pain in the assMichael Widenius14 Nov
                • Re: mysql is a pain in the assRaul Miller14 Nov
      • Re: mysql is a pain in the asssinisa3 Nov
        • Re: mysql is a pain in the assRaul Miller3 Nov
          • Re: mysql is a pain in the assMichael Widenius14 Nov
  • Re: mysql is a pain in the assDave Hodgkinson2 Nov
    • Re: mysql is a pain in the assRaul Miller2 Nov
Re: mysql is a pain in the assEd Carp3 Nov
  • Re: mysql is a pain in the assRaul Miller3 Nov
    • Re: mysql is a pain in the assMike Wexler3 Nov
      • Re: mysql is a pain in the assMatthias Urlichs7 Nov
        • Re: mysql is a pain in the assRaul Miller8 Nov
        • Re: mysql is a pain in the assMichael Widenius28 Nov
      • Re: mysql is a pain in the assMichael Widenius28 Nov
  • MySQL 3.23.7? (was)Re: mysql is a pain in the assVan28 Nov
    • Re: MySQL 3.23.7? (was)Re: mysql is a pain in the asssinisa28 Nov
  • Re: MySQL 3.23.7? (was)Re: mysql is a pain in the assTonu Samuel28 Nov