dtraCorp crashes dreamhost!!
7th-apr-2008 - posted by dtra
so i got an email this morning from dreamhost saying that a query in my database has been causing extreme load on the mysql server. i was wondering my site was so unresponsive 
, it turns out that my timezone checking query (which uses an 800 000 record table, and up to reads up to and over 600 000 records to ascertain your location) was causing the issue. i tested running the query, the guy sent me, and indeed, it took seven seconds to run. i wasn't too happy though, they basically disabled the table, and my site was inaccessible overnight.
had to do some rush job to fix it up this morning temporarily, and have since updated it so now all users will see the times in australian est and not the local time. unfortunately, i don't see a way around it, other than making the country to ip table really small, and pretty much saying everyone is from america, so wat eva, i pay $10 bux a month, i can't expect it all i guess.
i took this picture yesterday of an oil lamp my dad got, taken as a raw in-camera, and processed it as a jpeg in-camera, some slight rotation and resizing with the gimp. i can't think of how it is relevant to this post, but just wanted to post the picture somewhere.
#33 dtra (david tran)
Last edited at 7:50 7th-apr-2008
tags/bookmarks
notes
no notes for this item