MySQL Forums :: General :: Regarding use of swap memory for MySQL.


Advanced Search

Regarding use of swap memory for MySQL.
Posted by: Vikrant Patil ()
Date: May 20, 2009 08:27AM

Hello,

We have a 1 GB Linux box on which we have observed that MySQL consumes almost entire available physical memory. We increased the Swap memory from 1 GB to 3 GB hoping that MySQL will start using the swap memory along with RAM. What we observed though was that the swap memory was hardly used until the physical memory was first exhausted. Could anyone please share information related the queries that i am listing below?

1) Is there a MySQL parameter setting whcih allows me to force MySQL to use swap memory on the Linux box?

2) Is there a MySQL parameter setting which allows me to set the maximum memory (both RAM and swap)that can be used by MySQL server?

3) Which are the MySQL parameters that i would have to focus on to improve MySQL memory performance?

Thanking you in advance.

Regards,
Vikrant

Options: ReplyQuote


Subject Written By Posted
Regarding use of swap memory for MySQL. Vikrant Patil 05/20/2009 08:27AM
Re: Regarding use of swap memory for MySQL. Rick James 05/21/2009 10:51AM
Re: Regarding use of swap memory for MySQL. Vikrant Patil 05/22/2009 03:59AM


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.