anxiety, sleepless nights, worry and self-doubt if i can even do this or am the right person. talk about exposure therapy…..
as you see from the graph, we peaked at 6900% (haha) the usual users we normally got on moshi online.
this caused our poor server that was only configured to handle 50 users to lag and some cases crash. the issue?
mariadb…… taking up all the cpu usage and i tried every configuration i could. so, i upgraded the server. it helped the GPU issue but the loading times whenever a request to get information from our database?
no…difference….. for the type of server that was upgraded too as we now understood that this project had a future due to an endorsement from mind candy
it still took 10 seconds to up a minute to load your room, pinboard, friends and other things
this was not a good look for us, i was told that it got so bad that people were saying “don’t play moshi online, it’s far too slow play moshi rewritten”. but days prior i have noticed that moshi rewritten ran butter smooth and i was theorizing why that was but no one told me directly yet, will get back to this later
first i tried taking some load off of ‘apache2’ to see if that made difference by switching our assets and cdn to use ‘nginx’ on a different server. yes, it did help because ‘nginx’ sends requests asynchronously and moshi online’s assets are served by http resulting in millions of requests daily
second i thought maybe try editing the php and sql configuration files, it made some sort of a difference only because i would purge everyone’s sessions in the database and make them relog. but it did not last long, because when i woke up, the site was unusable again!!
third i considered purging inactive users from our database ones that only played once and or are over 2 years old
but NONE of this made sense, i always figured something was terribly wrong with how i set something up, the loading issues with pinboards and friends has always been an issue since 2024
over the course of 2 years i have done backend code optimizations, by grouping SQL queries and so on, this was a temporarily fix for now but it didn’t address the main issue which i was unaware of at this time……..
LASTLY, i started looking into our sql schema….. redoing 41 tables was not fun but guess what??? it didn’t make a difference
i felt defeated, i considered ok it is probably backend code again but looking at it
what could be improved??? why can’t we handle just a few million rows???
was the LAMPP stack really this bad?
no…… it’s not…….. 86% of the web uses this stack so does moshi rewritten. i was in a late night call with sallyann and she was telling me how fast moshi rewritten was and had no issues. i was like that was our competitor and if they can do it, i can too so i began searching again and i saw there was 1 thing i have not tried
indexing……………. welp back to editing 41 tables!!! and i took it out of maintenance nervously, it worked…………. THE LAST THING I TRY…..
loading the rooms, pinboards, and friends tree? INSTANT!!!
you have to understand you send many http requests when you load the game + the assets but the ones that are highlighted here used to take up to 30 seconds 1 minute or more to load. if the site is still slow for you, it could be your internet connection or other reasons that are out of our control but we fixed the main issue…..
don’t give up loves, you got this <3