Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| LOG_TYPE | enum('BINARY', 'RELAY') | 6 | null |
|
|
The log type to which the transactions were written. |
||
| COMPRESSION_TYPE | VARCHAR | 64 | null |
|
|
The transaction compression algorithm used. |
||
| TRANSACTION_COUNTER | BIGINT UNSIGNED | 20 | null |
|
|
Number of transactions written to the log |
||
| COMPRESSED_BYTES_COUNTER | BIGINT UNSIGNED | 20 | null |
|
|
The total number of bytes compressed. |
||
| UNCOMPRESSED_BYTES_COUNTER | BIGINT UNSIGNED | 20 | null |
|
|
The total number of bytes uncompressed. |
||
| COMPRESSION_PERCENTAGE | SMALLINT | 5 | null |
|
|
The compression ratio as a percentage. |
||
| FIRST_TRANSACTION_ID | TEXT | 65535 | √ | null |
|
|
The first transaction written. |
|
| FIRST_TRANSACTION_COMPRESSED_BYTES | BIGINT UNSIGNED | 20 | null |
|
|
First transaction written compressed bytes. |
||
| FIRST_TRANSACTION_UNCOMPRESSED_BYTES | BIGINT UNSIGNED | 20 | null |
|
|
First transaction written uncompressed bytes. |
||
| FIRST_TRANSACTION_TIMESTAMP | TIMESTAMP | 26 | √ | null |
|
|
When the first transaction was written. |
|
| LAST_TRANSACTION_ID | TEXT | 65535 | √ | null |
|
|
The last transaction written. |
|
| LAST_TRANSACTION_COMPRESSED_BYTES | BIGINT UNSIGNED | 20 | null |
|
|
Last transaction written compressed bytes. |
||
| LAST_TRANSACTION_UNCOMPRESSED_BYTES | BIGINT UNSIGNED | 20 | null |
|
|
Last transaction written uncompressed bytes. |
||
| LAST_TRANSACTION_TIMESTAMP | TIMESTAMP | 26 | √ | null |
|
|
When the last transaction was written. |
Relationships
Close relationships within degrees of separation
