How to use MORE ram

[tomturd2]

A topic you probably wont see very often :P

Some background:
My server has 16gb RAM.
It never seems to use more than 12gb.
MRTG: http://212.7.200.162/mrtg/memory.html

The server has 2 fairly big forum installs, one with around 200 active users and one with 500 odd.

my.cnf (based on tuning-primer and mysqltuner reccomendations)

[mysqld]

max_connections = 200

skip-locking

key_buffer = 1G

max_allowed_packet = 1M

table_cache = 50000

#keep the next 2 the same

tmp_table_size = 256M

max_heap_table_size = 256M

open_files_limit = 5000

join_buffer_size = 4M

sort_buffer_size = 1M

read_buffer_size = 1M

read_rnd_buffer_size = 4M

myisam_sort_buffer_size = 64M

thread_cache_size = 8

query_cache_size= 256M

# Try number of CPU's*2 for thread_concurrency

thread_concurrency = 8

skip-networking

skip-innodb

httpd.conf (this one I dont understand too well!)

KeepAlive On

MaxKeepAliveRequests 100

KeepAliveTimeout 1

MinSpareServers 16

MaxSpareServers 64

StartServers 16

MaxClients 256

MaxRequestsPerChild 1000

Any optimisation suggestions very welcome :)

[Gary.]

Daft question but why do you want to use more ram ? Lol

Another thing is, Your using linux I guess as you mentioned mysqltuner !

Lets point out this line:

thread_concurrency = 8

That option does not exist in linux, So you can happily remove that as it will do nothing.

This line also:

max_allowed_packet = 1M

Minimum should be around 16M or you may see connection issues, You may not, But guarentee others will

Use these settings and apache will functiuon better:

KeepAlive On

MaxKeepAliveRequests 100

KeepAliveTimeout 2

MinSpareServers 10

MaxSpareServers 20

StartServers 5

MaxClients 256

MaxRequestsPerChild 10000