Unwanted traffic caused hosting temporarily disabled my site.

[anson.c]

First thing in the morning I got an email from my hosting company (TMD hosting) saying that they temporarily disabled my site. They told me that my site caused extremely high CPU and memory consumption. They said that this might have been caused by temporary access peak on my website, application loop or crawling engine on my website.

They provided me a log that show what was running right before my site got suspended.

 

Here's some part of it:

 

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND

840652 wickdmed 15 0 0 0 0 Z 0.0 0.0 0:00.81

 <defunct>

845869 wickdmed 16 0 0 0 0 Z 0.0 0.0 0:00.82 [php] <defunct>

850340 wickdmed 16 0 0 0 0 Z 0.0 0.0 0:00.81 [php] <defunct>

856312 wickdmed 17 0 236m 22m 8740 S 0.0 0.1 0:00.17 /ecyclog/category.php

860793 wickdmed 15 0 236m 22m 8740 S 0.0 0.1 0:00.12 /ecyclog/category.php

 

 

111149079 | wickdmed_oGtpwo | localhost | wickdmed_oGtpwo | Query | 716 | Copying to tmp table | SELECT cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, pl.`name`,

pl.` |

| 111150341 | wickdmed_oGtpwo | localhost | wickdmed_oGtpwo | Query | 661 | Copying to tmp table | SELECT cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, pl.`name`,

pl.` |

 

I used some module to help me deleted some expired states such as ps_connections etc.

Now I'm suspecting some unwanted visitors caused this issue by creating a high traffic on my site.

My question is how do I spot them out?

I use IP deny manager on my cpanel to block some ips so they can't access my site no more. However it is to be done one by one which is very time consuming.

 

Is there any way to prevent such unwanted traffic?