MySQL Forums :: Partitioning :: what is user-defined partitioning


Advanced Search

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
what is user-defined partitioning 721 aaron chan 07/04/2016 07:33PM
Re: what is user-defined partitioning 475 Rick James 07/09/2016 10:53PM
Re: what is user-defined partitioning 365 Jon Stephens 07/12/2016 01:02AM
Re: what is user-defined partitioning 343 Rick James 07/15/2016 05:17PM
Re: what is user-defined partitioning 283 Jon Stephens 09/20/2016 03:36AM
Re: what is user-defined partitioning 303 Rick James 09/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.