Archive for June, 2012

MySQL CPU maxing out due to leap second, and AWS US-E1 outage

Wow, US-EAST-1 has the worst luck doesn't it?I had CPU consumption alerts fire off for ALL of my AWS instances running Percona Server (MySQL).I couldn't for the life of me figure it out - I re-mounted all but the root EBS volumes, restarted the services and ensured there was no...
Read More

MySQL COALESCE(), UNION behavior on zerofilled columns

I've just filed a (potential) bug report, depending on your views for MySQL's COALESCE() behavior: http://bugs.mysql.com/bug.php?id=65763 If you have a zerofill column and perform the COALESCE() function on it, the leading zeros are truncated. As I mention in the bug report, this may not matter to most - but it does change the...
Read More

On MySQL: The latest, far-reaching password circumvention

By now, everyone has, or will be hearing about this issue. While it's an extremely simple hack and covers (dare I say the majority) of MySQL installation version. Let's not forget to finish reading the entire disclosure: From the disclosure: But practically it's better than it looks - many MySQL/MariaDB builds are not...
Read More

Note to self: Digest hashing and crytpological hashing are birds of a different feather

Over decades of enhancements in computer science, there's always a revolution going on in cryptography and hashing, MD5, SHA1 yesterday, SHA256/512 today.As a programmer, it's sometimes hard to avoid the back and forth talk about how algorithm A is inferior to algorithm B, and forget how hashing can be used...
Read More