MySQL Forums
Forum List  »  Partitioning

Re: MySql Horizontal partitioning - Pros-Cons
Posted by: Rick James
Date: April 17, 2014 11:16PM

> And also is there any alternate solution for partitioning to get performance improvement and data separation.

First, let me dispel the myth that PARTITIONing will automatically give you a performance improvement. There are a limited number (about 3) of use cases for which PARTITIONing gives any perf. Please describe your dataset, and why you think partitioning might help.

Second, I question whether you really need FOREIGN KEYs in a production system. The code should be thoroughly QA'd such that the FK checks never find a problem with data integrity. Any CASCADEing can be done in code, or buried in Stored Procedures, or a "database layer" between the end-users and the server.
And... FOREIGN KEY checks are a performance hit.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySql Horizontal partitioning - Pros-Cons
2360
April 17, 2014 11:16PM


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.