maria-developers team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

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