0000011: Statistics, Field with the number of requests for the record in rr table - Mantis

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.

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