Welcome to WebmasterWorld Guest from 50.16.24.12

Forum Moderators: open

Do I need more RAM?

because I just added some

   
2:28 am on Oct 29, 2006 (gmt 0)

10+ Year Member



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]

10:41 pm on Oct 30, 2006 (gmt 0)

WebmasterWorld Senior Member leosghost is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



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 ..:)

1:39 am on Nov 1, 2006 (gmt 0)

10+ Year Member



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.
3:58 pm on Nov 14, 2006 (gmt 0)

5+ Year Member



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.
11:18 am on Nov 27, 2006 (gmt 0)

5+ Year Member



What are you trying to do with so much RAM?
get into the NASA?
7:09 pm on Dec 3, 2006 (gmt 0)

5+ Year Member



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?

 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved