Mantis Bugtracker

Viewing Issue Advanced Details Jump to Notes ] View Simple ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000011 [MyDNS-NG] Global feature always 2008-09-21 19:31 2008-11-05 08:35
Reporter jorge View Status public  
Assigned To howardwilkinson
Priority normal Resolution open Platform
Status assigned   OS
Projection none   OS Version
ETA none Fixed in Version Product Version
  Target Version 1.3.0 Product Build
Summary 0000011: Statistics, Field with the number of requests for the record in rr table
Description Hi Howard,
How about a field in the rr table, where every time a request if made for the record, an sql query like "update rr set requests=requests+1;", this way, having a statistic on how many times this record was served?
Steps To Reproduce
Additional Information
Tags No tags attached.
Attached Files

- Relationships

-  Notes
howardwilkinson (administrator)
2008-11-05 08:35

This is a "nice to have" which probably will not appear until I redo the cache code to allow multi-threaded and multi-process caches. Currently the effect would be to take a write lock in each process whenever the cache needs feeding. This would then cause retries to stack up the processes on the database.

My target architecture is to have a tiered cache with a shared central cache that is fed from the database(s), Once this is implemented I can introduce a statistics section in the cache which can record both record lookups and also database fetches.

I would be inclined to save this on a lazy update cycle, so that it does not introduce real time updates into the query path - so requires som e careful thought.

- Issue History
Date Modified Username Field Change
2008-09-21 19:31 jorge New Issue
2008-09-21 19:31 jorge Status new => assigned
2008-09-21 19:31 jorge Assigned To => howardwilkinson
2008-11-05 08:35 howardwilkinson Note Added: 0000038

Mantis 1.1.6[^]
Copyright © 2000 - 2008 Mantis Group
Powered by Mantis Bugtracker