← Back to team overview

maria-developers team mailing list archive

Progress (by Sanja): Avoid flushing keycache to disk in case of DROPping DATABASE (56)

 

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: Avoid flushing keycache to disk in case of DROPping DATABASE
CREATION DATE..: Thu, 15 Oct 2009, 17:35
SUPERVISOR.....: Monty
IMPLEMENTOR....: Sanja
COPIES TO......: 
CATEGORY.......: Server-Sprint
TASK ID........: 56 (http://askmonty.org/worklog/?tid=56)
VERSION........: Server-5.1
STATUS.........: Code-Review
PRIORITY.......: 60
WORKED HOURS...: 3
ESTIMATE.......: 1 (hours remain)
ORIG. ESTIMATE.: 3

PROGRESS NOTES:

-=-=(Sanja - Thu, 15 Oct 2009, 17:38)=-=-
Patch is done and testsed (tested that we do not flush and we mark tables as damaged before deleting
them)

Worked 3 hours and estimate 1 hour remain (original estimate increased by 1 hour).

-=-=(Sanja - Thu, 15 Oct 2009, 17:36)=-=-
Low Level Design modified.
--- /tmp/wklog.56.old.7415      2009-10-15 17:36:57.000000000 +0300
+++ /tmp/wklog.56.new.7415      2009-10-15 17:36:57.000000000 +0300
@@ -1 +1,2 @@
-
+mark tables of the database as deleting when we remove them from table cache
+(before removing from keycache).

-=-=(Sanja - Thu, 15 Oct 2009, 17:35)=-=-
High-Level Specification modified.
--- /tmp/wklog.56.old.7269      2009-10-15 17:35:57.000000000 +0300
+++ /tmp/wklog.56.new.7269      2009-10-15 17:35:57.000000000 +0300
@@ -1 +1 @@
-
+Mark the tables as deleting,



DESCRIPTION:

When DROP DATABASE executed keycache of tables of the database flushed to disk
before removing table which is wasting of resources. So better to have table
removed from keycache without writing changes on disk as it was done for DROP TABLE.


HIGH-LEVEL SPECIFICATION:



Mark the tables as deleting,


LOW-LEVEL DESIGN:



mark tables of the database as deleting when we remove them from table cache
(before removing from keycache).


ESTIMATED WORK TIME

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