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/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(). 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 <colin@xxxxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> Hi!
>>>>>>
>>>>>> On 8 May 2014, at 22:33, Sergei Golubchik <serg@xxxxxxxxxxx> 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 maria-developers@xxxxxxxxxxxxxxxxxxx - 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     : maria-developers@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~maria-developers
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Roberto Spadim
>> SPAEmpresarial
>> Eng. Automação e Controle
>>
>
>