vb.org Archive - URGENT: 503 error!!!

Alright, lately I have been getting this on my website.
http://img504.imageshack.us/img504/8130/scenz033ei0.png

Personally I thought it would be my shoutbox that was giving me this problem. So I uninstalled my old shoutbox. Then I installed a new shoutbox.

Right after I installed the new shoutbox I still received that annoying error message. I checked my statistics and I have a lot of space and all that. So I finally checked my e-mail. I have received this from my host.

Quote:

We have conducted a detailed investigation of the reason for the high resource consumption and it turned out that your website executes slow queries towards its database, which eventually hogs the server. The server tries to execute your slow queries while making other processes stay in the queue until some memory is freed. While they are waiting however, they stack up and further deteriorate the problem.

The reasons for such slow queries can be several:

1. Large database
2. Not well written scripts
3. Large number of internal links that query the database directly.

Upon further investigation, it turned out that the following queries in your account are slow and heavily consume server resources:

Recent slow queries:

# Time: 071020 11:28:06
# User@Host: sfoshowd_sfoshow[sfoshowd_sfoshow] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 208014
use sfoshowd_Forum;
select s.*, count(s.sid) as `TS`, u.username, u.usergroupid from shout s
left join user u on (u.userid = s.s_by)
--
# Time: 071020 13:42:21
# User@Host: sfoshowd_sfoshow[sfoshowd_sfoshow] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 10 Rows_examined: 208055
use sfoshowd_Forum;
select s.*, count(s.sid) as `TS`, u.username, u.usergroupid from shout s
left join user u on (u.userid = s.s_by)
--
# Time: 071020 13:42:45
# User@Host: sfoshowd_sfoshow[sfoshowd_sfoshow] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 10 Rows_examined: 208055
select s.*, count(s.sid) as `TS`, u.username, u.usergroupid from shout s
--
# Time: 071020 13:42:48
# User@Host: sfoshowd_sfoshow[sfoshowd_sfoshow] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 7 Rows_examined: 311673
select s.*, u.username, u.usergroupid from shout s
--
# Time: 071020 13:43:20
# User@Host: sfoshowd_sfoshow[sfoshowd_sfoshow] @ localhost []
# Query_time: 15 Lock_time: 0 Rows_sent: 10 Rows_examined: 208057
select s.*, count(s.sid) as `TS`, u.username, u.usergroupid from shout s
--
# Time: 071020 13:43:24
# User@Host: sfoshowd_sfoshow[sfoshowd_sfoshow] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 10 Rows_examined: 207712
select s.*, u.username, u.usergroupid from shout s
--
# Time: 071020 13:43:44
# User@Host: sfoshowd_sfoshow[sfoshowd_sfoshow] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 10 Rows_examined: 208057
select s.*, count(s.sid) as `TS`, u.username, u.usergroupid from shout s
--
# Time: 071020 13:43:46
# User@Host: sfoshowd_sfoshow[sfoshowd_sfoshow] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 10 Rows_examined: 207712
select s.*, u.username, u.usergroupid from shout s
--
# Time: 071020 16:23:52
# User@Host: sfoshowd_sfoshow[sfoshowd_sfoshow] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 208191
use sfoshowd_Forum;
select s.*, count(s.sid) as `TS`, u.username, u.usergroupid from shout s
left join user u on (u.userid = s.s_by)

Database size in Kb:
56752 - sfoshowd_Forum

In order to optimize the performance of your website, we recommend you to delete entries from your "shout" table to improve the connection speed with the database. Thus, the MySQL queries will become faster.

If this problem with your website is not resolved in 7 days we may need to SUSPEND YOUR ACCOUNT.

Please do NOT reply to this email. You can add comments on this issue by logging to your Customer Area (https://www.siteground.com/login_page.htm) and comment the ticket that has been automatically open on your behalf in connection to this case.

Now my question is if anyone can help me and tell me how I can delete these "MySQL queries" that are slowing down my site so I can enjoy and be on my website with out the annoying 503 error.
By the way, I thought that by removing my old shoutbox that it should be out now, but I guess not. So keep in mind that I installed a lighter newer shoutbox and I am still getting the error.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02362 seconds Memory Usage 1,748KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: