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 becomes huge after some time (we’ve seen it pass the 8GB bar) starting the MySQL […]
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 rather rare situation), you might get this error: # gem install mysql2 -v=0.3.11 Building native […]
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> set profiling=1; Query OK, 0 rows affected (0.00 sec) mysql> SELECT count(login_user_id) FROM stats.track_e_online WHERE […]
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 of meeting over the last two months with the new Electronical Government Office (ONGEI). Can’t […]
Recent comments