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 quite slow when I have thousands tables in TokuDB. How slow? For example…
select * from information_schema.tables limit 1000; ... 1000 rows in set (18 min 31.93 sec)
This is very similar to what InnoDB faced a couple years back. InnoDB solved it by adding[Read more...]