# TokuDB "Insert Into Select Group By" too slow

**URL:** https://forums.percona.com/t/tokudb-insert-into-select-group-by-too-slow/4581
**Category:** Other MySQL® Questions
**Created:** [December 8, 2015, 7:03pm UTC](https://forums.percona.com/t/tokudb-insert-into-select-group-by-too-slow/4581 "2015-12-08T19:03:32Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![kurnosem](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kurnosem/32/1101_2.png) [@kurnosem](https://forums.percona.com/u/kurnosem)
#### Post date: [December 8, 2015, 7:03pm UTC](https://forums.percona.com/t/tokudb-insert-into-select-group-by-too-slow/4581/1 "2015-12-08T19:03:32Z")

</div>

I’m testing TokuDB because we are thinking to migrate the MyISAM tables to TokuDB.

But there are some queries like:

```auto

INSERT INTO Table(M, F, A, D, DC, S, S0)
SELECT
M,
&#64;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?