Website down when clearing cache

[Syns]

hello master.

 

Whenever I clearing the cache/smarty cache via back office, the site goes down for several minutes, I've contacted the hosting provider they said that it's down due to heavy sql query procession.

I wonder whats wrong with it, I'm using prestashop 1.6.0.14 and I never experience this when I still in 1.5.5.

need assistance please.

 

thank you.

[PrestaHeroes USA]

back office-->advanced parms-->performance

 

for 'caching type' under smarty make sure set to 'file system'.

[las3r]

What caching method do you use? File System, XCache, Memcached?

 

Are you on a VPS or shared hosting?

 

"heavy SQL" queries is usually a way for hosting providers to tell you that their hosting platform has 1000 customers on 1 system, rather than 100 on 1, meaning you share MySQL with a lot of other people. Simple queries become heavy when there are 1000 websites using the same SQL Instance

[Syns]

back office-->advanced parms-->performance

 

for 'caching type' under smarty make sure set to 'file system'.

yes I'm using file system for caching type.

 

What caching method do you use? File System, XCache, Memcached?

 

Are you on a VPS or shared hosting?

 

"heavy SQL" queries is usually a way for hosting providers to tell you that their hosting platform has 1000 customers on 1 system, rather than 100 on 1, meaning you share MySQL with a lot of other people. Simple queries become heavy when there are 1000 websites using the same SQL Instance

I'm using file system.

well it's not VPS, they named it dedicated server (maybe shared hosting).

it makes sense since the hosting provider asked me to upgrade the plan hosting.

[las3r]

This proves my point.

 

I'll contact you through messenger.