|Anonymous | Login | Signup for a new account||2017-08-22 10:17 WEST|
|Main | My View | View Issues | Change Log | Roadmap | Docs | My Account|
|Viewing Issue Simple Details|
|ID||Category||Severity||Reproducibility||Date Submitted||Last Update|
|0000011||[MyDNS-NG] Global||feature||always||2008-09-21 19:31||2008-11-05 08:35|
|Summary||0000011: Statistics, Field with the number of requests for the record in rr table|
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?
|Tags||No tags attached.|
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.
|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|