vb.org Archive - Shared Hosting Not Cutting it?

Code:

# Fri Feb  1 21:35:10 2013

# Query_time: 2.246202  Lock_time: 0.000078 Rows_sent: 0  Rows_examined: 1

use fromthe4_vbulletin;

SET timestamp=1359779710;

UPDATE cron

                SET nextrun = 1359783300

                WHERE cronid = 29 AND nextrun = 1359779700



# Fri Feb  1 21:35:17 2013

# Query_time: 4.330291  Lock_time: 0.000187 Rows_sent: 0  Rows_examined: 6

use fromthe4_vbulletin;

SET timestamp=1359779717;

UPDATE blog AS blog,blog_aggregate_temp_1359779700 AS aggregate

        SET blog.views = blog.views + aggregate.views

        WHERE blog.blogid = aggregate.blogid



# Fri Feb  1 21:35:22 2013

# Query_time: 4.497857  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0

use fromthe4_vbulletin;

SET timestamp=1359779722;

DROP TABLE IF EXISTS blog_aggregate_temp_1359779700



# Fri Feb  1 21:35:40 2013

# Query_time: 9.925802  Lock_time: 3.490327 Rows_sent: 17  Rows_examined: 17

use fromthe4_vbulletin;

SET timestamp=1359779740;

SELECT *

  FROM datastore

  WHERE title IN ('smiliecache','bbcodecache','banemail','ranks','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')



# Fri Feb  1 21:35:47 2013

# Query_time: 6.873099  Lock_time: 4.622681 Rows_sent: 0  Rows_examined: 0

use fromthe4_vbulletin;

SET timestamp=1359779747;

SELECT *

  FROM session

  WHERE userid = 0

  AND host = '66.249.73.132'

  AND idhash = '021beeb527c7c95112d9c8c95547709a'

  LIMIT 1



# Fri Feb  1 21:35:52 2013

# Query_time: 7.974552  Lock_time: 1.364796 Rows_sent: 1  Rows_examined: 1

use fromthe4_vbulletin;

SET timestamp=1359779752;

SELECT *

  FROM session

  WHERE sessionhash = 'cdd25f1b226e193ff2acd18325c3a616'

  AND lastactivity > 1359778844

  AND idhash = '6aeb64ee0ea98ee32e7312b54577a0ec'



# Fri Feb  1 21:35:52 2013

# Query_time: 11.414806  Lock_time: 4.626423 Rows_sent: 0  Rows_examined: 0

use fromthe4_vbulletin;

SET timestamp=1359779752;

SELECT *

  FROM session

  WHERE userid = 0

  AND host = '72.223.6.85'

  AND idhash = 'aaebcd6f362ba57662b1cc3b0ee9b424'

  LIMIT 1



# Fri Feb  1 21:36:33 2013

# Query_time: 5.683098  Lock_time: 0.000054 Rows_sent: 0  Rows_examined: 1

use fromthe4_vbulletin;

SET timestamp=1359779793;

UPDATE cron

                SET nextrun = 1359779820

                WHERE cronid = 32 AND nextrun = 1359779760



# Fri Feb  1 21:40:01 2013

# Query_time: 1.195400  Lock_time: 0.000120 Rows_sent: 1  Rows_examined: 1

use fromthe4_vbulletin;

SET timestamp=1359780001;

SELECT IF(thread.visible = 2, 1, 0) AS isdeleted,

  post.pagetext AS description,

  thread.*

  FROM thread AS thread

  LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

  WHERE thread.threadid = 99



# Fri Feb  1 21:47:43 2013

# Query_time: 2.975253  Lock_time: 0.806965 Rows_sent: 1  Rows_examined: 1

use fromthe4_vbulletin;

SET timestamp=1359780463;

SELECT *

  FROM session

  WHERE userid = 0

  AND host = '173.199.119.59'

  AND idhash = '1d41bce29a10b8fdb3d72b2fbac134e8'

  LIMIT 1



# Fri Feb  1 21:47:55 2013

# Query_time: 5.401879  Lock_time: 3.340980 Rows_sent: 17  Rows_examined: 17

use fromthe4_vbulletin;

SET timestamp=1359780475;

SELECT *

  FROM datastore

  WHERE title IN ('smiliecache','bbcodecache','mailqueue','bookmarksitecache','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')



# Fri Feb  1 21:50:45 2013

# Query_time: 4.390896  Lock_time: 2.244348 Rows_sent: 17  Rows_examined: 17

use fromthe4_vbulletin;

SET timestamp=1359780645;

SELECT *

  FROM datastore

  WHERE title IN ('smiliecache','bbcodecache','mailqueue','bookmarksitecache','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')



# Fri Feb  1 21:52:27 2013

# Query_time: 1.704731  Lock_time: 0.189938 Rows_sent: 2  Rows_examined: 15

use fromthe4_vbulletin;

SET timestamp=1359780747;

SELECT

  post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,

  user.*, userfield.*, usertextfield.*,

  icon.title as icontitle, icon.iconpath,

  avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,

  editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,

  editlog.reason AS edit_reason, editlog.hashistory,

  postparsed.pagetext_html, postparsed.hasimages,

  sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,

  sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,

  IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid

  ,blog_user.entries

                FROM post AS post

                LEFT JOIN user AS user ON(user.userid = post.userid)

                LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)

                LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

                LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)

                LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

  LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)

                LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 3 AND postparsed.languageid = 1)

                LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 3 AND sigparsed.languageid = 1)

                LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)

  LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid = post.userid)

                WHERE post.postid IN (0467,1485)

                ORDER BY post.dateline

This was one of the newest logs, I'm not familiar with cron jobs. Are these done on vB or on the server? Should I assume my host cannot handle the demands of my site?

http://pastebin.com/4p9SaJzY

Example of another, but much larger log.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01437 seconds Memory Usage 1,750KB 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 (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: