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]
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!

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

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)

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!

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

Community Member

Tue Jul 04, 2017 @ 06:51am

Seriously so happy about the inventory updates.

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?

logic mom
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?)

Community Member

Sun Jul 09, 2017 @ 08:15am

thanks so much Lanzer 3nodding

User Image
User Image
click to play.
Cheryll Blossom
Community Member

Mon Jul 10, 2017 @ 02:11pm


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?

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
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!