Not the answer you need?
Register and ask your own question!

TokuDB "Insert Into Select Group By" too slow

kurnosemkurnosem EntrantCurrent User Role Beginner
I'm testing TokuDB because we are thinking to migrate the MyISAM tables to TokuDB.

But there are some queries like:
INSERT INTO Table(M, F, A, D, DC, S, S0)
SELECT
M,
@prmDatetime,
A,
D,
DC,
S,
S0
FROM other_table
group by M;
Is REALLY slow compared to MyISAM. I only found some posts about bulk-fetch that is supposed now should be fixed. I'm using tokudb_version=5.6.27-76.0

Any ideas?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.