maria-developers team mailing list archive

[Anshu Avinash <anshu.avinash35@xxxxxxxxx>]

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