Ask Your Question
0

nova never delete records in mysql [closed]

asked 2013-05-30 17:48:59 -0500

chen-li gravatar image

When I working on Openstack, I noticed that mysql data size keep increase. Looks like nova never delete records from mysql for deleted instances. Is this a bug ? Or it designed to work like this ? If it is designed to work like this, why ?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by koolhead17
close date 2014-06-05 08:44:06.607488

5 answers

Sort by ยป oldest newest most voted
1

answered 2013-06-03 03:26:35 -0500

boris-42 gravatar image

Yes we are using "soft" deletion instead of deleting "records". It means that we mark records as deleted (using special column called "deleted").

So this approach is used by design.

If you would like to clean your db, then probably db-archiving will be interesting for you. DB-Archiving is new feature in Nova (grizzly) that allows you to move deleted records from tables to shadow tables. And then you will be able safely to remove these records from shadow.

Currently we are working on db-archiving support in other OpenStack projects. I think we will implement it in Havana.

edit flag offensive delete link more

Comments

nova-manage db archive_deleted_rows --max_rows 1143146 --verbose but it do not work for me in Mitaka

BiG_NoBoDy gravatar imageBiG_NoBoDy ( 2019-02-21 09:26:56 -0500 )edit
0

answered 2013-06-04 08:07:43 -0500

chen-li gravatar image

Thanks Boris Pavlovic, that solved my question.

edit flag offensive delete link more
0

answered 2014-01-08 09:43:33 -0500

tsjsdbd gravatar image

what's the exact commod for doing this?

#nova-manage db archive_deleted_rows --max_rows 1 is this one?

and how to remove these records from shadow?

edit flag offensive delete link more
0

answered 2014-01-09 09:02:37 -0500

gtt116 gravatar image

I'm afraid the only way is removing these rows by using sql commands

edit flag offensive delete link more
0

answered 2013-05-31 17:04:34 -0500

shantha-kumar gravatar image

No only nova, all the openstack stack components services behave in the same way.

Its not a bug, its a actual behavior of openstack WRT mysql.

edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2013-05-30 17:48:59 -0500

Seen: 437 times

Last updated: Jan 09 '14