Announcement

shah87

Member

Registered: 2016-01-21

Posts: 2

Chat history and other archives made my database explode. How to fix?

Hello there. Recently i found out that your chat app which i am happily using stores all the chat history and every information in database and my database size was increased massively and my hosting blocked my website due to excessive use of resources. Could you tell me how we can limit saving chat and other history to one month or two months?

There is one thing in database like: lh_cobrowse - 1.2 GB (huge) what it is and how to deal with it.

Below are the areas where my hosting ask me to make change:

lh_cobrowse 1.2 GB
lh_chat 47.0 MB
lh_chat_online_user 46.0 MB
lh_chat_online_user_footprint 25.0 MB
lh_question 530.1 KB 

I truncated most of them above except Ih_cobrowse. Anyone can assist please!

JustinUtesch

Member

Registered: 2014-04-13

Posts: 19

Re: Chat history and other archives made my database explode. How to fix?

Interesting just checked my database.

Here are my biggest LHC tables sorted by size.

+------------------------+----------------------------------------------------+------------+
| Database               | Table                                              | Size in MB |
+------------------------+----------------------------------------------------+------------+
| livehelperchat         | lh_cobrowse                                    |      20.82 |
| livehelperchat         | lh_chat_online_user_footprint             |      18.98 |
| livehelperchat         | lh_chat_online_user                          |       9.41 |
| livehelperchat         | lh_msg                                           |       2.02 |
| livehelperchat         | lh_chat                                           |       1.03 |
| livehelperchat         | lh_abstract_survey_item                    |       0.09 |

I wouldn't say I have a high usage site.

I assume your using shared hosting provider?
Do you use the Co-Browsing feature often?

This might be of use to you.

https://livehelperchat.com/how-to-setup … -341a.html

And maybe someone else will chime in.

remdex

Administrator

From: Lithuania

Registered: 2012-09-23

Posts: 3,661

Website

Re: Chat history and other archives made my database explode. How to fix?

You may empty lhc_cobrowse table, it does not store any sensitive data.