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
2639
September 18, 2013 03:06AM
1551
September 18, 2013 07:06AM
1495
September 18, 2013 07:51AM
1463
September 18, 2013 02:57PM
Re: Very slow dependent subquery
1388
September 18, 2013 02:13PM
1286
September 18, 2013 03:10PM
1323
September 24, 2013 10:04PM
1650
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.