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
