GabrielBailey74
|
 |
«
Posted
2012-01-10 00:23:25 » |
|
Looked like some MySql issues  |
|
|
|
Riven
|
|
«
Reply #1 - Posted
2012-01-10 00:35:52 » |
|
RAM usage of Apache was spiraling out of control (cause unknown as of yet). Eventually filled swap space and processes started grinding to a halt. Looked like some MySql issues You base that on...? |
|
|
|
|
teletubo
|
|
«
Reply #2 - Posted
2012-01-10 00:39:55 » |
|
RAM usage of Apache was spiraling out of control (cause unknown as of yet). Eventually filled swap space and processes started grinding to a halt. Looked like some MySql issues You base that on...? probably because that was the error message appearing: http://www.simplemachines.org/community/index.php?topic=358129.0 |
|
|
|
Games published by our own members! Check 'em out!
|
|
|
GabrielBailey74
|
|
«
Reply #3 - Posted
2012-01-10 00:42:19 » |
|
I based that on when I typed in this url...
It displayed a bunch of MySql dumps with errors.
FloodLog, some other stoofs.
About 7+ lines of errors, just letting em know.
|
|
|
|
|
Riven
|
|
«
Reply #4 - Posted
2012-01-10 01:22:55 » |
|
Thanks GabrielBailey74. Using your IP I could find the SQL warnings in the logs. They simply meant that there was no connection to MySQL, every time I made a call to mysql_query. Sloppy programming on my part, I should have terminated the code when no connection was established. Fixed that.
I investigated further, and have not noticed any faul play in the logs. There were a bunch of IPs bruteforcing HTTP requests (>100/sec), resulting in flooding the RAM by Apache, causing MySQL not to be able to allocate RAM for a new inbound connection.
|
|
|
|
|
GabrielBailey74
|
|
«
Reply #5 - Posted
2012-01-10 01:37:01 » |
|
Ah, thanks for explaining mate,  . |
|
|
|
|
ShannonSmith
|
|
«
Reply #6 - Posted
2012-01-10 05:26:30 » |
|
We are so lucky to have Riven, I doubt a full time IT department could accomplish half of what he does. Given how much care he takes with security it does make me wonder what percentage of forums out there aren't so lucky and have been (and remain) totally hacked (as was java-gaming before Riven was on the case).
|
|
|
|
|
|
theagentd
|
|
«
Reply #7 - Posted
2012-01-10 06:10:12 » |
|
We are so lucky to have Riven, I doubt a full time IT department could accomplish half of what he does. Given how much care he takes with security it does make me wonder what percentage of forums out there aren't so lucky and have been (and remain) totally hacked (as was java-gaming before Riven was on the case).
Jesus Christ, indeed. "OMG THE SITE WAS DOWN FOR A FEW MINUTES!!!1" <within 2 hours> "X overloaded Y which caused Z. I've updated the code to better handle this." If all programmers were like Riven, Java would be faster than C. >_> |
Myomyomyo.
|
|
|
|
|
|
GabrielBailey74
|
|
«
Reply #9 - Posted
2012-01-10 07:29:38 » |
|
Oo, that you mate?
|
|
|
|
Games published by our own members! Check 'em out!
|
|
|
Riven
|
|
«
Reply #10 - Posted
2012-01-10 07:53:22 » |
|
No, but those are my gloves.
|
|
|
|
|
theagentd
|
|
«
Reply #11 - Posted
2012-01-10 08:22:08 » |
|
No, but those are my gloves.
Lol.  |
Myomyomyo.
|
|
|
|
pitbuller
|
|
«
Reply #12 - Posted
2012-01-10 11:02:12 » |
|
|
|
|
|
|
|
CommanderKeith
|
|
«
Reply #13 - Posted
2012-01-10 16:57:21 » |
|
Yes this forum has been a spam free harmonious utopia over the last year or so
|
|
|
|
|
theagentd
|
|
«
Reply #14 - Posted
2012-01-10 17:01:50 » |
|
Yes this forum has been a spam free harmonious utopia over the last year or so
Quoted for truth. It's so tidy and nice you don't even notice that this forum is on the same Internet as Facebook, 4chan, e.t.c. |
Myomyomyo.
|
|
|
|
teletubo
|
|
«
Reply #15 - Posted
2012-01-10 18:06:42 » |
|
Riven, will you marry me ?
|
|
|
|
|
ra4king
|
|
«
Reply #16 - Posted
2012-01-10 18:25:43 » |
|
Wait....JGO is on the same internet as Facebook and 4Chan?!? WTF?!?
|
|
|
|
|
Riven
|
|
«
Reply #17 - Posted
2012-01-10 18:30:03 » |
|
Yes this forum has been a spam free harmonious utopia over the last year or so
I hope you guys are enjoying this walled garden. It's too late to fight back. Smell the flowers. |
|
|
|
|
sproingie
|
|
«
Reply #18 - Posted
2012-01-10 18:42:50 » |
|
|
|
|
|
|
|
theagentd
|
|
«
Reply #19 - Posted
2012-01-10 20:16:08 » |
|
Yes this forum has been a spam free harmonious utopia over the last year or so
I hope you guys are enjoying this walled garden. It's too late to fight back. Smell the flowers. Just be sure to hide the apple tree. Also, make a flower with the smell of anime please, Riven-sama! |
Myomyomyo.
|
|
|
|
Riven
|
|
«
Reply #20 - Posted
2012-01-11 11:39:58 » |
|
As some of you may remember, September 6th 1993, the Vault has been teleported in. Since then the vault has survived mostly freaks of nature. Its reign was ultimately ended by the third asian guy that touched it. After it was recovered from the wasteland barely six years later, it was voted to be on display in a local museum. I stole it. The rest is history. Every saturday I visit the garden, poke the vault with a stick. No results as of yet. For those of you with the mental capability of solving this riddle, this is engraved on the top: I mean, seriously, three dots? I'm really frustrated. |
|
|
|
|
theagentd
|
|
«
Reply #21 - Posted
2012-01-11 12:34:27 » |
|
I have no idea what you're talking about, Riven...
|
Myomyomyo.
|
|
|
|
ra4king
|
|
«
Reply #22 - Posted
2012-01-11 13:28:22 » |
|
I'm scared.....
|
|
|
|
|
jojoh
|
|
«
Reply #23 - Posted
2012-01-11 15:22:39 » |
|
Ehhh... It seems like this this walled garden utopia might have some magic mushrooms in it... |
|
|
|
|
ShannonSmith
|
|
«
Reply #24 - Posted
2012-01-13 06:48:08 » |
|
As some of you may remember, September 6th 1993, the Vault has been teleported in. Since then the vault has survived mostly freaks of nature. Its reign was ultimately ended by the third asian guy that touched it. After it was recovered from the wasteland barely six years later, it was voted to be on display in a local museum. I stole it. The rest is history. Every saturday I visit the garden, poke the vault with a stick. No results as of yet. For those of you with the mental capability of solving this riddle, this is engraved on the top: I mean, seriously, three dots? I'm really frustrated. Looks like no one has the mental capability, any hints for the lesser intellects. |
|
|
|
|
|
Riven
|
|
«
Reply #25 - Posted
2012-01-13 07:48:55 » |
|
The dots are not connected.
|
|
|
|
|
cylab
|
|
«
Reply #26 - Posted
2012-01-13 11:05:00 » |
|
The dots are not connected.
ROFLMAO |
Mathias - I Know What [you] Did Last Summer!
|
|
|
|
