MySQL Forums
Forum List  »  Optimizer & Parser

Re: Very slow dependent subquery
Posted by: Peter Brawley
Date: September 18, 2013 02:13PM

For MyISAM, key_buffer_size should be about 20% of available RAM, but if only 1GB of RAM is available, you may need to free up more or add some.



Edited 1 time(s). Last edit at 09/18/2013 02:15PM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
2788
September 18, 2013 03:06AM
1618
September 18, 2013 07:06AM
1569
September 18, 2013 07:51AM
1563
September 18, 2013 02:57PM
Re: Very slow dependent subquery
1457
September 18, 2013 02:13PM
1345
September 18, 2013 03:10PM
1390
September 24, 2013 10:04PM
1726
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.