From personal experience, if I had to start developing a PHP application that
involved databases there is no way I would do it without a framework. The
amount of library code that you will have to develop to handle even the basic
functions of an application that will soon become repetitive and
We have over 50 web applications using PHP & Firebird on Apache 2 web servers.
Some are deployed to be public facing Internet apps and others are private.
I've been developing these applications on Firebird SQL since about 2006. They
are reliable, fast and scale very well.
That said, there
I started to see this on one of our servers, and realized that the settings had
not been updated since installation. So I have increased semaphores to 128
which seems to have settled this down, but I'm wondering if anyone has any
settings for a higher number (ie. 500) that cover exactly what to
An update and a huge thank you to everyone for your input and help on this. I
spent most of yesterday writing Linux bash scripts and closing off ports on the
database server so I could run this from a remote SSH request from a web
server. I wrote a pretty extensive script library that will dro
Also one further question Do later versions of Firebird (ie. 3 or 4) have
any performance increase for cooperative garbage collection at all? Would I
expect to see any performance improvement by any newer version, or different
server implementation here?
Thanks
Myles
>That is your solution - but *do not delete those records*.
Thank you for the detailed reply, Helen. I can definitely execute a script to
drop all dependencies and then drop the table, and then rebuild them back in
via a CLI Linux script. I thought that was pretty extreme, but if this is the
>To me this sounds like the cooperative garbage collection kicks in when
you select from the table. You may want to consider dropping the table
entirely and recreating it. Alternatively, switch to SuperServer and set
its garbage collection policy to background (I believe this was
introduced in
I am attempting to debug some strange behavior on a large table that exhibits
the same problems on both FB 1.5 Classic and FB 2.5 Classic. This is on a
CentOS 7 server, with a ton of RAM and disk, etc.
The database has about 150 tables in it. One table is the culprit. All other
tables, st
Thanks Steve. That's interesting. I forgot about stopping xinetd. So if I
understand you right, you are suggesting the following:
1. Review all FB processes (ps -ax | grep fbserver) and kill -9 on those
2. Shutdown the service of xinetd
3. gfix to single user - then do maintenance
4.
Yes, but gfix refuses to shutdown the database to single user maintenance mode
if there are any existing connections to it. That is the main problem - I need
to kill those connections and prevent new ones from spawning so that I can
shutdown the database with gfix first.
Myles
HI everyone,
I have a large database on a dedicated server running on CentOS and I need to
run some maintenance tasks on it on a weekly basis. I've tried to write a cron
job to do most of this, which works just fine but one thing seems to constantly
get in the way...
End users (and end
Hi Karol, here's the gstat information I got once I was able to get the
database to effectively go into a tailspin when I finished updating that table:
The database:
Database header page information:
Flags 0
Checksum12345
G
Hi Karol, I'm going to run some tests on the database this weekend as I think I
know how to trigger this behavior. Once I get it to do that, I'll get the
results and post them.
Thanks
Myles
Hi Lester, I have definitely asked similar questions to the client. But they
have started to use this historical database for their own reporting, etc. and
that isn't its original purpose. Having said that, there is not an easy way to
identify changes, but I may talk to them further about whe
Thanks Mark. The nightly load process is triggered by the availability of the
source CSV file that is provided by a 3rd party, and we don't have that much
control over when this is produced. It is one of those things that the second
we get to access it, then the database has to begin the kill
Thanks Helen. Just a few clarifications, that might help whittle this down a
bit...
>Given that this table is "temporary" storage, one supposes that you
are deleting rows from it regularly. Do you happen to be deleting
900,000 rows each day before you load up the latest batch of 900,000?
Ye
Thank you for your comment. Very helpful. I ran gstat on the database, and on
the table in question. It is the default 16K page size. Are you saying that a
larger page size would be more appropriate? If so, how large would you
suggest? And is it correct that the only way to change the page
Thanks for your reply. The problem isn't that what you are saying *should* be
done. The problem is that this database has over 200 tables, and 1200 stored
procedures and the process to do it is long (ie. over a month of work likely).
I did manage to get a solution here by converting all store
I have a client with a Firebird 1.5 Classic server that is in the process of
being upgraded to a later version. The database is quite complex and this
upgrade will take some time. However the database has been working well for
the past 8 years, and just in the past few weeks we have seen somet
Firstly I realize I am asking for support on a very old Firebird version that
is no longer supported. However I'm in a situation where the upgrading of
these FB 1.5 databases to 3.x will take some time, and I need to get an interim
solution in place.
I have been successfully able to get F
Thank you. That is just what I needed.
Myles
Thank you. Do you happen to know the PPA address of those repositories for
Ubuntu 16.04? I haven't upgraded my development workstation to 18.04 yet (will
do that in the new year).
Thanks
Myles
There is reference to installing Firebird 2.5.x on Ubuntu on the website at
https://firebirdsql.org/manual/ubusetup.html
https://firebirdsql.org/manual/ubusetup.html but this information is very old.
The repository that is referenced does not seem to work with Ubuntu 18.04.
When I attempt to
Thank you so much for this information. Priceless!
I have a few older FB databases that will need upgrading to later versions.
They are pretty large, and most have between 500-1,000 stored procedures. Some
contain many tables with millions of rows of data. This is not likely to be a
small undertaking. Although I realize there are services ou
If you only need a single user instance of FB, you don't have to install
anything other than include the Firebird Embedded DLLs with your app and that's
it.
We have to produce a report for an external audit team of a large FB database
with over 120 tables and I was curious if there was any existing software tool
out there that could output the tables, stored procedures, etc. in the database
along with the number of rows in tables? Something that ba
We have a FB 1.56 classic server installation on CentOS 5 Linux 64 bit. We
have developed some UDFs for this that work very well using FreePascal, and are
contemplating something that will run as a UDF but will execute code that uses
REST to query an external data source (we can control ports,
28 matches
Mail list logo
