While checking out the awesome TokuDB MySQL storage engine, I wanted to write a simple PHP script to convert my tables from InnoDB to TokuDB. Using mysqli as a connector, I ran the script and got the following error: mysqli::mysqli(): Headers and client library minor version mismatch…

Syntax Error on ALTER TABLE ROW_FORMAT=TOKUDB_LZMA The MariaDB 5.5.37 TokuDB 7.1.6 Users Guide lists under Chapter 3.5.1 "Changing a table's compression" the following MySQL command: alter table <table-name> row_format=<row-format> Where <row-format> is one of the following: tokudb_zlib: Compress using the zlib library, which provides mid-range compression and CPU utilization…

Migrating From MySQL to MariaDB Last night I tried something that felt a little daring at first: migrating from MySQL 5.5 to MariaDB 10 on a production server. Having read at length about the advantages of MariaDB and Percona in scaling at higher processor core counts and multiple concurrent database accesses, I wanted to try it out for myself…