mailwatch / MailWatch

MailWatch for MailScanner is a web-based front-end to MailScanner
http://mailwatch.org/
GNU General Public License v2.0
117 stars 66 forks source link

Wishlist: TokuDB #827

Open yogurtnaturalny opened 7 years ago

yogurtnaturalny commented 7 years ago

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

endelwar commented 7 years ago

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

yogurtnaturalny commented 7 years ago

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.