Using MySQL sandbox for testing
MySQL Sandbox is a great tool for quickly deploying test MySQL instances, particularly if your daily work involves diagnosing problems across multiple MySQL versions. Once you’ve downloaded it, it needs no installation. Just have a few MySQL binary releases at hand, and begin creating sandboxes in just a few seconds: ./make_sandbox mysql-5.0.77-linux-x86_64-glibc23.tar.gz or ./make_sandbox mysql-5.1.32-linux-x86_64-glibc23.tar.gz [...]
Using the ENUM data type to increase performance
While going through the DATA TYPES section of the Certification Study Guide, I was refreshed of the ENUM datatype, which I rarely use.
I usually create individual tables for enumerations, so that new values can be added with just an insert, or deprecated values can be marked as such.
However, today I got to think about the performance issues involved in all that joining, and how could an ENUM column improve a select.
MySQL Certification self study
I’m taking the MySQL Certification exams soon, and while I’d love to take advantage of official training, the closest classes near me will be in Buenos Aires (just a few hundred kilometers and an estuary away) in over a month, and I hope to be done with the Developer exams by then. So I’ll be [...]