Skip navigation links

MySQL Forums :: Cluster :: Insert / deleting instead of insert if not exists or update. Hard disk usage.


Advanced Search

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. 772 Daniel Fernandez 01/16/2013 06:46AM
Re: Insert / deleting instead of insert if not exists or update. Hard disk usage. 421 Daniel Fernandez 01/16/2013 08:58AM


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.