Hi.
Please post the result of EXPLAIN for the two queries.
Bye,
Benjamin.
On Wed, Nov 28, 2001 at 12:50:21PM +0700, [EMAIL PROTECTED] wrote:
> I dont understand mysql eat system 13 load average after that mysql hang while
> runing query via web using DBD-Mysql and DBI.
> Everyone help me for your experience how to tuning mysql for this solution.
>
[...]
> mysql-server-3.23.36-1
>
> Total Record:
> ACCOUNT=23203
> DOMAIN=88
> STATUS=4
> USER_PROFILE=23202
> EMAIL_ADDRESS=23203
> DOMAIN_ADMIN=119
>
>
> SQL syntax running :
>
> SELECT
> COUNT(*)
> FROM
> ACCOUNT a,
> DOMAIN b,
[...]
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
