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(). 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@mariadb.org> wrote:
Hi!

On 8 May 2014, at 22:33, Sergei Golubchik <serg@mariadb.org> 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@lists.launchpad.net - 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