I wanna hire someone to edit my Wordpress Database for HIGH traffic

Discussion in 'Hire a Freelancer' started by BackY, Dec 1, 2013.

  1. BackY

    BackY Senior Member

    Joined:
    Dec 28, 2012
    Messages:
    1,160
    Likes Received:
    267
    Hey guys,

    Recently I launched a website, to which I sent 50,000-100,000 visitors per day, and I'm having problems when a lot of users come online at the same time (usualy it starts to lag, when I reach 900 online visitors).

    The dedicated server that I'm using is very good, but the main problem is the databases. I actualy crashed the server several times, and I checked the resources usage, it was very low..

    I need a database administrator, who could give me a hand around this?
    Thank you ..
     
  2. AquaticGamer

    AquaticGamer Jr. VIP Jr. VIP

    Joined:
    Apr 13, 2013
    Messages:
    5,011
    Likes Received:
    1,749
    Gender:
    Male
    Location:
    http://www.AQSocials.com
    Home Page:
    If it's the database error then it means that the dedicated server isn't good. Try getting a new one and make sure it has unlimited bandwith.
     
    • Thanks Thanks x 2
  3. BackY

    BackY Senior Member

    Joined:
    Dec 28, 2012
    Messages:
    1,160
    Likes Received:
    267
    Dude, no resrouce usage is being used nearly HALF of it's capacity.

    Operating System: CentOS 6.x with WHM/cPanel
    Server Specifications: Intel(R) Xeon(R) CPU E31220 @ 3.10GHz
    8GB DDR3-1333MHz ECC SDRAM
    2 x 1000GB SATAII HDD (7200 RPM)
    10000GB Bandwidth

    I think these performances are more than ENOUGH to be able to hold 900visitors :D
    I contacted the support team, and that's what they said. You need a database administrator to help u with this. THey said they'd apply a temporary fix to the database's configurations, and it helped a lot.
     
  4. Veyron

    Veyron BANNED BANNED

    Joined:
    Jun 3, 2013
    Messages:
    1,451
    Likes Received:
    1,302
    If you still need further help/assistance you should search around the BST for someone who could assist you. However, if you listen to what AquaticGamer said and upgrade to unlimited bandwith I think you'd see big improvements.

    Veyron
     
  5. BackY

    BackY Senior Member

    Joined:
    Dec 28, 2012
    Messages:
    1,160
    Likes Received:
    267
    I have used only 3GB out of 10,000GB during the 10days my website is running.. So I repeat, bandwidth an other resoures (CPU, RAM etc) are not the problem! I've checked them all.. It's just the mysql settings. My site is curently using the default ones, and I need it to be configured for many visitors. Use other settings instead the default ones.

    Let's wait for someone who understands this field ..
     
  6. tnhomestead

    tnhomestead Regular Member

    Joined:
    Oct 9, 2011
    Messages:
    385
    Likes Received:
    254
    Location:
    Tenneessee USA
    You might want to add some more information. Are you running Wordpress or some other CMS? Apache or something like NGINX? If Wordpress, what plugins? Or some custom code? A lot of times if its Wordpress, it is a plugin issue. On the database end, which database are you using?
    A bit more information might let someone help you better.
    Good Luck!
     
  7. indianbill007

    indianbill007 Jr. VIP Jr. VIP

    Joined:
    Jan 8, 2010
    Messages:
    5,244
    Likes Received:
    4,231
    Occupation:
    Making Money when the world is sleeping
    Location:
    Menlo Park - Next to Zuck
  8. BackY

    BackY Senior Member

    Joined:
    Dec 28, 2012
    Messages:
    1,160
    Likes Received:
    267
    Thank you all guys, it got fixed by: matsta and it's working like a charm!
     
  9. Repulsor

    Repulsor Power Member

    Joined:
    Jun 11, 2013
    Messages:
    776
    Likes Received:
    280
    Location:
    PHP Scripting ;)
    Mind sharing what he did?
     
  10. matsta

    matsta Power Member

    Joined:
    Oct 12, 2008
    Messages:
    555
    Likes Received:
    627
    Location:
    New Zealand
    Optimised and cached the hell out of Mysql, then setup Varnish and Memcached to handle the load a bit better. It's not using less ram than it was using with Apache alone!