Description:
On larger configurations, we would need to see >2G values in the counters or memory sizes displayed by the various falcon tables in information_schema.
Currently, all numbers are INT(4) and they might wrap or show wrong information.
How to repeat:
mysql> describe information_schema.FALCON_RECORD_CACHE_SUMMARY;
+---------------+--------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------+------+-----+---------+-------+
| TOTAL_SPACE | int(4) | NO | | 0 | |
| FREE_SPACE | int(4) | NO | | 0 | |
| FREE_SEGMENTS | int(4) | NO | | 0 | |
| BIG_HUNKS | int(4) | NO | | 0 | |
| SMALL_HUNKS | int(4) | NO | | 0 | |
| UNIQUE_SIZES | int(4) | NO | | 0 | |
+---------------+--------+------+-----+---------+-------+
6 rows in set (0.02 sec)
mysql> describe information_schema.FALCON_SYSTEM_MEMORY_DETAIL;
+-----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| FILE | varchar(120) | NO | | | |
| LINE | int(4) | NO | | 0 | |
| OBJECTS_IN_USE | int(4) | NO | | 0 | |
| SPACE_IN_USE | int(4) | NO | | 0 | |
| OBJECTS_DELETED | int(4) | NO | | 0 | |
| SPACE_DELETED | int(4) | NO | | 0 | |
+-----------------+--------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
mysql> describe information_schema.FALCON_SYSTEM_MEMORY_SUMMARY;
+---------------+--------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------+------+-----+---------+-------+
| TOTAL_SPACE | int(4) | NO | | 0 | |
| FREE_SPACE | int(4) | NO | | 0 | |
| FREE_SEGMENTS | int(4) | NO | | 0 | |
| BIG_HUNKS | int(4) | NO | | 0 | |
| SMALL_HUNKS | int(4) | NO | | 0 | |
| UNIQUE_SIZES | int(4) | NO | | 0 | |
+---------------+--------+------+-----+---------+-------+
6 rows in set (0.00 sec)
mysql> describe information_schema.FALCON_SYNCOBJECTS;
+--------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| WHERE | varchar(120) | NO | | | |
| SHARED | int(4) | NO | | 0 | |
| EXCLUSIVE | int(4) | NO | | 0 | |
| WAITS | int(4) | NO | | 0 | |
| QUEUE_LENGTH | int(4) | NO | | 0 | |
+--------------+--------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> describe information_schema.FALCON_RECORD_CACHE_DETAIL;
+-----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| FILE | varchar(120) | NO | | | |
| LINE | int(4) | NO | | 0 | |
| OBJECTS_IN_USE | int(4) | NO | | 0 | |
| SPACE_IN_USE | int(4) | NO | | 0 | |
| OBJECTS_DELETED | int(4) | NO | | 0 | |
| SPACE_DELETED | int(4) | NO | | 0 | |
+-----------------+--------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
mysql> describe information_schema.FALCON_TRANSACTION_SUMMARY;
+--------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------+-------+
| DATABASE | varchar(120) | NO | | | |
| COMMITTED | int(4) | NO | | 0 | |
| ROLLED_BACK | int(4) | NO | | 0 | |
| ACTIVE | int(4) | NO | | 0 | |
| PENDING_COMMIT | int(4) | NO | | 0 | |
| PENDING_COMPLETION | int(4) | NO | | 0 | |
+--------------------+--------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
mysql> describe information_schema.FALCON_DATABASE_IO;
+----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| DATABASE | varchar(120) | NO | | | |
| PAGE_SIZE | int(4) | NO | | 0 | |
| BUFFERS | int(4) | NO | | 0 | |
| PHYSICAL_READS | int(4) | NO | | 0 | |
| WRITES | int(4) | NO | | 0 | |
| LOGICAL_READS | int(4) | NO | | 0 | |
| FAKES | int(4) | NO | | 0 | |
+----------------+--------------+------+-----+---------+-------+
7 rows in set (0.00 sec)
mysql> describe information_schema.FALCON_TRANSACTIONS;
+-------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| DATABASE | varchar(120) | NO | | | |
| THREAD_ID | int(4) | NO | | 0 | |
| ID | int(4) | NO | | 0 | |
| STATE | varchar(10) | NO | | | |
| UPDATES | int(4) | NO | | 0 | |
| PENDING | int(4) | NO | | 0 | |
| DEP | int(4) | NO | | 0 | |
| OLDEST | int(4) | NO | | 0 | |
| RECORDS | int(4) | NO | | 0 | |
| WAITING_FOR | int(4) | NO | | 0 | |
| STATEMENT | varchar(120) | NO | | | |
+-------------+--------------+------+-----+---------+-------+
11 rows in set (0.02 sec)
mysql> describe information_schema.FALCON_SERIAL_LOG;
+--------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| DATABASE | varchar(120) | NO | | | |
| TRANSACTIONS | int(4) | NO | | 0 | |
| BLOCKS | bigint(8) | NO | | 0 | |
| WINDOWS | int(4) | NO | | 0 | |
| BUFFERS | int(4) | NO | | 0 | |
+--------------+--------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
Suggested fix:
Perhaps BIGINT UNSIGNED is more appropriate for some columns.
I guess now that bug #27047 is fixed, this can be implemented.
