Database Size Issues

Store Builder Questions
1

Hi All



Running CS-Cart 3.01 with MySQL database



Setup n config.local.php: $config[‘db_type’] = ‘mysqli’;



The database has blown out to a ridiculous size: 2.2 GB (database has been optimised)



We only have a few customers and 900 products.



The offending table in MySQL database is cscart_cache. (2GB)



Does anybody know if I can safely empty the table?



EG: with SQL query TRUNCATE cscart_cache



I know people have said you can empty the stored sessions, but that table is not really the concern.



Much appreciated if someone can shed some light.

2

If you use several store-fronts and want to clear cache for all stores, please run the following query



TRUNCATE cscart_cache;




If you want to clear cache only for one store, please use:



DELETE FROM cscart_cache WHERE company_id = XXX;




where xxx is the ID of the store

3

Awesome - thank you!



Just wondering if it would be safer to delete the actual rows in the cscart_cache table through phpMyAdmin. I know this will be a lot slower. Any opinions?



Thanks in advance

4

[quote name='emilio' timestamp='1422608882' post='203902']

Awesome - thank you!



Just wondering if it would be safer to delete the actual rows in the cscart_cache table through phpMyAdmin. I know this will be a lot slower. Any opinions?



Thanks in advance

[/quote]



Sure, you can use phpMyAdmin. I have corrected my post