Archive for September, 2009
total mysql rows
Turns out our Mysql server at work is a little bigger than I thought:
Databases 75
Tables 1,549
Rows 1,018,085,348
However over the last couple of months, we’ve only averaged 130 queries/second
Hacked up PHP to gather stats:
class MysqlCounter
{
public function __construct($host, $username, $password)
{
$this->conn = mysql_connect($host, $username, $password, true);
[...]
No One Likes a Tattletale
DesuToys
WoW Combat Log Splitter
Something quick I whipped up last night, after noticing that after my log file was > 4GB the WorldOfLogs parser will no longer do real time logging.
Edit: Turns out that the WoW client itself stopped logging, even though the log file was a little over expected limit (4,334,806,196 bytes)
Note: The code is just a one [...]
hacked
Yep, I was hacked 5 days ago. Seems I’ve been part of some DOS attack (I forgot to record the IPs of who, and it was only ~60GB of traffic).
From what I can tell, it exploited an (old, now patched) hole in PHPMyAdmin that let you write PHP files with what ever content you [...]