Page 1 of 12 12611 ... LastLast
Results 1 to 10 of 115
Like Tree25Likes

Thread: The All New Forum Bug Reporting Thread.

  1. #1
    MisterX's Avatar
    Join Date
    Dec 2010
    Location
    Scotland
    Posts
    2,177

    The All New Forum Bug Reporting Thread.

    The last threads entry appears to have been damaged in the database. So I've removed it as a precaution.

    Any outstanding issues please re-post them here.

    Thanks

  2. #2
    Colombia [CO]
    Tao
    Tao is offline
    wat? Tao's Avatar
    Join Date
    Mar 2007
    Location
    DeeDot SeaDot
    Posts
    9,627

    Re: The All New Forum Bug Reporting Thread.

    the entire site has been slow for what seems to be the last few months. links take a while to resolve, and making posts (especially on mobile) will just sit there and sit there until you've inadvertently produced a double or triple post. if all of this is as it should be, this will be the last i speak of it.

    somehow i doubt that's the case. what's going on?

  3. #3
    Judgement time DanFortH's Avatar
    Join Date
    Nov 2004
    Posts
    7,582
    Blog Entries
    12

    Re: The All New Forum Bug Reporting Thread.

    Agreed.

  4. #4
    MisterX's Avatar
    Join Date
    Dec 2010
    Location
    Scotland
    Posts
    2,177

    Re: The All New Forum Bug Reporting Thread.

    There is currently a little dispute as to what's causing the slow down. It all started when the host lost a disk in the raid that hosts Sr ( they did deny there was any hardware issue at first btw) Ever since they replaced the faulty disk there has been performance issues that seem to come and go throughout the day. The host now say we need a Database administrator to work on the SQL side of things. We have some optimizations to do, but are somewhat struggling to implement them at the moment.

    So In summary, Its not gone un-noticed....
    DanFortH likes this.

  5. #5
    The Tux Teck's Avatar
    Join Date
    Nov 2004
    Location
    Inside The StrafeRight.com Webserver.
    Posts
    14,583
    Blog Entries
    9

    Re: The All New Forum Bug Reporting Thread.

    Quote Originally Posted by MisterX View Post
    There is currently a little dispute as to what's causing the slow down. It all started when the host lost a disk in the raid that hosts Sr ( they did deny there was any hardware issue at first btw) Ever since they replaced the faulty disk there has been performance issues that seem to come and go throughout the day. The host now say we need a Database administrator to work on the SQL side of things. We have some optimizations to do, but are somewhat struggling to implement them at the moment.

    So In summary, Its not gone un-noticed....
    Yeah... Basically...

    1) We had no problems for years before...

    2) The query's they say are a problem are optimized by vBulletin... Any others would have been done by me, and you guys on SR know how long I've been a DBA with my specialty being optimization and data repair.



    Anyway, there are config optimizations... but, i am a little skeptical.
    "Teck will be working on God's forum" -VincentVega

    "...and I like killing zombies and Cap'n Crunch. you put those two together and you've got one LETHAL-ASS good time combo" -DanFortH

    "teck is the noobest leet guy I've ever met" -CoffeeShark

  6. #6
    MisterX's Avatar
    Join Date
    Dec 2010
    Location
    Scotland
    Posts
    2,177

    Re: The All New Forum Bug Reporting Thread.

    Now Unfortunately my background is in Hardware mostly, BDA stuff is a mystery to me, but the slow downs feel Like a raid array that has a damaged stripe and is running on parity, but I could very well be mistaken.

  7. #7
    aka Boji-Chan Bojingles's Avatar
    Join Date
    Jun 2007
    Location
    Germany
    Posts
    10,201
    Blog Entries
    2

    Re: The All New Forum Bug Reporting Thread.

    Edited by Teck:
    did you really just ask if Bo has his cwp?

    he shot his name into the application form from 1000 yards... while on a Segway... One handed with his USP in .45ACP... While doing pushups AND eating his sandwich...

  8. #8
    The Tux Teck's Avatar
    Join Date
    Nov 2004
    Location
    Inside The StrafeRight.com Webserver.
    Posts
    14,583
    Blog Entries
    9

    Re: The All New Forum Bug Reporting Thread.

    Quote Originally Posted by MisterX View Post
    Now Unfortunately my background is in Hardware mostly, BDA stuff is a mystery to me, but the slow downs feel Like a raid array that has a damaged stripe and is running on parity, but I could very well be mistaken.
    I happen to agree... But... I've been known to be wrong from time to time...
    "Teck will be working on God's forum" -VincentVega

    "...and I like killing zombies and Cap'n Crunch. you put those two together and you've got one LETHAL-ASS good time combo" -DanFortH

    "teck is the noobest leet guy I've ever met" -CoffeeShark

  9. #9
    MisterX's Avatar
    Join Date
    Dec 2010
    Location
    Scotland
    Posts
    2,177

    Re: The All New Forum Bug Reporting Thread.

    Okaaaayyy Todays downtime was interesting, but Happily it seems resolved, and dare I say it, the site seems to be running quite nicely at the moment. I'll detail the fix in the next post for those interested.

  10. #10
    MisterX's Avatar
    Join Date
    Dec 2010
    Location
    Scotland
    Posts
    2,177

    Re: The All New Forum Bug Reporting Thread.

    Ok this was the resolution

    have checked the server and could see that the mysql configuration contained some invalid values and according to these values mysql was using a lot of memory. The other issue was some InnoDB parameters were wrongly defined and this has caused InnoDB to be unloaded from mysql and thus InnoDB engine was not detected in the server by MySQL previously. This is the reason why you got the mysql error as given in your attachment.

    I have fixed the values and the InnoDB parameters and restarted mysql. Now InnoDB is detected as an engine and the site is not showing any mysql errors now.

    -
    # mysql -e "show engines" | grep -i InnoDB
    InnoDB YES Supports transactions, row-level locking, and foreign keys YES YES YES

Page 1 of 12 12611 ... LastLast

Posting Permissions

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

Advertise:
Ads@StrafeRight.com

Terms of Service || Privacy & DMCA Policies || About Us
Powered by vBulletin® Version 4.2.2
Copyright © 2017 vBulletin Solutions, Inc. All rights reserved.
Search Engine Friendly URLs by vBSEO 3.6.0

All times are GMT -4. The time now is 11:36 AM.
Design by DanFortH