slower connectivity with DP

Discussion in 'Support & Feedback' started by Edz, Sep 7, 2005.

  1. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #21
    Nope... nothing to do with any front-end stuff or PHP stuff. It's 100% a mysql problem.
     
    digitalpoint, Sep 8, 2005 IP
  2. soapbath

    soapbath Peon

    Messages:
    909
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    0
    #22
    Oh, dam. Hope it gets fixed soon, Is SQL open source? I think it is but SQL is one of them things that I never researched into.
     
    soapbath, Sep 8, 2005 IP
  3. zman

    zman Peon

    Messages:
    3,113
    Likes Received:
    180
    Best Answers:
    0
    Trophy Points:
    0
    #23
    Argh! Im having to copy my posts before hitting submit just in case I get an error and have to go back to repost.

    Hope it is fixed soon.
     
    zman, Sep 8, 2005 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #24
    You shouldn't be getting any errors.
     
    digitalpoint, Sep 8, 2005 IP
  5. zman

    zman Peon

    Messages:
    3,113
    Likes Received:
    180
    Best Answers:
    0
    Trophy Points:
    0
    #25
    Havent gotten any today but yesterday I was getting the "page cannot be displayed" because it was taking too long to load. That is partially to blame on my connection at work but it isnt a whole lot better at at home as of late.

    Didnt mean to bitch DP, I know your working on it. :)
     
    zman, Sep 8, 2005 IP
  6. soapbath

    soapbath Peon

    Messages:
    909
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    0
    #26
    I got a few errors today, but they was only SQL errors.
     
    soapbath, Sep 8, 2005 IP
  7. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #27
    Well thankfully it's not a deal where it's happening to some people. It's either happening, or it's not and any given time, and if it's happening, restarting the mysqld process brings it back to normal.
     
    digitalpoint, Sep 8, 2005 IP
  8. yfs1

    yfs1 User Title Not Found

    Messages:
    13,798
    Likes Received:
    922
    Best Answers:
    0
    Trophy Points:
    0
    #28
    Shawn - Please turn off the SEOChat simulator! I just can't take the slow loading :eek:


    PS - The mySql leak seems to be starting again
     
    yfs1, Sep 9, 2005 IP
  9. docquesting

    docquesting Active Member

    Messages:
    54
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    98
    #29
    Today is extremly slow. Some how It posted triple on me in the domain forum it took about 5 mins to edit post.
     
    docquesting, Sep 9, 2005 IP
  10. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #30
    Yeah I know... trust me, it's pissing me off more than anyone else.
     
    digitalpoint, Sep 9, 2005 IP
  11. Edz

    Edz Peon

    Messages:
    1,690
    Likes Received:
    72
    Best Answers:
    0
    Trophy Points:
    0
    #31
    Today everything works fine, no delays what so ever:cool:
     
    Edz, Sep 10, 2005 IP
  12. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #32
    Just a FYI, I *finally* pinpointed what the problem was, and no longer need to force the mysqld process to restart about once a day. :)

    http://www.digitalpoint.com/~shawn/2005/10/mysql-problems-on-mac-os-x-server.html

    That also means the db server just got even faster (supporting this forum, the keyword tracker, the ad network and a high traffic geotargetting system, the server PEAKS at about 3% CPU utilization. :))
     
    digitalpoint, Oct 11, 2005 IP
  13. Nintendo

    Nintendo ♬ King of da Wackos ♬

    Messages:
    12,890
    Likes Received:
    1,064
    Best Answers:
    0
    Trophy Points:
    430
    #33
    WOW!!! I'm on an iMac, and I had no idea they were powerful enough to handle a domain like this, let alone mySQL, and the bandwidth!!!!!!

    Can the shell commands help speed it up on other kinds of servers? ie RedHat/Linux/Apache/other....
     
    Nintendo, Oct 11, 2005 IP
  14. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #34
    Well I'm not exactly running iMacs. :) Although Mac OS X is really just BSD at the core, so you probably could run all of digitalpoint.com on a single iMac if you really wanted.

    The MySQL machine in question that's running Mac OS X Server is an Xserve...

    http://www.apple.com/xserve/

    I think the ulimit stuff applies to most BSD based systems (FreeBSD, BSDi, Mac OS X, etc.)
     
    digitalpoint, Oct 11, 2005 IP