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
2743
September 18, 2013 03:06AM
1606
September 18, 2013 07:06AM
1557
September 18, 2013 07:51AM
1549
September 18, 2013 02:57PM
Re: Very slow dependent subquery
1442
September 18, 2013 02:13PM
1330
September 18, 2013 03:10PM
1381
September 24, 2013 10:04PM
1713
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.