MySQL Forums
Forum List  »  Partitioning

Re: Am I doing this correctly?
Posted by: Jim Buckley Barrett
Date: December 05, 2013 03:48AM

Rick,

Sorry for the late reply never got the notification by email that some one replied.

When you say it will slow down INSERTs any ideas by how much? we are inserting around 115,000 records each day some times more.

The reason behind this is that I have to delete data regularly and I'm finding it is causing deadlock. I thought if I partition I could just drop a partition.

Maybe partitioning isn't the best solution. Any suggestions are welcome.

Jim

Options: ReplyQuote


Subject
Views
Written By
Posted
2706
November 29, 2013 05:03AM
1539
November 29, 2013 06:22AM
1646
November 30, 2013 02:18PM
1427
December 04, 2013 12:38AM
Re: Am I doing this correctly?
1478
December 05, 2013 03:48AM
1542
December 05, 2013 10:21AM
1465
December 10, 2013 09:49AM
1491
December 05, 2013 03:51AM


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.