< SOLVED > Does Prestashop Runs 63609 Database Queries?

[Vilas]

Hello,

 

My hosting provider suspended my account stating that my database is running more than 63609 queries. Can anyone know does prestashop runs this much queries or they are telling lie? I am using ipage hosting.

 

Please suggest solution on it.

 

Thanks

[Vilas]

They are telling me Consult the application vendor for information on optimizing it's MySQL queries. Can anyone know how to do it?

 

Thanks

[Captain FLAM]

You have to de-activate the "statistics modules" (especially the config about tracking visitor's actions)

[Vilas]

Hi,

 

Thanks for prompt response. Can you tell me how and which module should be deactivated?

 

Regards

Vilas

[gkontos]

Hello, My hosting provider suspended my account stating that my database is running more than 63609 queries. Can anyone know does prestashop runs this much queries or they are telling lie? I am using ipage hosting. Please suggest solution on it. Thanks

 

They would have to specify during what period of time your database exceeded this amount of queries.

 

Depending on the number of daily visits you have, this could ring an alarm.

[Vilas]

Dear Gkonts,

 

Actually I am getting daily aproximately 150 visitors. But from last 2 week I found too much increase in it. Suddenly visitor traffic changed from 150 to 1000. I have seen many of visitors are belongs from US and unable to find exactly what they are doing at my site homepage.

 

Can anyone know how to block them.? I tried to block there ips but they again accessing my site from other ips.

 

Thanks

[gkontos]

Hi Vilas,

 

Do you have some sort of visitor tracking tool enabled like google analytics ? If you do then this will give you an idea on what those visitors are seeing in your site. If they don't appear in google analytics then it is probably some kind of robot tool.

 

Getting a sudden increase in traffic can certainly cause some issues in the performance of the site and the database server that is being hosted. Especially if this traffic is not legit it may often lead to DOS attacks.

 

A DOS attack will definitely affect your host so they suspended your account. But in my opinion what they did is wrong. What they should have done instead is work with you to prevent this from happening.

 

In order to assist further I would need to see the log files of the web server. That would give me a pattern to work with and identify who is causing this kind of behavior.

 

If you have access to those files, both access & error logs I would be happy to analyze them for you. You can contact me via PM or through our website. Don't post any IPs in public though.

 

What you can do now is ask your host to assist you by blocking those IPs.

 

Best Regards,

George

[Vilas]

Dear GKONTOS,

 

Thanks for paying attention & for kind support. Yes I am using google analytics. I found that there are many visitors from US are visiting my home page and I am unable to know what exactly they are doing. In analytics it shows only that visitor is at homepage. I found more than 8000 visitors from US visited in 7 days. Daily approximately 500-800 visitors.

 

So is there is any way to find out exactly what they are doing?

 

Please suggest.

 

thanks

Vilas

[gkontos]

Hi Vilas,

 

I would need to examine your web server log files in order to determine this.

 

Regards,

George