← Back to team overview

maria-developers team mailing list archive

Updated (by Fromdual): dynamic versionning of query plan for performance metric and downgrade . (33)

 

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: dynamic versionning of query plan for performance metric and downgrade
		. 
CREATION DATE..: Tue, 30 Jun 2009, 21:37
SUPERVISOR.....: Bothorsen
IMPLEMENTOR....: 
COPIES TO......: 
CATEGORY.......: Server-RawIdeaBin
TASK ID........: 33 (http://askmonty.org/worklog/?tid=33)
VERSION........: WorkLog-3.4
STATUS.........: Un-Assigned
PRIORITY.......: 30
WORKED HOURS...: 0
ESTIMATE.......: 0 (hours remain)
ORIG. ESTIMATE.: 0

PROGRESS NOTES:

-=-=(Fromdual - Tue, 30 Jun 2009, 21:53)=-=-
High Level Description modified.
--- /tmp/wklog.33.old.14359     2009-06-30 21:53:31.000000000 +0300
+++ /tmp/wklog.33.new.14359     2009-06-30 21:53:31.000000000 +0300
@@ -3,11 +3,13 @@
 A lot of internal SUN/ORACLE benchmarks are reporting performance improvements.
 But they are only tested on specific workload and predefined scenario like DBT2. 
 
-MariaDb should provide dynamique QP and provide a ratio of  efficiency in regard
-with the number of handler operations, each user would so on, be able to found
-out, if an improvement or a bug in the data acess path match is wokload . With
-such feature 5.0 to 5.1 would have found an inconsistant ratio of 2 to 1/1000
-with a serious fluctuation on time depending on closing , reopening , reclosing
-and reopening bugs like
+MariaDb could provide dynamic variable QP_vesion = 41|50|51 ...   
+
+providing benchmarks with a ratio of efficiency in regard with the number of
+handler operations, each user would so on, be able to found if an improvement or
+a bug in the data acess path match is wokload . 
+With such feature 5.0 to 5.1 migration would have provide an inconsistant metric
+of 2 to 1/1000 with a serious fluctuation on time depending on closing ,
+reopening , reclosing and reopening bugs like
 
 http://bugs.mysql.com/bug.php?id=28404

-=-=(Fromdual - Tue, 30 Jun 2009, 21:44)=-=-
Title modified.
--- /tmp/wklog.33.old.13936     2009-06-30 21:44:50.000000000 +0300
+++ /tmp/wklog.33.new.13936     2009-06-30 21:44:50.000000000 +0300
@@ -1 +1 @@
-Dynamique versionning of query plan for performance metric and downgrade . 
+dynamic versionning of query plan for performance metric and downgrade . 



DESCRIPTION:

Just for comparing apple and oranges , 

A lot of internal SUN/ORACLE benchmarks are reporting performance improvements.
But they are only tested on specific workload and predefined scenario like DBT2. 

MariaDb could provide dynamic variable QP_vesion = 41|50|51 ...   

providing benchmarks with a ratio of efficiency in regard with the number of
handler operations, each user would so on, be able to found if an improvement or
a bug in the data acess path match is wokload . 
With such feature 5.0 to 5.1 migration would have provide an inconsistant metric
of 2 to 1/1000 with a serious fluctuation on time depending on closing ,
reopening , reclosing and reopening bugs like

http://bugs.mysql.com/bug.php?id=28404


ESTIMATED WORK TIME

ESTIMATED COMPLETION DATE
-----------------------------------------------------------------------
WorkLog (v3.5.9)