Time flies when you're having fun
I didn't occur to me until this morning (my mind works in funny ways) that I have been running this weblog for over two years. The anniversary actually passed in July.
That's two years of mindless rambling, some silly rants and technical information nobody needs.. and all this fits in a 4.5MB MySQL database and 18MB worth of HTML pages. The MySQL apache log on the other hand is up to 1.2GB. What could one do with 1.5 years worth of apache logs (since March 2003) for a personal website?
That's 6,855,670 requests from 350,965 unique IPs (that query took 6min 15.30sec in case you're curious, no index).
Comments
If you have no use for them, why not setup a job to truncate the table once per week\month.
Runs fast and keeps your table nice and clean.
Posted by: pbw | September 10, 2004 10:32 AM
I remember the older design too..may you keep blogging for life.
Posted by: david | September 10, 2004 02:25 PM
Useless information?? I think not. And your ramblings have given me a smile many times. I'm no where near your level of geekiness, so I learn things here!
My 2 centavos
Posted by: packet-strangler | September 10, 2004 09:41 PM
I rotate my logs automatically.
Posted by: Larry | September 16, 2004 01:31 AM