MySQL Forums
Forum List  »  InnoDB

Re: sanity check on innodb config
Posted by: Rick James
Date: December 09, 2009 08:33PM

Unrelated...
query_cache_size = 128M
may be excessive.
SHOW VARIABLES LIKE 'query%';
SHOW GLOBAL STATUS LIKE 'Qc%';

(The query cache is not always very efficient, especially with more CPUs and bigger RAMs. I want to see if it might be better to turn it off.)

Options: ReplyQuote


Subject
Views
Written By
Posted
5263
December 01, 2009 01:46PM
2308
December 01, 2009 11:09PM
2017
December 02, 2009 07:33AM
2444
December 02, 2009 08:25AM
1966
December 02, 2009 10:42AM
1834
December 02, 2009 02:53PM
3096
December 09, 2009 08:34AM
Re: sanity check on innodb config
1869
December 09, 2009 08:33PM
2561
December 10, 2009 10:21AM
1903
December 10, 2009 10:44PM


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.