- developers - lists.mariadb.org

Re: [Maria-developers] options for CREATE TABLE (MWL#43)
by Oleksandr Byelkin 11 Mar '10

11 Mar '10

Hi! Quick answer to solve "big" questions faster. 11 марта 2010, в 12:30, Sergei Golubchik написал(а): > Hi, Sanja! > > Here's the review, below: > > Summary: > > 1. please, store options together with the objects they describe, not > separately. .frm file is not the place I can stuck where I want, IMHO one extension as it stored now only the way to keep .frm compatible. > 2. Unknown option should be an error by default. > 3. use something my_getopt-like as we discussed, don't force every > engine to parse its options Above is exactly against Monty's expectations (I remember old discussion, as far as I remember my_getopt-like idea was rejected at the end, about error messages it can be done for creation, but for alter table we agreed to have warnings). [skip] > 5. don't check for changed options in alter table with your > check_if_incompatible_data. let the engine do that. Do you mean additional call to engine? [skip] > 7. parser: make the equal sign optional > 8. few existing options, like row_format, insert_method, checksum, > delay_key_write, key_block_size, min_rows/max_rows, avg_row_length, > tablespace, connection, pack_keys could be moved into storage > engines > out of the parser. In some cases options goes without coma, there is 3 word option DATA DIRECTORY <value>, INDEX DIRECTORY <value> so I can't imagine how to move the existing options to engine and make equal sign optional. [skip]

1 0

[Maria-developers] LIMIT optimisations
by Jocelyn Fournier 10 Mar '10

10 Mar '10

Hi, Following this discussion in 2007 : http://lists.mysql.com/internals/34287 Is there any plan to implement such an optimisation in MariaDB ? (I think a lot of web app using pagination could take benefit of such an optimisation, although there are some workarounds to avoid big LIMIT for pagination) Thanks ! Jocelyn

3 4

[Maria-developers] Need help with packaging for MariaDB 5.2
by Kristian Nielsen 10 Mar '10

10 Mar '10

Hi Arjen, We are starting to think about MariaDB 5.2, in particular of start making (alpha) releases with packages. The current ourdelta packaging scripts for MariaDB 5.1 fail to build 5.2 (seen in Buildbot). I took a look at it, unfortunately it is more complicated than what I can easily fix with my limited knowledge of packaging stuff. For .deb, the "5.1" is part of packaging names, which again is part of package dependencies. So it needs to be updated with correct names and "Replaces:", "Conflicts:", etc headers and so on. For .rpm the issue may be similar, not sure. Can you (or other from OurDelta) help me with this, or suggest the best way forward? - Kristian.

2 1

[Maria-developers] Updated (by Igor): Backport optimizations for derived tables and views (106)
by worklog-noreply＠askmonty.org 10 Mar '10

10 Mar '10

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Backport optimizations for derived tables and views CREATION DATE..: Wed, 10 Mar 2010, 22:16 SUPERVISOR.....: Monty IMPLEMENTOR....: Igor COPIES TO......: Igor, Monty, Psergey, Sanja, Sergei, Timour CATEGORY.......: Server-Sprint TASK ID........: 106 (http://askmonty.org/worklog/?tid=106) VERSION........: Server-9.x STATUS.........: Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: -=-=(Igor - Wed, 10 Mar 2010, 22:17)=-=- Title modified. --- /tmp/wklog.106.old.2763 2010-03-10 22:17:28.000000000 +0000 +++ /tmp/wklog.106.new.2763 2010-03-10 22:17:28.000000000 +0000 @@ -1 +1 @@ -Backport optimizations for derived tables and views. +Backport optimizations for derived tables and views -=-=(Igor - Wed, 10 Mar 2010, 22:17)=-=- Version updated. --- /tmp/wklog.106.old.2763 2010-03-10 22:17:28.000000000 +0000 +++ /tmp/wklog.106.new.2763 2010-03-10 22:17:28.000000000 +0000 @@ -1 +1 @@ -WorkLog-3.4 +Server-9.x DESCRIPTION: The goal of this task is to backport the implementation of the late materialization of derived tables and views and the additional optimizations for derived tables/views from MySQL 6.0 code line to MariaDB 5.3. Numerous bugs in the existing code concerning this functionality are to be fixed within this task. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Updated (by Igor): Backport optimizations for derived tables and views (106)
by worklog-noreply＠askmonty.org 10 Mar '10

10 Mar '10

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Backport optimizations for derived tables and views CREATION DATE..: Wed, 10 Mar 2010, 22:16 SUPERVISOR.....: Monty IMPLEMENTOR....: Igor COPIES TO......: Igor, Monty, Psergey, Sanja, Sergei, Timour CATEGORY.......: Server-Sprint TASK ID........: 106 (http://askmonty.org/worklog/?tid=106) VERSION........: Server-9.x STATUS.........: Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: -=-=(Igor - Wed, 10 Mar 2010, 22:17)=-=- Title modified. --- /tmp/wklog.106.old.2763 2010-03-10 22:17:28.000000000 +0000 +++ /tmp/wklog.106.new.2763 2010-03-10 22:17:28.000000000 +0000 @@ -1 +1 @@ -Backport optimizations for derived tables and views. +Backport optimizations for derived tables and views -=-=(Igor - Wed, 10 Mar 2010, 22:17)=-=- Version updated. --- /tmp/wklog.106.old.2763 2010-03-10 22:17:28.000000000 +0000 +++ /tmp/wklog.106.new.2763 2010-03-10 22:17:28.000000000 +0000 @@ -1 +1 @@ -WorkLog-3.4 +Server-9.x DESCRIPTION: The goal of this task is to backport the implementation of the late materialization of derived tables and views and the additional optimizations for derived tables/views from MySQL 6.0 code line to MariaDB 5.3. Numerous bugs in the existing code concerning this functionality are to be fixed within this task. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Updated (by Igor): Backport optimizations for derived tables and views (106)
by worklog-noreply＠askmonty.org 10 Mar '10

10 Mar '10

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Backport optimizations for derived tables and views CREATION DATE..: Wed, 10 Mar 2010, 22:16 SUPERVISOR.....: Monty IMPLEMENTOR....: Igor COPIES TO......: Igor, Monty, Psergey, Sanja, Sergei, Timour CATEGORY.......: Server-Sprint TASK ID........: 106 (http://askmonty.org/worklog/?tid=106) VERSION........: Server-9.x STATUS.........: Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: -=-=(Igor - Wed, 10 Mar 2010, 22:17)=-=- Title modified. --- /tmp/wklog.106.old.2763 2010-03-10 22:17:28.000000000 +0000 +++ /tmp/wklog.106.new.2763 2010-03-10 22:17:28.000000000 +0000 @@ -1 +1 @@ -Backport optimizations for derived tables and views. +Backport optimizations for derived tables and views -=-=(Igor - Wed, 10 Mar 2010, 22:17)=-=- Version updated. --- /tmp/wklog.106.old.2763 2010-03-10 22:17:28.000000000 +0000 +++ /tmp/wklog.106.new.2763 2010-03-10 22:17:28.000000000 +0000 @@ -1 +1 @@ -WorkLog-3.4 +Server-9.x DESCRIPTION: The goal of this task is to backport the implementation of the late materialization of derived tables and views and the additional optimizations for derived tables/views from MySQL 6.0 code line to MariaDB 5.3. Numerous bugs in the existing code concerning this functionality are to be fixed within this task. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Updated (by Igor): Backport optimizations for derived tables and views (106)
by worklog-noreply＠askmonty.org 10 Mar '10

10 Mar '10

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Backport optimizations for derived tables and views CREATION DATE..: Wed, 10 Mar 2010, 22:16 SUPERVISOR.....: Monty IMPLEMENTOR....: Igor COPIES TO......: Igor, Monty, Psergey, Sanja, Sergei, Timour CATEGORY.......: Server-Sprint TASK ID........: 106 (http://askmonty.org/worklog/?tid=106) VERSION........: Server-9.x STATUS.........: Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: -=-=(Igor - Wed, 10 Mar 2010, 22:17)=-=- Title modified. --- /tmp/wklog.106.old.2763 2010-03-10 22:17:28.000000000 +0000 +++ /tmp/wklog.106.new.2763 2010-03-10 22:17:28.000000000 +0000 @@ -1 +1 @@ -Backport optimizations for derived tables and views. +Backport optimizations for derived tables and views -=-=(Igor - Wed, 10 Mar 2010, 22:17)=-=- Version updated. --- /tmp/wklog.106.old.2763 2010-03-10 22:17:28.000000000 +0000 +++ /tmp/wklog.106.new.2763 2010-03-10 22:17:28.000000000 +0000 @@ -1 +1 @@ -WorkLog-3.4 +Server-9.x DESCRIPTION: The goal of this task is to backport the implementation of the late materialization of derived tables and views and the additional optimizations for derived tables/views from MySQL 6.0 code line to MariaDB 5.3. Numerous bugs in the existing code concerning this functionality are to be fixed within this task. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Updated (by Igor): Backport optimizations for derived tables and views (106)
by worklog-noreply＠askmonty.org 10 Mar '10

10 Mar '10

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Backport optimizations for derived tables and views CREATION DATE..: Wed, 10 Mar 2010, 22:16 SUPERVISOR.....: Monty IMPLEMENTOR....: Igor COPIES TO......: Igor, Monty, Psergey, Sanja, Sergei, Timour CATEGORY.......: Server-Sprint TASK ID........: 106 (http://askmonty.org/worklog/?tid=106) VERSION........: Server-9.x STATUS.........: Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: -=-=(Igor - Wed, 10 Mar 2010, 22:17)=-=- Title modified. --- /tmp/wklog.106.old.2763 2010-03-10 22:17:28.000000000 +0000 +++ /tmp/wklog.106.new.2763 2010-03-10 22:17:28.000000000 +0000 @@ -1 +1 @@ -Backport optimizations for derived tables and views. +Backport optimizations for derived tables and views -=-=(Igor - Wed, 10 Mar 2010, 22:17)=-=- Version updated. --- /tmp/wklog.106.old.2763 2010-03-10 22:17:28.000000000 +0000 +++ /tmp/wklog.106.new.2763 2010-03-10 22:17:28.000000000 +0000 @@ -1 +1 @@ -WorkLog-3.4 +Server-9.x DESCRIPTION: The goal of this task is to backport the implementation of the late materialization of derived tables and views and the additional optimizations for derived tables/views from MySQL 6.0 code line to MariaDB 5.3. Numerous bugs in the existing code concerning this functionality are to be fixed within this task. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Updated (by Igor): Backport optimizations for derived tables and views (106)
by worklog-noreply＠askmonty.org 10 Mar '10

10 Mar '10

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Backport optimizations for derived tables and views CREATION DATE..: Wed, 10 Mar 2010, 22:16 SUPERVISOR.....: Monty IMPLEMENTOR....: Igor COPIES TO......: Igor, Monty, Psergey, Sanja, Sergei, Timour CATEGORY.......: Server-Sprint TASK ID........: 106 (http://askmonty.org/worklog/?tid=106) VERSION........: Server-9.x STATUS.........: Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: -=-=(Igor - Wed, 10 Mar 2010, 22:17)=-=- Title modified. --- /tmp/wklog.106.old.2763 2010-03-10 22:17:28.000000000 +0000 +++ /tmp/wklog.106.new.2763 2010-03-10 22:17:28.000000000 +0000 @@ -1 +1 @@ -Backport optimizations for derived tables and views. +Backport optimizations for derived tables and views -=-=(Igor - Wed, 10 Mar 2010, 22:17)=-=- Version updated. --- /tmp/wklog.106.old.2763 2010-03-10 22:17:28.000000000 +0000 +++ /tmp/wklog.106.new.2763 2010-03-10 22:17:28.000000000 +0000 @@ -1 +1 @@ -WorkLog-3.4 +Server-9.x DESCRIPTION: The goal of this task is to backport the implementation of the late materialization of derived tables and views and the additional optimizations for derived tables/views from MySQL 6.0 code line to MariaDB 5.3. Numerous bugs in the existing code concerning this functionality are to be fixed within this task. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] New (by Igor): Backport optimizations for derived tables and views. (106)
by worklog-noreply＠askmonty.org 10 Mar '10

10 Mar '10

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Backport optimizations for derived tables and views. CREATION DATE..: Wed, 10 Mar 2010, 22:16 SUPERVISOR.....: Monty IMPLEMENTOR....: Igor COPIES TO......: Igor, Monty, Psergey, Sanja, Sergei, Timour CATEGORY.......: Server-Sprint TASK ID........: 106 (http://askmonty.org/worklog/?tid=106) VERSION........: WorkLog-3.4 STATUS.........: Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: DESCRIPTION: The goal of this task is to backport the implementation of the late materialization of derived tables and views and the additional optimizations for derived tables/views from MySQL 6.0 code line to MariaDB 5.3. Numerous bugs in the existing code concerning this functionality are to be fixed within this task. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0