- developers - lists.mariadb.org

[Maria-developers] Updated (by Igor): Backport subquery optimizations (104)
by worklog-noreply＠askmonty.org 10 Mar '10

10 Mar '10

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Backport subquery optimizations CREATION DATE..: Wed, 10 Mar 2010, 18:54 SUPERVISOR.....: Igor IMPLEMENTOR....: Psergey COPIES TO......: CATEGORY.......: Server-Sprint TASK ID........: 104 (http://askmonty.org/worklog/?tid=104) VERSION........: Server-5.3 STATUS.........: Complete PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: -=-=(Igor - Wed, 10 Mar 2010, 20:54)=-=- High Level Description modified. --- /tmp/wklog.104.old.30758 2010-03-10 20:54:41.000000000 +0000 +++ /tmp/wklog.104.new.30758 2010-03-10 20:54:41.000000000 +0000 @@ -1,2 +1,2 @@ The target of this task is backport the code for subquery optimizations from the -MySQL 6.0 code line to MariaDB 5.3 +MySQL 6.0 code line to MariaDB 5.3. -=-=(Igor - Wed, 10 Mar 2010, 20:53)=-=- Title modified. --- /tmp/wklog.104.old.30184 2010-03-10 20:53:31.000000000 +0000 +++ /tmp/wklog.104.new.30184 2010-03-10 20:53:31.000000000 +0000 @@ -1 +1 @@ -Backport 6.0 subquery code +Backport subquery optimizations -=-=(Igor - Wed, 10 Mar 2010, 20:52)=-=- High Level Description modified. --- /tmp/wklog.104.old.30172 2010-03-10 20:52:27.000000000 +0000 +++ /tmp/wklog.104.new.30172 2010-03-10 20:52:27.000000000 +0000 @@ -1 +1,2 @@ -Backport 6.0 subquery code to MariaDB 5.3 +The target of this task is backport the code for subquery optimizations from the +MySQL 6.0 code line to MariaDB 5.3 -=-=(Guest - Wed, 10 Mar 2010, 20:48)=-=- Title modified. --- /tmp/wklog.104.old.29904 2010-03-10 20:48:13.000000000 +0000 +++ /tmp/wklog.104.new.29904 2010-03-10 20:48:13.000000000 +0000 @@ -1 +1 @@ -Backport 6.0 subquery code to MariaDB 5.3 +Backport 6.0 subquery code -=-=(Psergey - Wed, 10 Mar 2010, 18:55)=-=- Dependency created: 91 now depends on 104 DESCRIPTION: The target of this task is backport the code for subquery optimizations from the MySQL 6.0 code line to MariaDB 5.3. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Updated (by Igor): Backport subquery optimizations (104)
by worklog-noreply＠askmonty.org 10 Mar '10

10 Mar '10

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Backport subquery optimizations CREATION DATE..: Wed, 10 Mar 2010, 18:54 SUPERVISOR.....: Igor IMPLEMENTOR....: Psergey COPIES TO......: CATEGORY.......: Server-Sprint TASK ID........: 104 (http://askmonty.org/worklog/?tid=104) VERSION........: Server-5.3 STATUS.........: Complete PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: -=-=(Igor - Wed, 10 Mar 2010, 20:54)=-=- High Level Description modified. --- /tmp/wklog.104.old.30758 2010-03-10 20:54:41.000000000 +0000 +++ /tmp/wklog.104.new.30758 2010-03-10 20:54:41.000000000 +0000 @@ -1,2 +1,2 @@ The target of this task is backport the code for subquery optimizations from the -MySQL 6.0 code line to MariaDB 5.3 +MySQL 6.0 code line to MariaDB 5.3. -=-=(Igor - Wed, 10 Mar 2010, 20:53)=-=- Title modified. --- /tmp/wklog.104.old.30184 2010-03-10 20:53:31.000000000 +0000 +++ /tmp/wklog.104.new.30184 2010-03-10 20:53:31.000000000 +0000 @@ -1 +1 @@ -Backport 6.0 subquery code +Backport subquery optimizations -=-=(Igor - Wed, 10 Mar 2010, 20:52)=-=- High Level Description modified. --- /tmp/wklog.104.old.30172 2010-03-10 20:52:27.000000000 +0000 +++ /tmp/wklog.104.new.30172 2010-03-10 20:52:27.000000000 +0000 @@ -1 +1,2 @@ -Backport 6.0 subquery code to MariaDB 5.3 +The target of this task is backport the code for subquery optimizations from the +MySQL 6.0 code line to MariaDB 5.3 -=-=(Guest - Wed, 10 Mar 2010, 20:48)=-=- Title modified. --- /tmp/wklog.104.old.29904 2010-03-10 20:48:13.000000000 +0000 +++ /tmp/wklog.104.new.29904 2010-03-10 20:48:13.000000000 +0000 @@ -1 +1 @@ -Backport 6.0 subquery code to MariaDB 5.3 +Backport 6.0 subquery code -=-=(Psergey - Wed, 10 Mar 2010, 18:55)=-=- Dependency created: 91 now depends on 104 DESCRIPTION: The target of this task is backport the code for subquery optimizations from the MySQL 6.0 code line to MariaDB 5.3. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Updated (by Igor): Backport subquery optimizations (104)
by worklog-noreply＠askmonty.org 10 Mar '10

10 Mar '10

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Backport subquery optimizations CREATION DATE..: Wed, 10 Mar 2010, 18:54 SUPERVISOR.....: Igor IMPLEMENTOR....: Psergey COPIES TO......: CATEGORY.......: Server-Sprint TASK ID........: 104 (http://askmonty.org/worklog/?tid=104) VERSION........: Server-5.3 STATUS.........: Complete PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: -=-=(Igor - Wed, 10 Mar 2010, 20:53)=-=- Title modified. --- /tmp/wklog.104.old.30184 2010-03-10 20:53:31.000000000 +0000 +++ /tmp/wklog.104.new.30184 2010-03-10 20:53:31.000000000 +0000 @@ -1 +1 @@ -Backport 6.0 subquery code +Backport subquery optimizations -=-=(Igor - Wed, 10 Mar 2010, 20:52)=-=- High Level Description modified. --- /tmp/wklog.104.old.30172 2010-03-10 20:52:27.000000000 +0000 +++ /tmp/wklog.104.new.30172 2010-03-10 20:52:27.000000000 +0000 @@ -1 +1,2 @@ -Backport 6.0 subquery code to MariaDB 5.3 +The target of this task is backport the code for subquery optimizations from the +MySQL 6.0 code line to MariaDB 5.3 -=-=(Guest - Wed, 10 Mar 2010, 20:48)=-=- Title modified. --- /tmp/wklog.104.old.29904 2010-03-10 20:48:13.000000000 +0000 +++ /tmp/wklog.104.new.29904 2010-03-10 20:48:13.000000000 +0000 @@ -1 +1 @@ -Backport 6.0 subquery code to MariaDB 5.3 +Backport 6.0 subquery code -=-=(Psergey - Wed, 10 Mar 2010, 18:55)=-=- Dependency created: 91 now depends on 104 DESCRIPTION: The target of this task is backport the code for subquery optimizations from the MySQL 6.0 code line to MariaDB 5.3 ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Updated (by Igor): Backport subquery optimizations (104)
by worklog-noreply＠askmonty.org 10 Mar '10

10 Mar '10

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Backport subquery optimizations CREATION DATE..: Wed, 10 Mar 2010, 18:54 SUPERVISOR.....: Igor IMPLEMENTOR....: Psergey COPIES TO......: CATEGORY.......: Server-Sprint TASK ID........: 104 (http://askmonty.org/worklog/?tid=104) VERSION........: Server-5.3 STATUS.........: Complete PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: -=-=(Igor - Wed, 10 Mar 2010, 20:53)=-=- Title modified. --- /tmp/wklog.104.old.30184 2010-03-10 20:53:31.000000000 +0000 +++ /tmp/wklog.104.new.30184 2010-03-10 20:53:31.000000000 +0000 @@ -1 +1 @@ -Backport 6.0 subquery code +Backport subquery optimizations -=-=(Igor - Wed, 10 Mar 2010, 20:52)=-=- High Level Description modified. --- /tmp/wklog.104.old.30172 2010-03-10 20:52:27.000000000 +0000 +++ /tmp/wklog.104.new.30172 2010-03-10 20:52:27.000000000 +0000 @@ -1 +1,2 @@ -Backport 6.0 subquery code to MariaDB 5.3 +The target of this task is backport the code for subquery optimizations from the +MySQL 6.0 code line to MariaDB 5.3 -=-=(Guest - Wed, 10 Mar 2010, 20:48)=-=- Title modified. --- /tmp/wklog.104.old.29904 2010-03-10 20:48:13.000000000 +0000 +++ /tmp/wklog.104.new.29904 2010-03-10 20:48:13.000000000 +0000 @@ -1 +1 @@ -Backport 6.0 subquery code to MariaDB 5.3 +Backport 6.0 subquery code -=-=(Psergey - Wed, 10 Mar 2010, 18:55)=-=- Dependency created: 91 now depends on 104 DESCRIPTION: The target of this task is backport the code for subquery optimizations from the MySQL 6.0 code line to MariaDB 5.3 ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Updated (by Igor): Backport 6.0 subquery code (104)
by worklog-noreply＠askmonty.org 10 Mar '10

10 Mar '10

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Backport 6.0 subquery code CREATION DATE..: Wed, 10 Mar 2010, 18:54 SUPERVISOR.....: Igor IMPLEMENTOR....: Psergey COPIES TO......: CATEGORY.......: Server-Sprint TASK ID........: 104 (http://askmonty.org/worklog/?tid=104) VERSION........: Server-5.3 STATUS.........: Complete PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: -=-=(Igor - Wed, 10 Mar 2010, 20:52)=-=- High Level Description modified. --- /tmp/wklog.104.old.30172 2010-03-10 20:52:27.000000000 +0000 +++ /tmp/wklog.104.new.30172 2010-03-10 20:52:27.000000000 +0000 @@ -1 +1,2 @@ -Backport 6.0 subquery code to MariaDB 5.3 +The target of this task is backport the code for subquery optimizations from the +MySQL 6.0 code line to MariaDB 5.3 -=-=(Guest - Wed, 10 Mar 2010, 20:48)=-=- Title modified. --- /tmp/wklog.104.old.29904 2010-03-10 20:48:13.000000000 +0000 +++ /tmp/wklog.104.new.29904 2010-03-10 20:48:13.000000000 +0000 @@ -1 +1 @@ -Backport 6.0 subquery code to MariaDB 5.3 +Backport 6.0 subquery code -=-=(Psergey - Wed, 10 Mar 2010, 18:55)=-=- Dependency created: 91 now depends on 104 DESCRIPTION: The target of this task is backport the code for subquery optimizations from the MySQL 6.0 code line to MariaDB 5.3 ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Updated (by Igor): Backport 6.0 subquery code (104)
by worklog-noreply＠askmonty.org 10 Mar '10

10 Mar '10

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Backport 6.0 subquery code CREATION DATE..: Wed, 10 Mar 2010, 18:54 SUPERVISOR.....: Igor IMPLEMENTOR....: Psergey COPIES TO......: CATEGORY.......: Server-Sprint TASK ID........: 104 (http://askmonty.org/worklog/?tid=104) VERSION........: Server-5.3 STATUS.........: Complete PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: -=-=(Igor - Wed, 10 Mar 2010, 20:52)=-=- High Level Description modified. --- /tmp/wklog.104.old.30172 2010-03-10 20:52:27.000000000 +0000 +++ /tmp/wklog.104.new.30172 2010-03-10 20:52:27.000000000 +0000 @@ -1 +1,2 @@ -Backport 6.0 subquery code to MariaDB 5.3 +The target of this task is backport the code for subquery optimizations from the +MySQL 6.0 code line to MariaDB 5.3 -=-=(Guest - Wed, 10 Mar 2010, 20:48)=-=- Title modified. --- /tmp/wklog.104.old.29904 2010-03-10 20:48:13.000000000 +0000 +++ /tmp/wklog.104.new.29904 2010-03-10 20:48:13.000000000 +0000 @@ -1 +1 @@ -Backport 6.0 subquery code to MariaDB 5.3 +Backport 6.0 subquery code -=-=(Psergey - Wed, 10 Mar 2010, 18:55)=-=- Dependency created: 91 now depends on 104 DESCRIPTION: The target of this task is backport the code for subquery optimizations from the MySQL 6.0 code line to MariaDB 5.3 ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Updated (by Guest): Backport 6.0 subquery code (104)
by worklog-noreply＠askmonty.org 10 Mar '10

10 Mar '10

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Backport 6.0 subquery code CREATION DATE..: Wed, 10 Mar 2010, 18:54 SUPERVISOR.....: Igor IMPLEMENTOR....: Psergey COPIES TO......: CATEGORY.......: Server-Sprint TASK ID........: 104 (http://askmonty.org/worklog/?tid=104) VERSION........: Server-5.3 STATUS.........: Complete PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: -=-=(Guest - Wed, 10 Mar 2010, 20:48)=-=- Title modified. --- /tmp/wklog.104.old.29904 2010-03-10 20:48:13.000000000 +0000 +++ /tmp/wklog.104.new.29904 2010-03-10 20:48:13.000000000 +0000 @@ -1 +1 @@ -Backport 6.0 subquery code to MariaDB 5.3 +Backport 6.0 subquery code -=-=(Psergey - Wed, 10 Mar 2010, 18:55)=-=- Dependency created: 91 now depends on 104 DESCRIPTION: Backport 6.0 subquery code to MariaDB 5.3 ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Updated (by Guest): Backport 6.0 subquery code (104)
by worklog-noreply＠askmonty.org 10 Mar '10

10 Mar '10

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Backport 6.0 subquery code CREATION DATE..: Wed, 10 Mar 2010, 18:54 SUPERVISOR.....: Igor IMPLEMENTOR....: Psergey COPIES TO......: CATEGORY.......: Server-Sprint TASK ID........: 104 (http://askmonty.org/worklog/?tid=104) VERSION........: Server-5.3 STATUS.........: Complete PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: -=-=(Guest - Wed, 10 Mar 2010, 20:48)=-=- Title modified. --- /tmp/wklog.104.old.29904 2010-03-10 20:48:13.000000000 +0000 +++ /tmp/wklog.104.new.29904 2010-03-10 20:48:13.000000000 +0000 @@ -1 +1 @@ -Backport 6.0 subquery code to MariaDB 5.3 +Backport 6.0 subquery code -=-=(Psergey - Wed, 10 Mar 2010, 18:55)=-=- Dependency created: 91 now depends on 104 DESCRIPTION: Backport 6.0 subquery code to MariaDB 5.3 ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

Re: [Maria-developers] Linking to Launchpad page at source downloads
by Michael Widenius 10 Mar '10

10 Mar '10

Hi! >>>>> "Colin" == Colin Charles <colin(a)askmonty.org> writes: Colin> Hi! Colin> http://askmonty.org/wiki/index.php/MariaDB:Download Colin> Under source tarball, we recommend people to go grab stuff from Colin> Launchpad Colin> It will be nice if we told them how to do so Colin> 1. How to use Launchpad Colin> 2. What to branch Colin> 3. Introduction to bazaar Colin> I'm guessing all this should be part of our cogent manual Colin> What do you think? Something like this ? http://askmonty.org/wiki/index.php/Getting_the_MariaDB_Source_Code Of course, we can add more stuff and we should link to this page from our source tarball. Regards, Monty

1 0

[Maria-developers] Rev 2818: Increased loop counts of sql-bench tests to get run times around in file:///Users/hakan/work/monty_program/maria/
by Hakan Kuecuekyilmaz 10 Mar '10

10 Mar '10

At file:///Users/hakan/work/monty_program/maria/ ------------------------------------------------------------ revno: 2818 revision-id: hakan(a)askmonty.org-20100217201002-gax8y3ts7yf6u50a parent: monty(a)askmonty.org-20100212142113-wdv50xx19quursaf committer: Hakan Kuecuekyilmaz <hakan(a)askmonty.org> branch nick: maria timestamp: Wed 2010-02-17 21:10:02 +0100 message: Increased loop counts of sql-bench tests to get run times around 5 minutes on current machines. Tested on a Xeon machine and a new dual core laptop. === modified file 'sql-bench/test-ATIS.sh' --- a/sql-bench/test-ATIS.sh 2009-05-29 13:40:55 +0000 +++ b/sql-bench/test-ATIS.sh 2010-02-17 20:10:02 +0000 @@ -28,7 +28,7 @@ use DBI; use Benchmark; -$opt_loop_count=100; # Run selects this many times +$opt_loop_count=5000; # Run selects this many times $pwd = cwd(); $pwd = "." if ($pwd eq ''); require "$pwd/bench-init.pl" || die "Can't read Configuration file: $!\n"; === modified file 'sql-bench/test-alter-table.sh' --- a/sql-bench/test-alter-table.sh 2009-05-29 13:40:55 +0000 +++ b/sql-bench/test-alter-table.sh 2010-02-17 20:10:02 +0000 @@ -25,7 +25,7 @@ use Benchmark; $opt_start_field_count=8; # start with this many fields -$opt_loop_count=100; # How many tests to do +$opt_loop_count=10000; # How many tests to do $opt_row_count=1000; # Rows in the table $opt_field_count=1000; # Add until this many fields. $opt_time_limit=10*60; # Don't wait more than 10 min for some tests === modified file 'sql-bench/test-big-tables.sh' --- a/sql-bench/test-big-tables.sh 2009-05-29 13:40:55 +0000 +++ b/sql-bench/test-big-tables.sh 2010-02-17 20:10:02 +0000 @@ -25,7 +25,7 @@ use DBI; use Benchmark; -$opt_loop_count=1000; # Change this to make test harder/easier +$opt_loop_count=70000; # Change this to make test harder/easier $opt_field_count=1000; $pwd = cwd(); $pwd = "." if ($pwd eq ''); === modified file 'sql-bench/test-connect.sh' --- a/sql-bench/test-connect.sh 2010-02-10 21:26:06 +0000 +++ b/sql-bench/test-connect.sh 2010-02-17 20:10:02 +0000 @@ -28,7 +28,7 @@ use DBI; use Benchmark; -$opt_loop_count=100000; # Change this to make test harder/easier +$opt_loop_count=500000; # Change this to make test harder/easier $str_length=65000; # This is the length of blob strings in PART:5 $max_test=20; # How many times to test if the server is busy === modified file 'sql-bench/test-select.sh' --- a/sql-bench/test-select.sh 2009-05-29 13:40:55 +0000 +++ b/sql-bench/test-select.sh 2010-02-17 20:10:02 +0000 @@ -26,7 +26,7 @@ use Benchmark; $opt_loop_count=10000; -$opt_medium_loop_count=1000; +$opt_medium_loop_count=7000; $opt_small_loop_count=10; $opt_regions=6; $opt_groups=100; === modified file 'sql-bench/test-transactions.sh' --- a/sql-bench/test-transactions.sh 2009-05-29 13:40:55 +0000 +++ b/sql-bench/test-transactions.sh 2010-02-17 20:10:02 +0000 @@ -28,8 +28,8 @@ $opt_groups=27; # Characters are 'A' -> Z -$opt_loop_count=10000; # Change this to make test harder/easier -$opt_medium_loop_count=100; # Change this to make test harder/easier +$opt_loop_count=500000; # Change this to make test harder/easier +$opt_medium_loop_count=10000; # Change this to make test harder/easier $pwd = cwd(); $pwd = "." if ($pwd eq ''); require "$pwd/bench-init.pl" || die "Can't read Configuration file: $!\n"; === modified file 'sql-bench/test-wisconsin.sh' --- a/sql-bench/test-wisconsin.sh 2009-05-29 13:40:55 +0000 +++ b/sql-bench/test-wisconsin.sh 2010-02-17 20:10:02 +0000 @@ -21,7 +21,7 @@ use DBI; use Benchmark; -$opt_loop_count=10; +$opt_loop_count=5000; $pwd = cwd(); $pwd = "." if ($pwd eq ''); require "$pwd/bench-init.pl" || die "Can't read Configuration file: $!\n";

2 1