Indeed... If only we had time to do it... :( But we are really thinking about that. Cheers, Nicolas
Le ven. 12 juil. 2019 à 09:52, Andrea Aime <[email protected]> a écrit : > On Fri, Jul 12, 2019 at 8:41 AM Nicolas Fagart <[email protected]> > wrote: > >> >> The idea is to create your own Monitor class implementing the interface >> javax.servlet.Filter >> For information, in our implementation, we manage an equivalent 'request' >> table (same as the standard Monitor table + few additional columns) to >> store all single requests in the DB. >> But the process also archive weekly the requests in another 'archive' >> table (aggregated by day/user/resource/ip...) to merge the *Tile >> Requests* >> So the 'request' table keep only the requests for the last month to avoid >> to increase dramatically. >> >> Also to limit the number of database queries, our Monitor track all HTTP >> request, but keep that in memory on the Filter App and flush all the >> requests (asynchronously) in the database every 3 or 5 minutes. And that >> made a huge difference (before we could have thousands of requests every >> minutes). >> > > Sounds like it would make for a nice extension module, if you wanted to > contribute and maintain it :-) > > Cheers > Andrea > > == > > GeoServer Professional Services from the experts! Visit > http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf > Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa > (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 > http://www.geo-solutions.it http://twitter.com/geosolutions_it > ------------------------------------------------------- *Con riferimento > alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - > Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni > circostanza inerente alla presente email (il suo contenuto, gli eventuali > allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i > destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per > errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le > sarei comunque grato se potesse darmene notizia. This email is intended > only for the person or entity to which it is addressed and may contain > information that is privileged, confidential or otherwise protected from > disclosure. We remind that - as provided by European Regulation 2016/679 > “GDPR” - copying, dissemination or use of this e-mail or the information > herein by anyone other than the intended recipient is prohibited. If you > have received this email by mistake, please notify us immediately by > telephone or e-mail.* >
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
