List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:May 24 2003 9:37am
Subject:Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blog
View as plain text  
LS <alphafoo@stripped> wrote:

> The server is handling 800qps, and the slow query log is showing hundreds of cases
> where trivial unrelated INSERT DELAYED queries are being held up for 2 seconds. Is
> there something else I need to do to get these slow queries to go away?

Well, according to Jeremy, you need either: 
 - Linux
 - FreeBSD 5.0 

But I would suggest you to keep out of INSERT DELAYED. Personally I had no
success with them even on Linux. INSERT DELAYED may stay in queue forever due
to it's nature.

> Thanks!




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com



Thread
Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogLS24 May
  • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogDan Nelson24 May
    • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogLS24 May
      • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogDan Nelson24 May
        • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogcolbey24 May
        • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogLS24 May
          • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogDan Nelson24 May
  • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogEgor Egorov24 May
    • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogDan Nelson24 May
      • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogJeremy Zawodny25 May
        • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogLS25 May