Results 1 to 8 of 8
  1. #1

    JollyWorksHosting Mysql slowness

    Hello,

    I tried to store the mysql database on a jollyworkshosting 800GB account so that my VPS server access it to serve the pages.
    It is so slow that I stopped.

    Does someone has the same problem ?

    Mykeul

  2. #2
    Join Date
    Jul 2007
    Location
    Ashburn, VA
    Posts
    1,314
    What exactly is the issue? Is the network latency too high?
    Preetam Jinka

    Isomerous - High performance web services for business and individuals.
    Bitcable Colocation, KVMs, cPanel hosting, Oracle expertise, and more.

  3. #3
    Join Date
    Apr 2001
    Location
    Paradise
    Posts
    11,868
    I'm sorry, maybe I misunderstood you, are you trying to restore a 800 GB Mysql DB?
    Shared Web Hosting - Reseller Hosting - Semi-Dedicated Servers - SolusVM/XEN VPS
    LiteSpeed Powered - R1Soft Continuous Data Protection - 24/7 Chat/Email/Helpdesk Support
    Cpanel/WHM - Softaculous - R1soft Backup - Litespeed - Cloudlinux -Site Builder- SSH support - Account Migration
    DowntownHost LLC - In Business since 2001- West/Center/East USA - Netherlands - Singapore

  4. #4
    Hello,

    I had a 2GB database, stored it on JollyWorks, accessed it with my VPS in France ... and it was very very very slow.
    Network latency was OK

    Mykeul

  5. #5
    Join Date
    Apr 2001
    Location
    Paradise
    Posts
    11,868
    is that a VPS? if so, what's the mysql activity?
    Shared Web Hosting - Reseller Hosting - Semi-Dedicated Servers - SolusVM/XEN VPS
    LiteSpeed Powered - R1Soft Continuous Data Protection - 24/7 Chat/Email/Helpdesk Support
    Cpanel/WHM - Softaculous - R1soft Backup - Litespeed - Cloudlinux -Site Builder- SSH support - Account Migration
    DowntownHost LLC - In Business since 2001- West/Center/East USA - Netherlands - Singapore

  6. #6
    Join Date
    Feb 2008
    Location
    Houston, Texas, USA
    Posts
    2,955
    Any one DB query that takes over 1 second to run is going to be problematic for any website. The effect intensifies as more queries are executed. A query that has to travel from France to, say, the US will take at least 1-2 seconds to complete. For a typical blog, there are about 30-50 queries so that would take 10-15 seconds to complete over a high latency link.

    It's just not practical.

    Regards
    UNIXy - Fully Managed Servers and Clusters - Established in 2006
    [ cPanel Varnish Nginx Plugin ] - Enhance LiteSpeed and Apache Performance
    www.unixy.net - Los Angeles | Houston | Atlanta | Rotterdam
    Love to help pro bono (time permitting). joe > unixy.net

  7. #7
    Join Date
    Jan 2010
    Location
    so cal
    Posts
    232
    You're trying to host a mysql db on a shared or vps plan?

  8. #8
    Join Date
    Dec 2004
    Location
    New York, NY
    Posts
    10,574
    As UNIXy explained above, you're going to want the database server to be local to your web server (i.e. <1ms away). Otherwise even if the database server is fast and running perfectly fine, the network latency is going to cause a huge delay.

    You might want to try enabling persistent connections which can speed things up in these cases, but it still won't compare to having a local database server. Hosting your database on the VPS would probably even be better than the remote server.
    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

Similar Threads

  1. Is jollyworkshosting reliable ?
    By pt_trieu in forum Web Hosting
    Replies: 9
    Last Post: 03-01-2010, 08:20 AM
  2. JollyWorksHosting - Stay Away
    By Karl in forum VPS Hosting
    Replies: 11
    Last Post: 02-25-2010, 07:40 PM
  3. slowness problem
    By miscak in forum Hosting Security and Technology
    Replies: 7
    Last Post: 08-09-2006, 08:24 PM
  4. GearHost slowness...
    By OtherMDesign in forum Web Hosting
    Replies: 5
    Last Post: 02-02-2004, 11:21 PM
  5. slowness
    By clocker1996 in forum Hosting Security and Technology
    Replies: 2
    Last Post: 01-26-2002, 12:47 PM

Posting Permissions

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