[MDEV-16343] SHOW ENGINES output table is not really informative Created: 2018-05-30  Updated: 2018-05-30

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Trivial
Reporter: Federico Razzoli Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: 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.


Generated at Thu Feb 08 08:28:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.