heidisql + tukudb : clustering indexes

[expired user #6807]'s profile image [expired user #6807] posted 11 years ago in Feature discussion Permalink
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
ansgar's profile image ansgar posted 11 years ago Permalink
Does HeidiSQL even show the "tokudb" engine selection?
[expired user #6807]'s profile image [expired user #6807] posted 11 years ago Permalink
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
ansgar's profile image ansgar posted 11 years ago Permalink
Ok, that sounds as if that was doable.
[expired user #6807]'s profile image [expired user #6807] posted 11 years ago Permalink
cool :)
ansgar's profile image ansgar posted 11 years ago Permalink
Didn't knew there are TokuDB/HeidiSQL users out theresmileSo, thanks for feedback.
[expired user #6807]'s profile image [expired user #6807] posted 11 years ago Permalink
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.