ow_base_search_result            199,5 Mb

ow_mailbox_conversation         162,4 Mb

ow_memberx_search_id            80,3 Mb

ow_mailbox_last_message           53  Mb

can i empty ?

I'm all for more admin plugins and utilities and I have extensive DB, Filesystem and Library experience...

It would be great if this could be added to CacheExtreme.

but before someone release a plugin

can i empty all this tables with no harm my website? because this 10 are the biggest ones

Backup Database and Files and then try it out. 

Trial and Error is the best way to learn sometimes...

With that being said, It's not recommended that anyone alter / modify the database unless you are a developer and know exactly what you're doing.

This is why I recommend everyone have a dev sub domain that you can test updates, experiment with idea's, develop plugins / themes / modifications.

It only takes like 5-10 minutes to setup a new install on a new sub domain, so why not?

Then you can load the dev setup with a current version (clone) of your production site and test the database removals without crashing your main site...

I might actually put this in my OxBackup / OxUpdater for the option to restore to new Database / Sub Domain.

I need someone who already test this before, what tables that is okey empty in the top 9 list i was bring up here

hmmm.....but if nobody have the answer i forced like you say test it my self and do backups

The only problem is it would be up to the Admin to configure HTTPd (Apache) / DNS / SSL / etc...

I am developing a plugin to do this cleaning, but it is a delicate issue and I have to make sure, so it will take a while.

The table ow_base_log can empty it without problems, but careful not to delete it because the next access to write something will give an error that is difficult to locate because it is only written when there is already an error and it is very difficult to find this. 

but have in mind you clear some old statistic and all new and old messages will bee cleared.....but nothing that will harm you site to clear this tables

the site will work same as before but some history will bee gone....that is all

if someone want i will explain every tables data what type of data it saves 

ow_memberx_search_result = saved search result for faster search for new members from the start you was install and today date

ow_notifications_notification = notifications from the day you was install the plugin and today date

ow_mailbox_message = message history from install start date and today date

ow_base_site_statistic = statistic page in admin panel. history how many joined and how many buy membership how many upload photos and more....from install website and today date

The friends table is also a disaster but it can not be emptied in any way. A request for friendship remains forever accepted or not, and if accepted is a new record. If one of the two members involved is unsubscribed, nothing is deleted. This table encourages me to make a plugin with a widget for the profile of how many requests you reject or reject, how many ignore you or ignore you. In my future plugin you can configure how much this information is memorized, for example one year I see it useful but for example 500 records from two years ago of a boy who sent petitions to all the girls and did not accept them is not a valid fact It's worth keeping.

These three tables are continually consulted to show you up if you have friendship requests, notifications or messages. If you have a very full web, it is what makes it slower