homepage Welcome to WebmasterWorld Guest from 50.16.112.199
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

10+ Year Member



 
Msg#: 3138534 posted 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#: 3138534 posted 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

10+ Year Member



 
Msg#: 3138534 posted 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

5+ Year Member



 
Msg#: 3138534 posted 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

5+ Year Member



 
Msg#: 3138534 posted 11:18 am on Nov 27, 2006 (gmt 0)

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

erdsah88

5+ Year Member



 
Msg#: 3138534 posted 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