← Back to team overview

maria-developers team mailing list archive

Progress (by Sanja): Avoid flushing keycache to disk in case of DROPping table (53)

 

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: Avoid flushing keycache to disk in case of DROPping table
CREATION DATE..: Thu, 27 Aug 2009, 11:12
SUPERVISOR.....: Monty
IMPLEMENTOR....: Sanja
COPIES TO......: 
CATEGORY.......: Server-Sprint
TASK ID........: 53 (http://askmonty.org/worklog/?tid=53)
VERSION........: Server-5.0
STATUS.........: Complete
PRIORITY.......: 60
WORKED HOURS...: 19
ESTIMATE.......: 0 (hours remain)
ORIG. ESTIMATE.: 24

PROGRESS NOTES:

-=-=(Sanja - Fri, 13 Nov 2009, 00:24)=-=-
Ported to mysql 5.1 and tested

Worked 5 hours and estimate 0 hours remain (original estimate increased by 5 hours).

-=-=(Sanja - Tue, 06 Oct 2009, 12:30)=-=-
Status updated.
--- /tmp/wklog.53.old.27223     2009-10-06 12:30:38.000000000 +0300
+++ /tmp/wklog.53.new.27223     2009-10-06 12:30:38.000000000 +0300
@@ -1 +1 @@
-Assigned
+Complete

-=-=(Sanja - Tue, 06 Oct 2009, 12:30)=-=-
After review fixes and tests.

Worked 1 hour and estimate 0 hours remain (original estimate decreased by 10 hours).

-=-=(Sanja - Thu, 03 Sep 2009, 19:43)=-=-
New patch and its testing

Worked 8 hours and estimate 11 hours remain (original estimate unchanged).

-=-=(Sanja - Tue, 01 Sep 2009, 15:20)=-=-
moving to 5.0 part1

Worked 2 hours and estimate 19 hours remain (original estimate unchanged).

-=-=(Sanja - Tue, 01 Sep 2009, 15:19)=-=-
first patch

Worked 3 hours and estimate 21 hours remain (original estimate unchanged).

-=-=(Sanja - Thu, 27 Aug 2009, 11:15)=-=-
High-Level Specification modified.
--- /tmp/wklog.53.old.23490     2009-08-27 11:15:24.000000000 +0300
+++ /tmp/wklog.53.new.23490     2009-08-27 11:15:24.000000000 +0300
@@ -1 +1,3 @@
-
+To make special handler call 'prepare to drop' which mark table as changed (in
+case of server crash just before removing table it force table to be repaired)
+then flush keycache without writing on disk.



DESCRIPTION:

When DROP TABLE executed keycache flushed to disk before removing table which is
wasting of resources. So better to have table removed from keycache without
writing changes on disk.


HIGH-LEVEL SPECIFICATION:



To make special handler call 'prepare to drop' which mark table as changed (in
case of server crash just before removing table it force table to be repaired)
then flush keycache without writing on disk.


ESTIMATED WORK TIME

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