Migrate Redis Keys Without RDB Files
Recently we moved the Transloadit status page from an unmanaged EC2 instance to the Nodejitsu platform. We kept status uptime history in redis, and obviously I wanted to preserve t...
database
A collection of 9 posts
Convert All Tables to InnoDB
Some time ago I was in the situation where I was looking at 200 MyISAM tables screaming to get converted to InnoDB for performance reasons. You probably know that MyISAM is better...
Redis PHP Introduction
Don't know Redis? Think Memcache, with support for for lists, and disk-based storage. You can use Redis as a database, queue, cache server or all of those combined. Let's see how y...
Access MySQL Without Password
If you want to do command-line MySQL administration like restoring databases or dumping statistics, you need the root account and it's password. Or do you?
Create Youtube-Like IDs With PHP/Python/Javascript/Java/SQL
IDs are often numbers. Unfortunately there are only 10 digits to work with, so if you have a lot of records, IDs tend to get very lengthy. For computers that's OK. But human beings...
Improve MySQL Insert Performance
Sometimes MySQL needs to work hard. I've been working on an import script that fires a lot of INSERTs. Normally our database server handles 1,000 inserts / sec. That wasn't enough....
Boost MySQL Performance by 1200%
Sorry folks, this article was based on flawed benchmark results, I will soon post an update!
The Pragmatic SQL Style Guide
Code spends more time being read then being written. I think naturally this is true for queries as well. So it might help if we teach ourselves some guidelines as how to nicely for...
How Virtualization Will Improve Your Code
Good testing will result in better code. If you have to wait endlessly for on SVN commits, uploads or compile steps, you will simply produce less inventive code. This has to do wit...