MySQL Forums
Forum List  »  NDB clusters

Insert / deleting instead of insert if not exists or update. Hard disk usage.
Posted by: Daniel Fernandez
Date: January 16, 2013 06:46AM

Hi all,

I would appreciate much an advice about this issue. I have a logger table inside a mysql cluster that works as a buffer ring: It inserts one entry and immediately after it deletes an entry with the id = new_id-buffer_size.

This works well and is quite fast, more than checking if the row with an give id exists to update it or otherwise inserting it. When I explained the solution to the customer he said that this approach will cause the database in the hard disk grow indefinitely as we are inserting always and the deleting will create holes 'as a Swiss cheese', in his words, in the database.

Is it true? Is there any place I can document about this issue?

Thanks again,
Dani.

Options: ReplyQuote


Subject
Views
Written By
Posted
Insert / deleting instead of insert if not exists or update. Hard disk usage.
1342
January 16, 2013 06:46AM


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.