Author Topic: Stop board lag?  (Read 1151 times)

Offline USRanger

  • AvA Staff Member
  • Plutonium Member
  • *******
  • Posts: 10325
      • BoP Home
Re: Stop board lag?
« Reply #15 on: November 30, 2009, 07:09:21 PM »
Bad board lag tonight.  Lots of double, triple & even quadruple posts.  Took over 15 minutes for one of my posts to load after hitting "post".  I knew not to hit it again & just wait to avoid the dreaded double posting. :D  It's getting bad the last month. :confused:
Axis vs Allies Staff Member
☩ JG11 Sonderstaffel ☩
Flying 'Black[Death] 10' ☩JG11☩

Only the Proud, Only the Strong Ne Desit Virtus

Offline E25280

  • Gold Member
  • *****
  • Posts: 3475
      • http://125thspartanforums.com
Re: Stop board lag?
« Reply #16 on: November 30, 2009, 07:15:56 PM »
It's Cyber-Monday --- net lag is bound to be awful.

Probably will be until about Christmas.
Brauno in a past life, followed by LTARget
SWtarget in current incarnation
Captain and Communications Officer~125th Spartans

"Proudly drawing fire so that my brothers may pass unharmed."

Offline E25280

  • Gold Member
  • *****
  • Posts: 3475
      • http://125thspartanforums.com
Re: Stop board lag?
« Reply #17 on: November 30, 2009, 07:16:39 PM »
It's Cyber-Monday --- net lag is bound to be awful.

Probably will be until about Christmas.




No really.
Brauno in a past life, followed by LTARget
SWtarget in current incarnation
Captain and Communications Officer~125th Spartans

"Proudly drawing fire so that my brothers may pass unharmed."

Offline MachFly

  • Platinum Member
  • ******
  • Posts: 6296
Re: Stop board lag?
« Reply #18 on: November 30, 2009, 08:33:17 PM »
:aok That's what I do as well


 :furious Made my 1st double post 
"Now, if I had to make the choice of one fighter aircraft above all the others...it would be, without any doubt, the world's greatest propeller driven flying machine - the magnificent and immortal Spitfire."
Lt. Col. William R. Dunn
flew Spitfires, Hurricanes, P-51s, P-47s, and F-4s

Offline Skuzzy

  • Support Member
  • Administrator
  • *****
  • Posts: 31462
      • HiTech Creations Home Page
Re: Stop board lag?
« Reply #19 on: December 01, 2009, 07:49:49 AM »
I know what is causing it, but to fix it would require us to take the board down for about 2 days.
Roy "Skuzzy" Neese
support@hitechcreations.com

Offline MachFly

  • Platinum Member
  • ******
  • Posts: 6296
Re: Stop board lag?
« Reply #20 on: December 01, 2009, 02:25:10 PM »
I know what is causing it, but to fix it would require us to take the board down for about 2 days.

Perhaps we can make a poll to see what the majority of the people want; leave it or take the board down for 2 days to fix it?  :headscratch:
"Now, if I had to make the choice of one fighter aircraft above all the others...it would be, without any doubt, the world's greatest propeller driven flying machine - the magnificent and immortal Spitfire."
Lt. Col. William R. Dunn
flew Spitfires, Hurricanes, P-51s, P-47s, and F-4s

Offline Motherland

  • Plutonium Member
  • *******
  • Posts: 8110
Re: Stop board lag?
« Reply #21 on: December 01, 2009, 02:26:20 PM »
I know what is causing it, but to fix it would require us to take the board down for about 2 days.
Maybe you should take it down the day you release 2.17 so you don't have to read any whines  :devil

Offline Skuzzy

  • Support Member
  • Administrator
  • *****
  • Posts: 31462
      • HiTech Creations Home Page
Re: Stop board lag?
« Reply #22 on: December 01, 2009, 02:51:39 PM »
Now that would be evil Motherland.



I LIKE IT!  :)
Roy "Skuzzy" Neese
support@hitechcreations.com

Offline Gaidin

  • Silver Member
  • ****
  • Posts: 1191
Re: Stop board lag?
« Reply #23 on: December 01, 2009, 02:57:01 PM »
What is the cause?  It would be good information for those who want to learn something.  I have seen this problem on random boards, would be curious to know the cause.
Death is but a doorway to life, only those who fear life fear its opening.

Ingame: 68Gaidin

Proud Member of the CM Team
FSO - Admin

Offline Skuzzy

  • Support Member
  • Administrator
  • *****
  • Posts: 31462
      • HiTech Creations Home Page
Re: Stop board lag?
« Reply #24 on: December 01, 2009, 04:26:42 PM »
Boards can exhibit the same thing, but for very different reasons.  It can be resource related, out of balance parameters in MySQL, or any number of things related to hard disk usage.

In this case, it has to do with the InnoDB log files growing in too large of chunks.  I need to break them down into smaller chunks so updates are done more often, but with less impact to the boards performance.

Unfortunately, you cannot simply change those parameters on a live database.  The safest way (most paranoid) to accomplish it is to dump the databases to another server, perform the changes, then reload the databases.

What takes so long is the transfer of all the databases (tours, wiki, bulletin board).  In order to have an accurate roll back logs, you have to inject the data back into the databases.  If I was less paranoid, I would just copy the files over, but that would lose the ability to do any rollbacks on any of the databases from that point back.
Roy "Skuzzy" Neese
support@hitechcreations.com

Offline morfiend

  • AH Training Corps
  • Plutonium Member
  • *******
  • Posts: 10447
Re: Stop board lag?
« Reply #25 on: December 01, 2009, 07:20:46 PM »
Now that would be evil Motherland.



I LIKE IT!  :)


  Sounds like someone had a good vacation..... deservedly so... :lol

Offline USRanger

  • AvA Staff Member
  • Plutonium Member
  • *******
  • Posts: 10325
      • BoP Home
Re: Stop board lag?
« Reply #26 on: December 01, 2009, 07:49:39 PM »
Had a long wait tonight after hitting Community->Forum.  After 5 minutes I just gave up for an hour.  Usually when this stuff happens, I can open up the forums no prob, but can't open the individual threads.  Just hangs.
Axis vs Allies Staff Member
☩ JG11 Sonderstaffel ☩
Flying 'Black[Death] 10' ☩JG11☩

Only the Proud, Only the Strong Ne Desit Virtus

Offline stodd

  • Gold Member
  • *****
  • Posts: 2355
Re: Stop board lag?
« Reply #27 on: December 01, 2009, 10:04:00 PM »
And I was going to say it was all the pig/muppet threads?. :D
Stodd/ CandyMan
I don't get why you even typed that, you know it's stupid.


Offline Gaidin

  • Silver Member
  • ****
  • Posts: 1191
Re: Stop board lag?
« Reply #28 on: December 02, 2009, 10:16:00 AM »
Boards can exhibit the same thing, but for very different reasons.  It can be resource related, out of balance parameters in MySQL, or any number of things related to hard disk usage.

In this case, it has to do with the InnoDB log files growing in too large of chunks.  I need to break them down into smaller chunks so updates are done more often, but with less impact to the boards performance.

Unfortunately, you cannot simply change those parameters on a live database.  The safest way (most paranoid) to accomplish it is to dump the databases to another server, perform the changes, then reload the databases.

What takes so long is the transfer of all the databases (tours, wiki, bulletin board).  In order to have an accurate roll back logs, you have to inject the data back into the databases.  If I was less paranoid, I would just copy the files over, but that would lose the ability to do any rollbacks on any of the databases from that point back.

TY for the response.  This information has been added to my problem/cause/solution DB.
Death is but a doorway to life, only those who fear life fear its opening.

Ingame: 68Gaidin

Proud Member of the CM Team
FSO - Admin