Hello,
before you try FirstAID, download IBPump and try to pump all data to the
new database with the same structure.
Regards,
Alexey Kovyazin
IBSurgeon
On 27.12.2019 22:49, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
Hello.
FB 2.5.7
Windows 10 64 bits
Page size 4096
I am
zin a...@ib-aid.com [firebird-support] wrote:
>> we also started with Page Buffers = 25% RAM and increased it step by step
>> (and still
>> continue to work with fine tuning).
> Isn't it better to use cache hit ratio to make the deci
Hello,
Yes, better use default - pagecache in terms of Linux is different from
Page Buffers/Page cache of Firebird.
Regards,
Alexey
On 13.11.2019 15:10, kragh.tho...@yahoo.com [firebird-support] wrote:
Hey Alexey
Thanks for the answer, I only have one question left, do I need to
adjust
Hello Thomas,
Ok, good to know that you are prepared for the migration! FB3 with
proper migration and config certainly will increase the overall performance.
In my presentation regarding Linux I spoke about specific case which is
under everyday control, and in our long way, we also started
Hello Thomas,
My advice was only to fix the obvious mistake regarding the TempCacheLimit.
In general, I don't see a problem in high traffic to /tmp, and I don't
understand why do you think sorting queries produce the problem - and
even if they produce, the first attempt would be to identify
Hello Thomas,
Seems like your system generates a lot of sort files - the problem can
be that TempCacheLimit in Firebird 2.5 cannot be more than 2Gb -1.
When you set it to something between 2 and 4Gb, it means 0.
So, set something like
TempCacheLimit=21
Consider to tune other
Hello,
Don't know, if this means file cached work or not.
It works.
I recommend to do several experiments with different Pafe buffers and
FileSystemCacheThreshold values (Buffers > FileSystemCacheThreshold ,
Buffers < FileSystemCacheThreshold ), and check RAMMap. Try to do it
with and
Hello,
Download RAMMap from Sysinternals (Micorosft), and see if database file
is in list of cached files.
Regards,
Alexey Kovyazin
IBSurgeon
On 22.06.2019 11:42, trsk...@yahoo.com [firebird-support] wrote:
Hi guys,
I have FB 3.04 SS in windows 10.
I have a database with these setting on
Hello,
So, I did understand correctly - anyone can open any Firebird database and view the data
(unless it happens to be encrypted).
No, not exactly, - you can protect from scenario with replacing security
database with a change of database owner (create database under MyUser).
I am
Hello,
This is the point where I confess to being confused. I presume I am
wrong but it looks like any Firebird database has a "public back
door". What stops me taking a copy of SecretDatabase.fdb and
connecting to it on my own Firebird installation?
If you have access to Firebird server
Hi Karol,
This advice is based on our experience - disabling file cache for big
databases (definitely larger than RAM size) leads to slowness.
I don't have explanation for this on the theoretical level.
If you have real-world example when Firebird works faster without file
cache, please
Hello Dalton,
I am totally agree with you - all these features would be definitely good.
Regards,
Alexey
Hi Alexey,
Just my 2cents from someone who has not had time to review the code
and could not find a breakdown of the firebird code structure in a
very cursory search.
> (1) Schema
Hello All,
As there are many people involved and truly interested in further
Firebird development in this thread, I would like to remind, that
Firebird is funded by Firebird Foundation sponsors and members, and
there is always ability to boost development with money sponsorship and
donations.
Hello Dalton,
>Where do you see the list of features that are destined to be in 5?
There is no list of features yet. However, as a member of Technical Task
Group, I will work to include into 5.0 the 3 main features: multi-master
replication, partitioning/table spaces, schema support.
>I
Thank you!
In my opinion, Firebird will close the gap with PG in main features in 2
years, with FB5.0 version.
Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com
On 07.11.2018 19:58, 'Martijn Tonies (Upscene Productions)'
m.ton...@upscene.com [firebird-support] wrote:
> Hello Alexey,
>
>> What
Martijn,
What about compilation of stored procedures - is it true that it is
possible to create SP with errors, and they appear only when it will be
invoked?
Also, about checking the parameters - is it true that you can create
stored procedure which invokes other stored procedure with wrong
Hello,
As you probably know, Firebird a) uses complex mechanism to write
consistent data to the database file even in the multi-users
environment, b) intensively uses own cache, which must be synced with
database file.
SafeKit says it is byte-level replication.
So, essentially it is the same
Hello,
Since you have enough RAM, you can increase TempCacheLimit in
firebird.conf, for example, set 20Gb.
Fb_sort_xxx files will be created only if sorting will require more than
TempCacheLimit.
Regards,
Alexey Kovyazin
IBSurgeon
On 07.08.2018 10:35, bieten2...@yahoo.de [firebird-support]
Hello,
Don't install from repo, better download installation package from
firebirdsql.org and install it instead.
Regards,
Alexey Kovyazin
IBSurgeon
On 27.07.2018 19:41,
mailinglist.int.it.firebird.supp...@principledgroup.com
[firebird-support] wrote:
Problem: Firebird 3.0 will not
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,
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
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,
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
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
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,
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,
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,
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,
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,
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,
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,
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 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 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,
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 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,
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 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,
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,
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 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,
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 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 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 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,
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 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
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 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
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,
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,
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 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,
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,
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,
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,
>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 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,
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 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 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,
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 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 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,
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,
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,
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 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
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 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
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 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,
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,
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,
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 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 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,
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 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 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 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 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,
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 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,
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,
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 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
1 - 100 of 119 matches
Mail list logo