Details
-
Task
-
Status: Open (View Workflow)
-
Trivial
-
Resolution: Unresolved
-
None
-
None
-
None
Description
SHOW ENGINES output has the following columns:
- Engine
- Support
- Comment
- Transactions
- XA
- Savepoints
First 3 columns are general purpose and useful. Others are related to specific features. Transactions is probably useful but it's a special case. XA and especially Savepoints are not more important than other features, like indexes, compression, fulltext, GIS, etc. Sometimes feature-related columns are even confusing (FEDERATED). I suggest to remove them - otherwise you should choose between be consistent and having a reasonable number of columns.
An important column is also missing: you should indicate which storage engines can be used in CREATE TABLE. PERFORMANCE_SCHEMA and INFORMATION_SCHEMA can't.