-Hello
- If you are running FreeBSD 4.0 why not install mysql using
/usr/ports/database/mysql-server.3.xxx
make install
make clean
On Tue, 13 Feb 2001, pdewaha wrote:
> Hi,
> I've mysql 3.23.32 running on FreeBSD 4.0.
> It runs a site with heavy traffic and heavy
> database interaction.
>
> After starting mysql it hangs after some days.
>
> Mysql server is still in the processlist, but
> it is not possible to connect to the sql
> server anymore. Therefor it is impossible
> to stop the server and rerun it without killing.
>
> Problem with threads??
>
> I've found the following in the config.log generated
> by ./configure:
>
> --------------------- SNIP ------------------------
> configure:5648: gcc -o conftest conftest.c -lz -lcrypt -lm 1>&5
> /tmp/ccF77967.o: In function `main':
> /tmp/ccF77967.o(.text+0xf): undefined reference to `pthread_create'
> configure: failed program was:
> #line 5641 "configure"
> #include "confdefs.h"
> #include <pthread.h>
> int main() {
> (void) pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0);
> ; return 0; }
> configure:5662: checking for pthread_create in -lpthread
> configure:5673: gcc -o conftest conftest.c -lz -lcrypt -lm -lpthread
> 1>&5
> /usr/libexec/elf/ld: cannot open -lpthread: No such file or directory
> configure: failed program was:
> #line 5666 "configure"
> #include "confdefs.h"
> #include <pthread.h>
> int main() {
> (void) pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0);
> ; return 0; }
> configure:5688: checking for pthread_create in -lpthreads
> configure:5697: gcc -o conftest
> conftest.c -lz -lcrypt -lm -lpthreads 1>&5
> /usr/libexec/elf/ld: cannot open -lpthreads: No such file or directory
> configure: failed program was:
> #line 5690 "configure"
> #include "confdefs.h"
> #include <pthread.h>
> int main() {
> pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0);
> ; return 0; }
> --------------------- SNIP ------------------------
>
> I've no idea if this is important or not?
>
> I've made a script which reboots the server if connection
> to sql server fails. But this is not a solution :).
>
>
>
> Thanks in advance.
>
> Regards,
> Patric de Waha
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php