homepage Welcome to WebmasterWorld Guest from 54.205.106.111
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Hardware and OS Related Technologies / Webmaster Hardware
Forum Library, Charter, Moderator: open

Webmaster Hardware Forum

    
Do I need more RAM?
because I just added some
GerBot




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

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




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

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




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

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




msg:3156301
 3:58 pm on Nov 14, 2006 (gmt 0)

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




msg:3169215
 11:18 am on Nov 27, 2006 (gmt 0)

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

erdsah88




msg:3176918
 7:09 pm on Dec 3, 2006 (gmt 0)

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?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Webmaster Hardware
rss feed

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