|
Members in Shoutbox
None.
Shoutbox Search
Shoutbox Commands
/w [name] > Whisper
/r > Reply to last whisper /me > Marks as action Shoutbox Information
Moderators may delete any and all shouts at will.
|
Global Shoutbox
Please log in to shout.
[2017-5-09. : 1:00 am]  Ashamed -- Still took a bit for my shit to show up - Another good way to design shoutbox is to make Javascript on the local computer put the persons msg up and not wait for ajax to do a mysql lookup. You know what to display.. becuase they just wrote it.[2017-5-09. : 12:57 am]  O)FaRTy1billion[MM] -- how many tabs of the shoutbox should I leave open to make it work normally again?[2017-5-09. : 12:47 am] Moose -- Yeah. The shoutbox is loaded on every page and makes frequent queries, so if it's poorly optimized, then it kills things just by virtue of scale. So it's not going to fix everything, but fixing it definitely helped, I think.[2017-5-09. : 12:06 am] Moose -- Getting slow again. Guess someone is trying to use something that isn't the shoutbox, lel.[2017-5-09. : 12:02 am] Moose -- Indeed, but I can live with the criteria for "worst" being "kind of bad" instead of "DoS the site"[2017-5-08. : 11:59 pm] Suicidal Insanity -- Trust me, there always is a new worst part of the project.... it never ends[2017-5-08. : 11:57 pm] Moose -- All of the other shitty optimization will still kill us, but at least the shoutbox won't kill it anymore.[2017-5-08. : 11:57 pm] Suicidal Insanity -- ok.... "Some fancy color for your name? Devlin please give me proper descriptions! "[2017-5-08. : 11:56 pm] Moose -- Yeah. The high page number is static and determined on page load so that wasn't what was killing it anyway.[2017-5-08. : 11:56 pm] Suicidal Insanity -- Ok, so I can leave the shoutbox tab open without worrying about crashing the site  [2017-5-08. : 11:50 pm] Moose -- Mini Moose 2707Mini Moose 2707 shouted: Suicidal Insanity Suicidal Insanity It doesn't refresh the last page number, so it will become inaccurate over time instead. Furthermore, the query for non-deleted shouts that are public or whispered to you or whispered by you is the concatenated index now [2017-5-08. : 11:49 pm] Moose -- Suicidal InsanitySuicidal Insanity shouted: Does it slow down when I have the 'global shoutbox' page open... because it parses every single entry in the DB to figure out it has to print ' ... 2777' as the last page index? xD xD Suicidal InsanitySuicidal Insanity shouted: on every AJAX refresh It doesn't refresh the last page number, so it will become inaccurate over time instead.[2017-5-08. : 11:48 pm] Moose -- HOLY SHIT WE HAVEN'T HAD THIS MUCH CONVERSATION WITH MORE THAN FIVE PEOPLE ONLINE IN MONTHS[2017-5-08. : 11:47 pm] Suicidal Insanity -- Does it slow down when I have the 'global shoutbox' page open... because it parses every single entry in the DB to figure out it has to print ' ... 2777' as the last page index? xD xD[2017-5-08. : 11:47 pm] Moose -- AposApos shouted: It might be the case LOL I mean, it is loaded on every page ever, so I could see it clogging things up, especially with search bots spidering the site...[2017-5-08. : 11:47 pm] Moose -- Mini Moose 2707Mini Moose 2707 shouted: Suicidal Insanity Oh, it's structure only. And actually, the more recent versions of the structure and the production copy of that DB have the hashes and IP address columns removed.[2017-5-08. : 11:46 pm] Moose -- Suicidal InsanitySuicidal Insanity shouted: Mini Moose 2707 -- Suicidal Insanity <- SEN V4. The github page said something about a database dump, haven't taken a look at the contents yet Oh, it's structure only.[2017-5-08. : 11:46 pm] Moose -- What if it turns out the shoutbox was actually the culprit the entire time? LMAO[2017-5-08. : 11:46 pm] Suicidal Insanity -- Mini Moose 2707 -- Suicidal Insanity <- SEN V4. The github page said something about a database dump, haven't taken a look at the contents yet[2017-5-08. : 11:46 pm] Moose -- Hot damn, just went to some random page numbers of the shoutbox and didn't like ... die waiting.[2017-5-08. : 11:45 pm] Moose -- Though I made a nice concatenated index that should make loading the shouts faster.[2017-5-08. : 11:44 pm] Moose -- Yeah, but not really under load, we'll see how it goes as more clients connect.[2017-5-08. : 11:43 pm] Moose -- Also, using the primary key of shout id for order by clauses in a bunch of places instead of time, which wasn't even indexed SMH[2017-5-08. : 11:43 pm] *Apos now knows that*[2017-5-08. : 11:43 pm] *Apos didn't know that*[2017-5-08. : 11:42 pm] * lil-Inferno emotes*[2017-5-08. : 11:41 pm] *Moose optimized shoutbox slightly O_O*[2017-5-08. : 10:42 pm] Moose -- Mini Moose 2707Mini Moose 2707 shouted: "SELECT * FROM `shoutbox` WHERE sb_deleted NOT IN (0, 1)" MySQL returned an empty result set (i.e. zero rows). (Query took 0.0030 sec) <-- this is how you know this shit should be a boolean LMAO Boutta change it to a boolean live and see if that actually helps, anyone care about downtime at this point? LMAO. I really should make a maintenance mode that I just flick on and off and maybe even a scheduled maintenance window. Probably need those in the future anyway, for deploying updates and shit.[2017-5-08. : 10:39 pm]  DevliN -- jjf28jjf28 shouted: ohi DevliN; moose took ur job I've been doing little more than paying the bills for a long long time now, so fine with me.  [2017-5-08. : 10:37 pm] Moose -- jjf28jjf28 shouted: ohi DevliN; moose took ur job MOOSE GON GIVE IT TO YA, FUCK WAITIN FOR YOU TO GET IT ON YA OWN, MOOSE GON DELIVER TO YA |
Members Online: ihjel