Re: MySQL with KSE -- Unstable?

From: Sven Willenberger (sven_at_dmv.com)
Date: 02/03/04

  • Next message: Paul Seniura: "Haven't seen a trap 9 yet :) (Re: trap 9 still happening; ata1-slave still repeats; my kernel in uue/tar/bzip2 format with a couple extra files)" 
    To: freebsd-current@freebsd.org
Date: Tue, 03 Feb 2004 16:12:50 -0500

    On Tue, 2004-02-03 at 14:34, Kris Gale wrote:
    > I've given MySQL on KSE a couple of tries in production, and I've
    > run into a problem where threads seem to build up after an hour
    > or so, depending on load.
    >

    > Any ideas? Has anyone else had success with MySQL on 5.2
    > with KSE in high-load environments?
    >
    > Kris Gale

    Ran into a similar situation when I used libmap.conf to use libkse for
    apache and mpm worker model. Following the manpage example, I set
    default threads to use libthr instead of libc_r. Running a fairly hi
    load web/mysql server, I ended up with with the error "unable to create
    new threads" and and had to kill the mysql server. It seems that mysql
    is partial to libc_r rather than libkse or libthr(?) as changing the
    libmap entry back to libc_r for default cured the mysql woes.

    Sven

    _______________________________________________
    freebsd-current@freebsd.org mailing list
    http://lists.freebsd.org/mailman/listinfo/freebsd-current
    To unsubscribe, send any mail to "freebsd-current-unsubscribe@freebsd.org"

  • Next message: Paul Seniura: "Haven't seen a trap 9 yet :) (Re: trap 9 still happening; ata1-slave still repeats; my kernel in uue/tar/bzip2 format with a couple extra files)"

    Relevant Pages

    • Re: just what does kserel mean?
      ... I'm a newbie with freebsd and am concerned that this might be some sort of problem since my installation of Mysql turned out to be rather challenging. ... In other words, as soon as there is a scheduling decision to be made, the ... KSE becomes unassigned, because the kernel does not presume to know how ... always return to user space as soon as possible via the upcall mechanism ...
      (freebsd-questions)
    • mysqld 4.1.1_2 sig 11 for TCP-based access
      ... There is a PR related to 4.0 version of the server, ... It could be related to the kse, ... The mysql client connects ok. ... Do you Yahoo!? ...
      (freebsd-current)
    • MySQL with KSE -- Unstable?
      ... I've given MySQL on KSE a couple of tries in production, ... The first time I tried it, we were maintaining a load of about 600 ... threads and 300 queries/second and lasted about three hours ...
      (freebsd-current)
    • KSE & MySQL & rc.d
      ... I have one strange problem with mysql 4.1.0 when using KSE on 5.1-CURRENT. ... If I trying to start mysql by hands after system completely boot then ... If I add delay into mysql start script and run it in backgroud from rc.d ...
      (freebsd-current)