We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

DB auto-deletion of unused data [Being checked] | Forum

S. Bourdon
S. Bourdon Jul 14 '13
Hello,


While going through the database, I noticed that some tables were getting bigger and bigger without ever being emptied from unused data...


These tables don't seem to get rid of unused data:

- ow_ajaxim_message

- ow_base_login_cookie

- ow_base_media_panel_file

- ow_base_tag

- ow_base_user_block

- ow_base_user_disapprove (included accounts that had been deleted)

- ow_base_user_suspend

- ow_base_forum_subscription

- ow_notifications_rule

- ow_notifications_schedule


For all of the above, I couldn't find a "deleteExpired" function in their corresponding PHP file.


There may be other tables that get filled without ever being updated, but that's a start!


Could something be done in a future update to keep the database free of unecessary data?  This is important for large communities.


Thank you very much for your understanding!

The Forum post is edited by Alia Jul 15 '13
Alia Team
Alia Jul 15 '13
Thanks for the report. We will check this.
S. Bourdon
S. Bourdon Aug 17 '13
Thanks Aliia!


Please add the following tables to the list:

- ow_base_comment

- ow_base_comment_entity

- ow_base_entity_tag

- ow_base_theme_image

- ow_mailbox_last_message

- ow_mailbox_message

- ow_newsfeed_status

- ow_notifications_unsubscribe


Thank you!

Alia Team
Alia Aug 19 '13
Added those tables to the task.
Alia Team
Alia Sep 19 '13
S. Bourdon, developers have checked.
Those tables get cleared when "event" happens. For example: when the user is deleted.

The more users you will have, the bigger those tables will get.
You will loose important user data if you clean those tables ( giving that user still exists on your site).

S. Bourdon
S. Bourdon Sep 19 '13
Thank you very much for this follow up!

I really appreciate it!