Hi All,
1. Does anyone know if Firebird + DRBD is a thing or am I ploughing my
own furrow?
I have it working flawlessly for 5+ years here. DRBD + XFS + Firebird
Databases on 2 Cluster nodes with Heartbeat / Pacemaker.
The more interesting question is how database corruption will be
Ian,
My next test, hopefully tomorrow, will be to turn Forced Writes
off, and kill the link in the 5 second time between doing stuff and
the OS deciding to do anything with it, but I think I'm still on a
hiding to nothing unless I can get the packets to drop part way
through the
Hi Benny,
Look here
http://ib-aid.com/en/articles/cannot-commit-index-or-how-to-pump-data-from-partially-restored-inconsistent-database/
I suggest to insert fake record with ORDERID = 4127, and then try to
activate index.
Regards,
Alexey Kovyazin
IBSurgeon
Hi,
I have been an interbase guy
Hi All,
The Firebird Project is pleased to announce that the Firebird 2.5
Language Reference is now available in Russian. It can be downloaded via
the Firebird SQL documentation page
http://www.firebirdsql.org/en/reference-manuals/
Why is it only available in Russian? Moscow Exchange
Hi,
I want to replace my Firebird 32 1.5.6 with the last Firebird 64 2.5.3,
http://www.slideshare.net/ibsurgeon/firebird-migration-from-firebird-15-to-firebird-25
Regards,
Alexey Kovyazin
IBSurgeon
Hi Bill,
If your application and database are the same and and you using them in
the same manner with the same Firebird configuration
(http://ib-aid.com/en/optimized-firebird-configuration/), the difference
in performance is always explained by hardware - either hardware problem
(like
Jan,
Yes that would probably be a better choice for us, but we cannot
bundle IBFirstAId together with our application. Will however download
it and try it on files to got sent to us.
Actually, current version of FirstAID which is available at our web site
is a full version, but it requests
Hello,
If you have moved or deleted .delta-file, you got the correct message.
If delta file was corrupted, or database was corrupted in the way which
prevent merge, there could be various error messages.
Check your database with gfix -v -full now, to be sure it's Ok.
Is it risky to run a
Hi Jan,
You did not tell what kind of corruption you had (please provide full
text of error). There are plenty of them, as well as reasons.
You also could use our tool FirstAID (Direct) to analyze database on low
level and see where are the problems.
Regards,
Alexey Kovyazin
IBSurgeon
Hi Russel,
Good starting point could be our optimized configuration files:
http://ib-aid.com/en/optimized-firebird-configuration/
Regards,
Alexey Kovyazin
IBSurgeon
What type of access (read vs. write mix) are you expecting? Mainly write
What mix of small vs. large queries are you expecting?
Hi,
Ï am not sure that Dmitry wins here, since original question is not 100%
correct.
Cache is always per server process - each server process has own cache,
in all architectures, and difference is in connection/server process model.
So, SuperClassic is like Classic in terms of usage - the
Hi,
Try to open database with FirstAID Extractor (it's free) and check is
there data you are looking inside.
Regards,
Alexey Kovyazin
IBSurgeon
I have a Firebird 2.5.2 database (ODS 11.2). The database has
corrupted. When I open the database, I receive a message
page 1577 is
Hi Stefano,
To decrease database size you need to make backup/restore.
Then, to keep its growth under control, you need to perform the
following maintenance procedure:
1) stop Firebird server and then start it immediately (less than 3 sec
downtime).
2) run
gfix -sweep -user SYSDBA -pass
Hi Jonathan,
Most likely you have different firebird.conf.
Align them and check again.
Regards,
Alexey Kovyazin
Hi!
I have different Firebird instances/databases, one is running on
Windows, another on Linux (the servers have different RAM amount as
well). The execution of the same SQL code
Halim,
Ok, thank you.
1.5 is really old, upgrade asap.
Regards,
Alexey Kovyazin
Hi Alexey,
Here is where I read it. Page 7. PPT Presentation during FDD 2012, Brazil.
http://www.slideshare.net/ibsurgeon/resolving-firebird-performance-problems#
Keep in mind, we are still using 1.5 FB.
Thank
Hi Halim,
Try to use optimized configuration file for Firebird 1.5 Classic:
http://ib-aid.com/optimized-firebird-configuration
Regards,
Alexey Kovyazin
IBSurgeon
Here is the link to the zip file: http://ge.tt/1raCY2i1/v/0?c
Thank you,
-Halim
To: firebird-support@yahoogroups.com
From:
Hi Halim,
firebird-support does not allow attachments. Please put zip with info to
some sharing service like ge.tt, and post link here.
Regards,
Alexey Kovyazin
IBSurgeon
Please see attached zip file with questionnaire response regarding our server
performance.Also, I have attached restore
Hi,
In order to give you a good optimization advice, please answer the
following questions:
http://ib-aid.com/en/articles/required-information-for-firebird-database-performance-optimization/
Regards,
Alexey Kovyazin
IBSurgeon
Thank you for your reply.
I used default restore settings and I
Hi Ann,
Unfortunately, we did not receive your email to supp...@ib-aid.com or to
ibanal...@ib-aid.com.
Services API works through the same port (3050 by default), as all
connections.
Regarding IBAnalyst connection - most likely you don't have correct
version of client library in path, and
101 - 119 of 119 matches
Mail list logo