MySQL Forums
Forum List  »  Performance

Re: slow mysql response
Posted by: Felix Geerinckx
Date: September 30, 2005 06:34AM

uzwa ulhaque wrote:

> I am executing following query which returns a summary reports for the monthly sales of a local
> resturant, this query is taking up aroung 7 minutes:
> any ideas on how to optimize it :-S

Please post the output of

EXPLAIN SELECT ... \G

as well as the output of

SHOW INDEX FROM table \G

for each table involved in the query.

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote


Subject
Views
Written By
Posted
2697
September 29, 2005 06:46PM
1402
September 30, 2005 02:29AM
Re: slow mysql response
1329
September 30, 2005 06:34AM
1301
September 30, 2005 12:00PM
1232
September 30, 2005 12:59PM
1316
September 30, 2005 03:26PM
1444
September 30, 2005 03:40PM
1296
September 30, 2005 02:28PM
1283
September 30, 2005 04:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.