Do I need more RAM?

because I just added some

[GerBot]

Following the advice from my host I recently added another GB of RAM because I was getting into Swap usage.
I also had the advice to allow for a query cache
query_cache_size=300M
query_cache_limit=30M
table_cache=512

this had an instant impact and my sites repose name really picked up.
Because of this I was able to add more products to my database but it appears all is going slow again.
Am I due for another upgrade (see stats below)?
Or should I be chasing my programmers for a more efficient system?
What kind of traffic or site size should this server be able to deal with?

The sites I run are real estate sites, so lots of images and searches in a database with about 25,000 proeprties. visitors numbers are around 10,000/day.
40GB traffic this month so far.

CPU AuthenticAMD, AMD Athlon(tm) 64 Processor 3200+
Version psa v7.5.4_build75050824.12 os_RedHat el4
OS Linux 2.6.9-42.0.2.EL
Key number PLSK.00181323.0001
System Uptime: 4 day(s) 00:08

CPU usageLast 1 minute 1.47
Last 5 minutes 1.64
Last 15 minutes 1.34

Memory UsageTotal Used Free Shared Buffer Cached Usage
1.98 GB 1.97 GB 13.38 MB 0 B 203.97 MB 1.37 GB 99.34%


Swap usageTotal Used Free Usage
1.00 GB 0 B 1.00 GB 0%


Hard Disk UsageFilesystem Total Used Available Capacity
/dev/hda5 71 990.87 MB 17 614.05 MB 50 719.84 MB 24.47%

thanks

[edited by: GerBot at 2:40 am (utc) on Oct. 29, 2006]

[Leosghost]

on your specs ..I would think that the way your DB is being accessed is the problem and not the amount of RAM ( whilst one can never have too much RAM ;-) ..

DB programmers can be very resource hungry ( sometimes unnecessarily so )..

what I know about DB is very disjointed ..someone such as iamlost would be much better to advise you ..

hopefully they may join in ..:)

[motorhaven]

That query cache size looks way too big. I use a 48meg query cache on a 6 gigabyte database. A cache that big (300 meg!) can result in too much time traversing the cache and robbing ram that might be more effectively used by key buffers and disk cache.

[romaniucc]

the cache is too high if you ask me. We're using 30MB for a 1gig db. Sure, more RAM won't hurt one bit.

[gello]

What are you trying to do with so much RAM?
get into the NASA?

[erdsah88]

The sites I run are real estate sites, so lots of images and searches in a database with about 25,000 proeprties. visitors numbers are around 10,000/day.
40GB traffic this month so far.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

hmmmm but the thing is how many real estate adds do u get every day?
I wonder incase u need to rebuild the system. is it over-loaded?