My Website Is Down

General General Questions
1

I just got a message from my hosting provider that due to excessive database tables & over 1 GB used, it was creating an overload. The gentleman I was speaking with there found that the cscart_cache is very large at over 71,000 rows and size of 1.5 GiB.

He thinks I should empty this from Php MyAdmin, but also said he could not tell me to do this because he is not familiar with cscart.

My question is...can I clear my cscart_cache this way with out creating more issues?

I think it does automatically rebuild itself.

Thanks,

Jim.

2

Yes. But I recommend switching to files caching vs MySQL caching. Look in help file for instructions.

http://docs.cs-cart.com/4.6.x/install/useful_info/increase_performance.html?highlight=cache

3

Yes. But I recommend switching to files caching vs MySQL caching. Look in help file for instructions.

http://docs.cs-cart.com/4.6.x/install/useful_info/increase_performance.html?highlight=cache

Agree, you are using the database to cache data from the database when you use db caching... Tuning your server is important. I.e. distributing memory between the system file cache, database cache and still having enough left to service your pages properly.

4

My question is...can I clear my cscart_cache this way with out creating more issues?

I think it does automatically rebuild itself.

Yes, you can clear cscart_cache this way. It will not cause any issues in store work. Also we recommend you not to use 'database cache backend'. In order to change it, you need to edit config.local.php file. Default cache backend value is 

$config['cache_backend'] = 'file';