On Monday, 26 September 2005 at 9:29:32 +0200, mark carson wrote:
> 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.
>
> Most readers in this list expect
Joeffrey Betita wrote:
hi Jasper
the linux distribution is redhat 9, mysql-4.0.15a-log, apache-2.0.47, php-4.3.3 etc.
just clicking one hyperlink and searching for any item.
OK, would you mind providing the SQL query that's being executed when
you click that hyperlink?
You see, MySQL doesn'
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
Joeffrey Betita wrote:
do you have any idea why the mysql process is 99.9 percent?
No.
when i click one hyperlink it takes more than 1 minute to load the
page. thank you very much.
Maybe if you provided some details then someone would be able to help
you. We're not psychic. What programming
