Description:
Some Falcon tables (due to performance concerns) are filled only when one uses debug binary.
See output below:
regular binary:
mysql> select * from FALCON_SYSTEM_MEMORY_SUMMARY;
Empty set (0.00 sec)
mysql> select * from FALCON_SYSTEM_MEMORY_DETAIL;
Empty set (0.00 sec)
mysql> select * from FALCON_RECORD_CACHE_SUMMARY;
Empty set (0.00 sec)
mysql> select * from FALCON_RECORD_CACHE_DETAIL;
Empty set (0.00 sec)
debug binary:
mysql> select * from FALCON_SYSTEM_MEMORY_SUMMARY;
+-------------+------------+---------------+-----------+-------------+--------------+
| TOTAL_SPACE | FREE_SPACE | FREE_SEGMENTS | BIG_HUNKS | SMALL_HUNKS | UNIQUE_SIZES |
+-------------+------------+---------------+-----------+-------------+--------------+
| 4195336 | 2094184 | 1 | 1 | 1 | 1 |
+-------------+------------+---------------+-----------+-------------+--------------+
1 row in set (0.00 sec)
mysql> select * from FALCON_SYSTEM_MEMORY_DETAIL;
+--------------------+------+----------------+--------------+-----------------+---------------+
| FILE | LINE | OBJECTS_IN_USE | SPACE_IN_USE | OBJECTS_DELETED | SPACE_DELETED |
+--------------------+------+----------------+--------------+-----------------+---------------+
| Log.cpp | 166 | 1 | 64 | 0 | 0 |
| StorageHandler.cpp | 90 | 1 | 2904 | 0 | 0 |
+--------------------+------+----------------+--------------+-----------------+---------------+
2 rows in set (0.00 sec)
mysql> select * from FALCON_RECORD_CACHE_SUMMARY;
+-------------+------------+---------------+-----------+-------------+--------------+
| TOTAL_SPACE | FREE_SPACE | FREE_SEGMENTS | BIG_HUNKS | SMALL_HUNKS | UNIQUE_SIZES |
+-------------+------------+---------------+-----------+-------------+--------------+
| 8 | 0 | 0 | 0 | 0 | 0 |
+-------------+------------+---------------+-----------+-------------+--------------+
1 row in set (0.00 sec)
select * from FALCON_RECORD_CACHE_DETAIL;
+------------+------+----------------+--------------+-----------------+---------------+
| FILE | LINE | OBJECTS_IN_USE | SPACE_IN_USE | OBJECTS_DELETED | SPACE_DELETED |
+------------+------+----------------+--------------+-----------------+---------------+
| Table.cpp | 3542 | 258 | 22704 | 0 | 0 |
| Record.cpp | 948 | 280 | 24344 | 0 | 0 |
| Table.cpp | 3524 | 22 | 3168 | 0 | 0 |
+------------+------+----------------+--------------+-----------------+---------------+
3 rows in set (0.00 sec)
How to repeat:
Add note that data for some falcon I_S tables are available only with debug binary
