This worklog has been replaced with mariadb.org/jira

This site is here for historical purposes only. Do not add or edit tasks here!

 
 
 

WorkLog Frontpage Log in / Register
High-Level Description | Task Dependencies | High-Level Specification | Low-Level Design | File Attachments | User Comments | Time Estimates | Funding and Votes | Progress Reports

 Avoid flushing keycache to disk in case of DROPping table
Title
Task ID53
Queue
Version
Status
Priority
Copies to
Created bySanja27 Aug 2009Done
Supervisor   
Lead Architect    
Architecture Review  
Implementor  
Code Review  
QA  
Documentation  
 High-Level 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.
 Task Dependencies
Others waiting for Task 53Task 53 is waiting forGraph
 
 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.
 Low-Level Design
 File Attachments
 NameTypeSizeByDate
 User Comments
 Time Estimates
NameHours WorkedLast Updated
Sanja2113 Nov 2009
Total21 
 Hrs WorkedProgressCurrentOriginal
This Task21024
Total21024
 
 Funding and Votes
Votes: 0: 0%
 Make vote: Useless    Nice to have    Important    Very important    

Funding: 0 offers, total 0 Euro
 Progress Reports
(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.


Report Generator:
 
Saved Reports:

WorkLog v4.0.0
  © 2010  Sergei Golubchik and Monty Program AB
  © 2004  Andrew Sweger <yDNA@perlocity.org> and Addnorya
  © 2003  Matt Wagner <matt@mysql.com> and MySQL AB