The database of my website becomes: 1,491,305,979 bytes, very big, can't download on my local computer, but before was: 106,632kb only, and can download to my computer easily. Before having the file with sql.tgz only, but now have the sql more. Please see the image for more detail.
Does someone know how to change the database like before with small size please?
Are you using 'database' as the caching method? Suggest that you do not do this.
You can also clear things like the cscart_new_orders table, cscart_user_sessions table, cscart_logs table, etc.
Our EZ Admin Helper addon has events that do this either on a scheduled basis or on-demand. Note that it will also do things like preserve log entries so you can retain 30 days of logs.
I would identify where your growth has been and determine if you can reduce those table sizes.
Are you using 'database' as the caching method? Suggest that you do not do this.
You can also clear things like the cscart_new_orders table, cscart_user_sessions table, cscart_logs table, etc.
Our EZ Admin Helper addon has events that do this either on a scheduled basis or on-demand. Note that it will also do things like preserve log entries so you can retain 30 days of logs.
I would identify where your growth has been and determine if you can reduce those table sizes.
Hi Tbirnseth
I already have setting the clear cache on the server everyday, may be is another problem?
delete from cscart_stored_sessions WHERE expiry < unix_timestamp('2017-03-15');
delete from cscart_sessions WHERE expiry < unix_timestamp('2017-03-15');
3) click Go
This should remove all entries that are greater than 30 days old (or earlier than the date in the query).
Clear cscart_stored_sessions and cscart_sessions tables using previous posts. Then monitor the situation. If the size of the tables will grow up significantly again, contact CS-Cart support team
Clear cscart_stored_sessions and cscart_sessions tables using previous posts. Then monitor the situation. If the size of the tables will grow up significantly again, contact CS-Cart support team
Hi Ecomlabs, it's work now, thank very much for your help!
majority of sessions start 158, means its from within month or maximum 2 months old. Got only couple hundreds of abandoned carts from this year (deleted older ones), also ran to optimise db but this has taken away just 20mb.
So how do I separate actual cart data from this junk ?
they will be removed automatically based on SESSIONS_STORAGE_ALIVE_TIME which (by default) is set to 2 weeks.
If you have older data in there, you might have a customization that is preventing the standard DROP condition from executing or possibly have increased SESSIONS_STORAGE_ALIVE_TIME.
Note also that the table user_session_products will relate to the stored_sessions table so if you manually delete things from stored_sessions, they will remain in user_session_products.