Re: [firebird-support] How much percentage of a database space is a table contents taking.
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] How much percentage of a database space is a table contents taking.
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: Re: [firebird-support] Replication SW experience
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.
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, 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
[firebird-support] Re: Firebird for a web application
Thank you, Szilveszter. Mirco
Re: ODP: Re: [firebird-support] Replication SW experience
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 724 207 851 >>> icq:199 118 333 >>
ODP: Re: [firebird-support] Replication SW experience
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: [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] Replication SW experience
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
Re: [firebird-support] How much percentage of a database space is a table contents taking.
> 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
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 > >