Go Back   vb.org Archive > Community Discussions > Forum and Server Management
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 02-02-2013, 06:03 AM
elvinelol elvinelol is offline
 
Join Date: Jan 2013
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:44 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03587 seconds
  • Memory Usage 2,440KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete