Re: Regarding use of swap memory for MySQL.
DO NOT LET MySQL SWAP! Why? MySQL works hard to efficiently cache things in RAM; if ram is not really ram, then performance plummets. It is better to give MySQL less RAM for caching.
SHOW VARIABLES LIKE 'key_buffer%'; -- esp key_buffer_size
SHOW VARIABLES LIKE 'innodb%'; -- esp innodb_buffer_pool_size
SHOW VARIABLES LIKE 'q%'; -- may need to turn OFF query_cache_type
SHOW STATUS LIKE 'Q%'; -- shows QC usage
SHOW STATUS LIKE 'Key%'; -- shows MyISAM index cache usage
Are you using mostly InnoDB or MyISAM?
Do you have other applications running on the same box?
Subject
Written By
Posted
Re: Regarding use of swap memory for MySQL.
May 21, 2009 10:51AM
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.