Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-03 Thread Egor Egorov
Andrey Kotrekhov <[EMAIL PROTECTED]> wrote: > äÏÂÒÙÊ ÄÅÎØ. áÇÁ, ÄÏÂÒÙÊ, but we speak english here. :) > Usually I run configure like this: Well I don't remember the configure options used in mysql40-server port, but these are recommended. You just want to enable linuxthreads and buildstatic an

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-02 Thread Ken Menzel
Hi, It sounds like you are using the default thread library. I would install MySQL from /usr/ports/databases (WITH_LINUX_THREADS, see options in Makefile) or barring that try Jeremey's excellent build recipe at http://jeremy.zawodny.com/blog/archives/000458.html . We used to have the same pro

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-02 Thread Andrey Kotrekhov
Добрый день. Usually I run configure like this: ./configure \ "--prefix=/usr/local/mysql_4" \ "--without-debug" \ "--with-charset=koi8_ru" \ "--with-extra-charset=koi8_ukr,win1251,win1251ukr" \ "--with-mysqld-user=X" \ --without-berkeley-db \ --without-isam \ --without-innodb \ --enable-thread

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-02 Thread Egor Egorov
Andrey Kotrekhov <[EMAIL PROTECTED]> wrote: > Did you compile mysql from source or you use precompiled binary package? > I use mysql with different versions of FreeBSD without big problems. On FreeBSD, you can compile MySQL from ports. >>> I have several MySQL and FreeBSD installs across a few

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-02 Thread Andrey Kotrekhov
Did you compile mysql from source or you use precompiled binary package? I use mysql with different versions of FreeBSD without big problems. "adp" <[EMAIL PROTECTED]> wrote: I have several MySQL and FreeBSD installs across a few different sites, and I consistently have problems with mysqld. It wil

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-02 Thread Egor Egorov
"adp" <[EMAIL PROTECTED]> wrote: > I have several MySQL and FreeBSD installs across a few different sites, and > I consistently have problems with mysqld. It will begin to eat up all of the > CPU and eventually become unresponsive (or the machine will just burn). I > can't seem to manually reprodu

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-07-31 Thread Miles Keaton
> I have several MySQL and FreeBSD installs across a few different sites, and > I consistently have problems with mysqld. It will begin to eat up all of the > CPU and eventually become unresponsive (or the machine will just burn). I > can't seem to manually reproduce this, but given enough time a F

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-07-30 Thread mos
adp, There are quite a few people with a similar problem with Free BSD. I don't know if they found a solution but here is a place to start looking: http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&q=freebsd+mysql+heavy+cpu&btnG=Search Mike At 01:58 PM 7/30/2004, you wrote: I have sever