| 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: | |
| 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 | ||
[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
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.