MySQL and MariaDB innodb_file_per_table

For those of you pushing your MySQL instances to higher levels, you’ll have realized at some point that all InnoDB tables share their indexing space into a single file (ibdata1, usually). This has several very bad outcomes: the ibdata1 file…

More Details
gem install mysql2 on Debian Wheezy with MariaDB 10

Just in case you would be in this situation (and given the fact I couldn’t find online information about it), if you are ever installing the mysql2 gem on a Debian Wheezy system with MariaDB 10 (I would guess a…

More Details
Profiling MySQL/MariaDB queries

If you ever face an optimization issue in MySQL or MariaDB and want to know how to measure/benchmark the differences in execution between two queries, you should definitely know about the set profiling=1; command. Here is how it works: mysql>…

More Details
Important meetings

Sometimes I like to treat this blog as a personal one and write down things that might affect in fundamental ways our future… or at least my own future, potentially. Anyway, I’m currently living in Peru and had a series…

More Details

Quick Contact Form