ForumSpandex Party SiteSuggestions and site feedback

Site is experiencing a "hug of death"

Suggestions and site feedback
spandexpartyadmin
spandexpartyadmin
posted 3 months ago
Hey everyone, It's great to see the site continuing to grow! However, that growth also means some of our resources are starting to reach their limits. In this case, it's our database instance, which looks like it needs an upgrade to a larger one. While this "hug of death" is happening, I've temporarily disabled a few of the more intensive database queries overnight to prevent things from completely melting down. So tomorrow I'll be investigating and most likely moving our database to a more powerful (and unfortunately, more expensive 🥲) instance soon. Thanks for your understanding, and sorry for any inconvenience this might cause! Cheers, Simon
Last edited: 3 months ago

LycreyLycrey,LycraSteeLycraStee,spxbrlnspxbrln,ThongsandlycraThongsandlycra,WetspotsWetspots,KrovikanioKrovikanio,burbsl2580936burbsl2580936,cplethngcplethng,AAndrewsAAndrews,SxyolguySxyolguy,gearkinklovegearkinklove,lyjolyjo,SuperATSuperAT,GhostlyGhostly,the_crooked_thongthe_crooked_thong,MxmmxmMxmmxm,spandexhottiespandexhottie,bikeboy94bikeboy94,8eight88eight8,microluva1964microluva1964,nullbikernullbiker,lycradudeITlycradudeIT,lycsterlycster,James_LycraJames_Lycra,WhitespeedosWhitespeedos,CyclingboiiCyclingboii,UbiquitousUbiquitous,SpeedoLuvSVKSpeedoLuvSVK,bshortsbshorts,niceboyfsniceboyfs,ilikepecs246ilikepecs246,argon1argon1,MessyShinyLycraMessyShinyLycra,stringbody2015stringbody2015,Frenchy_LycraFrenchy_Lycra,Spandex25Spandex25,singlet_freaksinglet_freak liked this.

spxbrln
spxbrln
posted 3 months ago
I don't know if this is useful feedback, but today I noticed that all my messages (apart from the new ones) were gone, and that the notification button at the top was not showing any number anymore... But happy to hear that the site is getting more traffic ;-) Good luck with your investigation!

TightpantsxxTightpantsxx liked this.

spandexpartyadmin
spandexpartyadmin
posted 3 months ago
posted by: spxbrln
... I noticed that all my messages (apart from the new ones) were gone, and that the notification button at the top was not showing any number anymore...
Yes, notification and inbox queries are hot loads that I changed to let the server & database breathe a little. it will be back to normal by tomorrow (my experience told me not to do server surgeries in the evenings 😅)

SpandexSuckerSpandexSucker,wetlycraboywetlycraboy,spandexhottiespandexhottie,bikeboy94bikeboy94,8eight88eight8,spxbrlnspxbrln,cplethngcplethng,niceboyfsniceboyfs liked this.

pchimo
pchimo
posted 3 months ago
Thank you!

spandexpartyadminspandexpartyadmin,cplethngcplethng liked this.

spandexhottie
spandexhottie
posted 3 months ago
I'm a DBA if you need any help exSPANDing the database or migrating it ;)

DustinDustin,spandexpartyadminspandexpartyadmin,lyjolyjo,TightStuffTightStuff,singletdutch25singletdutch25,SpeedoLuvSVKSpeedoLuvSVK,argon1argon1,stringbody2015stringbody2015 liked this.

lycradudeIT
lycradudeIT
posted 3 months ago
...'and unfortunately, more expensive 🥲' ... Should be doable with some extra paying members. So guys get a premium membership if you can afford it and keep the site fast also for the ones that share fantastic pics but don't have the funds to contribute in money! 😘

lyjolyjo,spandexpartyadminspandexpartyadmin,ChrisjokerChrisjoker,lycsterlycster,cplethngcplethng,Nike80Nike80,stringbody2015stringbody2015,spandexnconversespandexnconverse liked this.

spandexpartyadmin
spandexpartyadmin
posted 3 months ago
POST MORTEN in this screenshot you can see the "hug of death" more clearly. it doesn't mean we got 25x more traffic than usual. it means that the database instance was running on 100%, and everything above that will cause a small wait time for the next database request. this accumulates, until you get to a pile of requests that is never decreasing, but increasing slightly. NOW THE GOOD NEWS I completed the resource upgrade of the database instance. I can see it's now sailing incredibly smoothly. on top I will try to optimise the hard hitter queries to the database, to give the poor instance a bit time to breathe. ✅
Log-in to view
Last edited: 3 months ago

FloridaSpandexJockFloridaSpandexJock,TightpantsxxTightpantsxx,SpeedoLuvSVKSpeedoLuvSVK,pumpingmonkeypumpingmonkey,lycradudeITlycradudeIT,spxbrlnspxbrln,bshortsbshorts,InukiInuki,LycraSneakerPPLycraSneakerPP,argon1argon1,pchimopchimo,stringbody2015stringbody2015,speedo_lovrspeedo_lovr,spandexhottiespandexhottie liked this.

FloridaSpandexJock
FloridaSpandexJock
posted 3 months ago
Thank goodness you know what you're doing....   Technology is not my friend.. lol Thanks for all you do for keeping us up and running.

spandexpartyadminspandexpartyadmin,MaxthongMaxthong,argon1argon1,miaswimmiaswim liked this.

spandexpartyadmin
spandexpartyadmin
posted 2 weeks ago
Hey, me again in this thread 💧 sorry yall for the brief downtime of ~1.5h yesterday.  the server instance, that you could say is the webserver, got hugged to its limits. last time a "hug of death" happened was on the database instance side. on one side it makes it makes the bill more expensive. but on the other side it means that we're doing great and get a healthy influx of new, interested lycra users. let's go! I replaced the old webserver instance with a more powerful one. now we have all instances buffed up to withstand a lot of incoming traffic.
Last edited: 2 weeks ago

cplethngcplethng,MarkUKMarkUK,James_LycraJames_Lycra,InukiInuki,WhitespeedosWhitespeedos,Joe9012245688Joe9012245688,ColbertlittleColbertlittle,LycraSneakerPPLycraSneakerPP,BiguylovesgearBiguylovesgear,petempetem,ilikepecs246ilikepecs246,AdidasRunAdidasRun,SuperJockSuperJock,nb75nb75,rubzzzrubzzz,twlltwll,LycrafavLycrafav,Smokinz14Smokinz14,SpandexnCASpandexnCA,LaxtexLaxtex,TightStuffTightStuff,SwimcycleSwimcycle,notsurerunotsureru,TnglvrTnglvr,Swimmer2004Swimmer2004,Aleks_plAleks_pl,argon1argon1,8eight88eight8,biglad_cjbiglad_cj,Lovevelo35Lovevelo35,SxyolguySxyolguy,darmontdarmont,pchimopchimo,burbsl2580936burbsl2580936,spencerkaynespencerkayne,MaxthongMaxthong,miaswimmiaswim,bulge_loverbulge_lover,FloridaSpandexJockFloridaSpandexJock,TightpantsxxTightpantsxx,speedo_lovrspeedo_lovr,lycsterlycster,actionmanactionman,spandexhottiespandexhottie,Frenchy_LycraFrenchy_Lycra,Spandex25Spandex25,Joe182021Joe182021 liked this.

argon1
argon1
posted 2 weeks ago
Thanks for all you do to keep the site running Now I'm thinking of being hugged "to my limits" in spandex...

8eight88eight8,MaxthongMaxthong,spandexpartyadminspandexpartyadmin,spandexhottiespandexhottie liked this.

speedo_lovr
speedo_lovr
posted 2 weeks ago
We all appreciate what you do to keep things going ❤️. Keeping things running smoothly in the IT world is often a thankless job...I know from experience.

spandexhottiespandexhottie,spandexpartyadminspandexpartyadmin,argon1argon1 liked this.

spandexhottie
spandexhottie
posted 2 weeks ago
Me too
spandexhottie
spandexhottie
posted 2 weeks ago
posted by: spandexpartyadmin
Hey, me again in this thread 💧 sorry yall for the brief downtime of ~1.5h yesterday.  the server instance, that you could say is the webserver, got hugged to its limits. last time a "hug of death" happened was on the database instance side. on one side it makes it makes the bill more expensive. but on the other side it means that we're doing great and get a healthy influx of new, interested lycra users. let's go! I replaced the old webserver instance with a more powerful one. now we have all instances buffed up to withstand a lot of incoming traffic.
I love that you’re an IT nerd and into spandex. Two great traits 😊😍😍

spandexpartyadminspandexpartyadmin,argon1argon1 liked this.