Bug #17356 Table Editor does not list new storage engines.
Submitted: 13 Feb 2006 23:58 Modified: 26 Sep 2006 11:47
Reporter: Mike Hillyer Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.20 OS:Windows (Windows XP Pro SP2)
Assigned to: Michael G. Zinner CPU Architecture:Any
Tags: Object Editors

[13 Feb 2006 23:58] Mike Hillyer
Description:
The table editor of the Query Browser/Administrator does not list the newer storage engines including Archive, BLACKHOLE, etc.

How to repeat:
Open the table editor from within the Query Browser by right-clicking on a table and choosing edit table.

Switch to Table Options tab.

Look for Archive Storage Engine.

Suggested fix:
Add Archive and Blackhole to list of storage engines used to populate list.

Better: Enumerage the results of SHOW STORAGE ENGINES:

+------------+---------+--------------------------------------------------------
--------+
| Engine     | Support | Comment
        |
+------------+---------+--------------------------------------------------------
--------+
| MyISAM     | YES     | Default engine as of MySQL 3.23 with great performance
        |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tabl
es      |
| InnoDB     | DEFAULT | Supports transactions, row-level locking, and foreign k
eys     |
| BerkeleyDB | NO      | Supports transactions and page-level locking
        |
| BLACKHOLE  | NO      | /dev/null storage engine (anything you write to it disa
ppears) |
| EXAMPLE    | NO      | Example storage engine
        |
| ARCHIVE    | YES     | Archive storage engine
        |
| CSV        | NO      | CSV storage engine
        |
| ndbcluster | NO      | Clustered, fault-tolerant, memory-based tables
        |
| FEDERATED  | NO      | Federated MySQL storage engine
        |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables
        |
| ISAM       | NO      | Obsolete storage engine
        |
+------------+---------+--------------------------------------------------------
--------+
12 rows in set (0.00 sec)

mysql>

List any storage engines where Support = YES using either a stored description or the contents of the Comment column. Set the default storage engine to whichever storage engine is listed as DEFAULT in the SHOW STORAGE ENGINES output.
[14 Feb 2006 11:40] Valeriy Kravchuk
Thank you for a bug report. Verified just as described.
[26 Sep 2006 11:47] Mike Lischke
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html