Results 1 to 19 of 19
  1. #1

    Find Server to 170.000 real visits/day

    This he is the present server that I have contracted:

    Professional Plan 1
    » 2000 GB Premium Multi-Homed Bandwidth
    (1000in + 1000out)
    » Dual Xeon 2.66GHZ Hyperthreaded
    » 2GB DDR Registered ECC
    » 120GB 7200RPM SATA / 8MB Cache
    » 120GB IDE Backup Drive
    » Linux - CentOS 4
    http://www.liquidweb.com/dedicated/c.../Professional/

    The problem is, that in rush hours the servant goes very slow, in short whiles loads and in short whiles it takes more in loading. Webs uses much MYSQL.

    If increase the ram in 4GB would solve east problem?

    PD: Si sabes español, contacta conmigo si puedes ayudarme. Gracias.

  2. #2
    Join Date
    Feb 2004
    Location
    Atlanta, GA
    Posts
    5,662
    Quote Originally Posted by Axo
    This he is the present server that I have contracted:

    Professional Plan 1
    » 2000 GB Premium Multi-Homed Bandwidth
    (1000in + 1000out)
    » Dual Xeon 2.66GHZ Hyperthreaded
    » 2GB DDR Registered ECC
    » 120GB 7200RPM SATA / 8MB Cache
    » 120GB IDE Backup Drive
    » Linux - CentOS 4
    http://www.liquidweb.com/dedicated/c.../Professional/

    The problem is, that in rush hours the servant goes very slow, in short whiles loads and in short whiles it takes more in loading. Webs uses much MYSQL.

    If increase the ram in 4GB would solve east problem?

    PD: Si sabes español, contacta conmigo si puedes ayudarme. Gracias.

    Liquidweb provides managed services. have you had them evaluate the box and make sure it's configured properly for that type of load?

    Most likely you'd be wasting your money on an extra 2gb

  3. #3
    ok, already consults to him to the support of liquidweb. What I want to know is if this servant will hold the visits well and but another servant superior makes lack to this.

  4. #4
    Join Date
    Aug 2005
    Location
    Seattle, WA
    Posts
    1,169
    If mysql is a big factor, then I believe that the RAM increse would definatly help.

    I'll take a shot in the dark with spanish.

    el aumento del RAM sería beneficioso

  5. #5
    Join Date
    Feb 2004
    Location
    Atlanta, GA
    Posts
    5,662
    Quote Originally Posted by goofygarber
    If mysql is a big factor, then I believe that the RAM increse would definatly help.

    I'll take a shot in the dark with spanish.

    el aumento del RAM sería beneficioso


    My spanish is awful, took 7 years of it and none of it stuck. Yet somehow my Italian is decent


    check the configuration first, before you spend the money on the ram

  6. #6
    Join Date
    Mar 2006
    Posts
    56
    Intense mysql usage, something like a forum? IMHO you should get two Opterons / SCSI, 1-2gb RAM each.

    I own a busy site/forum that use two Dual Opterons (246/248), SCSI, full redundancy/load balance/failover, on different DCs... highly optimized (long story heh), works really very well for me. I done a quick benchmark using the ab, requesting a topic from vanilla phpbb installation.... 320 reqs/s!.... sadly normally I dont have 320 pages requests per second, very far heheh For real life, even without a good setup two Dual Opterons will work for you I guess.
    Don't blame unmanaged services for your errors. Redundancy is the key for 100% of uptime, nothing else matter

  7. #7
    Ok, I think that to inrcementar the ram she could be a solution. In any case already envie the message to those of liquidweb. To see that they say to me. The greater load of the servant is produced by mysql. I do not use forums, is an own programming.

    to goofygarber, speaks uste very well Spanish, goes by good way xDD

  8. #8
    Join Date
    Feb 2004
    Location
    Atlanta, GA
    Posts
    5,662
    Quote Originally Posted by nsqlg
    Intense mysql usage, something like a forum? IMHO you should get two Opterons / SCSI, 1-2gb RAM each.

    I own a busy site/forum that use two Dual Opterons (246/248), SCSI, full redundancy/load balance/failover, on different DCs... highly optimized (long story heh), works really very well for me. I done a quick benchmark using the ab, requesting a topic from vanilla phpbb installation.... 320 reqs/s!.... sadly normally I dont have 320 pages requests per second, very far heheh For real life, even without a good setup two Dual Opterons will work for you I guess.

    I love the generic "you should use x" when you don't even understand what the problem is. 90% of the time I talk to people with these types of issues it's a serious misconfiguration or a lack of optimization.

  9. #9
    Join Date
    Mar 2006
    Posts
    56
    Quote Originally Posted by WireSix
    I love the generic "you should use x" when you don't even understand what the problem is. 90% of the time I talk to people with these types of issues it's a serious misconfiguration or a lack of optimization.
    Dont is the case for sure, 170k/day *uniques* on mysql intensive site (like him) really will slowdown the Dual Xeon 2.6ghz running IDE disk (right, you can buy 4GB of RAM, keeping mostly active files on memory, but skill a poor IDE), also they are managed, so less chance of be a newbie misconfiguration... of course can work just with a RAM upgrade, but who like slow sites, every peak time? I give my suggestion, that will make visitors happy, which is good. Also probably in near future will grown more the traffic....

    I love people that like servers running overloaded. Maybe works for X/Y shared hosting lowball clients, but not for profitable sites that cost of servers is almost nothing.
    Don't blame unmanaged services for your errors. Redundancy is the key for 100% of uptime, nothing else matter

  10. #10
    it might be a good idea to add another server just for mysql.
    P4HOST.COM -- Specialize in quality Web Hosting solutions.
    Affordable -- Prices are very comparative
    Reliable -- Very low load average guaranteed. 60 day money back. Fast Support --Support Forum -- Providing hosting since 2003

  11. #11
    Join Date
    Apr 2006
    Posts
    33
    what you already have is a serious monster machine man, i ran a program ...like SeenServ, which i wrote myself for an irc network we had before, on P4 server with 1GB RAM and it did like 15 queries/second (mostly insert/update queries) with absolutely no problems or load increase. I suggest you optimize your programming and tweak server a little.
    You should trade some of that RAM you already have for some CPU resources

  12. #12
    Join Date
    Nov 2005
    Location
    London UK
    Posts
    695
    I bet your running into IO problems ?

    For 170,000 *unique* visitors your gonna need a bigger box(s).
    Sure you *can* run it on yours, although that depends on how much of your power you want to be using. I'd say 20% resources average is a good marker. This leaves you space for spikes.

    John
    Ultra High Performance UK VPS without compromise.
    HPe servers, Intel NVMe DC P3700/P4600 SSD
    https://clustered.net

  13. #13
    Join Date
    Dec 2004
    Location
    New York, NY
    Posts
    10,710
    requesting a topic from vanilla phpbb installation.... 320 reqs/s
    uhh....right...care to tell us *how*?
    MediaLayer, LLC - www.medialayer.com Learn how we can make your website load faster, translating to better conversion rates for your business!
    The pioneers of optimized web hosting, featuring LiteSpeed Web Server & SSD Storage - Celebrating 10 Years in Business

  14. #14
    In order to add another servant with MYSQL, it would have to take it of equal characteristics? I buy it with the same company or layertech? I say it, because in layertech a little lower is the prices and I can buy a more powerful server.

    As it would be the ideal configuration for this type of traffic? What would have to change? It is for commenting it to it to those of liquidweb.

  15. #15
    If you don't want to upgrade to two servers. Why don't you upgrade to a quad core system with 4gb ram. That should be able to handle the amount of traffic you are seeking.

    Si usted no quiere mejorar a dos camareros. Por qué hace no usted mejora a un sistema de cuadratura del centro con la memoria de acceso aleatorio 4gb. Eso debe ser capaz de manejar la cantidad del tráfico que usted busca.

    Forgive me if I didn't do the spanish correctly.

    Erik

  16. #16
    top - 17:46:09 up 13 days, 6:35, 2 users, load average: 8.84, 6.45, 6.16
    Tasks: 291 total, 12 running, 278 sleeping, 1 stopped, 0 zombie
    Cpu(s): 69.2% us, 29.5% sy, 0.0% ni, 0.0% id, 0.8% wa, 0.0% hi, 0.5% si
    Mem: 1990876k total, 1972276k used, 18600k free, 181636k buffers
    Swap: 2040244k total, 160k used, 2040084k free, 820888k cached

    PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
    29551 mysql 18 0 130m 41m 2484 R 12.5 2.1 0:00.47 mysqld
    29522 mysql 17 0 130m 41m 2484 R 12.2 2.1 0:01.10 mysqld
    29546 mysql 17 0 130m 41m 2484 R 10.5 2.1 0:00.33 mysqld
    29557 mysql 17 0 130m 41m 2484 R 10.5 2.1 0:00.32 mysqld
    29547 mysql 17 0 130m 41m 2484 R 10.2 2.1 0:00.33 mysqld
    29559 mysql 17 0 130m 41m 2484 R 9.9 2.1 0:00.30 mysqld

    top - 17:46:33 up 13 days, 6:36, 2 users, load average: 12.39, 7.47, 6.50
    Tasks: 288 total, 8 running, 279 sleeping, 1 stopped, 0 zombie

    top - 17:46:58 up 13 days, 6:36, 2 users, load average: 10.81, 7.51, 6.54
    Tasks: 273 total, 4 running, 268 sleeping, 1 stopped, 0 zombie
    Cpu(s): 62.4% us, 29.7% sy, 0.0% ni, 7.5% id, 0.0% wa, 0.0% hi, 0.5% si
    Mem: 1990876k total, 1947892k used, 42984k free, 181888k buffers
    Swap: 2040244k total, 160k used, 2040084k free, 821112k cached

    PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
    29658 mysql 25 0 125m 39m 2484 R 46.8 2.1 0:06.88 mysqld
    29784 mysql 18 0 125m 39m 2484 S 11.3 2.1 0:00.34 mysqld
    29787 mysql 19 0 125m 39m 2484 S 10.6 2.1 0:00.32 mysqld
    29788 mysql 18 0 125m 39m 2484 S 10.6 2.1 0:00.32 mysqld
    29779 mysql 19 0 125m 39m 2484 S 10.3 2.1 0:00.31 mysqld
    29776 mysql 16 0 125m 39m 2484 S 7.3 2.1 0:00.22 mysqld
    29775 mysql 17 0 125m 39m 2484 S 5.3 2.1 0:00.32 mysqld
    29786 mysql 18 0 125m 39m 2484 R 5.3 2.1 0:00.16 mysqld
    28299 nobody 16 0 111m 8752 5656 S 2.7 0.4 0:00.69 httpd
    28241 nobody 15 0 111m 8568 5612 S 1.0 0.4 0:00.22 httpd


    root@host [~]# free -m
    total used free shared buffers cached
    Mem: 1944 1813 130 0 173 708
    -/+ buffers/cache: 931 1012
    Swap: 1992 0 1992


    Capture from consele...

    The mean load does not lower of 7. Optimizing the servant would be really solved this?

  17. #17
    Join Date
    Oct 2002
    Location
    In a house
    Posts
    949
    Quote Originally Posted by Axo
    In order to add another servant with MYSQL, it would have to take it of equal characteristics? I buy it with the same company or layertech? I say it, because in layertech a little lower is the prices and I can buy a more powerful server.

    As it would be the ideal configuration for this type of traffic? What would have to change? It is for commenting it to it to those of liquidweb.
    In my experience, you're better off purchasing the box from the same provider, so long as you're happy with their services, add in a 2nd NIC to the primary box, and run a GIGE cross connect to the SQL server (assumes 100/1000 NIC's are available). This will allow you to eliminate server to server bandwidth transfer, and avoid latency between two different providers for your setup.

    Clustering if you have the financial resources might not be a bad idea considering the traffic you're getting to your site, and will give you a bit better overall stability to things.
    Matthew McCormick
    Director of Customer Care
    www.caro.net
    mmccormick@carohosting.com

  18. #18
    Join Date
    Nov 2005
    Location
    London UK
    Posts
    695
    Your problem is mysql is eating your cpu cycles.

    Either get a bigger server, or optimize your code.
    Memory won't make much difference.


    John
    Ultra High Performance UK VPS without compromise.
    HPe servers, Intel NVMe DC P3700/P4600 SSD
    https://clustered.net

  19. #19
    Join Date
    Jun 2003
    Location
    San Francisco
    Posts
    623
    170000 visitors per day is average less than 2 visitors per sec. Of course, each visitor will have multiple page views and each page view will have multiple queries. So, at any given moment, you may have dozens of queries running.

    From your log, it doesn't look like that many.

    Like everyone said, mysql is taking too much time. If mysql has to hit the HD often, that will be a problem.

    I don't think RAM is the issue. 2GB should be enough for a couple of dozens quries at the same time.

    First, get the book "High Performance mySQL". You need to optimize the configuration file to cache as much as possible, and maybe change the indexing of your tables. You need to check the queries and make sure most of them (if not all) select on indice, to avoid mysql reading the whole table. For example, if you do a "SELECT ... WHERE city = 'San Francisco'", city should be indexed.

    There are some cache settings to change, to make sure all the indice are cached etc.

    Actually, you probably can find all the tips on optimizing mySQL on the board. However, the book is easier to follow and better organized (than search the board).

    Upgrade hardware only if you still have problems after the optimization. Upgrading to bigger server with bigger CPU won't help because the bottlenet is the disk IO. Upgrade to SCSI will help a lot. Upgrade to SCSI RAID (even RAID-1) will be even better because the RAID card has a nice big cache.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •