----------------------------------------------------------------------- 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...: 21 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 24 PROGRESS NOTES: -=-=(Sanja - Fri, 13 Nov 2009, 10:55)=-=- Ported to maria 5.1 _ maria and partitioning support added and tested Worked 2 hours and estimate 0 hours remain (original estimate increased by 2 hours). -=-=(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)