Handling lots of connections on FreeBSD 4.9
I compiled 4.0.18 on FreeBSD 4.9 with linuxthreads support and all of jeremy's suggestions. My database needs to handle a ton of connections that are very quick (one INSERT DELAYED each). Using super-smack to do some benchmarking, I've found that anyting over 80 connections and I begin to see the following errors over and over and over. super-smack: Could not lock the pipe semaphore 2228226 errno = 22, error is Invalid argument I've tried messing with almost every my.cnf parameter and it seems that have little to no effect on this error. Anyone have any advice here? I feel lost at this point. Thanks in advance, Max Michaels -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Handling lots of connections on FreeBSD
I compiled 4.0.18 on FreeBSD 4.9 with linuxthreads support and all of jeremy's suggestions. My database needs to handle a ton of connections that are very quick (one INSERT DELAYED each). Using super-smack to do some benchmarking, I've found that anyting over 80 connections and I begin to see the following errors over and over and over. super-smack: Could not lock the pipe semaphore 2228226 errno = 22, error is Invalid argument I've tried messing with almost every my.cnf parameter and it seems that have little to no effect on this error. Anyone have any advice here? I feel lost at this point. Thanks in advance, Max Michaels -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Building super-smack on freebsd 4.9
[EMAIL PROTECTED] wrote:
Not sure if this is the place to post this but...
I'm trying to build super-smack-1.2 on freebsd 4.9 w/ MySQL 4.0.18 and
am
running into the following problems. Below are configure, make and gmake
output:
[EMAIL PROTECTED] /usr/local/src/build/super-smack-1.2$ ./configure --with-mysql
creating cache ./config.cache
checking for a BSD compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... yes
checking for working aclocal... found
checking for working autoconf... found
checking for working automake... found
checking for working autoheader... found
checking for working makeinfo... found
checking for sh... /bin/sh
checking for gcc... gcc
checking whether the C compiler (gcc ) works... yes
checking whether the C compiler (gcc ) is a cross-compiler... no
checking whether we are using GNU C... yes
checking whether gcc accepts -g... yes
checking for c++... c++
checking whether the C++ compiler (c++ ) works... yes
checking whether the C++ compiler (c++ ) is a cross-compiler... no
checking whether we are using GNU C++... yes
checking whether c++ accepts -g... yes
checking how to run the C preprocessor... gcc -E
checking for a BSD compatible install... /usr/bin/install -c
checking whether ln -s works... yes
checking for flex... flex
checkin
g for flex... (cached) flex
checking for yywrap in -lfl... yes
checking lex output file root... lex.yy
checking whether yytext is a pointer... yes
checking for bison... no
checking for byacc... byacc
checking for compress in -lz... yes
checking for crypt in -lcrypt... yes
checking for crypt... yes
checking for libmysqlclient...
checking for mysql_real_connect in -lmysqlclient... yes
checking for mysql_real_connect in -lmysqlclient... (cached) yes
checking for mysql.h...
checking for ANSI C header files... yes
checking for sys/time.h... yes
checking for unistd.h... yes
checking whether time.h and sys/time.h may both be included... yes
checking return type of signal handlers... void
checking for gettimeofday... yes
checking for strerror... yes
updating cache ./config.cache
creating ./config.status
creating Makefile
creating src/Makefile
creating config.h
Building with the following options:
MySQL Support. yes
PostgreSQL Support no
Oracle Support no
If this is not what you intended, please re-run configure.
Thanks for using super-smack!
[EMAIL PROTECTED] /usr/local/src/build/super-smack-1.2$ gmake
gmake all-recursive
gmake[1]: Entering directory `/usr/local/src/build/super-smack-1.2'
Making all in src
gmake[2]: Entering directory `/usr/local/src/build/super-smack-1.2/src'
c++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -c
super-smack.cc
c++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -c client.cc
client.cc: In method `void Client::thread_sync()':
client.cc:347: `ERESTART' undeclared (first use this function)
client.cc:347: (Each undeclared identifier is reported only once
client.cc:347: for each function it appears in.)
gmake[2]: *** [client.o] Error 1
gmake[2]: Leaving directory `/usr/local/src/build/super-smack-1.2/src'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/usr/local/src/build/super-smack-1.2'
gmake: *** [all-recursive-am] Error 2
[EMAIL PROTECTED] /usr/local/src/build/super-smack-1.2$ make
make all-recursive
Making all in src
c++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include-g -O2 -c client.cc
client.cc: In method `void Client::thread_sync()':
client.cc:347: `ERESTART' undeclared (first use this function)
client.cc:347: (Each undeclared identifier is reported only once
client.cc:347: for each function it appears in.)
*** Error code 1
Stop in /usr/local/src/build/super-smack-1.2/src.
*** Error code 1
Stop in /usr/local/src/build/super-smack-1.2.
*** Error code 1
Stop in /usr/local/src/build/super-smack-1.2.
Hmm.. Looks like Jeremy did not quite fix everything on FreeBSD in version
1.2.
For a hack, change ERESTART to EINTR in client.cc for now until we've
figured it
out.
Ok, I did that. Gets further now but still doesn't finish building.
[EMAIL PROTECTED] /usr/local/src/build/super-smack-1.2$ make
make all-recursive
Making all in src
c++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include-g -O2 -c client.cc
c++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include-g -O2 -c engines.cc
c++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include-g -O2 -c die.cc
c++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include-g -O2 -c dictionary.cc
c++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include-g -O2 -c
super-smack-yacc.cc
super-smack-yacc.yy:9: getopt.h: No such file or directory
*** Error code 1
Stop in /usr/local/src/build/super-smack-1.2/src.
*** Error code 1
Stop in /usr/local/src/build/super-smack-1.2.
*** Error code 1
Stop in /usr/local/src/build/super-smack-1.2.
Thanks for
Building super-smack on freebsd 4.9
Not sure if this is the place to post this but...
I'm trying to build super-smack-1.2 on freebsd 4.9 w/ MySQL 4.0.18 and am
running into the following problems. Below are configure, make and gmake
output:
[EMAIL PROTECTED] /usr/local/src/build/super-smack-1.2$ ./configure --with-mysql
creating cache ./config.cache
checking for a BSD compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... yes
checking for working aclocal... found
checking for working autoconf... found
checking for working automake... found
checking for working autoheader... found
checking for working makeinfo... found
checking for sh... /bin/sh
checking for gcc... gcc
checking whether the C compiler (gcc ) works... yes
checking whether the C compiler (gcc ) is a cross-compiler... no
checking whether we are using GNU C... yes
checking whether gcc accepts -g... yes
checking for c++... c++
checking whether the C++ compiler (c++ ) works... yes
checking whether the C++ compiler (c++ ) is a cross-compiler... no
checking whether we are using GNU C++... yes
checking whether c++ accepts -g... yes
checking how to run the C preprocessor... gcc -E
checking for a BSD compatible install... /usr/bin/install -c
checking whether ln -s works... yes
checking for flex... flex
checking for flex... (cached) flex
checking for yywrap in -lfl... yes
checking lex output file root... lex.yy
checking whether yytext is a pointer... yes
checking for bison... no
checking for byacc... byacc
checking for compress in -lz... yes
checking for crypt in -lcrypt... yes
checking for crypt... yes
checking for libmysqlclient...
checking for mysql_real_connect in -lmysqlclient... yes
checking for mysql_real_connect in -lmysqlclient... (cached) yes
checking for mysql.h...
checking for ANSI C header files... yes
checking for sys/time.h... yes
checking for unistd.h... yes
checking whether time.h and sys/time.h may both be included... yes
checking return type of signal handlers... void
checking for gettimeofday... yes
checking for strerror... yes
updating cache ./config.cache
creating ./config.status
creating Makefile
creating src/Makefile
creating config.h
Building with the following options:
MySQL Support. yes
PostgreSQL Support no
Oracle Support no
If this is not what you intended, please re-run configure.
Thanks for using super-smack!
[EMAIL PROTECTED] /usr/local/src/build/super-smack-1.2$ gmake
gmake all-recursive
gmake[1]: Entering directory `/usr/local/src/build/super-smack-1.2'
Making all in src
gmake[2]: Entering directory `/usr/local/src/build/super-smack-1.2/src'
c++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -c super-smack.cc
c++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -c client.cc
client.cc: In method `void Client::thread_sync()':
client.cc:347: `ERESTART' undeclared (first use this function)
client.cc:347: (Each undeclared identifier is reported only once
client.cc:347: for each function it appears in.)
gmake[2]: *** [client.o] Error 1
gmake[2]: Leaving directory `/usr/local/src/build/super-smack-1.2/src'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/usr/local/src/build/super-smack-1.2'
gmake: *** [all-recursive-am] Error 2
[EMAIL PROTECTED] /usr/local/src/build/super-smack-1.2$ make
make all-recursive
Making all in src
c++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include-g -O2 -c client.cc
client.cc: In method `void Client::thread_sync()':
client.cc:347: `ERESTART' undeclared (first use this function)
client.cc:347: (Each undeclared identifier is reported only once
client.cc:347: for each function it appears in.)
*** Error code 1
Stop in /usr/local/src/build/super-smack-1.2/src.
*** Error code 1
Stop in /usr/local/src/build/super-smack-1.2.
*** Error code 1
Stop in /usr/local/src/build/super-smack-1.2.
Any ideas? Thanks!
Max
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
