[MDEV-16342] SHOW ENGINES: MyISAM description is useless Created: 2018-05-30  Updated: 2018-06-11  Resolved: 2018-06-11

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - MyISAM
Affects Version/s: 10.3
Fix Version/s: 5.5.61, 10.0.36, 10.1.34, 10.2.16, 10.3.8

Type: Bug Priority: Trivial
Reporter: Federico Razzoli Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: myisam


 Description   

In the output of SHOW ENGINES, MyISAM is described as "MyISAM storage engine". This adds no information and seems to me useful.

My suggestion is to add a comment which makes clear that MyISAM is no more intended for general use.



 Comments   
Comment by Elena Stepanova [ 2018-05-31 ]

Did we already claim somewhere that MyISAM is no more intended for general use?

Comment by Federico Razzoli [ 2018-05-31 ]

This page:

https://mariadb.com/kb/en/library/myisam-storage-engine/

suggests to use Aria instead of MyISAM. I wouldn't suggest a specific engine, but again, that's just my opinion. My point is that "MyISAM storage engine" is not a description.

Comment by Elena Stepanova [ 2018-05-31 ]

I wouldn't say it translates into "MyISAM is no more intended for general use", but I'll leave it to serg to decide.

Comment by Sergei Golubchik [ 2018-05-31 ]

KB says

MyISAM was the default storage engine from MySQL 3.23 until it was replaced by InnoDB in MariaDB and MySQL 5.5. It's a light, non-transactional engine with great performance, is easy to copy between systems and has a small data footprint.

I can use it for an engine description, like "light-weight, non-transactional engine with great performance and a small data footprint."

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