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

 Query statistics
Title
Task ID219
Queue
Version N/A
Status
PriorityN/A
Copies toSergei

Created byMonty30 Jun 2011Done
Supervisor N/A  
Lead Architect    
Architecture Review  
Implementor  
Code Review  
QA  
Documentation  
 High-Level Description
Log skeletons for queries in server (live from parser) but without constants
with statistics.

Things to consider:

* Should use a fixed memory size. Queries should be removed as FIFO
* Small CPU overhead
* IN(a,b,c) should be equal recorded as IN(#) (One constant)
* multi row inserts needs to be handled as one insert.

We also need a method to do regular expression replacement for table names. This
is needed to be able to recognize similar tables like log tables with a _YYMMDD
prefix.

Statistics to collect per query:
- Number of times executed
- Total time executed (in microseconds)
- Rows read, inserted, updated and deleted.

 Task Dependencies
Others waiting for Task 219Task 219 is waiting forGraph
 
 High-Level Specification
 Low-Level Design
 File Attachments
 NameTypeSizeByDate
 User Comments
 Time Estimates
NameHours WorkedLast Updated
Total0 
 Hrs WorkedProgressCurrentOriginal
This Task0120120
Total0120120
 
 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, 30 Jun 2011, 18:05
    
Observers changed: Sergei


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