MySQL Forums
Forum List  »  Optimizer & Parser

Re: Very slow dependent subquery
Posted by: patrick canarelli
Date: September 18, 2013 07:51AM

Thank you for the reply.
I have tried your query but did not get any significant improvement (still above 1 hour which is definitely not normal).
One thing related to the execution time I think is that when the query is running the hard disk is continuously accessed.
I checked that about 1 Go of RAM is available so the hard drive should not be so used (W7).
My mysql parameters seems ok too unless there are other parameters that may burn the available ram ?
key_buffer_size=256M
tmp_table_size=256M
max_heap_table_size=256M

Patrick

Options: ReplyQuote


Subject
Views
Written By
Posted
2436
September 18, 2013 03:06AM
1469
September 18, 2013 07:06AM
Re: Very slow dependent subquery
1400
September 18, 2013 07:51AM
1366
September 18, 2013 02:57PM
1298
September 18, 2013 02:13PM
1208
September 18, 2013 03:10PM
1238
September 24, 2013 10:04PM
1550
September 25, 2013 12:53AM


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.