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 < [email protected]> 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 <[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(). > > -- 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
