Dmitri Kuzmenko wrote:
>
> Pavel Tugarinov wrote:
>
> > ODS=10.1
> > Это старая?
> > Эта база данных растет в основном за счет таблицы событий, каждое из
> > которых мало, но случаются они иногда десятки раз в секунду. Вот за
> > эту таблицу я и переживаю. Оцениваю время подлета к лимиту в 1- 2
> > месяца.
>
> IBAnalyst предупреждение по этому поводу дает?
>
> дай
> gstat -a -r -t TableName db.gdb
>
> и посмотри (можешь мне прислать, для интереса, хотя и от полной
> статистики не откажусь).
IbAnalyst не ругается :). Без него ни шагу.
Быстрорастущая таблца это EVENTS, за 3 месяца 20GB(считая индексы), скорость
роста немного возрастает, отсюда 35GBбудет через 1-2 месяца.
В аттаче полная статистика, как раз сегодняшняя.
Спасибо за интерес!
--
Pavel Tugarinov
METALLINVESTBANK
[EMAIL PROTECTED]
Database "<èìÿ áàçû>.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 32437959
Page size 16384
ODS version 10.1
Oldest transaction 32353815
Oldest active 32353816
Oldest snapshot 32353816
Next transaction 32437884
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 65535
Next header page 0
Database dialect 3
Creation date Oct 27, 2005 12:33:10
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File <èìÿ áàçû>.fdb is the only file
Database log page information:
Creation date
Log flags: 2
No write ahead log
Next log page: 0
Variable log data:
Control Point 1:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Control Point 2:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Current File:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
*END*
Analyzing database pages ...
EVENTS (131)
Primary pointer page: 140, Index root page: 141
Average record length: 38.55, total records: 54889004
Average version length: 39.06, total versions: 10379, max versions: 1
Data pages: 261876, data page slots: 261876, average fill: 71%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 261875
80 - 99% = 0
Index EVENTS_IDX1 (2)
Depth: 3, leaf buckets: 102614, nodes: 54899498
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 218
20 - 39% = 10214
40 - 59% = 83067
60 - 79% = 969
80 - 99% = 8146
Index EVENTS_IDX2 (3)
Depth: 3, leaf buckets: 107195, nodes: 54899531
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 10197
40 - 59% = 93682
60 - 79% = 302
80 - 99% = 3014
Index EVENTS_IDX3 (0)
Depth: 3, leaf buckets: 95080, nodes: 54912302
Average data length: 7.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 21
20 - 39% = 17041
40 - 59% = 74735
60 - 79% = 348
80 - 99% = 2935
Index EVENTS_IDX4 (7)
Depth: 3, leaf buckets: 89100, nodes: 54924783
Average data length: 10.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 295
20 - 39% = 6290
40 - 59% = 53323
60 - 79% = 3013
80 - 99% = 26179
Index EVENTS_IDX5 (6)
Depth: 3, leaf buckets: 75239, nodes: 54924880
Average data length: 5.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 9413
40 - 59% = 59227
60 - 79% = 11
80 - 99% = 6588
Index EVENTS_IDX8 (4)
Depth: 3, leaf buckets: 131997, nodes: 54952382
Average data length: 12.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 15
20 - 39% = 24618
40 - 59% = 103319
60 - 79% = 196
80 - 99% = 3849
Index EVENTS_IDX9 (5)
Depth: 3, leaf buckets: 132487, nodes: 54976414
Average data length: 12.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 18
20 - 39% = 25203
40 - 59% = 102401
60 - 79% = 524
80 - 99% = 4341
Index PK_EVENTS (1)
Depth: 3, leaf buckets: 59698, nodes: 54992834
Average data length: 5.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 2366
40 - 59% = 32993
60 - 79% = 4945
80 - 99% = 19394
EVENTS_INFO (132)
Primary pointer page: 142, Index root page: 143
Average record length: 23.38, total records: 44955088
Average version length: 21.83, total versions: 1899, max versions: 1
Data pages: 175992, data page slots: 175992, average fill: 63%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 937
60 - 79% = 175054
80 - 99% = 0
Index EVENTS_INFO_IDX1 (1)
Depth: 3, leaf buckets: 46631, nodes: 44958845
Average data length: 5.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 23
20 - 39% = 5562
40 - 59% = 19058
60 - 79% = 4478
80 - 99% = 17510
Index PK_EVENTS_INFO (0)
Depth: 3, leaf buckets: 47768, nodes: 44962261
Average data length: 5.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 7624
40 - 59% = 18958
60 - 79% = 3707
80 - 99% = 17479
EVENTTYPES (143)
Primary pointer page: 149045, Index root page: 149046
Average record length: 14.20, total records: 5
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index EVENTTYPES_IDX1 (1)
Depth: 1, leaf buckets: 1, nodes: 5
Average data length: 3.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_EVENTTYPES (0)
Depth: 1, leaf buckets: 1, nodes: 5
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
LOGINS (147)
Primary pointer page: 294965, Index root page: 294966
Average record length: 27.67, total records: 6
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index LOGINS_IDX1 (1)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index LOGINS_IDX2 (2)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 2.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_LOGINS (0)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ORDEREVENTTYPES (152)
Primary pointer page: 588769, Index root page: 588770
Average record length: 19.57, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ORDEREVENTTYPES_IDX1 (1)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_ORDEREVENTTYPES (0)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ORDERKINDS (151)
Primary pointer page: 588477, Index root page: 588478
Average record length: 15.00, total records: 1
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 0%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ORDERKINDS_IDX1 (1)
Depth: 1, leaf buckets: 1, nodes: 1
Average data length: 2.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_ORDERKINDS (0)
Depth: 1, leaf buckets: 1, nodes: 1
Average data length: 2.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ORDERS (145)
Primary pointer page: 294395, Index root page: 294396
Average record length: 11.99, total records: 534
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 2, data page slots: 2, average fill: 47%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0
Index ORDERS_IDX1 (1)
Depth: 1, leaf buckets: 1, nodes: 534
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_ORDERS (0)
Depth: 1, leaf buckets: 1, nodes: 534
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ORDERTYPES (148)
Primary pointer page: 298371, Index root page: 298372
Average record length: 22.00, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 12%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ORDERTYPES_IDX1 (2)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 9.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_ORDERTYPES (0)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ORDER_EVENTS (153)
Primary pointer page: 588986, Index root page: 588987
Average record length: 54.36, total records: 1202
Average version length: 60.21, total versions: 24, max versions: 1
Data pages: 13, data page slots: 13, average fill: 57%
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 4
60 - 79% = 6
80 - 99% = 0
Index ORDER_EVENTS_IDX1 (1)
Depth: 2, leaf buckets: 2, nodes: 1202
Average data length: 10.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0
Index ORDER_EVENTS_IDX2 (2)
Depth: 2, leaf buckets: 2, nodes: 1202
Average data length: 9.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0
Index ORDER_EVENTS_IDX3 (5)
Depth: 2, leaf buckets: 4, nodes: 1202
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index ORDER_EVENTS_IDX4 (6)
Depth: 2, leaf buckets: 4, nodes: 1202
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0
Index ORDER_EVENTS_IDX5 (3)
Depth: 2, leaf buckets: 3, nodes: 1202
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
Index ORDER_EVENTS_IDX6 (4)
Depth: 1, leaf buckets: 1, nodes: 1202
Average data length: 7.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
Index ORDER_EVENTS_IDX7 (7)
Depth: 2, leaf buckets: 3, nodes: 1202
Average data length: 10.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0
Index PK_ORDER_EVENTS (0)
Depth: 2, leaf buckets: 3, nodes: 1202
Average data length: 7.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
ORDER_EVENTS_INFO (161)
Primary pointer page: 897602, Index root page: 897603
Average record length: 45.64, total records: 246
Average version length: 60.00, total versions: 1, max versions: 1
Data pages: 2, data page slots: 2, average fill: 48%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index ORDER_EVENTS_INFO_IDX1 (1)
Depth: 1, leaf buckets: 1, nodes: 246
Average data length: 7.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_ORDER_EVENTS_INFO (0)
Depth: 1, leaf buckets: 1, nodes: 246
Average data length: 7.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
QUOTATIONS (128)
Primary pointer page: 134, Index root page: 135
Average record length: 19.00, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_QUOTATIONS (0)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index QUOTATIONS_IDX1 (1)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 4.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RATETYPES (130)
Primary pointer page: 138, Index root page: 139
Average record length: 19.84, total records: 88
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 20%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_RATETYPES (1)
Depth: 1, leaf buckets: 1, nodes: 88
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RATETYPES_IDX2 (3)
Depth: 1, leaf buckets: 1, nodes: 88
Average data length: 0.00, total dup: 83, max dup: 34
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RATETYPES_IDX3 (4)
Depth: 1, leaf buckets: 1, nodes: 88
Average data length: 0.00, total dup: 79, max dup: 10
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RATETYPES_IDX4 (5)
Depth: 1, leaf buckets: 1, nodes: 88
Average data length: 0.00, total dup: 56, max dup: 3
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RATETYPES_IDX8 (8)
Depth: 1, leaf buckets: 1, nodes: 88
Average data length: 3.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RATETYPES_IDX9 (9)
Depth: 1, leaf buckets: 1, nodes: 88
Average data length: 0.00, total dup: 83, max dup: 31
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SOURCES (129)
Primary pointer page: 136, Index root page: 137
Average record length: 14.00, total records: 6
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SOURCES (0)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SOURCES_IDX1 (1)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 3.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
USERS (146)
Primary pointer page: 294923, Index root page: 294924
Average record length: 28.67, total records: 6
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_USERS (0)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index USERS_IDX1 (1)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 15.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
