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);
    [...]

Posted by Matthew on September 9th, 2009

Filed under mysql, php, programming | No Comments »

No One Likes a Tattletale

DesuToys

Posted by Matthew on September 5th, 2009

Filed under Uncategorized | 1 Comment »

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 [...]

Posted by Matthew on September 4th, 2009

Filed under games, programming, python | No Comments »

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 [...]

Posted by Matthew on September 1st, 2009

Filed under Uncategorized | 2 Comments »