Hello, I'm an undergraduate student currently in the 3rd year of my Computer Science degree at *FAST-National University of Computer and Emerging Sciences, Lahore, Pakistan.* I am interested in* "table definition files in an innodb table" *idea under 'Stewart Smith' as a mentor.
I am a part of the team that has posted this thread ( https://lists.launchpad.net/drizzle-discuss/msg08919.html ) namely Sohair Tayyab Butt and Waqas Iftikhar working in Software Engineering Research Center (FAST-NU) in the code base of MySQL. I have been doing an extensive debugging of MySQL source code on Windows. I worked with these team members on some of the bugs listed on bugs.mysql.comnumbered 50675, 50507, 54034 and 20093. I have excellent programming skills and have good expertise in C/C++,JAVA,C#. For the past few days , I have been studying the mysql innodb storage engine. I studied in mysql reference manual that MySQL server keeps data dictionary information in .frm files which it stores in the database directories, whereas InnoDB also stores the information into its own data dictionary inside the table space files. According to my knowledge , in case of drizzle, the problems occur when the innodb internal data dictionary goes out-of-sync with the table definition files ( same as in mysql ). The GSoC idea is " To make DDL truly crash safe, we should instead store them inside a InnoDB table as part of the data dictionary transaction ". My question is that what is the basic purpose to store the information inside the data dictionary when it is already present there? Why don't we just remove the mechanism of using table definition ( .frm / .dfe ) files so that drizzle just checks the information in data dictionary. I have built the source of Drizzle in Linux. I am curious to know which debugging tool you guys would recommend to use on Linux to debug and study the source base of Drizzle. I intend to solve a bug and I am on it. After starting work on MySQL i was always interested to work on innodb engine and planned to do it in summers as I will be totally free. This GSoC project will give me chance to work on innodb which will also help me in learning MySQL/Drizzle and develop them further. PS. I didn't look into the innodb source so it's just an educated guess based on my learning in previous days. I need an expert opinion on it. Regards, Kinaan Khan Sherwani,
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : drizzle-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
