Bug #29169 show globals status displays falcon variables
Submitted: 18 Jun 2007 9:29 Modified: 31 Aug 2007 12:28
Reporter: Oli Sennhauser Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0.0 OS:Any
Assigned to: CPU Architecture:Any

[18 Jun 2007 9:29] Oli Sennhauser 
Description:
show global status or select * from information_schema displays the 2 falcon variables

| FALCON_LOG_DIR           |        0.0000000 |
| FALCON_MAX_RECORD_MEMORY | 20971520.0000000 |

which is imho wrong.

How to repeat:
select * from GLOBAL_VARIABLES where variable_name like 'FALCON%';
+--------------------------+----------------+
| VARIABLE_NAME            | VARIABLE_VALUE |
+--------------------------+----------------+
| FALCON_LOG_DIR           |                |
| FALCON_MAX_RECORD_MEMORY | 20971520       |
| FALCON_MIN_RECORD_MEMORY | 0              |
| FALCON_PAGE_CACHE_SIZE   | 4194304        |
| FALCON_LOG_MASK          | 0              |
| FALCON_DEBUG_SERVER      | OFF            |
| FALCON_PAGE_SIZE         | 4096           |
+--------------------------+----------------+

select * from GLOBAL_STATUS where variable_name like 'FALCON%';
+--------------------------+------------------+
| VARIABLE_NAME            | VARIABLE_VALUE   |
+--------------------------+------------------+
| FALCON_LOG_DIR           |        0.0000000 |
| FALCON_MAX_RECORD_MEMORY | 20971520.0000000 |
+--------------------------+------------------+

Suggested fix:
not display them!
[18 Jun 2007 10:51] Hakan Küçükyılmaz 
Verified as described

| DELAYED_WRITES                 | 0              |
| FALCON_LOG_DIR                 |                |
| FALCON_MAX_RECORD_MEMORY       | 268435456      |
| FLUSH_COMMANDS                 | 1              |
| HANDLER_COMMIT                 | 4              |
| HANDLER_DELETE                 | 0              |
[18 Jun 2007 11:31] Bugs System 
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/28981

ChangeSet@1.2575, 2007-06-18 13:30:44+02:00, hakank@lu0011.wdf.sap.corp +1 -0
  Fix for Bug#29169.
[29 Aug 2007 16:31] Hakan Küçükyılmaz 
Fixed.
[31 Aug 2007 12:28] MC Brown 
Some Falcon variables were marked as status variables.
[31 Aug 2007 12:29] MC Brown 
A note has been added to the 6.0.2 changelog: 

Some Falcon variables were marked as status variables.