gbak running in embedded mode

матрациThose who are new to the Classic version of Firebird on Linux may find interesting that, while running gbak to backup a database, accessing the DB file locally (not by tcp/ip, etc), you will not find a fb_inet_server proccess serving the gbak connection. This is because, in this specific situation, gbak works in embedded mode. Alex Peshkov says this provides the best performance results.

Benchmark tool

Philippe Makowski posted this at fb-devel:

Hi,

I found this bench : http://tokutek.com/products/iibench/

(http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py)

and aibench.py:
http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/aibench.py

I made a Firebird version of both. You can download them here : http://www.firebirdsql.org/download/rabbits/pmakowski/

If you find them useful, I will put them in the svn QA repository

How to increase Firebird backup and restore speed (up to 30%)

It seems that many Firebird developers and administrators are not aware about  command line switch -se[rvice] for gbak.exe

-SE[RVICE] <servicename>

This switch causes gbak to backup a remote database via the service manager. This causes the backup file to be created on the remote server, so the path format and filename must be valid on the remote server. The servicename is currently always the text service_mgr.

here is the rest of the article in Eglish

also there is an Italian mention in blogosphere

Remember to participate on 3d Russian Firebird Conference in Moscow

3d Russian Firebird Conference will take place in Moscow, September
29, 2010. The conference will be devoted to the Firebird new versions
and to best practices in maintenance and development, with special
focus on big Firebird databases.

Special speakers at conference: Phillipe Makowski, President of
Firebird Foundation, Firebird developers team: Dmitry Yemanov, Vlad
Khorsun and Alex Peshkoff.
Registration (in Russian): http://ibase.ru/conf2010/

With google translate (Almost English)

1 2 3