Hi all, You can find this week's blog entry at: http://igniting.in/2014/06/23/work-before-mid-term/ Suggestions/reviews are welcome.
Regards Anshu Avinash On Mon, Jun 9, 2014 at 7:30 PM, Roberto Spadim <robe...@spadim.com.br> wrote: > Well i wws reading your posts > Do you need big data to test read and scan times? > > Em segunda-feira, 9 de junho de 2014, Anshu Avinash < > anshu.avinas...@gmail.com> escreveu: > > 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 <anshu.avinas...@gmail.com >> > 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 <robe...@spadim.com.br> >> 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 <anshu.avinas...@gmail.com>: >> >> 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 < >> anshu.avinas...@gmail.com> 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 <anshu.avinas...@gmail.com >> > 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(). >> >> > > -- > Roberto Spadim > SPAEmpresarial > Eng. Automação e Controle > >
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp