Here's my problem: I've just installed mysql version 3.23.51 (before this one I tried 3.23.49) compiled from scratch with:
CFLAGS="-fomit-frame-pointer -O3 -fPIC" ./configure --prefix=/opt/mysql --disable-shared --with-mysqld-user=mysql --with-debug It compiles and runs fine, but fails as soon as I use a script to load it up a bit. The script itself just opens a database connection, than does a "select * FROM $table1 s,$table2 t" where the two tables are choosen randomly (some of the tables are quite big), then repeats this with another (not cached) connection. The script runs on another machine. If I leave the script running it hangs mysql db in , say, 20 minutes. If I launch simultaneously 20 such scripts 3 minutes are enough. By "mysql hangs" I mean that there's no way to connect to get a "processlist" or a "debug", and the scripts remain blocked. If I stop the scripts and I wait some time (2 minutes) everything seems to come back to normality. Is there anyone who uses mysql on HP-UX under heavy load that can give me a hint? Thanks. -- - .a.c. - Andrea Carpani - <[EMAIL PROTECTED]> http://www.vitaminic.[it|com|co.uk|de|es|fr|nl|se|dk|ie] http://www.peoplesound.com http://www.iuma.com http://www.zipmind.it http://www.francemp3.com (www.mp3france.com) _______________________________________ DISCLAIMER, PLEASE NOTE: This communication is intended only for use by the addressee. It may contain confidential or privileged information. Transmission, distribution and/or copy cannot be permitted. Please notify Vitaminic Spa immediately by reply e-mail if you are not the intended recipient. Vitaminic Spa does not accept liability for corruption, interception or amendment, if any, or the consequences thereof. _______________________________________ --------------------------------------------------------------------- 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
