query help [resend]
Hi, I have two tables- books and copies every book has an id in the books table every copy of a book has the books id and a copy id in the copies table (1 row per copy) I want a list of all the books that don't have any copies meaning all the book id's in books that don't match any book id's in copies. how can I do this? thanks yonah -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: query help
I got a response off the list suggesting writing a function to go over the query results- it's not hard but I'd rather do this in sql if possible. I came up with this: select books.bookid,books.title,copies.copyid from books left join copies on books.bookid=copies.bookid where copies.copyid=NULL; this didn't work even though without the where clause I got exactly what I wanted- the left join filled in the entries that didn't have copies with a null copyid. what did I do wrong? thanks yonah Yonah Russ wrote: Hi, I have two tables- books and copies every book has an id in the books table every copy of a book has the books id and a copy id in the copies table (1 row per copy) I want a list of all the books that don't have any copies meaning all the book id's in books that don't match any book id's in copies. how can I do this? thanks yonah -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: compiling mysql on a pentium
There does seem to be a bug in icc- I've posted on intel's message boards and they've confirmed a problem. There is a work around - here is the post: Hi Yonah, I can see the same problem on my system. I will create a support issue for you and will let you when this get fixed. I found that if you take out libmysql.o from libmysqlclient.a and then link it as - icpc -O3 -DDBUG_OFF -O3 -ipo -axWN -march=pentium4 -mcpu=pentium4 -fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic -o mysql mysql.o readline.o sql_string.o completion_hash.o -lreadline -lncurses ../libmysql/.libs/libmysqlclient.a ../libmysql/libmysql.o -lz -lcrypt -lnsl -lm it works fine. you can try this as a workaround for your problem, till it get fixed. The problem is you have to include ../libmysql/libmysql.o explicitly whereever ../libmysql/.libs/libmysqlclient.a is linked. HTH, CP in addition- I got these helpful instructions from the folks on the mysql-packagers list- I specifically asked about 4.0.18 so they should work- I have successfully compiled 4.1.1 several times and the binaries passed the tests although I'm having trouble with the benchmark suite. good luck yonah That really sounds like an icc bug. Here's the line we currently use for our binaries on icc: CFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict CC=icc CXX=icc CXXFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict ./configure - --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data - --libexecdir=/usr/local/mysql/bin --with-extra-charsets=complex - --enable-thread-safe-client --enable-local-infile --enable-assembler - --disable-shared --with-client-ldflags=-all-static - --with-mysqld-ldflags=-all-static --with-readline --with-embedded-server - --with-innodb You may be able to use higher optimization levels (e.g. by removing -mp, which will however cause some loss in floatingpoint accuracy - some of the test suite tests will fail). I assume the --no-gcc is key here. Bye, LenZ - -- Lenz Grimmer [EMAIL PROTECTED] Senior Production Engineer Walter Andreas wrote: Hi there, how to compile mysql 4.0.18 on a pentium for best performance? I searched the net now for 2 days and found lots of hints on compiling with icc and pgcc, but it looks to me that icc is not working with mysql 4.0.18 and pgcc is out of date (maybe gcc already catched up with pgcc?). Setting compiler flags is also a miraqle for me. This is going to be a production server, so it should be really stable and not the trade for performance. Can anybody advice a configure command with compiler settings for a p4 machine with 1G ram? Thank you for your advice, Andy _ Der WEB.DE Virenschutz schuetzt Ihr Postfach vor dem Wurm Netsky.A-P! Kostenfrei fuer alle FreeMail Nutzer. http://f.web.de/?mc=021157 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sql bench problems
I've been trying to compile a mysql server optimized for a zeon processor and a specific application- I'm compiling with icc. the problem is with the sql benchmarks- the perl regexp for making the detailed report of the benchmark doesn't match the output from the benchmarks so it doesn't create the report but instead says that everything failed- Has anyone had this problem? I could futz around with the regexp but if there is a more correct solution, I'd rather do that. here is a sample output line: Time for alter_table_drop (91): 19 wallclock secs ( 0.02 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.02 CPU) here is the regexp: /^(estimated |)time (to|for) ([^\s:]*)\s*\((\d*)(:\d*)*\)[^:]*:\s*([\d.]+) .*secs \(\s*([^\s]*) usr\s*\+*\s*([^\s]*) sys.*=\s+([\d.]*)\s+cpu/i thanks yonah -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: compiling mysql with intel icc
are you sure that the icc binary is in your path? have you sourced the script in the icc directory which sets the environment variables for you? yonah Walter Andreas wrote: Hi there, I am trying to compile mysql 4.x with intel compiler for maximum performance. On my research I have found that following line will squese more performance out of mysql: CFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict CC=icc CXX=icc CXXFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict ./configure --prefix=/usr/local/mysql--with-mysqld-user=mysqladm --without-debug --with-client-ldflags=-all-static--with-mysqld-ldflags=-all-static --disable-shared--localstatedir=/home/mysqladm/data --enable-assembler The fun stops right away with following message: checking for gcc... icc checking for C compiler default output... configure: error: C compiler cannot create executables See `config.log' for more details. Whats wrong? I did not tell mysql to drop the c compiler?! Did I? Thanx for any help, Andy _ Der WEB.DE Virenschutz schuetzt Ihr Postfach vor dem Wurm Netsky.A-P! Kostenfrei fuer alle FreeMail Nutzer. http://f.web.de/?mc=021157 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
raid configure option?
Can anyone explain what the raid configure option does? Is this for use when storing mysql on hardware raid? if so, what type(s)- ie. striping, mirroring? Thanks yonah -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Fwd: Re: compiling with icc]
Hi all- Here is more info on compiling mysql with icc 8 from the mysql packagers list- As for my attempts, I compiled successfully a couple times and the first benchmark I did was faster than the gcc compiled server by about 10%- unfortunately, I can't say if this is a conculsive test since the gcc binary was 3.23 and the icc binary 4.1.1 - I only managed one benchmark b/c something has broken the benchmark suite and I haven't had time to check into it... I'll try the following and get back to you- hopefully with good news. yonah Original Message Subject:Re: compiling with icc Date: Thu, 1 Apr 2004 22:23:02 +0200 (CEST) From: Lenz Grimmer [EMAIL PROTECTED] To: Yonah Russ [EMAIL PROTECTED] CC: [EMAIL PROTECTED] References: [EMAIL PROTECTED] -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Yonah, sorry for the late reply. I have now been finally able to install icc 8.0 on one our build hosts (Running SuSE Linux 8.2) and made some tests. On Wed, 24 Mar 2004, Yonah Russ wrote: I'm trying to compile mysql 4.0.18 with icc 8.0 on RH AS 3u1. I'm including my last configuration for compiling and how it died- I've tried about a million other ways- this seems to come the closest to compiling normally but dies with an internal error(looks like intel's fault not yours). Does anyone have a configuration where this compiles? What did I do wrong? fyi- there is a problem with the configure/libtool script when you don't compile -static and you use ipo... the compilation runs icc -shared to link the libraries but it needs the -ipo option as well. thanks in advance for any help! yonah here the environment variables: AR=xiar CC=icc CFLAGS='-O3 -ipo -static -axWN -march=pentium4 -mcpu=pentium4' CXX=icc CXXFLAGS='-O3 -ipo -static -axWN -march=pentium4 -mcpu=pentium4' LANG=C LD=xild PATH=/usr/local/intel/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/root/bin:/usr/local/mysql/bin this is the configure line: ./configure --prefix=/usr/local/mysql --enable-thread-safe-client --without-innodb --without-debug --enable-assembler --with-named-curses-libs=/usr/lib/libncurses.so.5.3 it dies with this error: IPO Warning: unresolved : rl_attempted_completion_function Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : rl_completion_entry_function Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : rl_readline_name Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : popen Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : pclose Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : readline Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : add_history Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : completion_matches Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : write_history Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : read_history Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : __xstat64 Referenced in libmysqlclient.a(my_lib_ipo.o) IPO Warning: unresolved : __fxstat64 Referenced in libmysqlclient.a(my_lib_ipo.o) IPO Warning: unresolved : readdir64 Referenced in libmysqlclient.a(my_lib_ipo.o) IPO Warning: unresolved : fdopen Referenced in libmysqlclient.a(my_fopen_ipo.o) IPO Warning: unresolved : fclose Referenced in libmysqlclient.a(my_fopen_ipo.o) IPO Warning: unresolved : gethostbyname_r Referenced in libmysqlclient.a(my_gethostbyname_ipo.o) IPO Warning: unresolved : __lxstat64 Referenced in libmysqlclient.a(my_symlink_ipo.o) IPO Warning: unresolved : realpath Referenced in libmysqlclient.a(my_symlink_ipo.o) libmysql.c(1808): internal error: 0_1345 icc: error: problem during multi-file optimization compilation (code 4) make[2]: *** [mysql] Error 4 make[2]: Leaving directory `/moat-files/mysql-4.0.18/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/moat-files/mysql-4.0.18' make: *** [all] Error 2 That really sounds like an icc bug. Here's the line we currently use for our binaries on icc: CFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict CC=icc CXX=icc CXXFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict ./configure - --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data - --libexecdir=/usr/local/mysql/bin --with-extra-charsets=complex - --enable-thread-safe-client --enable-local-infile --enable-assembler - --disable-shared --with-client-ldflags=-all-static - --with-mysqld-ldflags=-all-static --with-readline --with-embedded-server - --with-innodb You may be able to use higher optimization levels (e.g. by removing -mp, which will however cause some loss in floatingpoint accuracy - some of the test suite tests will fail). I assume the --no-gcc is key here. Bye, LenZ - -- Lenz Grimmer [EMAIL PROTECTED] Senior Production Engineer MySQL GmbH, http://www.mysql.de
Re: [Fwd: Re: compiling with icc]
sorry- typo- the gcc binary was 4.0.18 yonah Yonah Russ wrote: Hi all- Here is more info on compiling mysql with icc 8 from the mysql packagers list- As for my attempts, I compiled successfully a couple times and the first benchmark I did was faster than the gcc compiled server by about 10%- unfortunately, I can't say if this is a conculsive test since the gcc binary was 3.23 and the icc binary 4.1.1 - I only managed one benchmark b/c something has broken the benchmark suite and I haven't had time to check into it... I'll try the following and get back to you- hopefully with good news. yonah Original Message Subject: Re: compiling with icc Date: Thu, 1 Apr 2004 22:23:02 +0200 (CEST) From: Lenz Grimmer [EMAIL PROTECTED] To: Yonah Russ [EMAIL PROTECTED] CC: [EMAIL PROTECTED] References: [EMAIL PROTECTED] -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Yonah, sorry for the late reply. I have now been finally able to install icc 8.0 on one our build hosts (Running SuSE Linux 8.2) and made some tests. On Wed, 24 Mar 2004, Yonah Russ wrote: I'm trying to compile mysql 4.0.18 with icc 8.0 on RH AS 3u1. I'm including my last configuration for compiling and how it died- I've tried about a million other ways- this seems to come the closest to compiling normally but dies with an internal error(looks like intel's fault not yours). Does anyone have a configuration where this compiles? What did I do wrong? fyi- there is a problem with the configure/libtool script when you don't compile -static and you use ipo... the compilation runs icc -shared to link the libraries but it needs the -ipo option as well. thanks in advance for any help! yonah here the environment variables: AR=xiar CC=icc CFLAGS='-O3 -ipo -static -axWN -march=pentium4 -mcpu=pentium4' CXX=icc CXXFLAGS='-O3 -ipo -static -axWN -march=pentium4 -mcpu=pentium4' LANG=C LD=xild PATH=/usr/local/intel/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/root/bin:/usr/local/mysql/bin this is the configure line: ./configure --prefix=/usr/local/mysql --enable-thread-safe-client --without-innodb --without-debug --enable-assembler --with-named-curses-libs=/usr/lib/libncurses.so.5.3 it dies with this error: IPO Warning: unresolved : rl_attempted_completion_function Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : rl_completion_entry_function Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : rl_readline_name Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : popen Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : pclose Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : readline Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : add_history Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : completion_matches Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : write_history Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : read_history Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : __xstat64 Referenced in libmysqlclient.a(my_lib_ipo.o) IPO Warning: unresolved : __fxstat64 Referenced in libmysqlclient.a(my_lib_ipo.o) IPO Warning: unresolved : readdir64 Referenced in libmysqlclient.a(my_lib_ipo.o) IPO Warning: unresolved : fdopen Referenced in libmysqlclient.a(my_fopen_ipo.o) IPO Warning: unresolved : fclose Referenced in libmysqlclient.a(my_fopen_ipo.o) IPO Warning: unresolved : gethostbyname_r Referenced in libmysqlclient.a(my_gethostbyname_ipo.o) IPO Warning: unresolved : __lxstat64 Referenced in libmysqlclient.a(my_symlink_ipo.o) IPO Warning: unresolved : realpath Referenced in libmysqlclient.a(my_symlink_ipo.o) libmysql.c(1808): internal error: 0_1345 icc: error: problem during multi-file optimization compilation (code 4) make[2]: *** [mysql] Error 4 make[2]: Leaving directory `/moat-files/mysql-4.0.18/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/moat-files/mysql-4.0.18' make: *** [all] Error 2 That really sounds like an icc bug. Here's the line we currently use for our binaries on icc: CFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict CC=icc CXX=icc CXXFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict ./configure - --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data - --libexecdir=/usr/local/mysql/bin --with-extra-charsets=complex - --enable-thread-safe-client --enable-local-infile --enable-assembler - --disable-shared --with-client-ldflags=-all-static - --with-mysqld-ldflags=-all-static --with-readline --with-embedded-server - --with-innodb You may be able to use higher optimization levels (e.g. by removing -mp, which will however cause some loss in floatingpoint accuracy - some of the test suite tests will fail). I assume the --no-gcc is key here. Bye, LenZ - -- Lenz Grimmer
compiling with icc
Hi, I'm trying to compile mysql 4.0.18 with icc 8.0 on RH AS 3u1. I'm including my last configuration for compiling and how it died- I've tried about a million other ways- this seems to come the closest to compiling normally but dies with an internal error(looks like intel's fault not yours). Does anyone have a configuration where this compiles? What did I do wrong? fyi- there is a problem with the configure/libtool script when you don't compile -static and you use ipo... the compilation runs icc -shared to link the libraries but it needs the -ipo option as well. thanks in advance for any help! yonah here the environment variables: AR=xiar CC=icc CFLAGS='-O3 -ipo -static -axWN -march=pentium4 -mcpu=pentium4' CXX=icc CXXFLAGS='-O3 -ipo -static -axWN -march=pentium4 -mcpu=pentium4' LANG=C LD=xild PATH=/usr/local/intel/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/root/bin:/usr/local/mysql/bin this is the configure line: ./configure --prefix=/usr/local/mysql --enable-thread-safe-client --without-innodb --without-debug --enable-assembler --with-named-curses-libs=/usr/lib/libncurses.so.5.3 it dies with this error: IPO Warning: unresolved : rl_attempted_completion_function Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : rl_completion_entry_function Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : rl_readline_name Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : popen Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : pclose Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : readline Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : add_history Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : completion_matches Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : write_history Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : read_history Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : __xstat64 Referenced in libmysqlclient.a(my_lib_ipo.o) IPO Warning: unresolved : __fxstat64 Referenced in libmysqlclient.a(my_lib_ipo.o) IPO Warning: unresolved : readdir64 Referenced in libmysqlclient.a(my_lib_ipo.o) IPO Warning: unresolved : fdopen Referenced in libmysqlclient.a(my_fopen_ipo.o) IPO Warning: unresolved : fclose Referenced in libmysqlclient.a(my_fopen_ipo.o) IPO Warning: unresolved : gethostbyname_r Referenced in libmysqlclient.a(my_gethostbyname_ipo.o) IPO Warning: unresolved : __lxstat64 Referenced in libmysqlclient.a(my_symlink_ipo.o) IPO Warning: unresolved : realpath Referenced in libmysqlclient.a(my_symlink_ipo.o) libmysql.c(1808): internal error: 0_1345 icc: error: problem during multi-file optimization compilation (code 4) make[2]: *** [mysql] Error 4 make[2]: Leaving directory `/moat-files/mysql-4.0.18/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/moat-files/mysql-4.0.18' make: *** [all] Error 2 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: compiling with icc
Victor Medina wrote: 8 must probably no one here uses the Intel compiler since it is paid =( actually there is a free non-commercial license version here: http://www.intel.com/software/products/compilers/clin/noncom.htm which is how I happen to have it yonah it dies with this error: IPO Warning: unresolved : rl_attempted_completion_function Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : rl_completion_entry_function 8 Ncurses devel and the readline libriries must be installed for the client to compile Best Regards! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: compiling with icc
this is what you are looking for: http://www.intel.com/software/products/global/techtopics/mysql.pdf according to intel- mysql ab provided all the performance data- much more than 20% performance boost sometimes. I'll be darned if their compiler flags work- maybe with 4.1 (apparently that's what they used) but not with 4.0.18 yonah Chris Nolan wrote: Victor Medina wrote: Hi! On Wed, 2004-03-24 at 09:51, Yonah Russ wrote: Hi, I'm trying to compile mysql 4.0.18 with icc 8.0 on RH AS 3u1. I'm 8 GUAO! nice!, let us know how faster it is with the Intel compiler, just curious! =) An ad in one of the Linux magazines I leaf through on occassion showed some pretty noticable improvements (in the order of 20% in some cases), but I'm betting that these were crafted test cases, as we all know that MySQL's two main storage engines are extremely smart when it comes to using discs. fyi- there is a problem with the configure/libtool script when you don't compile -static and you use ipo... the compilation runs icc -shared to link the libraries but it needs the -ipo option as well. 8 must probably no one here uses the Intel compiler since it is paid =( it dies with this error: IPO Warning: unresolved : rl_attempted_completion_function Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : rl_completion_entry_function 8 Ncurses devel and the readline libriries must be installed for the client to compile Best Regards! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: compiling with icc
Victor Medina wrote: it dies with this error: IPO Warning: unresolved : rl_attempted_completion_function Referenced in ipo_icc5X7oE4.o IPO Warning: unresolved : rl_completion_entry_function 8 Ncurses devel and the readline libriries must be installed for the client to compile I installed ncurses-devel and readline-devel. not much changed but then I added --without-readline to the configure options and we seem to have made progress: here is the error now: IPO Warning: unresolved : popen Referenced in ipo_icct8OVHG.o IPO Warning: unresolved : pclose Referenced in ipo_icct8OVHG.o IPO Warning: unresolved : __xstat64 Referenced in libmysqlclient.a(my_lib_ipo.o) IPO Warning: unresolved : __fxstat64 Referenced in libmysqlclient.a(my_lib_ipo.o) IPO Warning: unresolved : readdir64 Referenced in libmysqlclient.a(my_lib_ipo.o) IPO Warning: unresolved : fdopen Referenced in libmysqlclient.a(my_fopen_ipo.o) IPO Warning: unresolved : fclose Referenced in libmysqlclient.a(my_fopen_ipo.o) IPO Warning: unresolved : gethostbyname_r Referenced in libmysqlclient.a(my_gethostbyname_ipo.o) IPO Warning: unresolved : __lxstat64 Referenced in libmysqlclient.a(my_symlink_ipo.o) IPO Warning: unresolved : realpath Referenced in libmysqlclient.a(my_symlink_ipo.o) libmysql.c(1808): internal error: 0_1345 icc: error: problem during multi-file optimization compilation (code 4) make[2]: *** [mysql] Error 4 make[2]: Leaving directory `/moat-files/mysql-4.0.18/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/moat-files/mysql-4.0.18' make: *** [all] Error 2 any ideas what I'm missing? thanks yonah Best Regards! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: compiling with icc
no problem- its a fresh install of RH AS 3u1 (basically the same setup as rh 9)- minimal installation with one or two rpms from the cds added afterwards the mysql source tarball is upacked in /moat-files/mysql-4.0.18/ here is my ld.so.conf if it helps /usr/kerberos/lib /usr/X11R6/lib /usr/local/mysql/lib/mysql /usr/local/lib /usr/local/intel/lib . thanks yonah Victor Medina wrote: On Wed, 2004-03-24 at 10:57, Yonah Russ wrote: 8 make[2]: Leaving directory `/moat-files/mysql-4.0.18/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/moat-files/mysql-4.0.18' make: *** [all] Error 2 any ideas what I'm missing? thanks yonah ---8 Something is missing in the path, altough i am guessing here, would you mind describing your set up? where are things installled. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: compiling with icc
Great! Thanks for the help. Here is some more info, in case it's helpful- these are all the compile warnings from the make: my_thr_init.c(67): warning #266: function declared implicitly pthread_mutexattr_setkind_np(my_fast_mutexattr,PTHREAD_MUTEX_ADAPTIVE_NP); ^ ... icc: Command line warning: ignoring unknown option '-fno-implicit-templates' sql_string.h(20): warning #161: unrecognized #pragma #pragma interface /* gcc class implementation */ ^ icc: Command line warning: ignoring unknown option '-fno-implicit-templates' icc: Command line warning: ignoring unknown option '-fno-implicit-templates' sql_string.cc(20): warning #161: unrecognized #pragma #pragma implementation// gcc: Class implementation ^ sql_string.h(20): warning #161: unrecognized #pragma #pragma interface /* gcc class implementation */ ^ icc: Command line warning: ignoring unknown option '-fno-implicit-templates' icc: Command line warning: ignoring unknown option '-fno-implicit-templates' the rest I've posted already. thanks again yonah Victor Medina wrote: Hi! OK, i have installed a fresh RH9 (i had the cd's here, altough i use a SuSE 9 and Debian). I downloaded a fresh copy of mysql 4.0.18 and 4.1 (just to try). I installed a complete develompent environment (gcc, bison, yacc, m4, etc etc) and it compiles cleanly, again; with gcc, I will download the icc just to try =) Let's see what happens! =) Best Regards! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mystifying mysqld memory usage explosion
I'm not a big mysql expert but I think mysql has some buffers which it keeps per connection here are some examples (from mysql website): / /If you have complex queries |sort_buffer_size| and |tmp_table_size| are likely to be very important. Values will depend on the query complexity and available resources, but 4Mb and 32Mb, respectively are recommended starting points. / Note: These are per connection values, among |read_buffer_size|, |read_rnd_buffer_size| and some others, meaning that this value might be needed for each connection. So, consider your load and available resource when setting these parameters. For example |sort_buffer_size| is allocated only if MySQL nees to do a sort. Note: be careful not to run out of memory. / I might start up mysql and watch the memory usage as you start dumb clients on at a time - see what the step in memory usage is and match it up against something in your my.cnf good luck yonah Tim Cutts wrote: On 22 Mar 2004, at 18:24, Tim Cutts wrote: Some users' code is causing MySQL's memory use to explode. By the time we reach about 200 simultaneous connections, the MySQL server is using 8GB of virtual memory, and then falls over (the machine is an AlphaServer ES45 with 8 GB of physical memory, and 16 GB of swap, although processes are constrained to a total of 8GB of virtual memory in the OS) The versions of MySQL I have found this behaviour on are 4.0.14 and 4.0.17 Well, a deafening silence from the list. :-) I've got some more information now. I wanted to exclude perl, DBI and whatnot from the list of suspects, so I wrote a client in C. All the client does is connect to the database and sleep for 10 minutes. If I run 100 or so of these simultaneously, the MySQL server still explodes in memory use and crashes. So it's nothing to do with either the SQL that's being run, or the use of perl/DBI clients. It's simply a matter of connection count. Now, here's the kicker: The problem goes away completely if I start the server with --skip-innodb So my question is: are there buffers which are allocated per connection to do with accessing InnoDB tables? My reading of the documentation suggests that all the innodb_ variables refer to global buffers, logs and so on. Or have I missed something? Tim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: compiling with icc
News- I have compiled mysql 4.1.1-alpha with the icc compiler using the options intel reported in their case study pdf. specifically '-O3 -ip -unroll2' The compilation was pretty ugly and threw up a lot of warnings. I'm benchmarking now and I'll let you know what comes out of it. yonah Yonah Russ wrote: Great! Thanks for the help. Here is some more info, in case it's helpful- these are all the compile warnings from the make: my_thr_init.c(67): warning #266: function declared implicitly pthread_mutexattr_setkind_np(my_fast_mutexattr,PTHREAD_MUTEX_ADAPTIVE_NP); ^ ... icc: Command line warning: ignoring unknown option '-fno-implicit-templates' sql_string.h(20): warning #161: unrecognized #pragma #pragma interface /* gcc class implementation */ ^ icc: Command line warning: ignoring unknown option '-fno-implicit-templates' icc: Command line warning: ignoring unknown option '-fno-implicit-templates' sql_string.cc(20): warning #161: unrecognized #pragma #pragma implementation// gcc: Class implementation ^ sql_string.h(20): warning #161: unrecognized #pragma #pragma interface /* gcc class implementation */ ^ icc: Command line warning: ignoring unknown option '-fno-implicit-templates' icc: Command line warning: ignoring unknown option '-fno-implicit-templates' the rest I've posted already. thanks again yonah Victor Medina wrote: Hi! OK, i have installed a fresh RH9 (i had the cd's here, altough i use a SuSE 9 and Debian). I downloaded a fresh copy of mysql 4.0.18 and 4.1 (just to try). I installed a complete develompent environment (gcc, bison, yacc, m4, etc etc) and it compiles cleanly, again; with gcc, I will download the icc just to try =) Let's see what happens! =) Best Regards! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]