High Performance MySQL: Optimization, Backups, Replication, Load Balancing & More (Advanced Tools and Techniques for Mysql Administrators)
Jeremy Zawodny Blog (Free subscription) | 16/11/2009
I'll be speaking Tuesday night at the San Francisco MySQL Meetup . Here's the blurb from the announcement: Jeremy Zawodny will talk about Craigslist's current use of MySQL, where it's painful, and how things are being re-architected to make the pains go away. This includes hardware changes, sphinx, redis, memcached, and some custom Perl work. Despite not living too far away from the SF MySQL Meetup...
Simon Willison's Weblog (Free subscription) | 09/11/2009
Fixing Poor MySQL Default Configuration Values . Some tips from Jeremy Zawodny on configuring MySQL for high traffic environments—he suggests skip-name-resolve, connect_timeout=20, thread_cache_size=not-zero, max_connect_errors=very-high-number, slave_net_timeout=30.
Jeremy Zawodny Blog (Free subscription) | 09/11/2009
I've recently been accumulating some MySQL configuration variables that have defaults which have proven to be problematic in a high-volume production environment. The thing they all have in common is a network blip or two can trigger some very undesirable behavior. max_connect_errors If a client is having trouble connecting to MySQL, the server will give up waiting after connect_timeout seconds and...
Planet Intertwingly (Free subscription) | 04/11/2009
Like Jeremy Zawodny, I’ve had persistent issues with Intel Video since the Jaunty release of Ubuntu. The short version is that the fancy effects that I eventually came to depend on stopped working after the Intrepid release of the distribution. Both Jaunty and Karmic include Intel video drivers – and I’ve tried every bleeding edge [...]
Jeremy Zawodny Blog (Free subscription) | 30/10/2009
If you use the Sphinx search engine and have been watching the development branch (0.9.10) and wondering when to upgrade, I'm here to tell you that "now" is a great time. As of r2037 , the last major issue I regularly saw has been fixed. The other big bug was fixed in r2031 . Late last week I began testing those fixes in a "burn-in" test I've developed that makes liberal use of...
Jeremy Zawodny Blog (Free subscription) | 22/10/2009
In The EU and MySQL , Tim Bray treads lightly on the topic of Oracle's pending ownership of MySQL if the Sun acquisition goes through. I left a comment on his post, but he's likely to be heavily moderating what appears there since he works for Sun. So here's what I posted on his blog. I haven't yet seen anyone explain what motivation Oracle has for pouring resources into MySQL, especially if it eats...
Beyond Search (Free subscription) | 20/10/2009
A happy quack to the reader who sent me a link to “NoSQL: Distributed and Scalable Non-Relational Database Systems”. I have mentioned the problems that petascale data flows create for traditional RDBMs systems. Jeremy Zawodny has gathered together a number of non-SQL databases and provided a comment about each in this Linux Magazine write up. [...]
Digital Media Minute (Free subscription) | 15/10/2009
Via linux-mag.com, here’s a good overview by Jeremy Zawodny of Consistent Hashing, a useful technique for horizontal scaling of services that will also give you protection against future growth and server failures.
Ryan Tomayko (Free subscription) | 13/10/2009
Jeremy Zawodny takes a look at the * is Unix thing and throws in some additional goodness: more on fork(2) , the benefits of copy-on-write, and atomic file operations. # | Discuss
Jeremy Zawodny Blog (Free subscription) | 12/10/2009
What's with all the lazy shopping carts? It seems that through the years, shopping carts have become progressively more lazy. Years ago, when a shopping cart was done with its duty, it had to find its way all the way back from your car to the store entrance--either just inside or just outside. But, apparently as the result of an aging population of shopping card, grocery store designers started scattering...
Paidcontent (Free subscription) | 09/10/2009
The Inside Word is a weekly feature that looks at compelling industry debates and discussions unfolding on the blogs of employees at digital-media companies. Blogger: Jeremy Zawodny Position: Zawodny was a tech evangelist at Yahoo ( NSDQ: YHOO )—and one of that company’s best- known employee bloggers—until he quit in June 2008. He now works as an engineer at Craigslist. Blog name:...
jr conlin's ink stained banana (Free subscription) | 08/10/2009
As is the case with a great many things of this nature, i blame Jeremy Zawodny. A few years ago, he decided for various reasons (possibly due to rising fuel costs and his love of flying) that he needed to reduce his bulk. He did so, quite successfully, and blogged about it which was picked up [...]
Jeremy Zawodny Blog (Free subscription) | 24/09/2009
Reading The Duct Tape Programmer really hit a nerve with me. If you code for a living (or part of your living), go read it. I sometimes get annoyed by Joel Spolsky's writing, but this time he hit the nail right on the head. I am by no means putting myself in the same league as Jamie Zawinski, but I definitely subscribe to the idea that keeping my code as simple as possible is going to pay big, big...
Jeremy Zawodny Blog (Free subscription) | 22/09/2009
Having not worked at Yahoo in a bit over a year, it's interesting, amusing, and frustrating to watch what's going on over there. Some of their moves confirm feelings I've had for some time, while others are more puzzling. The Search deal with Microsoft was basically inevitable. You could see even two years ago how out-gunned Yahoo was compared to Google and to what Microsoft was rumored to be thinking...
Jeremy Zawodny Blog (Free subscription) | 20/09/2009
I've had this low-level urge to try a new window manager for a few months now. I work on a Linux box (Ubuntu) daily and mostly run a number of terminals , GNU Emacs , Mozilla Firefox , and Google Chrome . Nothing too fancy, really. Oh, and a shitty VPN client. Background Most of the time I'm doing this in front of a 24" (or larger) monitor running at 1920x1200, so there's a lot of screen real...
Videos