Author Topic: Site Maintenance  (Read 4227 times)

Offline Pumpkin

  • Hero Member Mark III
  • *****
  • Posts: 1,194
  • Neinzul Gardener Enclave
Re: Site Maintenance
« Reply #30 on: May 25, 2015, 09:40:51 AM »
The wiki text table is about 2.0 GiB and Mantis's file table is about 4.3GiB.
I love seeing the innards of all this. We could do some funny facts lists, like the total number of suggestions on Mantis, the number of character in the Wiki, the number of posts in the Forum...

Quote from: The Forum
156,525 Posts in 10,301 Topics by 18,007 Members.
Holly... forum!


And yeah: good luck. Seems like you need it.
Please excuse my english: I'm not a native speaker. Don't hesitate to correct me.
Pumpkin>> Do I need another cure about paranoia on top of overexcitement?
Mal>> We play AI War, enthusiasm and paranoia are both required!

Offline Mánagarmr

  • Core Member Mark V
  • *****
  • Posts: 4,254
  • if (isInRange(target)) { kill(target); }
Re: Site Maintenance
« Reply #31 on: May 25, 2015, 10:31:18 AM »
Is it just me or is the page significantly slower these days?
Click here to get started with Mantis for Suggestions and Bug Reports.

Thank you for contributing to making the game better!

Offline Dominus Arbitrationis

  • Arcen Games Contractor
  • Administrator
  • Sr. Member Mark III
  • *****
  • Posts: 443
Re: Site Maintenance
« Reply #32 on: May 25, 2015, 10:48:07 AM »
Good luck with ironing out the issues! :)

All issues should be ironed out now! The only thing left is performance-enhancing stuff and a little bit of infrastructure that you guys really won't notice.

I love seeing the innards of all this. We could do some funny facts lists, like the total number of suggestions on Mantis, the number of character in the Wiki, the number of posts in the Forum...

There are currently about 16835 reports in Mantis, the number of characters on the Wiki is impossible to store, it actually overflows the max integer value, and you found the number of posts in the forum! If you want more innards of the wiki you can look at Special:Statistics which is automatically updated a ton. Make sure to sign in to view the most recent stuff though! For Mantis you can see the date when each issue is resolved/closed at the Change Log. :)

Is it just me or is the page significantly slower these days?

Its slower for you? Hmm... that might actually be a location thing then. The server is in Michigan, USA rather than spread out across the world. Although, in theory, Cloudflare should be giving you really good results still. I'll definitely look into speeding it up for you though!
Come help out at the Wiki!

Have ideas or bug reports for one of Arcen's games or any part of the site? Use  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games and site better!

Offline Draco18s

  • Resident Velociraptor
  • Core Member Mark IV
  • *****
  • Posts: 3,925
Re: Site Maintenance
« Reply #33 on: May 25, 2015, 11:02:54 AM »
There are currently about 16835 reports in Mantis, the number of characters on the Wiki is impossible to store, it actually overflows the max integer value, and you found the number of posts in the forum!

Number of characters = [number of gigabytes of text data] * [size of a gigabyte in bytes]

;)

Offline Dominus Arbitrationis

  • Arcen Games Contractor
  • Administrator
  • Sr. Member Mark III
  • *****
  • Posts: 443
Re: Site Maintenance
« Reply #34 on: May 25, 2015, 11:05:47 AM »
Number of characters = [number of gigabytes of text data] * [size of a gigabyte in bytes]

;)

Heh, that would work. Wouldn't be perfect, but relatively close. There are other tables and other bits of data in each table that add to the size :P
Come help out at the Wiki!

Have ideas or bug reports for one of Arcen's games or any part of the site? Use  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games and site better!

Offline Draco18s

  • Resident Velociraptor
  • Core Member Mark IV
  • *****
  • Posts: 3,925
Re: Site Maintenance
« Reply #35 on: May 25, 2015, 11:14:22 AM »
Number of characters = [number of gigabytes of text data] * [size of a gigabyte in bytes]

;)

Heh, that would work. Wouldn't be perfect, but relatively close. There are other tables and other bits of data in each table that add to the size :P

It's a good ballpark estimate and its not like the exact count is a useful number in any meaningful fashion anyway.  "Oh, I'm sorry, the number we were looking for was seventeen qaudrillion, four hundred and fifteen trillion, seventy five billion, two hundred and thirty nine million, seven thousand, and one."

Offline x4000

  • Chris Park, Arcen Games Founder and Lead Designer
  • Administrator
  • Zenith Council Member Mark III
  • *****
  • Posts: 30,699
Re: Site Maintenance
« Reply #36 on: May 25, 2015, 11:18:15 AM »
Mantis just went down for about 30 seconds, and the wiki is still acting incredibly slow right now.  Is this maintenance or...?
Have ideas or bug reports for one of our games?  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games better!

Offline Dominus Arbitrationis

  • Arcen Games Contractor
  • Administrator
  • Sr. Member Mark III
  • *****
  • Posts: 443
Re: Site Maintenance
« Reply #37 on: May 25, 2015, 11:19:55 AM »
That was an Apache restart to update the configuration stuff. Tell me if it stays slow though.
Come help out at the Wiki!

Have ideas or bug reports for one of Arcen's games or any part of the site? Use  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games and site better!

Offline x4000

  • Chris Park, Arcen Games Founder and Lead Designer
  • Administrator
  • Zenith Council Member Mark III
  • *****
  • Posts: 30,699
Re: Site Maintenance
« Reply #38 on: May 25, 2015, 12:15:42 PM »
Sorry, have been in mantis like crazy the past while and forgot to check back.  The wiki is still super slow.  It's on 60+ seconds and counting for one page refresh for me right now, although the prior one was 4 seconds.  Table locking contention, maybe?
Have ideas or bug reports for one of our games?  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games better!

Offline x4000

  • Chris Park, Arcen Games Founder and Lead Designer
  • Administrator
  • Zenith Council Member Mark III
  • *****
  • Posts: 30,699
Re: Site Maintenance
« Reply #39 on: May 25, 2015, 12:16:15 PM »
And then after hitting cancel and then refreshing again, it refreshed in 1 second.  So that's all over the place.
Have ideas or bug reports for one of our games?  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games better!

Offline Dominus Arbitrationis

  • Arcen Games Contractor
  • Administrator
  • Sr. Member Mark III
  • *****
  • Posts: 443
Re: Site Maintenance
« Reply #40 on: May 25, 2015, 12:47:37 PM »
The only thing I can think of to cause that would be table locking contention, but we don't have any MyISAM tables that would lock the whole table, only row-level locking is available. It might be a client thing, I know that my browser occasionally takes forever to load a page at one point but then loads the rest of that site extremely fast. When you were doing the page refresh, did you have ?action= in the URL?
Come help out at the Wiki!

Have ideas or bug reports for one of Arcen's games or any part of the site? Use  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games and site better!

Offline Mánagarmr

  • Core Member Mark V
  • *****
  • Posts: 4,254
  • if (isInRange(target)) { kill(target); }
Re: Site Maintenance
« Reply #41 on: May 25, 2015, 01:14:35 PM »
I'm in Sweden and loading a reply page takes ca 15 seconds. It never used to be that slow.
Click here to get started with Mantis for Suggestions and Bug Reports.

Thank you for contributing to making the game better!

Offline Dominus Arbitrationis

  • Arcen Games Contractor
  • Administrator
  • Sr. Member Mark III
  • *****
  • Posts: 443
Re: Site Maintenance
« Reply #42 on: May 25, 2015, 01:33:00 PM »
I'm in Sweden and loading a reply page takes ca 15 seconds. It never used to be that slow.

That is definitely unacceptable for the speed. Does it only happen on the forums, on certain forum actions, or is it site-wide? Also, what actions are you taking when it is slow?
Come help out at the Wiki!

Have ideas or bug reports for one of Arcen's games or any part of the site? Use  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games and site better!

Offline Mánagarmr

  • Core Member Mark V
  • *****
  • Posts: 4,254
  • if (isInRange(target)) { kill(target); }
Re: Site Maintenance
« Reply #43 on: May 25, 2015, 01:35:24 PM »
I'm in Sweden and loading a reply page takes ca 15 seconds. It never used to be that slow.

That is definitely unacceptable for the speed. Does it only happen on the forums, on certain forum actions, or is it site-wide? Also, what actions are you taking when it is slow?
It seems to be rather intermittent. I've had it happen twice now today, but right NOW when I replied to you both loading the forum and the reply page was snappy.
Click here to get started with Mantis for Suggestions and Bug Reports.

Thank you for contributing to making the game better!

Offline Dominus Arbitrationis

  • Arcen Games Contractor
  • Administrator
  • Sr. Member Mark III
  • *****
  • Posts: 443
Re: Site Maintenance
« Reply #44 on: May 25, 2015, 01:37:41 PM »
That suggests it is more of a database problem. I'll look into it and see if I can diagnose the speed issues. When it does happen, try to refresh and bypass the cache (The shortcut depends on your browser).
Come help out at the Wiki!

Have ideas or bug reports for one of Arcen's games or any part of the site? Use  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games and site better!