Hi
Following is server information
OS version:Linux playpen 2.6.18-6-amd64 #1 SMP Thu Dec 25 21:08:54 UTC 2008 x86_64 GNU/Linux
64 bit OS
MySQL version
mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (x86_64) using readline 5.2
By using TOP command mysql is allocated 4.5G and using upto 58.5 %
Database size 150GB
Innodb_buffer_pool_size=4GB
Max connection =500 avg used connection 201
Current query_cache_size = 16 M
Current query_cache_used = 14 M
!!] Query cache efficiency: 15.6% (3M cached / 23M selects)
[!!] Query cache prunes per day: 3551088
[!!] InnoDB data size / buffer pool: 104.3G/4.0G
[!!] Maximum possible memory usage: 36.4G (467% of installed RAM)
Physical Memory 8G
Reads / Writes: 86% / 14%
server Information
playpen:~# free -m
total used free shared buffers cached
Mem: 7988 3155 4832 0 66 1547
-/+ buffers/cache: 1541 6447
Swap: 16383 43 16340
for top command
USER PR NI VIRT RES SHR S CPU% % MEM TIME COMMAND
1841 root 15 0 4903m 4.5g 4340 S 229 58.0 3835:26 mysqld
PLEASE RECOMMEND SHOULD 8 GB RAM BE INCREASED ?