[firebird-support] MON$IO_Stats and prepared statements

2015-11-18 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
All, We are investigating a client report of performance problems and are looking at the MON$IO_Stats values but they look very large. We are wondering if for prepared statements the values represent the total of all uses/executions of the prepared statement or just the last run. All answer

[firebird-support] Re: MON$IO_Stats and prepared statements

2015-11-18 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
18.11.2015 19:39, 'Leyne, Sean' s...@broadviewsoftware.com wrote: > > We are investigating a client report of performance problems and are > looking at the MON$IO_Stats values but they look very large. > We are wondering if for prepared statements the values represent the > total of all

[firebird-support] Firebird for a web application

2015-11-18 Thread mirco.malag...@ingeniaonline.it [firebird-support]
Hi all here, I want to ask some question about using Firebird in a production environment for a web application. My experience is more then 12 years with Firebird for our client server application and have to say is a very good experience. Now that application is being ported to web by a

Re: [firebird-support] Firebird for a web application

2015-11-18 Thread Steve Wiser st...@specializedbusinesssoftware.com [firebird-support]
Hi Mirco, We have written multiple java EE web applications with Firebird on linux as the database. Usually we will use Glassfish (or Payara) as the app server and run Firebird in classic or superclassic form. We will usually use Nagios to monitor the servers and databases. My only complaint

Re: [firebird-support] Firebird for a web application

2015-11-18 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Steve, What kind of monitoring are you doing with Nagios? Do you mean this plugin? http://exchange.nagios.org/directory/Plugins/Databases/check_firebird-2Epy/details Normally, Firebird monitoring should include: 1) Transactions monitoring, including long-running and stuck transactions 2) #

Re: [firebird-support] Firebird for a web application

2015-11-18 Thread Steve Wiser st...@specializedbusinesssoftware.com [firebird-support]
Hi Alexey, No, we do not use the firebird plugin for nagios, and we don't check for as many things that you mention! We are doing basic server checks and then just making sure the DB can be connected to. Each night we make sure the restores worked fine and the database contains some of the