Talk:Comparison of MySQL database engines: Difference between revisions

Revision as of 09:58, 24 June 2020

Revision as of 10:58, 13 November 2020

Line 11:

:I think it would be a good idea to turn this into an actual table of storage engine features, with some detailed description of some of the more finer differences above/below the table. Whenever someone gets the chance. <span style="color:#FF0000">~</span> '''[[User:JoshDuffMan|Josh "Duff Man"]]''' ([[User_talk:JoshDuffMan|talk]]) 05:06, 25 October 2011 (UTC)

:Perhaps the above comments are dated. There is no apparent bias. In professional relational DB circles InnoDB is strongly preferred. Indeed most relational database systems do not offer an engine that is less capable of full ACID. The article is well written and to the point. Perhaps someone that has a really great use case or two for MyISAM can add to it. Personally I have yet to find a case where it is the right choice. <!-- Template:Unsigned --><small class="autosigned">—&nbsp;Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[User:Sjatkins|Sjatkins]] ([[User talk:Sjatkins#top|talk]] • [[Special:Contributions/Sjatkins|contribs]]) 20:49, 2 May 2017 (UTC)</small> <!--Autosigned by SineBot-->

== Proposals to modify the table ==

I propose some changes to the storage engines table.

* Move obsolete engines to another table, with its own title. So we don't pollute information about the currently supported engines.

* We could add columns "MySQL versions" and "MariaDB versions". Content example: "5.0-5.5". in this way it will be clear if the engine is still available, and when it was first made available.

* If the previous proposal is accepted, please let's remove "actively developed". For example, FEDERATED may not be actively developed but it's shipped with both MySQL and MariaDB. MyISAM is not actively developed since the Stone Age, except for some additions made by MariaDB in the Middle Age.

* We could add a column "Description". It should contain a single statement about the engine. When it makes sense, it should be copied from the output of the SHOW ENGINES command. Where the command doesn't provide a meaningful description (for example, for MyISAM is just says "MyISAM storage engine", which means nothing) we can describe the engine in the shortest possible way.

I can make the changes myself if they're approved. --[[Special:Contributions/81.98.53.246|81.98.53.246]] ([[User talk:81.98.53.246|talk]]) 10:58, 13 November 2020 (UTC)