Re: [Maria-developers] GSoC 2016: Unique indexes for blobs

2016-04-27 Thread Sergei Golubchik
Hi, Shubham! On Apr 27, Shubham Barai wrote: > Hi Sergei, > > I was trying to debug mysqld using gdb.I used full backtrace option but I > didn't get the stack trace for queries that I executed. Could you please > help me out with this? Sure, but it's better to do on irc. Ping me on #maria, my ni

Re: [Maria-developers] GSoC 2016: Unique indexes for blobs

2016-04-27 Thread Shubham Barai
Hi Sergei, I was trying to debug mysqld using gdb.I used full backtrace option but I didn't get the stack trace for queries that I executed. Could you please help me out with this? Regards, Shubham On 27 April 2016 at 16:57, Sergei Golubchik wrote: > Hi, Shubham! > > On Apr 26, Shubham Barai w

Re: [Maria-developers] GSoC 2016: Unique indexes for blobs

2016-04-27 Thread Sergei Golubchik
Hi, Shubham! On Apr 26, Shubham Barai wrote: > Hi Sergei, > > Here is the link to new repository > > https://github.com/shubhambaraiss/MariaDB.git > > As you said, I pushed changes with git. Cool, thanks! See: https://github.com/shubhambaraiss/MariaDB/commit/5cecbae8 this is very readable now

Re: [Maria-developers] GSoC 2016: Unique indexes for blobs

2016-04-26 Thread Shubham Barai
Hi Sergei, Here is the link to new repository https://github.com/shubhambaraiss/MariaDB.git As you said, I pushed changes with git. Regards, Shubham On 24 April 2016 at 14:28, Sergei Golubchik wrote: > Hi, Shubham! > > On Apr 24, Shubham Barai wrote: > > Hi Sergei, > > > > URL : https:/

Re: [Maria-developers] GSoC 2016: Unique indexes for blobs

2016-04-24 Thread Sergei Golubchik
Hi, Shubham! On Apr 24, Shubham Barai wrote: > Hi Sergei, > > URL : https://github.com/shubhambaraiss/server.git > Actually, I am having Wi-Fi problems. So I haven't cloned the > repository locally.Instead, I have replaced files with upload option. > Is that okay for now? There was no need to h

Re: [Maria-developers] GSoC 2016: Unique indexes for blobs

2016-04-24 Thread Shubham Barai
Hi Sergei, URL : https://github.com/shubhambaraiss/server.git Actually, I am having Wi-Fi problems. So I haven't cloned the repository locally.Instead, I have replaced files with upload option. Is that okay for now? Regards, Shubham On 24 April 2016 at 12:33, Sergei Golubchik w

Re: [Maria-developers] GSoC 2016: Unique indexes for blobs

2016-04-24 Thread Sergei Golubchik
Hi, Shubham! On Apr 24, Shubham Barai wrote: > Hi Sergei, > > I have created github repository with a new branch for my prototype. Great, what's the url? btw, please, use "Reply to all", so that the whole list could see your progress. Also google recommends you to blog regularly about what you

[Maria-developers] GSoC 2016: Unique indexes for blobs

2016-04-23 Thread Sergei Golubchik
Hi, Shubham! While there's a community bonding period now, let's get prepared for coding, shall we? You can start from creating a proper git repository with your prototype code. Here's how you can do it: * read https://help.github.com/categories/bootcamp/ * fork https://github.com/MariaDB/se

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-04-14 Thread Sergei Golubchik
Hi, Shubham! What do you think about a higher-level implementation? Not in InnoDB or in MyISAM at all, but in the sql/ directory, on the sql layer? Like, on CREATE TABLE you automatically add a new BIGINT column, but hide it from the user (not show it in SHOW COLUMNS and in SELECT *). Create an i

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-24 Thread Shubham Barai
Hello Sergei, After discussing with Jan and you , I have included the proposal for InnoDB and project timeline in my draft proposal. It would be great if you can provide final feedback so that I will be able to submit my final proposal today. Thanks, Shubham On 24 March 2016 at 21:21, S

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-24 Thread Shubham Barai
Hello Jan, Thanks for the kind response and for giving the details of implementation. I am going to explore InnoDB data dictionary before the official coding period starts. Thanks, Shubham On 24 March 2016 at 01:47, Sergei Golubchik wrote: > Hi, Jan! > > On Mar 23, Jan Lindström wrote

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-23 Thread Sergei Golubchik
Hi, Jan! On Mar 23, Jan Lindström wrote: > Hi, > > All below is correct and naturally you may re-implement duplicate search on > different index type. I think there is more code that needs change as this > new index type would contain a column (hash value of the blob field) that > is not on store

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-23 Thread Jan Lindström
Hi, All below is correct and naturally you may re-implement duplicate search on different index type. I think there is more code that needs change as this new index type would contain a column (hash value of the blob field) that is not on stored on base table, right ? Indexed columns are also stor

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-23 Thread Shubham Barai
Hello Sergei, I have gone through some of the source files in InnoDB. / handler/ha_innodb.cc /row/row0mysql.cc /row/row0ins.cc /dict/dict0mem.cc

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-22 Thread Shubham Barai
Hello Sergei, I understood most of the internals of long unique constraints in MyISAM. I am still going through the code in InnoDB. I will soon reply to you. Thanks, Shubham On 21 March 2016 at 16:37, Sergei Golubchik wrote: > Hi, Shubham! > > On Mar 21, Shubham Barai wrote: > > > > I

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-21 Thread Sergei Golubchik
Hi, Shubham! On Mar 21, Shubham Barai wrote: > > I am currently looking into InnoDB codebase to see if it is possible > for me to extend this feature to InnoDB storage engine. As InnoDB > doesn't support this feature internally, it would require more time > than MyISAM. Any suggestions regardin

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-20 Thread Shubham Barai
Hello Sergei, I have created a draft proposal and submitted to summerofcode website. I haven't written the project timeline yet. Actually, the project looks small for three months. I have already developed a prototype for blobs and it is working but there are a lot of things to be taken

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-20 Thread Sergei Golubchik
Hi, Shubham! On Mar 20, Shubham Barai wrote: > Hi Sergei, > > As I told you, I was working on prototype just for blobs. I was > having some issue with key definition between MariaDB .frm file and > information in the MyISAM storage engine. I have solved that problem > temporarily. Here is my out

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-20 Thread Shubham Barai
Hi Sergei, As I told you, I was working on prototype just for blobs. I was having some issue with key definition between MariaDB .frm file and information in the MyISAM storage engine. I have solved that problem temporarily. Here is my output MariaDB [database1]> set storage_engine=myisam;

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-19 Thread Shubham Barai
Hi Sergei, Sorry! I made a mistake. Actually, when I changed my storage engine to MyISAM and executed create table statement(with unique blobs and no prefix length),mysqld crashed. After reconnecting to the server, the storage engine got changed to default (InnoDB).I didn't know about t

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-19 Thread Sergei Golubchik
Hi, Shubham! On Mar 16, Shubham Barai wrote: > Hello, Sergie! > I tried to explore the source code from > mi_create.c,ha_myisam.cc,sql/sql_table.cc,include/myisam.h,.and some other > files. > The main task is to create MI_UNIQUEDEF "uniques" for long unique > constraints. > We have to consider

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-19 Thread Shubham Barai
Hello Sergei, As you suggested, I tried to develop a prototype just for blobs. So far it is working fine but I am still verifying it for different cases. I will provide you the link to my Github repository shortly. Thanks, Shubham On 16 March 2016 at 17:55, Sergei Golubchik wrot

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-15 Thread Sachin Setia
Hello everyone @Shubham As I said i am just prototyping This is not the final code It is just poc to see whether if I send some unique key will mi_create work fine or not as it is working fine in create_internal_tmp_table on following query "select distinct(a2) from tbl" where schema of tbl will

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-15 Thread Shubham Barai
Hello, Sergie! I tried to explore the source code from mi_create.c,ha_myisam.cc,sql/sql_table.cc,include/myisam.h,.and some other files. The main task is to create MI_UNIQUEDEF "uniques" for long unique constraints. We have to consider all the cases where we need to create MI_UNIQUEDEF instead o

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-04 Thread Sergei Golubchik
Hi, Shubham! On Mar 03, Shubham Barai wrote: > > I am interested in the project "Unique indexes for blobs".I have read the > description of the project given on the link > https://jira.mariadb.org/browse/MDEV-371. Great! > I want to know what exactly is the task for this project.Any help > woul

[Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-03 Thread Shubham Barai
Hello everyone, I am Shubham Barai, a 3rd-year undergraduate student in computer science at Maharashtra Institute of technology, Pune, India. I am interested in the project "Unique indexes for blobs".I have read the description of the project given on the link https://jira.mariadb.