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
2437
September 18, 2013 03:06AM
1469
September 18, 2013 07:06AM
1401
September 18, 2013 07:51AM
1366
September 18, 2013 02:57PM
Re: Very slow dependent subquery
1299
September 18, 2013 02:13PM
1208
September 18, 2013 03:10PM
1239
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.