My 2010 Blogging in Review
This is a graphic summary of the most commonly used words in my blog posts in 2010.
Speed up laptop boot & resume times with large MySQL databases
I’m in the interesting position of using my laptop for both programming work and day-to-day web surfing. I’m the lead developer for SAGrader, a web-based computationally intelligent essay grading system. We use MySQL for the database, and naturally I run a copy on my laptop to develop with. Unfortunately, MySQL and laptop power-saving goes together [...]
Reliable InnoDB hot backups
There are number of blog posts out there that mention –lock-all-tables as a good option to backup MySQL tables with mysqldump – even InnoDB tables. Don’t do that! That option is for MyISAM tables that don’t do transactions. InnoDB has ooey-gooey transactional goodness that will take a consistant backup without locking all your tables and [...]