MySQL Bugs: #35490: FALCON_DATABASE_IO should be FALCON_TABLESPACE

Bug #35490	FALCON_DATABASE_IO should be FALCON_TABLESPACE_IO
Submitted:	21 Mar 2008 20:38	Modified:	27 Aug 2008 17:09
Reporter:	Kevin Lewis	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Falcon storage engine	Severity:	S3 (Non-critical)
Version:	6.0.4	OS:	Any
Assigned to:	Kevin Lewis	CPU Architecture:	Any

Description:
Robin Schumacher wrote;
I'm writing a new article on the falcon diagnostic tables and just noticed that the falcon_database_io table really doesn't show information by database, but rather by tablespace - should it instead be called falcon_tablespace_io?  Or can we get diagnostics by database instead of by tablespace?

Ann Harrison wrote;
The diagnostics are available only by tablespace, so it probably
makes sense to change the name of the column.

How to repeat:
mysql> show tables like 'falcon_d%';
+----------------------------------------+
| Tables_in_information_schema (falcon%) |
+----------------------------------------+
| FALCON_DATABASE_IO                     |
+----------------------------------------+
11 rows in set (0.00 sec)

mysql> select * from falcon_database_IO;
+------------------+-----------+---------+----------------+--------+---------------+-------+
| TABLESPACE       | PAGE_SIZE | BUFFERS | PHYSICAL_READS | WRITES | LOGICAL_READS | FAKES |
+------------------+-----------+---------+----------------+--------+---------------+-------+
| FALCON_MASTER    |      4096 |    1024 |              0 |      0 |          5005 |   111 |
| FALCON_TEMPORARY |      4096 |    1024 |              0 |      4 |             0 |     4 |
| FALCON_USER      |      4096 |    1024 |              3 |      4 |            43 |    10 |
+------------------+-----------+---------+----------------+--------+---------------+-------+

Suggested fix:
Change the name of the table.

mysql> show tables like 'falcon%';
+----------------------------------------+
| Tables_in_information_schema (falcon%) |
+----------------------------------------+
| FALCON_TABLES                          |
| FALCON_RECORD_CACHE_SUMMARY            |
| FALCON_SYSTEM_MEMORY_DETAIL            |
| FALCON_SYSTEM_MEMORY_SUMMARY           |
| FALCON_VERSION                         |
| FALCON_TRANSACTION_SUMMARY             |
| FALCON_SERIAL_LOG_INFO                 |
| FALCON_SYNCOBJECTS                     |
| FALCON_TRANSACTIONS                    |
| FALCON_RECORD_CACHE_DETAIL             |
| FALCON_TABLESPACE_IO                   |
+----------------------------------------+
11 rows in set (0.00 sec)

mysql> select * from falcon_tablespace_IO;
+------------------+-----------+---------+----------------+--------+---------------+-------+
| TABLESPACE       | PAGE_SIZE | BUFFERS | PHYSICAL_READS | WRITES | LOGICAL_READS | FAKES |
+------------------+-----------+---------+----------------+--------+---------------+-------+
| FALCON_MASTER    |      4096 |    1024 |             49 |      1 |           984 |     3 |
| FALCON_TEMPORARY |      4096 |    1024 |              1 |      0 |             0 |     1 |
| FALCON_USER      |      4096 |    1024 |              1 |      0 |             0 |     1 |
+------------------+-----------+---------+----------------+--------+---------------+-------+

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/44338

ChangeSet@1.2605, 2008-03-21 15:42:16-05:00, klewis@klewis-mysql. +2 -0
  Bug#35490 - Rename falcon_database_io to falcon_tablespace_io

Pushed into 6.0.5-alpha

Noted in 6.0.5 changelog.

In the INFORMATION_SCHEMA database, the FALCON_DATABASE_IO table was
renamed to FALCON_TABLESPACE_IO.