MySQL Forums
Forum List  »  Partitioning

Re: what is user-defined partitioning
Posted by: Rick James
Date: July 09, 2016 10:53PM

I don't know what the intent behind "user-defined" was.

I see "partitioning" as

* What is discussed in chapter 19.

* "vertical partitioning" where you manually split a table into two tables - some columns in one table, some in the other. This is rarely needed in InnoDB.

* "Sharding", which may feel like "partitioning", but it is not. Think of it as partitioning across multiple servers. There is no built-in support for sharding in MySQL or MariaDB, but some 3rd party packages help.

So, the chapter 19 is really the only kind being discussed in the documentation.

My discussion of how to effectively use partitioning, and when it is not useful: http://mysql.rjweb.org/doc.php/partitionmaint

Options: ReplyQuote


Subject
Views
Written By
Posted
933
July 04, 2016 07:33PM
Re: what is user-defined partitioning
567
July 09, 2016 10:53PM
400
September 20, 2016 03:36AM
382
September 24, 2016 04:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.