1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    863
    Likes Received:
    206
    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:
    4,091
    Likes Received:
    1,520
    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:
    863
    Likes Received:
    206
    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,452
    Likes Received:
    1,297
    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:
    863
    Likes Received:
    206
    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:
    253
    Location:
    Tenneessee USA
    Home Page:
    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:
    4,817
    Likes Received:
    4,053
    Occupation:
    Making Money when the world is sleeping
    Location:
    Menlo Park - Next to Zuck
  8. BackY

    BackY Senior Member

    Joined:
    Dec 28, 2012
    Messages:
    863
    Likes Received:
    206
    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:
    712
    Likes Received:
    267
    Location:
    PHP Scripting ;)
    Mind sharing what he did?
     
  10. matsta

    matsta Power Member

    Joined:
    Oct 12, 2008
    Messages:
    555
    Likes Received:
    620
    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!