Pada 23 Jul 2002 12:11:18 +0200
Andrea Carpani <[EMAIL PROTECTED]> menulis :
> "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?
I think the proper word for your case is "mysql busy" not "hang".
you should check from your system (OS) side the cpu usage of mysql where the query is
running
and you should also use tools like mtop or mytop to monitor what happens during the
query inside mysql server.
My opinion is a matter of query or table design ... not mysql application / OS .... ;-)
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan & Plaugher)
MySQL 3.23.51 : up 32 days, Queries : 354.126 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.com
---------------------------------------------------------------------
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
