List:General Discussion« Previous MessageNext Message »
From:LS Date:May 25 2003 5:15am
Subject:Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blog
View as plain text  
Hey Jeremy-
    I saw in your blog here (http://jeremy.zawodny.com/blog/archives/000697.html)
your mentioning that 4.x+FreeBSD+LinuxThreads doesn't suffer from the starved query
problem anymore. Do you think what I am seeing (the slow query log I posted) is
caused by something else perhaps? 
    On a possibly unrelated note, if I try running the same scenario (long query on
DB "A" + many short queries on DB "B" interleaved) with a 4.1.0-alpha build, I am
able to reliably wedge both query threads within 30 seconds, and have to kill -9
the mysql processes to shutdown. I know it's an alpha build and all, but that just
seems a bit fishy. I'm not sure if that is connected to my slow query problem, but
I thought I'd mention it in case it rang a bell with someone.

-Loren

--- Jeremy Zawodny <Jeremy@stripped> wrote:
> On Sat, May 24, 2003 at 01:02:37PM -0500, Dan Nelson wrote:
> > In the last episode (May 24), Egor Egorov said:
> > > 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 
> > 
> > Or FreeBSD 4 + LinuxThreads.
> 
> Yup.  It's working quite well for us. :-)
> -- 
> Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
> <Jeremy@stripped>  |  http://jeremy.zawodny.com/
> 
> MySQL 4.0.8: up 110 days, processed 3,450,993,894 queries (361/sec. avg)
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.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