Re: KSE & MySQL & rc.d

From: Alexander Motin (mav_at_alkar.net)
Date: 10/15/03

  • Next message: Doug White: "Re: sata stripe & dual boot" 
    Date: Wed, 15 Oct 2003 18:21:06 +0300
To: David Xu <davidxu@freebsd.org>

    David Xu wrote:
    > Alexander Motin wrote:
    >> This patch did not fix the problem. On the 4th boot system hang with
    >> same symptoms.
    >>
    >> Daniel Eischen wrote:
    >>
    >>>> I have P4 system with SMP kernel and HyperThreading enabled.
    >>>> I have one strange problem with mysql 4.1.0 when using KSE on
    >>>> 5.1-CURRENT.
    >>>
    >>>
    > I have been running MySQL 4.1.0 on my SMP machine for monthes, it is
    > not P4 HyperThreading,
    > but a dual P3 machine, it just works fine for me.

    Do you have 5.1-CURRENT on your machine? Do you using KSE?
    >
    >>>> After building mysql server with libkse as thread library and adding
    >>>> its start script into /usr/local/etc/rc.d, system hangs on boot
    >>>> without any error message when mysql trying to start.
    >>>
    >>>
    > Did kernel lock up or can you press ctrl+c to see if you can interrupt it ?

    After that computer do not respond on Ctrl+C, Ctrl+Alt+Del, Enter or any
    other key.
    >
    >>>> If I trying to start mysql by hands after system completely boot
    >>>> then everything works just fine.
    >>>> If I add delay into mysql start script and run it in backgroud from
    >>>> rc.d - everything is fine
    >>>
    >>>
    > If you build mysql from ports, it should install script mysql-server.sh
    > under /usr/local/etc/rc.d,
    > the default script will run mysqld_safe in background, I am confused
    > that you need to
    > manually turn it into background, the work should be done atomically by
    > the script.

    I had built mysql by hands from sources with options:
    ./configure \

    --prefix=/usr/local/mysql_4 \

    --without-debug \

    --with-charset=koi8r \

    --with-extra-charset=koi8_ukr,win1251,win1251ukr \

    --with-mysqld-user=mysql \

    --without-berkeley-db \

    --without-isam \

    --without-innodb \

    --enable-thread-safe-client \

    --with-named-thread-libs=-lkse

    I use mysql.server script from mysql sources. My workaround is not only
    in background running of mysqld_safe (mysql.server script doing this
    anyway) but in running it after some delay to allow system finish his
    boot process and create virtual consoles.
    >
    >>>> If I build mysql without KSE it works fine. 

    -- 
Alexander Motin mav@alkar.net
ISP "Alkar-Teleport"
_______________________________________________
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: Doug White: "Re: sata stripe & dual boot"

    Relevant Pages

    • Re: Cyrus IMAP with pam_mysql?
      ... FreeBSD, but if you check the startup script, all the parameters are ... Default log directories are in the default data directory, ... Makefile for mysql) They are changed in the above script prior to ... imaps auth sufficient pam_unix.so ...
      (freebsd-questions)
    • Re: MySQL to SQL
      ... basically I want to take a MySql script and load it into a SQL database. ... BIOS_RELEASE_DATE datetime default NULL, ... CUSTOM_TEXT_FIELD1 mediumtext, ...
      (microsoft.public.scripting.wsh)
    • Re: mysql - kern.maxfiles limit exceeded by uid 500 please see tuning(7)
      ... Since mysql crashes after 5 days of running your script, ... better check its operation and see if it is causing your system to exceed ...
      (comp.unix.bsd.freebsd.misc)
    • Re: MySQL
      ... Then you can use it from inside MySQL or on the commandline ... it is crying out for a script wrapper to make it more flexible. ... you have the option to use a csv engine. ... So you can now select from your dbase files into a csv file. ...
      (alt.os.linux.suse)
    • RE: [PHP] Encrypted 2.5+M files do upload, but dont create a record when stored as LongBlobs (PHP/Ap
      ... This may be a stupid question. ... Set the script operational memory to 80M. ... I did read something about a limitation of MySQL and max packet ... it is mostly people asking the same question I am with recommendations on ...
      (php.general)