MySQL ODBC Connector - mysql process 99.9 percent

Author

mysql process 99.9 percent

Joeffrey Betita

2005-09-26, 3:23 am

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Jasper Bryant-Greene

2005-09-26, 3:23 am

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 language/API? What MySQL
version? What OS/platform? How much load is on your database from other
users, if any? What is the query being executed when the process is at
99.9%?

--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

mark carson

2005-09-26, 3:23 am

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 : mcarson@ipi.co.za/mcarson@pixie.co.za
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/mysql? unsub...sie.nctu.edu.tw

Jasper Bryant-Greene

2005-09-26, 3:23 am

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't have anything to do with hyperlinks and searching
(well, not searching at the user-level, anyway). It only knows about SQL
queries. So if something's making it go slow, the culprit is an SQL
query, not a hyperlink.

Please always reply to the list, not just to me.

--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Greg 'groggy' Lehey

2005-09-27, 3:23 am

--O8/n5iBOhiUtMkxf
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Monday, 26 September 2005 at 9:29:32 +0200, mark carson wrote:
> Joeffrey Betita wrote:
>
> 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 %.

FWIW, we have at least one case where the server gets itself into a
loop for no obvious reason. See http://bugs.mysql.com/bug.php?id=414
and http://bugs.mysql.com/bug.php?id=12061 for more details. If the
problem at hand is related to this bug, I'd be very interested in
hearing from you, especially if you can reproduce the problem easily.

Note that the submitter of the second-mentioned bug report has done a
very good job of describing his problem. Only reports of similar
quality would be of much help.

If this isn't your (Joeffrey's) problem, it might give you an idea of
the kind of information we're looking for.

Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http://www.mysql.com/
Echunga, South Australia
See complete headers for address and phone numbers.

Are you MySQL certified? http://www.mysql.com/certification/

--O8/n5iBOhiUtMkxf
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (FreeBSD)

iD8DBQFDN6VhIubykFB6
QiMRAtt5AJ4xVyD6gu87
N5GEeggTpeFkwDHI/QCfTM6J
3XxxMopbk7mMCGQry0H5
vLk=
=jlI8
-----END PGP SIGNATURE-----

--O8/n5iBOhiUtMkxf--

Sponsored Links