MySQL Forums
Forum List  »  Optimizer & Parser

Re: MySQL cache optimization
Posted by: Peter Brawley
Date: December 09, 2014 12:28PM

innodb_buffer_pool_size is too small, should be about three quarters of available ram.

Let's see Show Create Table for each table and Explain Extended results for each query.



Edited 1 time(s). Last edit at 12/09/2014 01:38PM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
2455
November 27, 2014 06:33AM
1469
November 27, 2014 04:34PM
1147
December 09, 2014 04:33AM
Re: MySQL cache optimization
1021
December 09, 2014 12:28PM


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.