maria-developers team mailing list archive

[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
>>>
>>>
>>
>