distal-attribute
distal-attribute
distal-attribute
distal-attribute

heidisql + tukudb : clustering indexes

User, date Message
Written by jujubre
1 year 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
1 year ago
4936 posts since Fri, 07 Apr 06
Does HeidiSQL even show the "tokudb" engine selection?
Written by jujubre
1 year 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
1 year ago
4936 posts since Fri, 07 Apr 06
Ok, that sounds as if that was doable.
Written by jujubre
1 year ago
5 posts since Mon, 18 Feb 13
cool :)
Written by ansgar
1 year ago
4936 posts since Fri, 07 Apr 06
Didn't knew there are TokuDB/HeidiSQL users out theresmileSo, thanks for feedback.
Written by jujubre
1 year 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.