Mantis Bugtracker

Viewing Issue Simple Details Jump to Notes ] View Advanced ] 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  
Status assigned   Product Version
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?
Additional Information
Tags No tags attached.
Attached Files

- Relationships

-  Notes
(0000038)
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