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.avinash35@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.avinash35@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 <roberto@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.avinash35@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.avinash35@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.avinash35@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