delete old chat message and big Tables with old data

okmedicina

hi, I need to delete old chat message. How I can do?
Can I delete ndayo_community_chat_activity ?Or is there a problem?
I have 700.000 row in ndayo_community_location_cache can I delete?
because database is very very big

Ninja

okmedicina
Hi
Before suggestion may i know the Jomsocial version you are using?
as in new version Message setting we have option to delete chat after a time you will set on the backend.

okmedicina

4,8. I need to clean up the database. too much old data and I need a system to bring it to new by keeping the users and posts

Ninja

okmedicina
Hi
If you want to delete all message at once it can be from clear DB message table. About making all new please share more info as all users DB deletion will delete Jomsocial data.

okmedicina

Then Can I delete ndayo_community_chat_activity TABLE? And which is the other TABLE that I can delete to resize the database?
thank you

Ninja

okmedicina
Hi
Do not delete as delete table means you are removing it from site and no new message will come as table not exist, just empty that.

okmedicina

I truncate it right?

Ninja

okmedicina
Hi
I did not get what you want to say in last post. Could you share the results if you not delete and only empty the data?
As Delete means you are deleted complete table that should not be done.

okmedicina

Hi I hd truncate the table ndayo_community_chat_activity. As result I don't see messagge but I have a big problem.
I have all old chat present but empty. A red write say 102, that is all the old chat. I think there is somethings to put a zero, the counter of user chat. I need to reset other table.

okmedicina

Ninja

okmedicina
Hi
We have added an option to mark all as read for users who not read message to remove the notifications.
Click on the inbox message icon and mark all as read.