Re: [firebird-support] Re: Automating Firebird maintenance on Linux

Hi Myles, Yes, I believe we actually stopped xinetd first to prevent new connections from being made, then killed existing connections. When you connect to the database with xinetd stopped you have to connect using the local filesystem path, not the network path. -steve On Wed, Apr 17, 2019

Re: [firebird-support] Text search ...

Sorry, to be more clear we used lucene outside of firebird. We also happened to store specific information about the files in firebird. I stayed away from the lucene within firebird approach because the libraries seemed out of date and I wasn't sure on support. hope that helps -steve On Thu,

Re: [firebird-support] Text search ...

We have used tesseract-ocr and lucene (plus firebird for the index data) for this in the past. It works pretty well, but not completely out of the box -- you will have to tweak the image a bit. -steve On Wed, Mar 13, 2019 at 4:33 AM Lester Caine les...@lsces.co.uk [firebird-support] wrote: >

Re: [firebird-support] Re: replicating On Premise FB environment to AWS

1) How many of the processors are you actually using -- what is your load average? 2) How much of the memory are you using? 3) How much of the disk space are you using? How large is the database? 4) Are these multiple databases that can be split up into separate servers? Normally AWS seems to

Re: [firebird-support] Re: Firebird stopped after 190 connections

Are you seeing any error messages in /var/log/messages or from running dmesg? On Tue, Nov 7, 2017 at 5:37 AM, mirc...@gmail.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Isn't fb_inte_server the process for Firebird Classic? I'm using > superserver. The active process

Re: [firebird-support] gbak error

Can you show us the permissions of the directory that you are trying to write to? And also of the database file that you are trying to back up? And is there an existing fbk that you are trying to overwrite or is it a new file? And what user and group are you using to perform the gbak along with

Re: [firebird-support] Problems with connecting to Firebird 2.5.5 over TCP/IP on Linux (Ubuntu).

Also run 'netstat -an' to make sure you see port 3050 listening. If you don't then make sure you have xinetd running. -steve On Thu, Feb 25, 2016 at 11:17 AM, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 25 Feb 2016 08:15:12 -0800,

Re: [firebird-support] When to use Firebird 3 Classic

>From an IT operations side it is so nice and easy to run top on linux and see all of the processes for classic. For superserver and superclassic that is all mostly hidden in threads for a single process and you can't terminate a single thread through the OS tools in the case of an emergency.

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

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

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

Re: [firebird-support] Conditional where statements

Hi Alan, It might not be an elegant solution, but I think you could also union the same query together 8 times and have the where clause "short circuit" if it is not supposed to execute. I would love to hear if anyone has any better ideas though, as this slowdown is something we have also seen.

Re: [firebird-support] Re: FB 2.1 CS High FBLockPrint Mutex wait figure

I am also curious as to why you are seeing such high mutex wait percentages and would love to see some responses. During load testing of one of our systems we noticed the same thing, by migrating the test environment to SuperClassic 2.5.4 we were able to get better throughput over Classic 2.1.5

Re: [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0

FYI - We are running CentOS 6.5 with Firebird 2.5.4 SuperClassic and we are correctly getting the IP addresses in the monitoring tables. -steve On Tue, Jun 9, 2015 at 3:56 AM, Marianne Castel - Titelive caste...@titelive.be [firebird-support] firebird-support@yahoogroups.com wrote: Hello ,

Re: [firebird-support] large system slows over time

direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 8 May 2015 at 14:55, Steve Wiser st...@specializedbusinesssoftware.com [firebird-support] firebird-support@yahoogroups.com wrote: Hi Nick, My interpretation of those stats is that you are now out of memory as I always look

Re: [firebird-support] large system slows over time

Hi Nick, My interpretation of those stats is that you are now out of memory as I always look at the Swap Used. You aren't using any. My experience with Linux is that the OS will take as much memory as it can/needs so it can look like you are maxed out on RAM usage or something, but you really

Re: [firebird-support] Re: Performance of Stored Procedures versus execute blocks

On Thu, May 22, 2014 at 1:33 AM, Lafras Henning laf...@xietel.com[firebird-support] firebird-support@yahoogroups.com wrote: Hi Steve, Do you think the performance gains were mostly due to the elimination of the sub procedure, or mostly due the pure speed of the C functions? During testing

Re: [firebird-support] Performance of Stored Procedures versus execute blocks

On Sun, May 18, 2014 at 6:16 AM, laf...@xietel.com [firebird-support] firebird-support@yahoogroups.com wrote: 4) SQL statements run as byte code in a “virtual machine” and are just as as speed efficient(if not more so) at data and sting manipulation (Casting, concatenation, substing and