MySQL Forums
Forum List  »  InnoDB

Re: From production to archive ..
Posted by: Mike Moran
Date: October 30, 2012 09:48AM

Fortunately, the performance issues are still mostly do to php. We have php time out more than anything else and the customer just thinks it is a php problem :-)

As far as mgmt goes, they know the bad design that they also inherited, so I get full mgmt support for any structural changes I want to make until I requires more than a weekend to implement.

Speaking of which, I tried to partition the test environment by range and was shot down by the presence of foreign keys.

Error Code: 1217. Cannot delete or update a parent row: a foreign key constraint fails

So is there a way to add partition by range to a table with foreign keys ?

Options: ReplyQuote


Subject
Views
Written By
Posted
1694
September 28, 2012 09:42AM
867
October 01, 2012 07:22PM
686
October 04, 2012 08:24AM
740
October 07, 2012 04:54PM
Re: From production to archive ..
842
October 30, 2012 09:48AM
784
October 30, 2012 10:50AM
817
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.