heidisql + tukudb : clustering indexes
| User, date | Message |
|---|---|
|
Written by jujubre
3 months ago Category: Feature discussion 5 posts since Mon, 18 Feb 13 |
hello, I would like to propose the option to create clustered indexes with TokuDB engine. Here is the syntax : mysql> create table foo ( -> a int, -> b int, -> c int, -> primary key a_index (a), -> clustering key b_index (b)) -> engine = tokudb; Reference : http://www.tokutek.com/2009/05/introducing_multiple_clustering_indexes/ Thank you Jujubre |
|
Written by ansgar
3 months ago 3958 posts since Fri, 07 Apr 06 |
Does HeidiSQL even show the "tokudb" engine selection? |
|
Written by jujubre
3 months ago 5 posts since Mon, 18 Feb 13 |
Hello Anse, Yes, tokudb shows up in the engine selection. Heidisql even provide the 'T' icon in the session manager window. I am using the build 4321. Im fine with creating this type of index by hand, but if heidsql could handle it, it is a nice addition from my point of view. I love using it :) Jujubre |
|
Written by ansgar
3 months ago 3958 posts since Fri, 07 Apr 06 |
Ok, that sounds as if that was doable. |
|
Written by jujubre
3 months ago 5 posts since Mon, 18 Feb 13 |
cool :) |
|
Written by ansgar
3 months ago 3958 posts since Fri, 07 Apr 06 |
Didn't knew there are TokuDB/HeidiSQL users out there So, thanks for feedback.
|
|
Written by jujubre
3 months ago 5 posts since Mon, 18 Feb 13 |
I discover tokudb recently, and was a heidiSQL user for... a long time. If I can help with code or tokudb stuff, i would do it happily. I am a bioinformatician, and we are using it to keep SNPs organised. |
|
Please login to leave a reply, or register at first. |