Wishlist: TokuDB

Open yogurtnaturalny opened this issue 8 years ago • 2 comments

MariaDB 10.1 and Percona MySQL support TokuDB engine, any chance to add this/change from InnoDB? 99% of SQL query is "REPLACE" so changing storage engine will help with speed and take off a load from the server.

TokuDB Documentation

Jun 01 '17 12:06 yogurtnaturalny

Did you already tried to convert an actual database to tokudb? any impression on it?

Jun 04 '17 14:06 endelwar

Hello

Yes, however the problem is a TokuDB do not understand foreign keys so tables like mtalogs need to drop them. This will require to change a code how logs are push to database also adding php multithreading will help with this problem, however this might require that every change to database will ned to have a separate mysql connection so all CPU cores will be in use.

Jun 04 '17 14:06 yogurtnaturalny