Subject | Re: firebird.conf for HP Proliant Server |
---|---|
Author | frodo_haija |
Post date | 2008-06-17T07:59:39Z |
Dear Helen
Thanks you verry much for your interesting writes.
The gstat -i give me a file with 6280 lines. Here the first part of
the file:
Database "d:\database\msup.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 21374673
Page size 4096
ODS version 11.0
Oldest transaction 21374659
Oldest active 21374660
Oldest snapshot 21374660
Next transaction 21374667
Bumped transaction 1
Sequence number 0
Next attachment ID 12
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Feb 13, 2008 20:13:13
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
Database file sequence:
File d:\database\msup.fdb is the only file
Analyzing database pages ...
ABFRAGESOURCE (229)
Index IXTYPE_208 (1)
Depth: 1, leaf buckets: 1, nodes: 249
Average data length: 0.01, total dup: 248, max dup: 248
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index IX_208_208_0_0 (2)
Depth: 1, leaf buckets: 1, nodes: 249
Average data length: 0.69, total dup: 128, max dup: 38
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index IX_208_208_1_0 (3)
Depth: 1, leaf buckets: 1, nodes: 249
Average data length: 0.86, total dup: 104, max dup: 13
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_208 (0)
Depth: 1, leaf buckets: 1, nodes: 249
Average data length: 1.24, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ABSTRACTORDNER (136)
Index IXTYPE_105 (1)
Depth: 2, leaf buckets: 2, nodes: 1104
Average data length: 0.01, total dup: 1096, max dup: 541
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0
How do i have to interpret this?
Do i have to upload the hole file?
Greetings from Switzerland
Haija
Thanks you verry much for your interesting writes.
The gstat -i give me a file with 6280 lines. Here the first part of
the file:
Database "d:\database\msup.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 21374673
Page size 4096
ODS version 11.0
Oldest transaction 21374659
Oldest active 21374660
Oldest snapshot 21374660
Next transaction 21374667
Bumped transaction 1
Sequence number 0
Next attachment ID 12
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Feb 13, 2008 20:13:13
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
Database file sequence:
File d:\database\msup.fdb is the only file
Analyzing database pages ...
ABFRAGESOURCE (229)
Index IXTYPE_208 (1)
Depth: 1, leaf buckets: 1, nodes: 249
Average data length: 0.01, total dup: 248, max dup: 248
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index IX_208_208_0_0 (2)
Depth: 1, leaf buckets: 1, nodes: 249
Average data length: 0.69, total dup: 128, max dup: 38
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index IX_208_208_1_0 (3)
Depth: 1, leaf buckets: 1, nodes: 249
Average data length: 0.86, total dup: 104, max dup: 13
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_208 (0)
Depth: 1, leaf buckets: 1, nodes: 249
Average data length: 1.24, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ABSTRACTORDNER (136)
Index IXTYPE_105 (1)
Depth: 2, leaf buckets: 2, nodes: 1104
Average data length: 0.01, total dup: 1096, max dup: 541
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0
How do i have to interpret this?
Do i have to upload the hole file?
Greetings from Switzerland
Haija