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

 Add a mysqlbinlog option to filter certain kinds of statements
Title
Task ID41
Queue
Version N/A
Status
PriorityN/A
Copies to
Created byPsergey10 Aug 2009Done
Supervisor N/A  
Lead Architect    
Architecture Review  
Implementor  
Code Review  
QA  
Documentation  
 High-Level Description
Add a mysqlbinlog option to filter certain kinds of statements, i.e. (syntax
subject to discussion):

  mysqlbinlog --exclude='alter table,drop table,alter database,...'
 Task Dependencies
Others waiting for Task 41Task 41 is waiting forGraph
 
 High-Level Specification
The implementation will depend on design choices made in WL#40:

Option 1:

If we decide to parse the statement, SQL-verb filtering will be trivial

Option 2:
If we decide not to parse the statement, we still can reliably distinguish the
statement by matching the first characters against a set of patterns.

If we chose the second, we'll have to perform certain normalization before
matching the patterns:
 - Remove all comments from the command
 - Remove all pre-space
 - Compare the string case-insensitively
 - etc

Option 3:

Server-side support for ignoring certain statements:

  SET SESSION ignored_statements="alter table, analyze table, ...";
 Low-Level Design
 File Attachments
 NameTypeSizeByDate
 User Comments
 Time Estimates
NameHours WorkedLast Updated
Total0 
 Hrs WorkedProgressCurrentOriginal
Total000
 
 Funding and Votes
Votes: 0: 0%
 Make vote: Useless    Nice to have    Important    Very important    
Funding: 0 offers, total 0 Euro
 Progress Reports
(Sergei - Thu, 01 Jul 2010, 06:01) 
    
Version updated.
No change.
(Sergei - Thu, 01 Jul 2010, 06:01) 
    
Category updated.
--- /tmp/wklog.41.old.28386	2010-07-01 06:01:38.000000000 +0000
+++ /tmp/wklog.41.new.28386	2010-07-01 06:01:38.000000000 +0000
@@ -1 +1 @@
-Server-RawIdeaBin
+Client-RawIdeaBin
(Sergei - Thu, 01 Jul 2010, 06:01) 
    
Category updated.
--- /tmp/wklog.41.old.28374	2010-07-01 06:01:21.000000000 +0000
+++ /tmp/wklog.41.new.28374	2010-07-01 06:01:21.000000000 +0000
@@ -1 +1 @@
-Client-RawIdeaBin
+Server-RawIdeaBin
(Sergei - Thu, 01 Jul 2010, 06:01) 
    
Version updated.
--- /tmp/wklog.41.old.28374	2010-07-01 06:01:21.000000000 +0000
+++ /tmp/wklog.41.new.28374	2010-07-01 06:01:21.000000000 +0000
@@ -1 +1 @@
-Benchmarks-3.0
+9.x
(Guest - Thu, 17 Jun 2010, 00:38) 
    
Dependency deleted: WL#39 no longer depends on WL#41
(Knielsen - Mon, 05 Oct 2009, 10:05) 
    
Category updated.
--- /tmp/wklog.41.old.24136	2009-10-05 10:05:02.000000000 +0300
+++ /tmp/wklog.41.new.24136	2009-10-05 10:05:02.000000000 +0300
@@ -1 +1 @@
-Client-BackLog
+Client-RawIdeaBin
(Knielsen - Mon, 17 Aug 2009, 13:56) 
    
High-Level Specification modified.
--- /tmp/wklog.41.old.10632	2009-08-17 13:56:52.000000000 +0300
+++ /tmp/wklog.41.new.10632	2009-08-17 13:56:52.000000000 +0300
@@ -14,3 +14,10 @@
  - Remove all pre-space
  - Compare the string case-insensitively
  - etc
+
+Option 3:
+
+Server-side support for ignoring certain statements:
+
+  SET SESSION ignored_statements="alter table, analyze table, ...";
+
(Knielsen - Fri, 14 Aug 2009, 14:17) 
    
High-Level Specification modified.
--- /tmp/wklog.41.old.6963	2009-08-14 14:17:32.000000000 +0300
+++ /tmp/wklog.41.new.6963	2009-08-14 14:17:32.000000000 +0300
@@ -1,6 +1,11 @@
 The implementation will depend on design choices made in WL#40:
-- If we decide to parse the statement, SQL-verb filtering will be trivial
-- If we decide not to parse the statement, we still can reliably distinguish the
+
+Option 1:
+
+If we decide to parse the statement, SQL-verb filtering will be trivial
+
+Option 2:
+If we decide not to parse the statement, we still can reliably distinguish the
 statement by matching the first characters against a set of patterns.
 
 If we chose the second, we'll have to perform certain normalization before
(Psergey - Mon, 10 Aug 2009, 15:47) 
    
High-Level Specification modified.
--- /tmp/wklog.41.old.13282	2009-08-10 15:47:13.000000000 +0300
+++ /tmp/wklog.41.new.13282	2009-08-10 15:47:13.000000000 +0300
@@ -2,3 +2,10 @@
 - If we decide to parse the statement, SQL-verb filtering will be trivial
 - If we decide not to parse the statement, we still can reliably distinguish the
 statement by matching the first characters against a set of patterns.
+
+If we chose the second, we'll have to perform certain normalization before
+matching the patterns:
+ - Remove all comments from the command
+ - Remove all pre-space
+ - Compare the string case-insensitively
+ - etc
(Psergey - Mon, 10 Aug 2009, 15:35) 
    
High-Level Specification modified.
--- /tmp/wklog.41.old.12689	2009-08-10 15:35:04.000000000 +0300
+++ /tmp/wklog.41.new.12689	2009-08-10 15:35:04.000000000 +0300
@@ -1 +1,4 @@
-
+The implementation will depend on design choices made in WL#40:
+- If we decide to parse the statement, SQL-verb filtering will be trivial
+- If we decide not to parse the statement, we still can reliably distinguish the
+statement by matching the first characters against a set of patterns.
-- View All Progress Notes (11 total) --
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