[MDEV-15223] Document that InnoDB's native partitioning was not merged into MariaDB Created: 2018-02-06  Updated: 2020-08-25  Resolved: 2018-02-12

Status: Closed
Project: MariaDB Server
Component/s: Documentation, Partitioning, Storage Engine - InnoDB
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Ian Gilfillan
Resolution: Fixed Votes: 1
Labels: documentation, innodb, partitioning

Issue Links:
Relates
relates to MDEV-15242 Poor RBR update performance with part... Closed
relates to MDEV-6113 merge 5.7 innodb Closed

 Description   

We can see that InnoDB's native partitioning from MySQL 5.7 was not merged into MariaDB from the following commit message:

https://github.com/MariaDB/server/commit/358ab5d6b1460b7ab6e2d58c0444bf4a54a8f44b

However, this doesn't seem to be documented. Maybe it should be documented somewhere in the InnoDB and/or Partitioning sections?

https://mariadb.com/kb/en/library/partitioning-tables/

https://mariadb.com/kb/en/library/xtradb-and-innodb/



 Comments   
Comment by Ian Gilfillan [ 2018-02-09 ]

This has been documented in https://mariadb.com/kb/en/library/incompatibilities-and-feature-differences-between-mariadb-102-and-mysql-57/ and https://mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/#incompatibilities-between-mariadb-101-and-mysql-57

Is this sufficient? I don't think it needs to be added to the InnoDB or partitioning sections. Both those sections are fairly incomplete, so the priority should be document what is there. not what isn't, but that's another issue...

Comment by Geoff Montee (Inactive) [ 2018-02-09 ]

That does sound sufficient. Thanks!

Although, if we don't manage to fix MDEV-15242, then it may also be a good idea to add a disclaimer to the documentation section on partitioning that it can negatively affect replication performance. That seems to be tied to the lack of native partitioning, since MySQL 5.7 performs quite a bit better.

Comment by Ian Gilfillan [ 2018-02-12 ]

Also documented the slowness on the partitioning limitations page.

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