Welcome to Gaia! :: View User's Journal | Gaia Journals

 
 

View User's Journal

Lanzer's Journal
Another emergency
Despite having increase the performance of the database access code, the site still came across performance issue a few days ago. In general many Gaians have large inventories which can be taxing on the database, but what came across as particularly bad as a problem turned out to be related to how things are cached.

When data is retrieved from the database, we store the info in memory so that we don’t have to ask the database the same question over and over again. Most cache last for about 10 to 30 minutes, then the cache expires, and we query the database again (with exceptions). What ended up happening is that right when the cache expires, there happen to be many people access the same web page (in this case, the store), and if 50 people access that page, we query the database 50 times with the same request. Now the database is running slower, and next came another 50 people, asking the same question. Before you know it, the database is bogged down with 100 identical requests.

What I needed to do was to write a new caching layer which detect when a cache is about to expire, then before it expires, ask one user to fetch the information, and refresh the memory with the new data. This way we will never have more than one identical request happening, and the cache technically never expires and causes slowdowns.

Hopefully we won’t come across another performance issue in the near future. But I’m sure there will be another emergency right around the corner!

While I’m here, I should make a note of the recent bug fixes:


  • Guild vice captains can now leave the guild on their own accord
  • Private messaging flood control fixed
  • Android app now back in the Google Play store, GCash payment finally fixed
  • Convention page is back
  • Captcha on journal commenting is fixed
  • Boku payment exploit fixed


I’ve been busy spending the rest of my time writing new inventory backend to support additional storage containers. Soon you can have many different folders or containers to organize your inventory with. Sorting and filtering options will soon follow.

Lionheart is finally finished with the economy project! Still lots of bugs to fix as we test the feature, hopefully we can have it released in two weeks!






User Comments: [19]
OtakuKat
Community Member





Mon Jul 03, 2017 @ 05:52am


Thanks for all your hard work! 3nodding


Akabi Yoru
Community Member





Mon Jul 03, 2017 @ 05:58am


Very few people realize all the hard work you guys do. Thank you so much for all your effort, I love what you're doing with the place!


Sianserais
Community Member





Mon Jul 03, 2017 @ 06:19am


Can't wait to see how the new inventory organization will work!
Thank you for all the effort you're putting into this. ^_^


Viktuuri Kiss
Community Member





Mon Jul 03, 2017 @ 06:22am


so looking forward to the inventory management features! sounds great
thank you so much for all your hard work! heart


-Totalanimefan-
Community Member





Mon Jul 03, 2017 @ 06:42am


I'm excited to see the economy project! I hope that feedback from the economy thread was taken into consideration. (Not all of it though because some of the things people said would have been bad for the site lol)


baby_kitty_258
Community Member





Mon Jul 03, 2017 @ 10:20am


ty. can't wait to organize and file inventory items. 3nodding 3nodding you are all so amazing! heart


Whorey Dorey
Community Member





Mon Jul 03, 2017 @ 11:05am


Thank you for all that you do for us as always heart


Anamosa Valentine
Community Member





Mon Jul 03, 2017 @ 05:04pm


Thank you for all your hard work, Lanzer!


Dogoda
Community Member





Mon Jul 03, 2017 @ 11:14pm


Thank you for fixing the Google Cash payment option for cash! That was my main way of buying cash since I don't like using my debit card online.


Castiel Lover
Community Member





Tue Jul 04, 2017 @ 01:28am


Thanks for the hard work!
Letting you know that the wishlist check marks still do not show without sparkles turned on.


Roronoa Churro
Community Member





Tue Jul 04, 2017 @ 03:15am


Not trying to sound rude or something, because all of us are thankful for all your hardwork, but will there ever be some update to the iOS app? xp xp xd


water_spirit
Community Member





Tue Jul 04, 2017 @ 06:51am


Seriously so happy about the inventory updates.


demonic_angelkynd1
Community Member





Tue Jul 04, 2017 @ 01:08pm


is there going to be a summer event this year? if yes, are they going to announce them soon?


Logician Extraordinaire
Community Member





Sat Jul 08, 2017 @ 08:54am


What's the name of the new app? I know there is the Gaia on the Go 2014 - but if you've updated it, it must have a new name? ^^ (or is it still coming out in Fall 2017?)


Mus1ccure
Community Member





Sun Jul 09, 2017 @ 08:15am


thanks so much Lanzer 3nodding


User Image
User Image
click to play.
SilentSpace
Community Member





Mon Jul 10, 2017 @ 02:11pm


#GoGaia


Synapt
Community Member





Mon Jul 10, 2017 @ 09:31pm


Doubt I'll get a reply of any sort whatsoever but;

This sounds frighteningly like the same caching implementation you guys had in for years and years now. Any particular reason attempts have not been made to move to an external native caching mechanism that would handle the stale cache expiry more appropriately instead of trying to write one in PHP itself?


DarkRybrin
Community Member





Wed Jul 12, 2017 @ 12:11pm


Thank you so much for all of your hard work! Your bug-fix list is always such a joy to see.


Castiel Lover
Community Member





Thu Jul 13, 2017 @ 03:35am


Another check in. Wishlist checkmarks still don't show up without sparkles turned on.


User Comments: [19]
 
 
Manage Your Items
Other Stuff
Get GCash
Offers
Get Items
More Items
Where Everyone Hangs Out
Other Community Areas
Virtual Spaces
Fun Stuff
Gaia's Games
Play with GCash
Play with Platinum

Customize your own avatar now!

Join Now

Have an account? Login Now!