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
