If server has loads of RAM (32GB) where is wise to direct it to?

[Smaily]

I have so far found out that directing some of RAM into MailScanner via child process will give lower CPU usage and therefore lower load. (one child uses 20M)

I only have about 20% RAM in use from 32GB.. wondering if MySQL can get anything good from it or other parts of server.

How and where can I direct more RAM so server would have less load in CPU and lower load?
So it would become more stable.

Server is used for domains, apache, mail, MySQL

 

[STS Admin]

You can check the below videos for MySQL and Apache-PHP Optimization

 

[24x7server]

Hello,

For the MySQL optimization I will suggest you run the mysqltuner.pl on your server and optimize the MySQL

Here are the some useful thread of MySQL optimization

http://forums.cpanel.net/f189/help-optimize-my-cnf-file-354881.html
http://forums.cpanel.net/f189/my-cnf-optimisation-24gb-ram-350031.html
http://forums.cpanel.net/f189/please-help-me-optimize-mysql-my-cnf-354191.html

 

[cPanelMichael]

Hello

You can also ensure the following option is turned off under the "System" tab in "WHM Home » Server Configuration » Tweak Settings":

"Conserve memory"

Thank you.

 

[ilaurens]

1. You can use high caching settings for mysql, this is rather useful.
2. /tmp in memory
3. optimize php for high load.
4. higher mysql connection count.


Keep about 40% or more free, the memory amount will change when busy, not to mention linux has caching build in <-- which people tend to forget.