its took a long time.
--process list--
+-----+---------+-----------+---------+---------+------+-------------------+---------------------------------------------------------------------------------------------
---------+
| Id | User | Host | db | Command | Time | State | Info
|
|
+-----+---------+-----------+---------+---------+------+-------------------+---------------------------------------------------------------------------------------------
---------+
| 281 | udm_dba | localhost | udm | Query | 680 | Sending data | SELECT
COUNT(*)
FROM
ACCOUNT a,
DOMAIN b,
STATUS c,
USER_PROFILE d,
EMAIL_ADDRESS e,
D |
| 283 | udm_dba | localhost | udm | Query | 648 | Sending data | SELECT
COUNT(*)
FROM
ACCOUNT a,
DOMAIN b,
STATUS c,
USER_PROFILE d,
EMAIL_ADDRESS e,
D |
| 284 | root | localhost | udm | Query | 203 | Waiting for table | desc
|ACCOUNT
|
| 285 | udm_dba | localhost | udm | Query | 191 | Waiting for table | SELECT
COUNT(*)
FROM
ACCOUNT a,
DOMAIN b,
STATUS c,
USER_PROFILE d,
EMAIL_ADDRESS e,
D |
Abu([EMAIL PROTECTED])@Wed, Nov 28, 2001 at 12:50:21PM +0700:
> 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.
>
> Thanks
> -Abu-
>
>
> kernel-2.4.9-6 on rh 7.1
> mysql-3.23.36-1
> mysql-devel-3.23.36-1
> 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,
> STATUS c,
> USER_PROFILE d,
> EMAIL_ADDRESS e,
> DOMAIN_ADMIN f
> WHERE
> b.ID = a.DOMAIN and
> f.DOMAIN = a.DOMAIN and
> c.ID = a.STATUS and
> d.ACCOUNT = a.ID and
> e.ACCOUNT = a.ID and
> a.STATUS <> 163 and
> b.STATUS <> 163
> /* and b.STATUS IN (161, 162) */
> and f.MASTER = 1
> and a.ID <> 1
>
> ---or----
>
> SELECT
> COUNT(*)
> FROM
> ACCOUNT a,
> DOMAIN b,
> STATUS c,
> USER_PROFILE d,
> EMAIL_ADDRESS e,
> DOMAIN_ADMIN f
> WHERE
> b.ID = a.DOMAIN and
> f.DOMAIN = a.DOMAIN and
> c.ID = a.STATUS and
> d.ACCOUNT = a.ID and
> e.ACCOUNT = a.ID and
> a.STATUS <> 163 and
> b.STATUS <> 163
> /* and b.STATUS IN (161, 162) */
> and f.MASTER = 1
> and CONCAT(e.ADDRESS, d.REALNAME) like '%abu%'
> and a.ID <> 1
--
__
(oo) Open Solution Provider visit http://www.trabas.com
/ \/ \ GnuPg public information pub 1024/EBD26280
`V__V' A9A9 8F57 9E9D 14E3 05B4 3EDB C241 A313 EBD2 6280
Don't relax! It's only your tension that's holding you together.
---------------------------------------------------------------------
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
