Hi all, You can find this week's blog entry at http://igniting.in/gsoc2014/2014/06/09/more-coding/. I'm now maintaining the code only on github: https://github.com/igniting/server/tree/selfTuningOptimizer.
Regards Anshu Avinash On Sun, May 25, 2014 at 3:27 PM, Anshu Avinash <[email protected]> wrote: > Hi all, > > You can find my this week's blog entry at > http://igniting.in/gsoc2014/2014/05/25/coding-things-up/ . I have created > a branch on launchpad for my work: > http://bazaar.launchpad.net/~igniting/maria/maria/revision/4211 . You can > give your suggestions/reviews either on this thread or as a comment on the > blog itself. > > Regards > Anshu Avinash > > > On Tue, May 20, 2014 at 1:22 AM, Roberto Spadim <[email protected]> > wrote: > >> wow a big work, congratulation guy, i will read part by part >> to better understand mariadb code >> >> >> 2014-05-19 16:33 GMT-03:00 Anshu Avinash <[email protected]>: >> >>> Hi all, >>> >>> This week's blog entry would get delayed by couple of days. I have >>> started coding though and would like to give heads up on what I'm doing. >>> >>> I've looked at the diffs for "Cost model project" of mysql: >>> http://bazaar.launchpad.net/~mysql/mysql-server/5.7/revision/7596 and >>> http://bazaar.launchpad.net/~mysql/mysql-server/5.7/revision/7222 . >>> These give a pretty good idea about what are the hard-coded constants and >>> where are they being used. >>> >>> The idea is to multiply "READ_TIME_FACTOR" and "SCAN_TIME_FACTOR" to the >>> values returned by read_time() and scan_time() in handler.h, while >>> returning. These values would be read from a table in mysql db. For that >>> I've looked at sql_statistics.cc. After completing this, I'll first change >>> the values of these constants manually and check if the better or worse >>> query plans are being selected. I'll first do the last step manually, to >>> check if everything is working as expected and later automate it. >>> >>> Regards >>> Anshu >>> >>> >>> On Mon, May 12, 2014 at 11:22 AM, Anshu Avinash < >>> [email protected]> wrote: >>> >>>> Hi all, >>>> >>>> You can find my blog entry for this week at >>>> http://igniting.in/gsoc2014/2014/05/11/first-steps/ . >>>> >>>> Regards >>>> Anshu Avinash >>>> >>>> >>>> On Thu, May 8, 2014 at 11:46 PM, Anshu Avinash < >>>> [email protected]> wrote: >>>> >>>>> Hi all, >>>>> >>>>> Sorry for the irregular updates. I had been busy for last couple of >>>>> days and might still be busy for 1-2 days more. I would be completely free >>>>> starting next week, and would be updating my blog weekly on every Monday >>>>> (so 1st update would be on May 12). I would also send the link of my post >>>>> weekly on the mailing list. >>>>> >>>>> As discussed on irc, I started to explore the pair of constants: >>>>> handler::scan_time() and handler::read_time(). I also started looking into >>>>> sql_statistics.cc for writing the optimizer constants into a persistent >>>>> db. >>>>> >>>>> Regards >>>>> Anshu Avinash >>>>> >>>>> On Thu, May 8, 2014 at 11:08 PM, Colin Charles <[email protected]> >>>>> wrote: >>>>> >>>>>> Hi! >>>>>> >>>>>> On 8 May 2014, at 22:33, Sergei Golubchik <[email protected]> wrote: >>>>>> >>>>>> > Hi, Anshu! >>>>>> > >>>>>> > How are you doing? Any progress so far? >>>>>> > >>>>>> > On Apr 30, Anshu Avinash wrote: >>>>>> >> >>>>>> >>> And, by the way, when you start coding (May 19) or earlier, as you >>>>>> >>> prefer, I would like to start seeing some kind of weekly updates >>>>>> from >>>>>> >>> you. In email or in your blog - whatever you feel more >>>>>> comfortable with. >>>>>> >> >>>>>> >> Blog updates should be fine. >>>>>> > >>>>>> > That's fine. Whatever you prefer. >>>>>> > One blog post every week then, preferrably on Monday. >>>>>> > >>>>>> >>>>>> For the benefit of others Anshu, please also post your weekly reports >>>>>> to [email protected] - I think it will be really >>>>>> good for those that don't drop by your blog and you'll likely also get >>>>>> other feedback maybe >>>>>> >>>>>> This goes to all those participating in GSoC. >>>>>> >>>>>> Also for those with a blog + RSS feed, you should aim to get it on >>>>>> http://planetmariadb.org/ and http://planet.mysql.com/ >>>>>> >>>>>> >>>>>> cheers, >>>>>> -colin >>>>>> >>>>>> >>>>>> -- >>>>>> Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company >>>>>> blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: >>>>>> colincharles >>>>>> >>>>>> >>>>> >>>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~maria-developers >>> Post to : [email protected] >>> Unsubscribe : https://launchpad.net/~maria-developers >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> Roberto Spadim >> SPAEmpresarial >> Eng. Automação e Controle >> > >
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
