MySQL Forums
Forum List  »  Optimizer & Parser

Re: Optimize a query
Posted by: Rick James
Date: March 14, 2011 06:26PM

Yes, how many rows in the SELECT in the VIEW.

SHOW TABLE STATUS LIKE 'jos%'; -- I want to see how big they are.

16MB is rather small, but then so is your VM. You could probably increase it to 50M. It would be nice to have it big enough for all the tables' indexes, but it should not be so big that you "swap".

Options: ReplyQuote


Subject
Views
Written By
Posted
2884
March 10, 2011 08:59AM
1407
March 13, 2011 03:48PM
1480
March 14, 2011 03:35PM
Re: Optimize a query
1490
March 14, 2011 06:26PM
1344
March 15, 2011 02:20PM
1382
March 15, 2011 09:12PM
1285
March 28, 2011 06:20AM


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.