Re: [firebird-support] How much percentage of a database space is a table contents taking.

[rgilland1...@gmail.com [firebird-support]]

Thomas, 

 I ran gstat and here is the result there is no USAGE% column:
 

 Kind Regards,
 

 Robert.
 

 Database "op.fdb" 
 Database header page information: 
 Flags 0 
 Checksum 12345 
 Generation 28661 
 Page size 8192 
 ODS version 11.2 
 Oldest transaction 25549 
 Oldest active 28643 
 Oldest snapshot 28643 
 Next transaction 28644 
 Bumped transaction 1 
 Sequence number 0 
 Next attachment ID 158 
 Implementation ID 16 
 Shadow count 0 
 Page buffers 0 
 Next header page 0 
 Database dialect 3 
 Creation date Nov 15, 2015 8:58:58 
 Attributes force write 
  
 Variable header data: 
 Sweep interval: 0 
 *END* 
  
  
 Database file sequence: 
 File op.fdb is the only file 
  
 Analyzing database pages ... 
 AS_AZN_TND_TML (419) 
 Primary pointer page: 1869, Index root page: 1870 
 Data pages: 0, data page slots: 0, average fill: 0% 
 Fill distribution: 
 0 - 19% = 0 
 20 - 39% = 0 
 40 - 59% = 0 
 60 - 79% = 0 
 80 - 99% = 0 

 

Re: [firebird-support] How much percentage of a database space is a table contents taking.

[rgilland1...@gmail.com [firebird-support]]

Hi,
 

 this is an output from ibexpert, no usage% column here either:
 

 Kind Regards,
 

 Robert.
 

 Database "OP.FDB"
 Database header page information:
 Flags   0
 Checksum12345
 Generation  28674
 Page size   8192
 ODS version 11.2
 Oldest transaction  25549
 Oldest active   28656
 Oldest snapshot 28656
 Next transaction28657
 Bumped transaction  1
 Sequence number 0
 Next attachment ID  161
 Implementation ID   16
 Shadow count0
 Page buffers0
 Next header page0
 Database dialect3
 Creation date   Nov 15, 2015 8:58:58
 Attributes  force write
 

 Variable header data:
 Sweep interval: 0
 *END*
 

 

 Database file sequence:
 File OP.FDB is the only file
 

 Analyzing database pages ...
 AS_AZN_TND_TML (419)
 Primary pointer page: 1869, Index root page: 1870
 Average record length: 0.00, total records: 0
 Average version length: 0.00, total versions: 0, max versions: 0
 Data pages: 0, data page slots: 0, average fill: 0%
 Fill distribution:
  0 - 19% = 0
 20 - 39% = 0
 40 - 59% = 0
 60 - 79% = 0
 80 - 99% = 0

Re: Re: [firebird-support] Replication SW experience

[Sudheer Palaparambil sudheer....@gmail.com [firebird-support]]

Hi,

Please have a look at SymmetricDS (http://www.symmetricds.org/). I have
been using it for the past 4 years with Firebird.

Thanks and regards.

Sudheer Palaparambil

On Thu, Nov 26, 2015 at 9:05 PM, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support]  wrote:

>
>
> hi,
>
> modification datetime is not enaugh to replication. think about
>
> 1. transaction started and modify data
> 2. synchronization started and fetch data from last modifird datetime
> 3. synchronization end
> 4. transaction commit data from point 1 and store datetime before synch
> started
> 5. synchronization start and omit modification from point 1 because date
> is older
>
> regards,
> Karol Bieniaszewski
>
>
>
> Pozdrawiam
>
>
>  Oryginalna wiadomość 
> Od: "Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]" <
> firebird-support@yahoogroups.com>
> Data: 26.11.2015 12:46 (GMT+01:00)
> Do: firebird-support@yahoogroups.com
> Temat: Re: [firebird-support] Replication SW experience
>
>
>
> Hi Aldis,
> more info about situation.
>
> 1. Normal operation
> - Asynchronous replication will wait for DB Event and than
> immediately start transfer.
> All data changes will be logged by triggers into log table.
>
> 2. Disaster
> Local production will continue works because have production plan and
> records data into local DB.
> When connection will be back all data will be synchronized.
> There are no so much real possibilities to conflict.
>
> Each table has UTC time stamp of last modification. In most cases,
> latest wins.
> Rest of conflict we have to program manually.
>
> I have idea how to do it (it is nice work), but I don't want to invent
> "wheel".
>
> I'm looking on something like copycat, but web site is little bit
> confusing.
>
> Any experience?
>
> Slavek
>
> Ing. Slavomir Skopalik
> Executive Head
> Elekt Labs s.r.o.
> Collection and evaluation of data from machines and laboratories
> by means of system MASA (http://www.elektlabs.cz/m2demo)
> --
> Address:
> Elekt Labs s.r.o.
> Chaloupky 158
> 783 72 Velky Tynec
> Czech Republic
> --
> Mobile: +420 724 207 851
> icq:199 118 333
> skype:skopaliks
> e-mail:skopa...@elektlabs.cz
> http://www.elektlabs.cz
>
> On 26.11.2015 9:00, Alan J Davies alan.dav...@aldis-systems.co.uk
> [firebird-support] wrote:
> > Hi Slavek, there are a number of issues you need to resolve before
> > making a decision. If network performance is an issue then replication
> > is not the answer - unless you can send the changes back to head office
> > 'out of hours'. This means the different databases will be out of sync
> > for some time. Is this acceptable from your customer's point of view?
> > Are there different production plants making the same item? What happens
> > if plant 1 and plant 2 make the same item on the same day?
> >
> > I think you may have to generate your own version because replication is
> > not what you need (imho) but you could create a series of triggers and
> > tables to do what you want. e.g. if you have a table called PARTS,
> > create SYNC_PARTS and each time there is a change to PARTS you add a
> > record. You could then send your updates to HO via a scheduled update or
> > even within the same transaction if your network access allows for that.
> >
> > Alan J Davies
> > Aldis
> >
> >
> > On 25/11/2015 21:35, Slavomir Skopalik skopa...@elektlabs.cz
> > [firebird-support] wrote:
> >> 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 replication SW you can recommend for this bidirectional
> replication?
> >> What is typical issues and weakness of this SW.
> >>
> >> Thank you.
> >>
> >> Slavek
> >>
> >> --
> >> Ing. Slavomir Skopalik
> >> Executive Head
> >> Elekt Labs s.r.o.
> >> Collection and evaluation of data from machines and laboratories
> >> by means of system MASA (http://www.elektlabs.cz/m2demo)
> >> --
> >> Address:
> >> Elekt Labs s.r.o.
> >> Chaloupky 158
> >> 783 72 Velky Tynec
> >> Czech Republic
> >> --
> >> Mobile: +420 724 207 851
> >> icq:199 118 333
> >> skype:skopaliks
> >> e-mail:skopa...@elektlabs.cz
> >> http://www.elektlabs.cz
> >>
> >>
>
> 
>

Re: [firebird-support] How much percentage of a database space is a table contents taking.

[Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support]]

Hi Robert, you need to click on the second tab of the results - Tables. 
The first tab - Text - does only show what you have here.

TableName   SizeUsage%
CUSTOMER11,960,3200.295
PARAMFIL16,3840.000
POSTCODES3,903,012,86496.335
POSTCODE_MISSING16,384 3.000

Alan J Davies
Aldis

On 26/11/2015 23:24, rgilland1...@gmail.com [firebird-support] wrote:
> Hi,
>
> this is an output from ibexpert, no usage% column here either:
>
> Kind Regards,
>
> Robert.
>
> Database "OP.FDB"
> Database header page information:
>  Flags   0
>  Checksum12345
>  Generation  28674
>  Page size   8192
>  ODS version 11.2
>  Oldest transaction  25549
>  Oldest active   28656
>  Oldest snapshot 28656
>  Next transaction28657
>  Bumped transaction  1
>  Sequence number 0
>  Next attachment ID  161
>  Implementation ID   16
>  Shadow count0
>  Page buffers0
>  Next header page0
>  Database dialect3
>  Creation date   Nov 15, 2015 8:58:58
>  Attributes  force write
>
>  Variable header data:
>  Sweep interval: 0
>  *END*
>
>
> Database file sequence:
> File OP.FDB is the only file
>
> Analyzing database pages ...
> AS_AZN_TND_TML (419)
>  Primary pointer page: 1869, Index root page: 1870
>  Average record length: 0.00, total records: 0
>  Average version length: 0.00, total versions: 0, max versions: 0
>  Data pages: 0, data page slots: 0, average fill: 0%
>  Fill distribution:
>   0 - 19% = 0
>  20 - 39% = 0
>  40 - 59% = 0
>  60 - 79% = 0
>  80 - 99% = 0
>
> 

Re: [firebird-support] How much percentage of a database space is a table contents taking.

['Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]]

rgilland1...@gmail.com [firebird-support] schrieb am 27.11.2015 00:24:

> Hi,
> 
> 
> this is an output from ibexpert, no usage% column here either:
> 
> 
> Kind Regards,
> 
> 
> Robert.
> 
> 
> Database "OP.FDB"
> Database header page information:
> Flags   0
> Checksum12345
> Generation  28674
> Page size   8192
> ODS version 11.2
> Oldest transaction  25549
> Oldest active   28656
> Oldest snapshot 28656
> Next transaction28657
> Bumped transaction  1
> Sequence number 0
> Next attachment ID  161
> Implementation ID   16
> Shadow count0
> Page buffers0
> Next header page0
> Database dialect3
> Creation date   Nov 15, 2015 8:58:58
> Attributes  force write
> 
> 
> Variable header data:
> Sweep interval: 0
> *END*
> 
> 
> 
> 
> Database file sequence:
> File OP.FDB is the only file
> 
> 
> Analyzing database pages ...
> AS_AZN_TND_TML (419)
> Primary pointer page: 1869, Index root page: 1870
> Average record length: 0.00, total records: 0
> Average version length: 0.00, total versions: 0, max versions: 0
> Data pages: 0, data page slots: 0, average fill: 0%
> Fill distribution:
>  0 - 19% = 0
> 20 - 39% = 0
> 40 - 59% = 0
> 60 - 79% = 0
> 80 - 99% = 0

Divide the value of "Data pages" in the per table gstat output by the database 
page size. This will give you an approximate value on space used on disk for 
the table. Approximate in a way as this does not include BLOB data. AFAIK, with 
Firebird 3 (ODS12), even BLOB data is counted here or displayed as a separate 
value. Can't remember exactly.



--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

Re: [firebird-support] Replication SW experience

[Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support]]

Hi Slavek, there are a number of issues you need to resolve before 
making a decision. If network performance is an issue then replication 
is not the answer - unless you can send the changes back to head office 
'out of hours'. This means the different databases will be out of sync 
for some time. Is this acceptable from your customer's point of view?
Are there different production plants making the same item? What happens 
if plant 1 and plant 2 make the same item on the same day?

I think you may have to generate your own version because replication is 
not what you need (imho) but you could create a series of triggers and 
tables to do what you want. e.g. if you have a table called PARTS, 
create SYNC_PARTS and each time there is a change to PARTS you add a 
record. You could then send your updates to HO via a scheduled update or 
even within the same transaction if your network access allows for that.

Alan J Davies
Aldis


On 25/11/2015 21:35, Slavomir Skopalik skopa...@elektlabs.cz 
[firebird-support] wrote:
> 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 replication SW you can recommend for this bidirectional replication?
> What is typical issues and weakness of this SW.
>
> Thank you.
>
> Slavek
>
> --
> Ing. Slavomir Skopalik
> Executive Head
> Elekt Labs s.r.o.
> Collection and evaluation of data from machines and laboratories
> by means of system MASA (http://www.elektlabs.cz/m2demo)
> --
> Address:
> Elekt Labs s.r.o.
> Chaloupky 158
> 783 72 Velky Tynec
> Czech Republic
> --
> Mobile: +420 724 207 851
> icq:199 118 333
> skype:skopaliks
> e-mail:skopa...@elektlabs.cz
> http://www.elektlabs.cz
>
> 

Re: [firebird-support] How much percentage of a database space is a table contents taking.

['Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]]

> Hi Robert, you can do this easily with a tool such as IBExpert. Just run 
> Services / Database Statistics and this is the result:
> 
> TableName SizeUsage%
> CUSTOMER  11,960,320  0.295
> PARAMFIL  16,384  1   0.000
> POSTCODES 3,903,012,864   96.335
> POSTCODE_MISSING  16,384  1   3.000
>   
> I've removed a lot more detail such as number of records, pages, fill 
> size etc.

Or low-level, for free, running gstat. ;-)



--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

Re: [firebird-support] Replication SW experience

[Alexey Kovyazin a...@ib-aid.com [firebird-support]]

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 replication SW you can recommend for this bidirectional replication?
What is typical issues and weakness of this SW.

Thank you.

Slavek

--
Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (http://www.elektlabs.cz/m2demo)
--
Address:
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
--
Mobile: +420 724 207 851
icq:199 118 333
skype:skopaliks
e-mail:skopa...@elektlabs.cz
http://www.elektlabs.cz

ODP: Re: [firebird-support] Replication SW experience

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

hi,
modification datetime is not enaugh to replication. think about
1. transaction started and modify data2. synchronization started and fetch data 
from last modifird datetime3. synchronization end4. transaction commit data 
from point 1 and store datetime before synch started5. synchronization start 
and omit modification from point 1 because date is older
regards,Karol Bieniaszewski


Pozdrawiam

 Oryginalna wiadomość 
Od: "Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]" 
 
Data: 26.11.2015  12:46  (GMT+01:00) 
Do: firebird-support@yahoogroups.com 
Temat: Re: [firebird-support] Replication SW experience 


 



  



  
  
  Hi Aldis,

more info about situation.



1. Normal operation

   - Asynchronous replication will wait for DB Event and than 

immediately start transfer.

   All data changes will be logged by triggers into log table.



2. Disaster

   Local production will continue works because have production plan and 

records data into local DB.

   When connection will be back all data will be synchronized.

   There are no so much real possibilities to conflict.



Each table has UTC time stamp of last modification. In most cases, 

latest wins.

Rest of conflict we have to program manually.



I have idea how to do it (it is nice work), but I don't want to invent 

"wheel".



I'm looking on something like copycat, but web site is little bit confusing.



Any experience?



Slavek



Ing. Slavomir Skopalik

Executive Head

Elekt Labs s.r.o.

Collection and evaluation of data from machines and laboratories

by means of system MASA (http://www.elektlabs.cz/m2demo)

--

Address:

Elekt Labs s.r.o.

Chaloupky 158

783 72 Velky Tynec

Czech Republic

--

Mobile: +420 724 207 851

icq:199 118 333

skype:skopaliks

e-mail:skopa...@elektlabs.cz

http://www.elektlabs.cz



On 26.11.2015 9:00, Alan J Davies alan.dav...@aldis-systems.co.uk 

[firebird-support] wrote:

> Hi Slavek, there are a number of issues you need to resolve before

> making a decision. If network performance is an issue then replication

> is not the answer - unless you can send the changes back to head office

> 'out of hours'. This means the different databases will be out of sync

> for some time. Is this acceptable from your customer's point of view?

> Are there different production plants making the same item? What happens

> if plant 1 and plant 2 make the same item on the same day?

>

> I think you may have to generate your own version because replication is

> not what you need (imho) but you could create a series of triggers and

> tables to do what you want. e.g. if you have a table called PARTS,

> create SYNC_PARTS and each time there is a change to PARTS you add a

> record. You could then send your updates to HO via a scheduled update or

> even within the same transaction if your network access allows for that.

>

> Alan J Davies

> Aldis

>

>

> On 25/11/2015 21:35, Slavomir Skopalik skopa...@elektlabs.cz

> [firebird-support] wrote:

>> 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 replication SW you can recommend for this bidirectional replication?

>> What is typical issues and weakness of this SW.

>>

>> Thank you.

>>

>> Slavek

>>

>> --

>> Ing. Slavomir Skopalik

>> Executive Head

>> Elekt Labs s.r.o.

>> Collection and evaluation of data from machines and laboratories

>> by means of system MASA (http://www.elektlabs.cz/m2demo)

>> --

>> Address:

>> Elekt Labs s.r.o.

>> Chaloupky 158

>> 783 72 Velky Tynec

>> Czech Republic

>> --

>> Mobile: +420 724 207 851

>> icq:199 118 333

>> skype:skopaliks

>> e-mail:skopa...@elektlabs.cz

>> http://www.elektlabs.cz

>>

>>






 

Re: ODP: Re: [firebird-support] Replication SW experience

[Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]]

I know,
what is better?

It is same in normal client server.
Two client start editing same record. Who will win?

In paranoia system, you will use dummy update before edit starts.
But in real, mainly web, system?

Slavek

Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (http://www.elektlabs.cz/m2demo)
-
Address:
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
---
Mobile: +420 724 207 851
icq:199 118 333
skype:skopaliks
e-mail:skopa...@elektlabs.cz
http://www.elektlabs.cz

On 26.11.2015 16:35, liviuslivius liviusliv...@poczta.onet.pl 
[firebird-support] wrote:
>  
> hi,
> modification datetime is not enaugh to replication. think about
> 1. transaction started and modify data2. synchronization started and fetch 
> data from last modifird datetime3. synchronization end4. transaction commit 
> data from point 1 and store datetime before synch started5. synchronization 
> start and omit modification from point 1 because date is older
> regards,Karol Bieniaszewski
>
>
> Pozdrawiam
>
>  Oryginalna wiadomość 
> Od: "Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]" 
> 
> Data: 26.11.2015  12:46  (GMT+01:00)
> Do: firebird-support@yahoogroups.com
> Temat: Re: [firebird-support] Replication SW experience
>
>
>   
>
>
>
>
>
>
>  
>
>
>Hi Aldis,
>
> more info about situation.
>
>
>
> 1. Normal operation
>
> - Asynchronous replication will wait for DB Event and than
>
> immediately start transfer.
>
> All data changes will be logged by triggers into log table.
>
>
>
> 2. Disaster
>
> Local production will continue works because have production plan and
>
> records data into local DB.
>
> When connection will be back all data will be synchronized.
>
> There are no so much real possibilities to conflict.
>
>
>
> Each table has UTC time stamp of last modification. In most cases,
>
> latest wins.
>
> Rest of conflict we have to program manually.
>
>
>
> I have idea how to do it (it is nice work), but I don't want to invent
>
> "wheel".
>
>
>
> I'm looking on something like copycat, but web site is little bit confusing.
>
>
>
> Any experience?
>
>
>
> Slavek
>
>
>
> Ing. Slavomir Skopalik
>
> Executive Head
>
> Elekt Labs s.r.o.
>
> Collection and evaluation of data from machines and laboratories
>
> by means of system MASA (http://www.elektlabs.cz/m2demo)
>
> --
>
> Address:
>
> Elekt Labs s.r.o.
>
> Chaloupky 158
>
> 783 72 Velky Tynec
>
> Czech Republic
>
> --
>
> Mobile: +420 724 207 851
>
> icq:199 118 333
>
> skype:skopaliks
>
> e-mail:skopa...@elektlabs.cz
>
> http://www.elektlabs.cz
>
>
>
> On 26.11.2015 9:00, Alan J Davies alan.dav...@aldis-systems.co.uk
>
> [firebird-support] wrote:
>
>> Hi Slavek, there are a number of issues you need to resolve before
>> making a decision. If network performance is an issue then replication
>> is not the answer - unless you can send the changes back to head office
>> 'out of hours'. This means the different databases will be out of sync
>> for some time. Is this acceptable from your customer's point of view?
>> Are there different production plants making the same item? What happens
>> if plant 1 and plant 2 make the same item on the same day?
>> I think you may have to generate your own version because replication is
>> not what you need (imho) but you could create a series of triggers and
>> tables to do what you want. e.g. if you have a table called PARTS,
>> create SYNC_PARTS and each time there is a change to PARTS you add a
>> record. You could then send your updates to HO via a scheduled update or
>> even within the same transaction if your network access allows for that.
>> Alan J Davies
>> Aldis
>> On 25/11/2015 21:35, Slavomir Skopalik skopa...@elektlabs.cz
>> [firebird-support] wrote:
>>> 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 replication SW you can recommend for this bidirectional replication?
>>> What is typical issues and weakness of this SW.
>>> Thank you.
>>> Slavek
>>> --
>>> Ing. Slavomir Skopalik
>>> Executive Head
>>> Elekt Labs s.r.o.
>>> Collection and evaluation of data from machines and laboratories
>>> by means of system MASA (http://www.elektlabs.cz/m2demo)
>>> --
>>> Address:
>>> Elekt Labs s.r.o.
>>> Chaloupky 158
>>> 783 72 Velky Tynec
>>> Czech Republic
>>> --
>>> Mobile: +420 

[firebird-support] Re: Firebird for a web application

[mirco.malag...@ingeniaonline.it [firebird-support]]

Thank you, Szilveszter. 

 Mirco