MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: From production to archive ..
Posted by: Jonathan Stephens
Date: October 08, 2012 02:36AM

Rick James Wrote:
-------------------------------------------------------

> 4TB of data and FOREIGN KEYs may not play nicely
> together. Are you beginning to see performance
> issues?


Partitioning and foreign keys definitely do not play nicely together.

See https://dev.mysql.com/doc/refman/5.5/en/partitioning-limitations.html.

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
From production to archive ..
1698
Mike Moran
September 28, 2012 09:42AM
Re: From production to archive ..
871
Rick James
October 01, 2012 07:22PM
Re: From production to archive ..
689
Mike Moran
October 04, 2012 08:24AM
Re: From production to archive ..
766
Jonathan Stephens
October 05, 2012 01:53AM
Re: From production to archive ..
742
Rick James
October 07, 2012 04:54PM
Re: From production to archive ..
770
Jonathan Stephens
October 08, 2012 02:36AM
Re: From production to archive ..
849
Mike Moran
October 30, 2012 09:48AM
Re: From production to archive ..
785
Mike Moran
October 30, 2012 10:50AM
Re: From production to archive ..
820
Rick James
October 30, 2012 12:51PM


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.