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
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 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 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:
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 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
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,
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,
Ï 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 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 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
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
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
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
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 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 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,
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 Andre,
- get some sleep
This is the key to find a solution, never optimize anything in a bad mood :)
WinSrv2008R2 is a perfect Windows Server, when properly configured.
Regards,
Alexey
Hi,
All architectures of 32 bit Firebird will work bad at 64 bit Windows
with mem4GB, fixed in 2.52 only
It is fixed in 2.1.5, 2.5.2 and 3.0.
2.0 does not have this fix, end of life was announced.
The problem is described here
Hi All,
We invite all Firebird developers and administrators to 1-day seminar in
the frames of Firebird 2015 Tour. Firebird 2015 Tour is devoted to the
SQL performance optimization: SQL plans, queries and database
statistics, query tuning techniques and deep understanding of undercover
Hi Walter,
I have just one doubt, and it is with page 46.
Do you mean Record versions visibility?
Regards,
Alexey
Hi Walter,
On slide 46 of http://www.slideshare.net/ibsurgeon/3-how-transactionswork
we consider how transaction 20 view record versions.
It's important to note that transaction 20 is a snapshot.
Tx16 did the INSERT?
Yes, it created original version of Record 1.
Tx12 can do a COMMIT although
Hi Hugo,
So if the computer is shutdown during a nbackup the database is locked
in this way indefinelty?
Yes, it's one of the most prevalent problems with nbackup.
To prevent it you need to monitor delta file age and size - manually, or
automatically using our FBDataGuard tool.
What
Hi,
Unfortunately, your experiments are not useful at all, since you are
using complex GUI tools, which run background queries in the frames of
implicit transactions to get metadata information, etc.
If you really want to do clean experiments with Firebird transactions,
use only isql.exe, and
Hi,
There is a fix in 254 snapshot for similar problem.
Download fresh 2.5.4 Firebird snapshot and try it.
Regards,
Alexey Kovyazin
IBSurgeon
Firebird Recovery service:
http://ib-aid.com/en/firebird-interbase-recovery-service/
Database Performance optimization:
Hi Josef,
Such error is the consequence of the corruption - in the original
database there was a NULL in the field (most likely, all fields in that
record are NULL).
gbak does not check constraints when reading.
The best way to fix it is to find record with NULLs in the original
database
Hi Bruce,
DBInfo from IBSurgeon Free Tools
(http://ib-aid.com/en/ibsurgeon-free-tools/) will give you database
pages statistics.
Regards,
Alexey Kovyazin
IBSurgeon
Hi guys.
I know that I need to use gstat, and I know that I have detailed
description about it here: Gstat Examples And
Hi Bruce,
To view size of tables and indices you need to use our IBAnalyst tool
(http://ib-aid.com/en/ibanalyst/).
Regards,
Alexey Kovyazin
IBSurgeon
Thank you Alexey.
This is nice tool, however it does not show how much space is taken by
given table and its indices... I am sure this
Hi Tim,
2.1 series was discontinued, so nobody will invest in tools for it.
Instead of this, consider migration - 2.1 is pretty close to 2.5, where
TraceAPI is available.
Regards,
Alexey Kovyazin
IBSurgeon
I've just discovered MON$CALL_STACK, and it seems possible that one
could use this
Hi,
It is a typical corruption usually caused by Firebird abnormal termination due
to power outage.
You can fix it with IBSurgeon FirstAID more details at www.ib-aid.com
Regards,
Alexey Kovyazin
IBSurgeon
16 июня 2015 г. 6:50 пользователь Nagy Szilveszter nagy_szilvesz...@yahoo.com
Hi Jojakim,
Can you please do the following - download FBMonLogger trial from
http://ib-aid.com/en/fbmonlogger/
install it, run it, connect to the database and make snapshot of MON$.
It will grab all information from MON$ tables and store it to the disk
(you will be requested to select
Hi,
You can use IBDataPump free tool. It allows data pumping between exact
databases or using custom Select queries.
Regards,
Alexey Kovyazin
IBSurgeon
Hi there,
I am new to firebird and need to manipulate or merge two firebird
databases. The tables should be the same format but I need to
Hi,
Please provide full error text and detailed description of the problem.
Regards,
Alexey Kovyazin
IBSurgeon
Hi all
I experience the same problem.
Is there a tutorial to track theese kind of problems?
tks
Razvan
Hi,
Probably you mean Lock conflict, not a true deadlock (full error text
will help).
If you see transaction number in the message, you can track it using
MON$ tables, and then find out which connection has started it.
Regards,
Alexey Kovyazin
IBSurgeon
Hi All
If possible at all, how
Hi,
OAT is an active transaction. You can see it alive if you analyze MON$
snaphot (you can use trial of our FBMonLogger).
So, disconnects are not related with Next-OAT gap - because this gap is
caused by some open transaction which you can easily identify.
However, disconnects can lead
Hi Virgo,
You should be able to connect to this database with your Firebird
(except 3.0).
There could be incompatibilities, of course, like reserved words (YEAR,
TYPE), but in general it should work for simple SELECT * FROM table.
Regards,
Alexey Kovyazin
IBSurgeon
www.ib-aid.com
It is
Hi All,
The Firebird Docs team is calling for people who are fluent in both
English and Firebird's SQL to assist with reviewing the English text of
the Firebird 2.5 Language Reference manual.
Of 10 chapters and 8 Appendices, 4.5 chapters are still untouched by
reviewers. It would be
Hi,
this is a known bug with Services API in 2.5.3 and 2.5.5.
We had the same problem with our HQbird FBDataGuard, and with our report
it was fixed in 255.
Use 2.5.5 - it has this fix, and it is in pre-release state, and in
general it's much more stable than 2.5.3 and 2.5.4.
Regards,
Hi,
Try IBReplicator (commercial) instead.
Regards,
Alexey Kovyazin
IBSurgeon
I've downloaded the FB Replicator and tryed it on my database. When I
want to add it as a souce database I enter path to the DB user pass
and click save, but it gives me the following error:
ISC ERROR CODE:
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) #
Hi Hernado,
You are the third person during several days with this question.
Can you please post the full error text?
Otherwise it is not possible to provide any help.
Regards,
Alexey
Hi to all,
From several days ago we are having trouble with Lock conflict on no
wait transaction on a
Hi,
I can do regular backup with gbak but i look for some smarter solution
to.
To backup any of the databases with VM snapshots or similar mechanisms a
series of special preparation and post-backup steps must be fulfilled,
or database should be in archivelog (Oracle) mode.
You can use
Hi Hector,
I discovered something else quite interesting:
I realized both IB and FB dbs have pagebuffers set to 100.000. I
changed FB to 0 and now it works like I expected!!..Same query now
completes on FB on 50 sec. It seems this is the problem although I
don't understand why.
100 000 is
always disable
system cache
Regards,
Karol Bieniaszewski
Oryginalna wiadomość
Od: "Alexey Kovyazin a...@ib-aid.com [firebird-support]"
<firebird-support@yahoogroups.com>
Data: 05.09.2015 19:06 (GMT+01:00)
Do: firebird-support@yahoogroups.com
Temat: Re: [firebir
Hi Neil,
Run DBInfo from IBSurgeon Free tools and check what pages are there.
I suppose there are many TIPS, which indicate transactions.
Verify it with gstat -h transaction markers values.
Regards,
Alexey Kovyazin
IBSurgeon
Hello
Something I have noticed with Firebird v2.1 with Windows 32
Hi,
Usually such huge log is related with a database corruption.
Can you please send here small excerpt from the most recent records of
firebird.log (10-15 lines)?
Regards,
Alexey Kovyazin
IBSurgeon
Hi,
Translation was completed several weeks ago, now Helen Borrie performs
proof-reading and editing of the text.
Recent preview version of LR looks very promising.
Regards,
Alexey Kovyazin
IBSurgeon
Hello everybody
Do you know what has happened with the translation of the document
Hi,
Translation was completed several weeks ago, now Helen Borrie performs
proof-reading and editing of the text.
Recent preview version of LR looks very promising.
Regards,
Alexey Kovyazin
IBSurgeon
Hello everybody
Do you know what has happened with the translation of the document
Hi,
See page 20-21 here
http://ru.scribd.com/doc/20128182/The-InterBase-and-Firebird-Developer-Magazine-Issue-2-2005
Regards,
Alexey Kovyazin
IBSurgeon
Hello Sean, and everybody
That's a very interesting and very important theme: "the new record
version will only include the updated fields
Hi,
In addition to FW On and UPS, I suggest to look at our tool FBDataGuard
(http://ib-aid.com/en/fbdataguard), which is specifically designed to
protect databases against corruptions (among other features).
FBDataGuard stores a copy of raw metadata in the repository outside
database, and if
Hi Rudi,
You did not provide all required information to give you a reasonable
answer.
At least, post fb_lock_print -d output.
Regards,
Alexey Kovyazin
Try HQbird now! www.hqbird.com
Hi Eduardo,
Can you please give links to these articles?
Regards,
Alexey Kovyazin
IBSurgeon
I searched in Google and found that, for instance, MS suggests not to
install SQL Server in a domain controller, but for security reasons.
In some articles, MS even recommends to disable disk write
the following phrase:
* /- Disk caching should be disabled in order to use the drive with
SQL Server./
Mensaje original
*Asunto: *Re: [firebird-support] Bad performance of Firebird in
Windows Server 2012
*De: *Alexey Kovyazin a...@ib-aid.com [firebird-support]
<firebird-
Hi,
>The following file is affected:
>http://sourceforge.net/projects/firebird/files/firebird-win64/2.5.5-Release/Firebird-2.5.5.26952_0_x64.exe/download
I can confirm that Security Essential also reported this exe as
Trojan.Win32/Varpes.J!plock
Regards,
Alexey Kovyazin
IBSurgeon HQbird
Hi,
There should a reason why optimizer chooses the wrong plan.
Try to recalculate indices statistics.
Also, for general performance, use optimized Firebird configuration:
http://ib-aid.com/en/optimized-firebird-configuration/
Regards,
Alexey Kovyazin
IBSurgeon HQbird
www.ib-aid.com
I am
Hi Caroline,
It could be a chain of many record versions.
If you have such database handy, run
gstat -a -r > stat.txt
and load it to HQbird Database Analyst (trial version will be enough),
then open tab Tables and sort on Max Versions column.
Check how many versions on the table you are
Hi,
We are running Firebird Performance tests everyday (using oltp-emulation
test), for 2.5 SC and 3.0 SS respectively:
http://ib-aid.com/en/logs-2-5/
http://ib-aid.com/en/logs-3-0/
These tests are running to catch fluctuations from one build to another,
but they also show that 3.0 SS is
Hi,
Try IBReplicator.
Regards,
Alexey Kovyazin
IBSurgeon
Hi all,
we are preparing new project with bidirectional replication.
Customer idea is to have master database in head quoter
and slave databases on production plant (to solve network performance
and availability issues).
Witch
Hi Fabian,
Is is ready for production, but migration process in not just
backup/restore (it was never so in older versions, but it worked
relatively well due to high backward incompatibility) - it requires
thorough check of triggers, stored procedures, data itself and ad hoc
queries.
When
Hi Fabian,
Also I recommend you to try our optimized configuration file for FB3:
http://ib-aid.com/en/optimized-firebird-configuration/
Regards,
Alexey
Hi Alexey
Thank you for the comments. So far everything has gone ok, I fixed all
the fields with ASCII charset at the FB 2.54 DB (changed
Hi All!
Call For Papers
Conference to be held at the Barcelo Praha Hotel, Prague, Czech
Republic, on the 7th and 8th of October 2016.
The Firebird Foundation is seeking submissions from Firebird users and
developers on the theme of "Firebird in the Enterprise". A session
submission should
Hi,
use Trace API - the basic variant with text output is included into
Firebird.
If you need GUI and retrospective analysis, you can try HQbird (trial
version of Standard is 14 days), it contains PerfMon tool with TraceAPI
support
More details in HQbird Guide, page 66
Hi,
It is faster to use RDB$DB_KEY to find and delete duplicates.
See more details here
http://ib-aid.com/en/articles/how-to-find-and-delete-duplicate-records-in-firebird-database/
Regards,
Alexey Kovyazin
IBSurgeon
I had finally figured it out just before your reply
SELECT DISTINCT
Hi Sergio,
Definitely there should transaction which produces conflict, probably
your query does not catch it.
You can track it with Monlogger - download HQbird, install it and
register as trial (14 days), then connect with MonLogger to your
database and at the moment of error message click
Hi,
Gfix visits each page of the database, so 90 minutes is not so long if
your disk subsystem is not based SSD.
In general, follow these steps
http://ib-aid.com/en/articles/how-to-repair-a-corrupt-firebird-database/
Check firebird.log too - gfix reports there its findings.
Regards,
Alexey
Hi,
Check your database with Database Analyst from HQbird (trial will be
enough) and look at the list of Useless indices (indices with only 1 key
for all values) and Bad indices (with a few keys for many values).
Then, you need to run tracing of your database in action, for example,
with
Hi Patrick,
If you say that problem occurred recently, I would suggest you to check
SAN disks health.
However, these values
Average system IOPS under load read: 100
>Average system IOPS under load write: 550
>Backup Restore IOPS read: 1700
>Backup Restore IOPS write: 250
are really,
Hi,
download HQbird Standard trial (http://ib-aid.com/en/hqbird/) and
analyze your database statistics with Database Analyst and database file
DBInfo.
Database Analyst will give you an exact information of tables and
indices sizes tab Tables -> sort on Size), their fragmentation due to
Hi Karol,
44. This option turn off individual savepoints. Our tests proof that
gives slight increase in case of massive inserts or updates. Use it
with caution, since the rollback will be forced (through TIP), so if you
insert less than 50k records, there could be difference with and without
Hi,
Yes, sure, my mistake - I should not answer questions so late and need
to sleep more :)
Regards,
Alexey
23.05.2016 22:32, Alexey Kovyazin wrote:
>
> 44. This option turn off individual savepoints.
Individual savepoints are never turned off. This option disables the
root
Hi Bob,
In general, we recommend to apply the same configuration as at the old
server (even if it looks not very good), and compare the performance -
if there will be a problem, obviously it will be related with the new
hardware/OS.
If there will be the same performance, then you can tune
Firebird 3.0 Is Available Now - with major improvements in
performance, security and SQL features
April 19, 2016 -- The Firebird Project is pleased to announce the
release of version 3 of Firebird, its open source relational database
management system:
Hi Andreas,
I think the main thing is
* blockdev -setfra 32768 - this has nothing to do with
firebird but speeds up reads in the RAID array quite a bit. Thanks
to wltjr on IRC.
and, probably, backup/restore.
In 2.5 the bad effect of autosweep is almost eliminated on the systems
Hi,
Use optimized configuration file:
http://ib-aid.com/en/optimized-firebird-configuration/
Please note that if you have number of buffers set in database header,
it overrides firebird.conf value.
Check that RAID has BBU, read-write cache is enabled and write is set to
write-back.
After
Hi Ian,
It seems that you have multi-volume database, is it correct?
Regards,
Alexey Kovyazin
IBSurgeon
Hi FB Support!
We have been running FB since IB4.2 days and have only previously had
any database corruption when we've had hardware issues...until
recently, when I've seen this error
Hi,
Please take a look
http://www.slideshare.net/ibsurgeon/failsafe-cluster-for-firebirdsql-and-something-more
Regards,
Alexey Kovyazin
IBSurgeon
Hi Everyone,
First, I apologise if this isn't the correct group - please forgive me.
I'm trying to find some contemporary (ie from in the last 24
Hi,
We did it several times for our clients.
Not very difficult, but requires to detect and rewrite wrong SQL queries.
Regards,
Alexey Kovyazin
IBSurgeon
Hi ,
It is my First question in this group.
I would like to know if someone has accomplished a migration from
Interbase 7.5 to Firebird
Hi,
Recompile all stored procedures and triggers in Firebird 3.
Regards,
Alexey Kovyazin
IBSurgeon HQbird www.ib-aid.com/hqbird
Dear Sir/Madam,
I am trying to migrate my database from 2.5 to 3.0 now.
It was tested before and worked successfully
with great help from firebird community.
But
Hi,
Look at the English version of the page
https://ib-aid.com/en/optimized-firebird-configuration/
Regards,
Alexey Kovyazin
IBSurgeon
Those are for 2.5 aren't them?
The only ones I found there are at
https://ib-aid.com/br/optimized-firebird-configuration/
I was guessing there are different
Hi,
Migrate to Firebird 3 - it has protocol improvements for high latency
networks.
With 2.5 you will never reach such good results as with FB3.
Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com
Hi.
I'm testing Firebird 2.5 x64 on Windows Server 2012 R2 VPS
From tests,remote access
Hi,
It can be several reasons.
Try ##7, 20, 21, 23 from this list
https://www.ib-aid.com/en/articles/45-ways-to-speed-up-firebird-database/
Regards,
Alexey
On 15.08.2017 19:50, anderphil...@hotmail.com [firebird-support] wrote:
Hi, I have a strange problem which is probably quite obvious
Hi Ed,
There is IBAanalyst tool (now it is a part of HQbird), it shows sizes of
tables and associated indices, see column Size
http://ib-aid.com/images/iba_tables.gif
Regards,
Alexey Kovyazin
IBSurgeon HQbird
www.ib-aid.com
I have a number of growing databases on my server and would like
Hi Freddy,
Try to use optimized Firebird configuration
https://ib-aid.com/en/optimized-firebird-configuration/
As Sean already told, hang could be caused by very long processing of
some requests - extremely long queues in lock table, or related with
excessive number of record versions (Max
Hi,
The only thing I can say that situation is not obvious, I suggest to ask
for professional support:
https://www.firebirdsql.org/en/support/
Regards,
Alexey
Hi Alexey,
I have already changed the configuration, but it didn’t help. What I
find strange is the fact, that the memory
Hi,
For 6 months of fees of powerful Azure VM you can buy the whole server.
I don't know if they charge for IO rounds, like Amazon - there IO adds a
huge $$ to the bill.
If you want your database hosted and be reliable and safe - rent 2
servers with SSD in Hetzner and install asynchronous
Hi,
In short - 5 years of development.
These versions are different major releases, no backward compatibility.
Regards,
Alexey Kovyazin
IBSurgeon HQbird www.ib-aid.com
On 23.06.2017 12:15, 'Vonica Tng (Madsoft)' vonica@madsoft.com.sg
[firebird-support] wrote:
Hi,
Can anyone advise
Hi Hugo,
Yes, in this case you can check MON$ tables.
Please note that in case of many connections query to MON$ can consume
significant resources.
How do you recover if it's stuck?
nbackup -n
>I noticed that the larger the database is the longer it takes to do
nbackup even if the delta
Hi Hugo,
In HQbird, we monitor size and age of delta files.
If it is bigger or older than appropriate size/age (like 500Mb/6 hours,
for example), the database is marked as critical in Control Center.
You can implement the same - the status of the database and path to
delta file can be
Hi,
Usually such corruptions happen due to hardware problems.
Check you RAM
https://ib-aid.com/en/articles/how-to-check-ram-and-avoid-database-corruptions/
Try to fix with standard means
https://ib-aid.com/en/articles/how-to-repair-a-corrupt-firebird-database/
If it fails, FirstAID will help.
Hi,
Firebird 3 is not a silver bullet, it mostly increases performance in
the multiprocessing area.
With 30 connections, I would say that multiprocessing is not a problem,
most likely you are having problems with SQL queries.
I would suggest to take a look on
Hi,
I remember I answered incorrectly that time :)
TempCacheLimit is always per server instance.
For Classic it means it is allocated per each connection (since each
connection has own server process), for SuperClassic and SuperServer
temp space will be shared between connections, since
Hi,
If you have big sort files (you can check their existence manually in
temp folder or use HQbird FBBDataGuard to monitor them for you),
increasing TempCacheLimit to fit all of them can speed up sorting
queries (with GROUP BY and ORDER BY, for example).
However, the better approach is to
Hi,
Look at System Audit feature.
Regards,
Alexey Kovyazin
IBSurgeon HQbird
www.ib-aid.com
On 09.10.2017 2:49, Hamish Moffatt ham...@risingsoftware.com
[firebird-support] wrote:
Is there an official way to detect if a database has changed?
I have some expensive reports and backups to run,
Hello Nils,
No other issues.
Regards,
Alexey Kovyazin
IBSurgeon
On 05.12.2017 14:52, Nils Boedeker nilsboede...@t-online.de
[firebird-support] wrote:
Hi
I want to use windows server 2016 as server for
firebird 2.5.7 (Classic Server)
are there any known issus with using firebird with
Hello,
We recommend perform at least everyday sweep - with disconnect of long
running active writeable transactions before it.
Can you please clarify what do you mean by
> measuring the effectiveness of the page cache
?
Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com
On 04.05.2018
I am totally agree with Mark.
Ratio of page reads/page fetches for all queries has a little sense.
For example, the single badly designed query with many page fetches can
"improve" this parameter a lot, without any real improvement in the
performance, of course.
Regards,
Alexey Kovyazin
Hello Rudi,
Usually, queries with the dozens of millions of index operations are
responsible for high CPU usage.
You can find them with HQbird MonLogger: get snapshot during the high
CPU peak, open it, open tab Statements (disable check "Link to selected
attachment"), and sort on
Hi Josef,
Firebird 3 shows plan Natural for all procedures.
2.5 also sometimes shows Natural, sometimes - mix of plans of queries
inside the procedure.
So, you cannot apply this plan to the statement.
Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com
On 22.06.2018 9:47,
1 - 100 of 119 matches
Mail list logo