MySQLTuner v1.3.0

It’s been three long years since the last MySQLTuner release but you’ll now find version 1.3.0 available on GitHub. You can get it from the git repository or via these extremely simple methods: wget -O mysqltuner.pl mysqltuner.pl wget –trust-server-names mysqltuner.pl There are a bunch of new features and fixes that you can find in the list of commits from today (2014-02-21). Some of the bigger adjustments include: Basic support for MariaDB 10.
Read more →

Survive the Google Reader exodus with Tiny Tiny RSS

It’s no secret that Google Reader is a popular way to keep up with your RSS feeds, but it’s getting shelved later this year. Most folks suggested Feedly as a replacement but I found the UI quite clunky in a browser and on Android devices. Then someone suggested Tiny Tiny RSS. I couldn’t learn more about it on the day Google Reader’s shutdown was announced because the site was slammed. In a nutshell, Tiny Tiny RSS is a well-written web UI for managing feeds and a handy API for using it with mobile applications.
Read more →

mysql-json-bridge: a simple JSON API for MySQL

My quest to get better at Python led me to create a new project on GitHub. It’s called mysql-json-bridge and it’s ready for you to use. Why do we need a JSON API for MySQL? The real need sprang from a situation I was facing daily at Rackspace. We have a lot of production and pre-production environments which are in flux but we need a way to query data from various MySQL servers for multiple purposes.
Read more →

MySQLTuner mentioned at the O’Reilly MySQL Conference

If you push play, the video should scoot out to about the 14m40s mark where MySQLTuner appears on one of the slides. Thanks to Trent Hornibrook for letting me know!
Read more →

Monitor MySQL restore progress with pv

The pv command is one that I really enjoy using but it’s also one that I often forget about. You can’t get a much more concise definition of what pv does than this one: pv allows a user to see the progress of data through a pipeline, by giving information such as time elapsed, percentage completed (with progress bar), current throughput rate, total data transferred, and ETA. The usage certainly isn’t complicated:
Read more →