host deactivated me for mysql slow queries

[soboyle]

I had a real shock yesterday, my webhost deactivated my account with no warning or heads up for using to much cpu on their servers. They are saying that my pixelpost database is causing the server to slow down.
The problem is, I don't have a clue on how to troubleshoot this. I have pasted a couple of the mysql_slow_queries logs files here, if anyone has any suggestions as to what is going on, let me know. Am I being hacked here? The only thing I have done so far is to run phpmyAdmin and repair and optimize the tables.
I'm running version 1.7.1 on my site.

# Wed Nov 19 15:54:13 2008
# Query_time: 1049 Lock_time: 1041 Rows_sent: 0 Rows_examined: 0
use oboyleph_oboylephoto2;
insert into pixelpost_visitors(id,datetime,host,referer,ua,ip, ruri)
VALUES(NULL,'2008-11-19 17:36:44','oboylephoto.com','','Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)','72.30.79.24','/photoblog/index.php?showimage=71')

# Wed Nov 19 15:55:00 2008
# Query_time: 1024 Lock_time: 1009 Rows_sent: 0 Rows_examined: 0
use oboyleph_oboylephoto2;
insert into pixelpost_visitors(id,datetime,host,referer,ua,ip, ruri)
VALUES(NULL,'2008-11-19 17:37:56','www.oboylephoto.com','','Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)','72.30.142.153','/photoblog/index.php?showimage=26&x=atom')

# Wed Nov 19 15:58:20 2008
# Query_time: 1170 Lock_time: 1041 Rows_sent: 0 Rows_examined: 0
use oboyleph_oboylephoto;
delete from `oboyleph_oboylephoto`.cpg140_sessions where time<1227130730 and remember=0

# Wed Nov 19 15:58:20 2008
# Query_time: 1153 Lock_time: 1025 Rows_sent: 0 Rows_examined: 0
use oboyleph_oboylephoto;
delete from `oboyleph_oboylephoto`.cpg140_sessions where time<1227130747 and remember=0

# Wed Nov 19 15:58:23 2008
# Query_time: 1126 Lock_time: 1054 Rows_sent: 0 Rows_examined: 0
use oboyleph_oboylephoto2;
insert into pixelpost_visitors(id,datetime,host,referer,ua,ip, ruri)
VALUES(NULL,'2008-11-19 17:39:37','oboylephoto.com','','Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)','72.30.79.24','/photoblog/index.php?showimage=3')

# Wed Nov 19 15:58:23 2008
# Query_time: 1147 Lock_time: 1075 Rows_sent: 0 Rows_examined: 0
use oboyleph_oboylephoto2;
insert into pixelpost_visitors(id,datetime,host,referer,ua,ip, ruri)
VALUES(NULL,'2008-11-19 17:39:16','oboylephoto.com','','Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)','72.30.79.24','/photoblog/index.php?showimage=3')

# Wed Nov 19 15:58:24 2008
# Query_time: 1082 Lock_time: 1010 Rows_sent: 0 Rows_examined: 0
use oboyleph_oboylephoto2;
insert into pixelpost_visitors(id,datetime,host,referer,ua,ip, ruri)
VALUES(NULL,'2008-11-19 17:40:22','oboylephoto.com','','Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)','72.30.79.24','/photoblog/index.php?showimage=3')

# Wed Nov 19 15:58:24 2008
# Query_time: 1106 Lock_time: 1033 Rows_sent: 0 Rows_examined: 0
use oboyleph_oboylephoto2;
insert into pixelpost_visitors(id,datetime,host,referer,ua,ip, ruri)
VALUES(NULL,'2008-11-19 17:39:58','oboylephoto.com','','Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)','72.30.79.24','/photoblog/index.php?showimage=3')

# Wed Nov 19 15:58:27 2008
# Query_time: 1050 Lock_time: 1006 Rows_sent: 0 Rows_examined: 0
use oboyleph_oboylephoto2;
insert into pixelpost_visitors(id,datetime,host,referer,ua,ip, ruri)
VALUES(NULL,'2008-11-19 17:40:57','www.oboylephoto.com','','SharpReader/0.9.7.0 (.NET CLR 1.1.4322.2407; WinNT 5.1.2600.0)','65.199.93.3','/photoblog/index.php?x=rss')

[jaywilliams]

for starters, you could try disabling any visitor tracking/stats addons & options. Also, while you're at it, try turning off any addons that you aren't using.

If that still doesn't help, you might want to take a look at some other web hosts. There are lots of great web hosts out there that won't have any problem with you running your photoblog.

I hope that helps you!

[soboyle]

Is there any way to block yahoo slurp from crawling my site? It seems that is causing most of the problems.

[Trauko]

http://www.robotstxt.org/faq/prevent.html
http://help.yahoo.com/l/us/yahoo/search/webcrawler/slurp-02.html


file robots.txt

User-agent: Slurp
Disallow: /

:)