Fun with ANALYZE TABLE
MySQL has been naughty for me lately. First, I ran into a neat little issue on FreshBooks’ production servers last week involving the table cache and an O(n) algorithm for selecting a table to close. I wrote up a little explanation over on the FreshBooks blog that you might find interesting if you find any […]
FreshBooks is hiring a sysadmin!
I’m not sure that I’ve got a lot of Toronto-local intermediate-level sysadmins reading here, but just in case, I’ve just posted a job posting for an Intermediate Linux System Administrator (SAGE level III) to our careers site. The details are all at the link, but basically we’re at the point where there’s enough to do […]
Toronto Bike Month
I just realized that tomorrow is the first day of Toronto Bike Month! There’s a list of events online. I didn’t get up in time for Bells on Bloor today, but there’s a bunch of things coming up that i’m looking forward to. I can’t participate in the opening pancake breakfast at Nathan Phillips Square […]
In other news, I’ve got my bike out again. Toronto’s going to be a much better city than Ottawa for bike-as-transportation, except that the elevation profile for my ride from home to work looks like this: feet elev. miles Unfortunate, especially since there are no showers at work. I might end up taking the bus […]
Fun with DHCP
I rolled out a new firewall/DNS server/DHCP server at FreshBooks today. Went well except for one problem: occasionally people would lose DNS resolution. Well, that’s not good. Checking out their machines showed that their DNS server addresses were being changed to an address on the wrong subnet, and their domain being changed to “mshome.net”. That […]
Rogers Portable Internet
At FreshBooks, Internet access is pretty critical to day-to-day operations. In fact, there’s basically nothing we do that doesn’t require it. But we’re not big enough and don’t transfer enough to bother with, say, an E10 or multiple T1s. So we’re on Bell business ADSL, which with a bit of traffic shaping is fast enough. […]
Yay, I’ve got DSL now…
Yay, I’ve got DSL now at the new apartment. I ended up going with Teksavvy, which was a bit of a roller coaster to order — they mistranscribed my credit card number, phone number, and mailed my DSL modem to “First Books”, and then the Bell tech showed up today at the wrong house number, […]
Fame is fleeting.
I’m on the FreshBooks staff page now — I guess they’re keeping me!