Hi
Most readers in this list expect OS and MySQL server information etc
before responding.
In our experience this is usually caused by poor SQL query construction
e.g. large result set e.g. x million rows and/or index choice, database
table design and/or MySQL server setup.
Turn-on logging, rerun selected queries with and without the explain
syntax, look at the MySQL administrator process list to see which query
is the problem whilst the CPU is 99.9 %.
Good news is : 'it is solvable'.
Mark
Joeffrey Betita wrote:
hi
do you have any idea why the mysql process is 99.9 percent? when i click
one hyperlink it takes more than 1 minute to load the page. thank you very
much.
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.6/111 - Release Date: 9/23/2005
--
Mark Carson
Managing
Integrated Product Intelligence/IPI CC CK 95/35630/23
Members : MH Carson and AG Carson
EMail : [EMAIL PROTECTED]/[EMAIL PROTECTED]
snailmail : P.O. Box 36095 Menlo Park 0102, South Africa
Cell : +27 83 260 8515
Tel : +27 12 349 2786
Fax : +27 12 349 2787
This e-mail may contain PRIVILEGED AND/OR CONFIDENTIAL INFORMATION intended
only for use of the addressee. If you are not the addressee, or the person
responsible for delivering it to the person addressed, you may not copy or
deliver this to anyone else. If you received this e-mail by mistake, please
do not make use of it, nor disclose it's contents to anyone. Thank you for
notifying us immediately by return e-mail or telephone. INFORMATION PROVIDED
IN THIS ELECTRONIC MAIL IS PROVIDED "AS IS" WITHOUT WARRANTY REPRESENTATION
OR CONDITION OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT
LIMITED TO CONDITIONS OR OTHER TERMS OF MERCHANTABILITY AND/OR FITNESS FOR A
PARTICULAR PURPOSE. THE USER ASSUMES THE ENTIRE RISK AS TO THE ACCURACY AND
THE USE OF THIS DOCUMENT.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]