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
2242
November 29, 2013 05:03AM
1274
November 29, 2013 06:22AM
1383
November 30, 2013 02:18PM
1191
December 04, 2013 12:38AM
Re: Am I doing this correctly?
1240
December 05, 2013 03:48AM
1293
December 05, 2013 10:21AM
1219
December 10, 2013 09:49AM
1262
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.