MySQL Performance: MySQL => can any one help me

Home » Performance » MySQL » can any one help me

can any one help me [message #3759]

Thu, 04 December 2008 03:20

daredavil82
Messages: 2
Registered: November 2008
Location: Malaysia

Junior Member

i have this query. it take over than 10 minute to execute. can any one guide me to improve this query performances? any help much appreciated.

[Updated on: Fri, 05 December 2008 04:30]

Re: can any one help me [message #3825 is a reply to message #3759 ]

Fri, 19 December 2008 03:00

debug
Messages: 132
Registered: March 2008

Senior Member

I don't see the query Smile

Please post the query, EXPLAIN ... for this query, and information about tables involved in query (SHOW CREATE TABLE ...)

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting

Previous Topic:	Slow-queries - Problems with mysql configuration
Next Topic:	Disabling Queries

Goto Forum:

]

Current Time: Fri Jul 10 02:40:19 EDT 2009

Total time taken to generate the page: 0.00991 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.