EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL compression: Compressed and Uncompressed data size

 | October 10, 2014 |  Posted In: InnoDB, MySQL, Percona Server, TokuDB

MySQL has information_schema.tables that contain information such as “data_length” or “avg_row_length.” Documentation on this table however is quite poor, making an assumption that those fields are self explanatory – they are not when it comes to tables that employ compression. And this is where inconsistency is born. Lets take a look at the same table […]

Read More

TokuDB gotchas: slow INFORMATION_SCHEMA TABLES

 | July 9, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Cloud Tools, Percona Server, Percona Software, TokuDB

We are using Percona Server + TokuDB engine extensively in Percona Cloud Tools and getting real usage operational experience with this engine. So I want to share some findings we came across, in hope it may help someone in their work with TokuDB. So, one problem I faced is that SELECT * FROM INFORMATION_SCHEMA.TABLES is […]

Read More