New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database Size #599

Closed
oliviersaintgobain opened this Issue Aug 22, 2017 · 6 comments

Comments

Projects
None yet
2 participants
@oliviersaintgobain

oliviersaintgobain commented Aug 22, 2017

Hello,
we are working on a version 1.5.74 of bimserver.
we made a lot of test but now, it's difficult because the database is huge and the memory is full at the start of the bimserver...
volume of DB (berkeley database space):

  • 2284 jdb files
  • more than 22 Go

how to proceed to check the content of the berkeley java db ?
how to clean this database ?

thanks a lot

olivier

@xie-qianyue

This comment has been minimized.

Show comment
Hide comment
@xie-qianyue

xie-qianyue Aug 23, 2017

When you say "clean" the database, do you mean drop the data physically? If so, you can search "delete physically" in the issues, there have been several discussions on that topic.

xie-qianyue commented Aug 23, 2017

When you say "clean" the database, do you mean drop the data physically? If so, you can search "delete physically" in the issues, there have been several discussions on that topic.

@oliviersaintgobain

This comment has been minimized.

Show comment
Hide comment
@oliviersaintgobain

oliviersaintgobain Aug 23, 2017

yes correct. but in your post, I don't really see any concrete solution. You mention that you developd your own procedure to "delete" data in the db, but we can't see the source code. is it possible to share it ?
thanks.

oliviersaintgobain commented Aug 23, 2017

yes correct. but in your post, I don't really see any concrete solution. You mention that you developd your own procedure to "delete" data in the db, but we can't see the source code. is it possible to share it ?
thanks.

@xie-qianyue

This comment has been minimized.

Show comment
Hide comment
@xie-qianyue

xie-qianyue Aug 23, 2017

My solution is to drop the data by project, not to clean the database. I'm not sure whether it fits your request. Also I remember that the author @rubendel have said that it may have an official "physical delete".

xie-qianyue commented Aug 23, 2017

My solution is to drop the data by project, not to clean the database. I'm not sure whether it fits your request. Also I remember that the author @rubendel have said that it may have an official "physical delete".

@oliviersaintgobain

This comment has been minimized.

Show comment
Hide comment
@oliviersaintgobain

oliviersaintgobain Aug 23, 2017

ok. so, how to drop the data by project ? (it will fit my request ;))

oliviersaintgobain commented Aug 23, 2017

ok. so, how to drop the data by project ? (it will fit my request ;))

@xie-qianyue

This comment has been minimized.

Show comment
Hide comment
@xie-qianyue

xie-qianyue Aug 25, 2017

Here is the class for the delete function. I couldn't create the whole project on github.

xie-qianyue commented Aug 25, 2017

Here is the class for the delete function. I couldn't create the whole project on github.

@oliviersaintgobain

This comment has been minimized.

Show comment
Hide comment
@oliviersaintgobain

oliviersaintgobain Sep 24, 2018

it's working fine. thanks

oliviersaintgobain commented Sep 24, 2018

it's working fine. thanks

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment