----------------------------------------------------------------------- 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)