Results 1 to 5 of 5

Thread: Regarding recent forum 'lag'.

  1. #1
    Join Date
    Nov 2006
    Location
    Portugal
    Posts
    2,373

    Regarding recent forum 'lag'.

    Hello everyone,

    As most of you have noticed, our forums have been running a bit slower than usual since last Friday, which was when I submitted a support ticket to Hostgator, this was their response given to me on Saturday.

    Quote Originally Posted by Hostgator

    Hello there,

    We're terribly sorry for the confusion, frustration, and inconvenience this has caused you as well as for the delayed response as we are experiencing higher than normal ticket volume at this time and are working to address each request as soon as possible.

    Recently, a Wordpress update was automatically pushed to all Wordpress installations via Wordpress' upgrade mechanism. Unfortunately, this caused quite a bit of load on the servers with Wordpress installed on them as well as some MySQL connectivity issues as well.

    Once we found the cause of the issue, there was unfortunately little that could be done other than letting them complete as stopping these upgrades before they completed would have broken those sites.

    At this time, your site seems to be loading without any apparent issues. More information about this issue can be found at http://forums.hostgator.com/wordpres...e-t324253.html

    Please let us know if you experience any issues or have any questions or concerns.
    Thank you for your patience,
    Regards!
    "Making mistakes is human, but the ability to acknowledge them, the humility and maturity to apologize and try to correct them is GODLY"


    Because we have cookies!

    Quotes & Stuff
     



    Because I'm ninja!


    Because Senya rocks!

    The ultimate "small time" criminal...


    Vote for me, USA 2016


    Some of my favorite quotes:

    "When a man is denied the right to live the life he believes in, he has no choice but to become an outlaw" - Nelson Mandela

    "There is no fate but what we make" - John Connor (Christian Bale)

    "Embrace your dreams and protect your honor" Zack Fair (FF7)

    "I don't step aside, I step up" - Vic Mackey (Michael Chiklis)

    "Falling is the last thing an angel feels" - Gabriel (Andy Whitfield RIP)

    "Revenge is a meal best served cold" - John W. Creasy (Denzel Washington)

    "I don't believe in God but I believe in Angels" - Max Payne (Mark Wahlberg)

    "Accept your fate of be destroyed by it" - Batiatus

    "Accept your fate or be destroyed by specters of a past never to return" - Spartacus

    "Certainly there is no hunting like the hunting of man and those who have hunted armed men long enough and liked it, never really care for anything else thereafter" - Ernest Hemingway

    "It is easier to find men willing to die, than men who endure pain with patience" - Gaius Julius Caesar

    "Forgiveness is between them and God, it's my job to arrange the meeting" - John W. Creasy (Denzel Washington)

    "I live to see a day where (...) cruelty is but a distant memory" - Spartacus.

    "A man is never too weak or too wounded to fight. If his cause is greater than his own life." - Oenomaus.

    "Revenge is a meal best served cold" - John W. Creasy.

    "The price of freedom is sacrifice" - Zack Fair.

    "Track them, find them, kill them" - Barney Ross.

    "There is no justice, not in this world" - Spartacus.

    I'm sorry Crixus, I just couldn't help myself.




  2. #2
    NOPROBLEM Guest
    still laggy as fuck

  3. #3
    Join Date
    Nov 2006
    Location
    Portugal
    Posts
    2,373
    Quote Originally Posted by NOPROBLEM View Post
    still laggy as fuck
    Hostgator has been notified, don't worry ;]
    "Making mistakes is human, but the ability to acknowledge them, the humility and maturity to apologize and try to correct them is GODLY"


    Because we have cookies!

    Quotes & Stuff
     



    Because I'm ninja!


    Because Senya rocks!

    The ultimate "small time" criminal...


    Vote for me, USA 2016


    Some of my favorite quotes:

    "When a man is denied the right to live the life he believes in, he has no choice but to become an outlaw" - Nelson Mandela

    "There is no fate but what we make" - John Connor (Christian Bale)

    "Embrace your dreams and protect your honor" Zack Fair (FF7)

    "I don't step aside, I step up" - Vic Mackey (Michael Chiklis)

    "Falling is the last thing an angel feels" - Gabriel (Andy Whitfield RIP)

    "Revenge is a meal best served cold" - John W. Creasy (Denzel Washington)

    "I don't believe in God but I believe in Angels" - Max Payne (Mark Wahlberg)

    "Accept your fate of be destroyed by it" - Batiatus

    "Accept your fate or be destroyed by specters of a past never to return" - Spartacus

    "Certainly there is no hunting like the hunting of man and those who have hunted armed men long enough and liked it, never really care for anything else thereafter" - Ernest Hemingway

    "It is easier to find men willing to die, than men who endure pain with patience" - Gaius Julius Caesar

    "Forgiveness is between them and God, it's my job to arrange the meeting" - John W. Creasy (Denzel Washington)

    "I live to see a day where (...) cruelty is but a distant memory" - Spartacus.

    "A man is never too weak or too wounded to fight. If his cause is greater than his own life." - Oenomaus.

    "Revenge is a meal best served cold" - John W. Creasy.

    "The price of freedom is sacrifice" - Zack Fair.

    "Track them, find them, kill them" - Barney Ross.

    "There is no justice, not in this world" - Spartacus.

    I'm sorry Crixus, I just couldn't help myself.




  4. #4
    Join Date
    Nov 2006
    Location
    Portugal
    Posts
    2,373
    Hello,

    Here's another reply from Hostgator:

    Quote Originally Posted by Hostgator
    Hello Luis,

    It doesn't appear as though the Wordpress updates are causing the issue at this time.

    I was able to visit the site and can confirm that it is taking a while to load the forums. I performed a repair and optimize on the database which seems to have helped a little bit, but I also noticed that there are many tables with more than 10,000 records each:

    ---------------------------------------------------------------
    | Tables | Columns | Total Rows |
    | adminlog | 7 | 31928 |
    | contentread | 7 | 28194 |
    | cronlog | 5 | 114535 |
    | ipdata | 8 | 28194 |
    | phrase | 9 | 16658 |
    | pm | 6 | 22037 |
    | pmtext | 11 | 19707 |
    | post | 17 | 45714 |
    | searchcore | 10 | 52350 |
    | searchcore_text | 3 | 52350 |
    | searchgroup | 6 | 10970 |
    | searchgroup_text | 2 | 10991 |

    If you have had many members join recently, a lot of post activity, or have added any new features to the site, this could be causing a large number of records to be made which will ultimately slow down the operation of the site as those records are read or those tables are written to.

    It appears that the database itself is the cause for the slowness as the site has seen many slow queries over the last 24 hours:

    [+] Checking ---------------------
    [-] ------- killed 7604 times.
    [-] ------- killed 90 times in past 24hrs.
    [-] ------- was first killed: Mon Aug 5 21:09:02 2013
    [-] ------- was last killed: Mon Aug 11 17:12:01 2014

    If possible, we recommend cleaning up the database and creating indexes for the tables where possible. In addition, I see that many of the tables are MyISAM and we recommend converting those to InnoDB if possible to take advantage of InnoDB's ability to due row level locking instead of table level locking like MyISAM does.

    Please let us know if you experience any issues or have any questions or concerns.

    Regards,
    The Hostgator technician who responded to my ticket, along with myself and Wesley, have already executed several maintenance operations in order to improve the forums' performance, however, they were still running a bit slow today.

    I have temporarily disabled the forums' search function, which was visibly overloading the forums. The forums' speed has increased significantly, but they still lag a bit.

    Please be patient while we solve this matter permanently.

    Thank you all for your patience!
    "Making mistakes is human, but the ability to acknowledge them, the humility and maturity to apologize and try to correct them is GODLY"


    Because we have cookies!

    Quotes & Stuff
     



    Because I'm ninja!


    Because Senya rocks!

    The ultimate "small time" criminal...


    Vote for me, USA 2016


    Some of my favorite quotes:

    "When a man is denied the right to live the life he believes in, he has no choice but to become an outlaw" - Nelson Mandela

    "There is no fate but what we make" - John Connor (Christian Bale)

    "Embrace your dreams and protect your honor" Zack Fair (FF7)

    "I don't step aside, I step up" - Vic Mackey (Michael Chiklis)

    "Falling is the last thing an angel feels" - Gabriel (Andy Whitfield RIP)

    "Revenge is a meal best served cold" - John W. Creasy (Denzel Washington)

    "I don't believe in God but I believe in Angels" - Max Payne (Mark Wahlberg)

    "Accept your fate of be destroyed by it" - Batiatus

    "Accept your fate or be destroyed by specters of a past never to return" - Spartacus

    "Certainly there is no hunting like the hunting of man and those who have hunted armed men long enough and liked it, never really care for anything else thereafter" - Ernest Hemingway

    "It is easier to find men willing to die, than men who endure pain with patience" - Gaius Julius Caesar

    "Forgiveness is between them and God, it's my job to arrange the meeting" - John W. Creasy (Denzel Washington)

    "I live to see a day where (...) cruelty is but a distant memory" - Spartacus.

    "A man is never too weak or too wounded to fight. If his cause is greater than his own life." - Oenomaus.

    "Revenge is a meal best served cold" - John W. Creasy.

    "The price of freedom is sacrifice" - Zack Fair.

    "Track them, find them, kill them" - Barney Ross.

    "There is no justice, not in this world" - Spartacus.

    I'm sorry Crixus, I just couldn't help myself.




  5. #5
    Join Date
    Aug 2012
    Location
    Erie, PA
    Posts
    690
    I myself and Neo are working on getting the forums back up to speed. Hopefully we can fix it.

    ~Wes

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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