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