Most of the websites am hosting are running PHP-MySQL applications like Nuke, post Nuke, VB etc.
am facing problem with the momery which as it is shown in the plesk like that
Total Used Free Shared Buffer Cached Usage
1.48 GB 1.45 GB 22.89 MB 0 B 41.24 MB 1.15 GB 98.49%
how can I reduce the Cached amount it's taking allot of the memory,
the my.cnf file is : -
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
skip-innodb
key_buffer = 128M # 384M
max_allowed_packet = 3M
max_connections=400
max_user_connections=100
table_cache = 32 #512
sort_buffer_size = 2M
read_buffer_size = 2M #64M
myisam_sort_buffer_size = 2M #64M
thread_cache = 8
query_cache_size = 2M #32M
thread_concurrency = 2
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
here's httpd.conf file
ServerTokens OS
ServerRoot "/etc/httpd"
Timeout 120
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 10
StartServers 2
MinSpareServers 4
MaxSpareServers 8
ServerLimit 1024
MaxClients 512
MaxRequestsPerChild 500
StartServers 2
MaxClients 100
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
NumServers 5
StartThreads 5
MinSpareThreads 5
MaxSpareThreads 10
MaxThreadsPerChild 20
MaxRequestsPerChild 0
Please advice