Re: [Maria-developers] GSoC Introduction

2019-05-26 Thread Vicențiu Ciorbaru
Hi Rucha! Great start. Whenever you have some code ready for the parser part, please share the repository and the branch onto which you are pushing your code. We should discuss implementation details once you have managed to get the grammar to work. Remember to include test cases to show that

Re: [Maria-developers] [GSoC] Introduction Mail

2014-08-04 Thread Roberto Spadim
i didn't read the code yet, but some min/max problems can add restrictions about variables, for example you could set that variables are =0 must check but well that's a nice step guy :) a nice work :) 2014-08-04 13:31 GMT-03:00 Anshu Avinash anshu.avinas...@gmail.com: Hi all, Here is a blog

Re: [Maria-developers] [GSoC] Introduction Mail

2014-08-04 Thread Anshu Avinash
Hi all, Here is a blog post describing my progress so far: http://igniting.in/gsoc2014/2014/08/04/progress-so-far/ Comments and suggestions are welcome. Regards Anshu Avinash On Wed, Jul 9, 2014 at 1:14 AM, Roberto Spadim robe...@spadim.com.br wrote: please include the output

Re: [Maria-developers] [GSoC] Introduction Mail

2014-08-04 Thread Roberto Spadim
if you have time, you could take a look at linear programming lpsolve is a well know library, i used it a lot some years ago, there's others libs but this one is well known, http://lpsolve.sourceforge.net/5.5/ maybe it give better results, instead of trying to solve a equation you execute a

Re: [Maria-developers] [GSoC] Introduction Mail

2014-07-08 Thread Anshu Avinash
Hi all, This week's blog post is at: http://igniting.in/gsoc2014/2014/07/08/solving-linear-equations/ . Sorry for the delay. Suggestions for an approach to solve the system of linear equations are welcome. Regards Anshu Avinash On Mon, Jun 23, 2014 at 7:39 PM, Roberto Spadim

Re: [Maria-developers] [GSoC] Introduction Mail

2014-07-08 Thread Roberto Spadim
could you 'display' the dataset you used with octave? 2014-07-08 13:55 GMT-03:00 Anshu Avinash anshu.avinas...@gmail.com: Hi all, This week's blog post is at: http://igniting.in/gsoc2014/2014/07/08/solving-linear-equations/ . Sorry for the delay. Suggestions for an approach to solve the

Re: [Maria-developers] [GSoC] Introduction Mail

2014-07-08 Thread Anshu Avinash
Hi all, You can download it here ( https://drive.google.com/file/d/0B7NiQb4EbbUVNVJFZ2xkRVR3Ylk/edit?usp=sharing). It is around 26M. I have added the link on blog too. Regards Anshu On Tue, Jul 8, 2014 at 10:38 PM, Roberto Spadim robe...@spadim.com.br wrote: could you 'display' the dataset

Re: [Maria-developers] [GSoC] Introduction Mail

2014-07-08 Thread Roberto Spadim
just to understand... --- the solve_equation part, today only used to save information: std::ofstream datafile; char file_name[100]; my_snprintf(file_name, 100, /tmp/mariadb_cost_coefficients_%lu.txt, thread_id); datafile.open(file_name, std::ios::app); for(int i=0; i MAX_CONSTANTS;

Re: [Maria-developers] [GSoC] Introduction Mail

2014-07-08 Thread Anshu Avinash
Hi, The idea is we know the total time the query took, and how many times an operation was performed. For example, consider the case of 'read_time'. We know how many times an index read took place, but don't know how much time does it take to do an index read. By solving these equations, we are

Re: [Maria-developers] [GSoC] Introduction Mail

2014-07-08 Thread Roberto Spadim
ops, linear equation 2014-07-08 15:47 GMT-03:00 Roberto Spadim robe...@spadim.com.br: going back... a1t1 + a2t2 + … + a130t130= ttotal a1, t1... a1 is something you don't know t1 is the coefficients[i]? it's a first order equation, right? 2014-07-08 15:20 GMT-03:00 Anshu Avinash

Re: [Maria-developers] [GSoC] Introduction Mail

2014-07-08 Thread Anshu Avinash
Hi, a1, a2, ..., a130 are coefficients. t1, t2, .., t130 are unknowns. We need 130 linearly independent equations to solve for these variables. We can never get 130 linearly independent equations as some of the coefficients would be 0 every time. Hence, we get an approximate solution by forming

Re: [Maria-developers] [GSoC] Introduction Mail

2014-07-08 Thread Roberto Spadim
a1,a2 is what your solve equation function is saving? and you want know t1,t2,t3..t130, to understand how much time each 'read function' take, that's it? doing this, what's the next step? this is a start point to select what's better? index vs table scan? 2014-07-08 15:54 GMT-03:00 Anshu

Re: [Maria-developers] [GSoC] Introduction Mail

2014-07-08 Thread Roberto Spadim
check lapack lib, i used it some years ago, and it solve linear equations, at least you don't waste time with 'how to solve linear equations', if you want to study :) lapack was a nice lib, at least i used without problems 2014-07-08 16:04 GMT-03:00 Roberto Spadim robe...@spadim.com.br: a1,a2 is

Re: [Maria-developers] [GSoC] Introduction Mail

2014-07-08 Thread Roberto Spadim
http://www.netlib.org/lapack/lapacke.html a C api to lapack 2014-07-08 16:23 GMT-03:00 Roberto Spadim robe...@spadim.com.br: check lapack lib, i used it some years ago, and it solve linear equations, at least you don't waste time with 'how to solve linear equations', if you want to study :)

Re: [Maria-developers] [GSoC] Introduction Mail

2014-07-08 Thread Roberto Spadim
please include the output (solutions.txt) link too, to check what happened 2014-07-08 16:24 GMT-03:00 Roberto Spadim robe...@spadim.com.br: http://www.netlib.org/lapack/lapacke.html a C api to lapack 2014-07-08 16:23 GMT-03:00 Roberto Spadim robe...@spadim.com.br: check lapack lib, i used it

Re: [Maria-developers] [GSoC] Introduction Mail

2014-06-23 Thread Anshu Avinash
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 robe...@spadim.com.br wrote: Well i wws reading your posts Do you need big data to test

Re: [Maria-developers] [GSoC] Introduction Mail

2014-06-23 Thread Roberto Spadim
Sorry this page does not exist =( 2014-06-23 8:07 GMT-03:00 Anshu Avinash anshu.avinas...@gmail.com: 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

Re: [Maria-developers] [GSoC] Introduction Mail

2014-06-23 Thread Anshu Avinash
Hi, Sorry for the confusion, this is the new link: http://igniting.in/gsoc2014/2014/06/23/work-before-mid-term/ Thanks for pointing out. Regards Anshu On Mon, Jun 23, 2014 at 7:32 PM, Roberto Spadim robe...@spadim.com.br wrote: Sorry this page does not exist =( 2014-06-23 8:07 GMT-03:00

Re: [Maria-developers] [GSoC] Introduction Mail

2014-06-23 Thread Roberto Spadim
MDEV. it's nice to put full name (MDEV-350), since google and others search engines help when someone try to find information about mdev 350 text is ok :) 2014-06-23 11:04 GMT-03:00 Anshu Avinash anshu.avinas...@gmail.com: Hi, Sorry for the confusion, this is the new link:

Re: [Maria-developers] [GSoC] Introduction Mail

2014-06-09 Thread Roberto Spadim
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.avinas...@gmail.com 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

Re: [Maria-developers] [GSoC] Introduction Mail

2014-05-25 Thread Anshu Avinash
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

Re: [Maria-developers] [GSoC] Introduction Mail

2014-05-19 Thread Anshu Avinash
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

Re: [Maria-developers] [GSoC] Introduction Mail

2014-05-19 Thread Roberto Spadim
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.avinas...@gmail.com: 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

Re: [Maria-developers] [GSoC] Introduction Mail

2014-05-11 Thread Anshu Avinash
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.avinas...@gmail.comwrote: Hi all, Sorry for the irregular updates. I had been busy for last couple of days

Re: [Maria-developers] [GSoC] Introduction Mail

2014-05-08 Thread Sergei Golubchik
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

Re: [Maria-developers] [GSoC] Introduction Mail

2014-05-08 Thread Colin Charles
Hi! On 8 May 2014, at 22:33, Sergei Golubchik s...@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

Re: [Maria-developers] [GSoC] Introduction Mail

2014-04-29 Thread Sergei Golubchik
Hi, Anshu! So, how do we start? I see you're often present on irc, which is great. You've looked at the code, what do you think? Do you understand how different parts of this feature fit together? We can start from just one constant (global or per-engine) and see how it'll work. And, by the

Re: [Maria-developers] [GSoC] Introduction Mail

2014-04-29 Thread Anshu Avinash
Hi, I had been busy with my exams (which got finished today). I'll come up with more detailed working plan and doubts in a couple of days. On Tue, Apr 29, 2014 at 11:28 PM, Sergei Golubchik s...@mariadb.org wrote: Hi, Anshu! So, how do we start? Till now, I have not done much. I had

Re: [Maria-developers] [GSoC] Introduction Mail

2014-04-29 Thread Sergei Golubchik
Hi, Anshu! On Apr 30, Anshu Avinash wrote: You've looked at the code, what do you think? Do you understand how different parts of this feature fit together? We can start from just one constant (global or per-engine) and see how it'll work. I had started exploring tmptable_create_cost.