Forum manchmal träge?

ernesto.che

Der Woltlab-Support benötigt zur Analyse weitere Angaben. Dazu ist der Footer wieder mit der Statistik gefüllt.

Wenn bei jemanden nun eine sehr lange Ladezeit auftritt: Bitte unten auf die Zeile mit "Execution time" klicken, den Inhalt kopieren und hier dann posten. Danke!

GrandAdmiralThrawn

Alles klar, auf zum fröhlichen Debuggen!

ernesto.che

Ich hab tatsächlich schon einen Fang gemacht

Code

(SQL Query) SELECT * FROM wcf1_session WHERE sessionID = ?
Execution time: 0.0007s
(SQL Query) SELECT user_option_value.*, user_table.* FROM wcf1_user user_table LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) WHERE user_table.userID = ?
Execution time: 0.0007s
(SQL Query) SELECT * FROM wcf1_session_virtual WHERE sessionID = ? AND ipAddress = ? AND userAgent = ?
Execution time: 0.0004s
(SQL Query) SELECT * FROM wcf1_user_storage WHERE userID IN (?)
Execution time: 0.0005s
(SQL Query) SELECT COUNT(*) AS amount FROM wbb1_post
Execution time: 15.9874s
(SQL Query) SELECT COUNT(*) AS amount FROM wbb1_thread
Execution time: 0.113s
(SQL Query) SELECT COUNT(*) AS amount FROM wcf1_user
Execution time: 0.0124s
(SQL Query) SELECT * FROM wcf1_user ORDER BY userID DESC LIMIT 1
Execution time: 0.0004s
(SQL Query) SELECT box.* FROM wcf1_box box WHERE (box.visibleEverywhere = ? AND boxID NOT IN (SELECT boxID FROM wcf1_box_to_page WHERE pageID = ? AND visible = ?)) OR boxID IN (SELECT boxID FROM wcf1_box_to_page WHERE pageID = ? AND visible = ?) 
Execution time: 0.001s
(SQL Query) SELECT boxID, showOrder FROM wcf1_page_box_order WHERE pageID = ?
Execution time: 0.0003s
(SQL Query) SELECT COUNT(*) AS count FROM wcf1_user_group_leader WHERE leaderID = ?
Execution time: 0.0003s
(SQL Query) SELECT COUNT(*) AS count, thread.boardID FROM wbb1_thread thread LEFT JOIN wcf1_tracked_visit tracked_thread_visit ON (tracked_thread_visit.objectTypeID = 267 AND tracked_thread_visit.objectID = thread.threadID AND tracked_thread_visit.userID = 3) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 266 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 3) WHERE thread.lastPostTime > ? AND thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL AND (thread.lastPostTime > tracked_thread_visit.visitTime OR tracked_thread_visit.visitTime IS NULL) AND (thread.lastPostTime > tracked_board_visit.visitTime OR tracked_board_visit.visitTime IS NULL) AND thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) GROUP BY thread.boardID
Execution time: 0.0095s
(SQL Query) SELECT thread.* FROM wbb1_thread thread WHERE thread.threadID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY lastPostTime DESC, lastPostID DESC
Execution time: 0.0019s
(SQL Query) SELECT user_option_value.*,user_avatar.*,user_rank.*, session.pageID, session.pageObjectID, session.lastActivityTime AS sessionLastActivityTime, user_table.* FROM wcf1_user user_table LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user_rank user_rank ON (user_rank.rankID = user_table.rankID) LEFT JOIN wcf1_session session ON (session.userID = user_table.userID) WHERE user_table.userID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY user_table.username
Execution time: 0.0022s
(SQL Query) SELECT thread.threadID AS objectID FROM wbb1_thread thread WHERE thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL AND thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.threadID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY thread.lastPostTime DESC,thread.threadID DESC LIMIT 5
Execution time: 0.0311s
(SQL Query) SELECT DISTINCT post.userID AS ownPosts,tracked_visit.visitTime,tracked_board_visit.visitTime AS boardVisitTime,user_object_watch.watchID, user_object_watch.notification,like_object.likes, like_object.dislikes,moderation_queue.queueID AS reportQueueID, thread.* FROM wbb1_thread thread LEFT JOIN wbb1_post post ON (post.threadID = thread.threadID AND post.userID = 3) LEFT JOIN wcf1_tracked_visit tracked_visit ON (tracked_visit.objectTypeID = 267 AND tracked_visit.objectID = thread.threadID AND tracked_visit.userID = 3) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 266 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 3) LEFT JOIN wcf1_user_object_watch user_object_watch ON (user_object_watch.objectTypeID = 292 AND user_object_watch.userID = 3 AND user_object_watch.objectID = thread.threadID) LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 268 AND like_object.objectID = thread.firstPostID) LEFT JOIN wcf1_moderation_queue moderation_queue ON (moderation_queue.objectTypeID = 290 AND moderation_queue.objectID = thread.firstPostID AND moderation_queue.status <> 2 AND moderation_queue.status <> 3 AND moderation_queue.status <> 4) WHERE thread.threadID IN (?,?,?,?,?) ORDER BY thread.lastPostTime DESC,thread.threadID DESC
Execution time: 0.0019s
(SQL Query) SELECT * FROM wcf1_box_content WHERE boxID = ?
Execution time: 0.0006s
(SQL Query) SELECT thread.threadID AS objectID FROM wbb1_thread thread WHERE thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL AND thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.threadID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY ((((thread.replies + .1) * 50 + thread.views) * 1000000000000) / POWER(UNIX_TIMESTAMP() - thread.time, 1.5)) DESC,thread.time DESC LIMIT 5
Execution time: 0.0209s
(SQL Query) SELECT DISTINCT post.userID AS ownPosts,tracked_visit.visitTime,tracked_board_visit.visitTime AS boardVisitTime,user_object_watch.watchID, user_object_watch.notification,like_object.likes, like_object.dislikes,moderation_queue.queueID AS reportQueueID, thread.* FROM wbb1_thread thread LEFT JOIN wbb1_post post ON (post.threadID = thread.threadID AND post.userID = 3) LEFT JOIN wcf1_tracked_visit tracked_visit ON (tracked_visit.objectTypeID = 267 AND tracked_visit.objectID = thread.threadID AND tracked_visit.userID = 3) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 266 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 3) LEFT JOIN wcf1_user_object_watch user_object_watch ON (user_object_watch.objectTypeID = 292 AND user_object_watch.userID = 3 AND user_object_watch.objectID = thread.threadID) LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 268 AND like_object.objectID = thread.firstPostID) LEFT JOIN wcf1_moderation_queue moderation_queue ON (moderation_queue.objectTypeID = 290 AND moderation_queue.objectID = thread.firstPostID AND moderation_queue.status <> 2 AND moderation_queue.status <> 3 AND moderation_queue.status <> 4) WHERE thread.threadID IN (?,?,?,?,?) ORDER BY ((((thread.replies + .1) * 50 + thread.views) * 1000000000000) / POWER(UNIX_TIMESTAMP() - thread.time, 1.5)) DESC,thread.time DESC
Execution time: 0.0026s
(SQL Query) SELECT user_option_value.*,user_avatar.*,user_rank.*, session.pageID, session.pageObjectID, session.lastActivityTime AS sessionLastActivityTime, user_table.* FROM wcf1_user user_table LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user_rank user_rank ON (user_rank.rankID = user_table.rankID) LEFT JOIN wcf1_session session ON (session.userID = user_table.userID) WHERE user_table.userID IN (?) ORDER BY user_table.username
Execution time: 0.0017s
(SQL Query) SELECT * FROM wcf1_box_content WHERE boxID = ?
Execution time: 0.0005s
(SQL Query) SELECT user_option_value.userOption19 AS canViewOnlineStatus, session.userID FROM wcf1_session session LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = session.userID) WHERE session.lastActivityTime > ? AND session.spiderID IS NULL
Execution time: 0.0025s
(SQL Query) SELECT user_avatar.*, user_option_value.*, user_group.userOnlineMarking, user_table.*, session.* FROM wcf1_session session LEFT JOIN wcf1_user user_table ON (user_table.userID = session.userID) LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user_group user_group ON (user_group.groupID = user_table.userOnlineGroupID) WHERE session.lastActivityTime > ? AND session.userID IS NOT NULL ORDER BY user_table.username
Execution time: 0.0024s
(SQL Query) SELECT * FROM wcf1_box_content WHERE boxID = ?
Execution time: 0.0006s

Alles anzeigen

Bin ich mal gespannt, ob der Support damit etwas anfangen kann.

GrandAdmiralThrawn

SELECT COUNT(*) AS amount FROM wbb1_post, heh?

Knapp 16 Sekunden sind Mal eine Ansage. Das Query klingt als würde er alle (!) Posts zählen. Vielleicht wird das geblockt, wenn grade ein paar Leute neue Beiträge schicken? Aber ich bin in SQL ein n00b, daher keine "wirkliche" Ahnung.

Oder der RAM ist knapp, und er muß die Post Tabelle gelegentlich von langsamer Disk holen?

ernesto.che

So verstehe ich das auch - da wird einmal alles inventarisiert. Offensichtlich bei jedem einzelnen Aufruf.

Die DB ist zu groß für die im Paket enthaltene 1GB SSD - liegt also auf einer HDD. Ob RAM ausreicht oder nicht - ich habe keine Ahnung.

ernesto.che

Gerade war es sogar noch ein bisschen lahmer.

Code

(SQL Query) SELECT COUNT(*) AS amount FROM wbb1_post
Execution time: 18.771s

Laut Woltlab wird der Wert idR aus dem Cache geholt und deswegen ist die Abfrage nur manchmal so langsam.

CryptonNite

Jetzt war es gerade eben wieder. -.-

Löschzwerg

Code

(SQL Query) SELECT * FROM wcf1_session WHERE sessionID = ?
Execution time: 0.0003s
(SQL Query) SELECT user_option_value.*, user_table.* FROM wcf1_user user_table LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) WHERE user_table.userID = ?
Execution time: 0.0005s
(SQL Query) SELECT * FROM wcf1_session WHERE userID = ?
Execution time: 0.0003s
(SQL Query) INSERT INTO wcf1_session (sessionID,userID,ipAddress,userAgent,lastActivityTime,requestURI,requestMethod) VALUES (?,?,?,?,?,?,?)
Execution time: 0.0006s
(SQL Query) SELECT * FROM wcf1_session WHERE sessionID = ?
Execution time: 0.0003s
(SQL Query) SELECT * FROM wcf1_session_virtual WHERE sessionID = ? AND ipAddress = ? AND userAgent = ?
Execution time: 0.0005s
(SQL Query) INSERT INTO wcf1_session_virtual (sessionID,lastActivityTime,ipAddress,userAgent) VALUES (?,?,?,?)
Execution time: 0.0004s
(SQL Query) SELECT * FROM wcf1_session_virtual WHERE virtualSessionID = ?
Execution time: 0.0004s
(SQL Query) SELECT COUNT(*) AS amount FROM wbb1_post
Execution time: 14.1968s
(SQL Query) SELECT COUNT(*) AS amount FROM wbb1_thread
Execution time: 0.2483s
(SQL Query) SELECT COUNT(*) AS amount FROM wcf1_user
Execution time: 0.0025s
(SQL Query) SELECT * FROM wcf1_user ORDER BY userID DESC LIMIT 1
Execution time: 0.0004s
(SQL Query) SELECT box.* FROM wcf1_box box WHERE (box.visibleEverywhere = ? AND boxID NOT IN (SELECT boxID FROM wcf1_box_to_page WHERE pageID = ? AND visible = ?)) OR boxID IN (SELECT boxID FROM wcf1_box_to_page WHERE pageID = ? AND visible = ?)
Execution time: 0.0009s
#0 wcf\system\benchmark\Benchmark->start() (line 91) 
#1 wcf\system\database\statement\PreparedStatement->execute() (line 195) 
#2 wcf\data\DatabaseObjectList->readObjects() (line 37) 
#3 wcf\data\box\BoxList->readObjects() (line 232) 
#4 wcf\system\box\BoxHandler::loadBoxes() (line 57) 
#5 wcf\system\box\BoxHandler->init() (line 25) 
#6 wcf\system\SingletonFactory->__construct() (line 55) 
#7 wcf\system\SingletonFactory::getInstance() (line 1.012) 
#8 wcf\system\WCF->getBoxHandler() (line 744) 
#9 /is/htdocs/wp1127489_DEW6KIWD61/www/board/lib/system/template/TemplateEngine.class.php: include() (line 321) 
#10 wcf\system\template\TemplateEngine->display() (line 323) 
#11 wcf\page\AbstractPage->show() (line 114) 
#12 wcf\page\AbstractPage->__run() (line 83) 
#13 wcf\system\request\Request->execute() (line 96) 
#14 wcf\system\request\RequestHandler->handle() (line 9) 
(SQL Query) SELECT boxID, showOrder FROM wcf1_page_box_order WHERE pageID = ?
Execution time: 0.0003s
(SQL Query) SELECT thread.* FROM wbb1_thread thread WHERE thread.threadID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY lastPostTime DESC, lastPostID DESC
Execution time: 0.0007s
(SQL Query) SELECT user_option_value.*,user_avatar.*,user_rank.*, session.pageID, session.pageObjectID, session.lastActivityTime AS sessionLastActivityTime, user_table.* FROM wcf1_user user_table LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user_rank user_rank ON (user_rank.rankID = user_table.rankID) LEFT JOIN wcf1_session session ON (session.userID = user_table.userID) WHERE user_table.userID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY user_table.username
Execution time: 0.0023s
(SQL Query) SELECT thread.threadID AS objectID FROM wbb1_thread thread WHERE thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL AND thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.threadID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY thread.lastPostTime DESC,thread.threadID DESC LIMIT 5
Execution time: 0.017s
(SQL Query) SELECT like_object.likes, like_object.dislikes, thread.* FROM wbb1_thread thread LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 268 AND like_object.objectID = thread.firstPostID) WHERE thread.threadID IN (?,?,?,?,?) ORDER BY thread.lastPostTime DESC,thread.threadID DESC
Execution time: 0.0006s
(SQL Query) SELECT * FROM wcf1_box_content WHERE boxID = ?
Execution time: 0.0004s
(SQL Query) SELECT thread.threadID, thread.boardID FROM wbb1_thread thread WHERE isDisabled = ? AND isDeleted = ? AND movedThreadID IS NULL AND time < UNIX_TIMESTAMP() ORDER BY ((((thread.replies + .1) * 50 + thread.views) * 1000000000000) / POWER(UNIX_TIMESTAMP() - thread.time, 1.5)) DESC, thread.time DESC LIMIT 50
Execution time: 0.2481s
(SQL Query) SELECT thread.threadID AS objectID FROM wbb1_thread thread WHERE thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL AND thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.threadID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY ((((thread.replies + .1) * 50 + thread.views) * 1000000000000) / POWER(UNIX_TIMESTAMP() - thread.time, 1.5)) DESC,thread.time DESC LIMIT 5
Execution time: 0.0241s
(SQL Query) SELECT like_object.likes, like_object.dislikes, thread.* FROM wbb1_thread thread LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 268 AND like_object.objectID = thread.firstPostID) WHERE thread.threadID IN (?,?,?,?,?) ORDER BY ((((thread.replies + .1) * 50 + thread.views) * 1000000000000) / POWER(UNIX_TIMESTAMP() - thread.time, 1.5)) DESC,thread.time DESC
Execution time: 0.0007s
(SQL Query) SELECT user_option_value.*,user_avatar.*,user_rank.*, session.pageID, session.pageObjectID, session.lastActivityTime AS sessionLastActivityTime, user_table.* FROM wcf1_user user_table LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user_rank user_rank ON (user_rank.rankID = user_table.rankID) LEFT JOIN wcf1_session session ON (session.userID = user_table.userID) WHERE user_table.userID IN (?) ORDER BY user_table.username
Execution time: 0.0012s
(SQL Query) SELECT * FROM wcf1_box_content WHERE boxID = ?
Execution time: 0.0005s
(SQL Query) SELECT user_option_value.userOption19 AS canViewOnlineStatus, session.userID FROM wcf1_session session LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = session.userID) WHERE session.lastActivityTime > ? AND session.spiderID IS NULL
Execution time: 0.0015s
(SQL Query) SELECT user_avatar.*, user_option_value.*, user_group.userOnlineMarking, user_table.*, session.* FROM wcf1_session session LEFT JOIN wcf1_user user_table ON (user_table.userID = session.userID) LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user_group user_group ON (user_group.groupID = user_table.userOnlineGroupID) WHERE session.lastActivityTime > ? AND session.userID IS NOT NULL ORDER BY user_table.username
Execution time: 0.0033s
(SQL Query) SELECT * FROM wcf1_box_content WHERE boxID = ?
Execution time: 0.0006s

Alles anzeigen

Gerade eben ein langer Hänger mit 14sec

GrandAdmiralThrawn

Und wieder das gleiche Query schuld. Damit isses wohl schon ganz gut eingegrenzt.

Löschzwerg

Code

(SQL Query) SELECT * FROM wcf1_session WHERE sessionID = ?
Execution time: 0.0007s
(SQL Query) SELECT user_option_value.*, user_table.* FROM wcf1_user user_table LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) WHERE user_table.userID = ?
Execution time: 0.001s
(SQL Query) SELECT * FROM wcf1_session WHERE userID = ?
Execution time: 0.0004s
(SQL Query) INSERT INTO wcf1_session (sessionID,userID,ipAddress,userAgent,lastActivityTime,requestURI,requestMethod) VALUES (?,?,?,?,?,?,?)
Execution time: 0.0004s
(SQL Query) SELECT * FROM wcf1_session WHERE sessionID = ?
Execution time: 0.0003s
(SQL Query) SELECT * FROM wcf1_session_virtual WHERE sessionID = ? AND ipAddress = ? AND userAgent = ?
Execution time: 0.0003s
(SQL Query) INSERT INTO wcf1_session_virtual (sessionID,lastActivityTime,ipAddress,userAgent) VALUES (?,?,?,?)
Execution time: 0.0004s
(SQL Query) SELECT * FROM wcf1_session_virtual WHERE virtualSessionID = ?
Execution time: 0.0003s
(SQL Query) SELECT COUNT(*) AS amount FROM wbb1_post
Execution time: 16.9218s
(SQL Query) SELECT COUNT(*) AS amount FROM wbb1_thread
Execution time: 1.3501s
(SQL Query) SELECT COUNT(*) AS amount FROM wcf1_user
Execution time: 0.0077s
(SQL Query) SELECT * FROM wcf1_user ORDER BY userID DESC LIMIT 1
Execution time: 0.0006s
(SQL Query) SELECT box.* FROM wcf1_box box WHERE (box.visibleEverywhere = ? AND boxID NOT IN (SELECT boxID FROM wcf1_box_to_page WHERE pageID = ? AND visible = ?)) OR boxID IN (SELECT boxID FROM wcf1_box_to_page WHERE pageID = ? AND visible = ?)
Execution time: 0.001s
(SQL Query) SELECT boxID, showOrder FROM wcf1_page_box_order WHERE pageID = ?
Execution time: 0.0002s
(SQL Query) SELECT thread.* FROM wbb1_thread thread WHERE thread.threadID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY lastPostTime DESC, lastPostID DESC
Execution time: 0.001s
(SQL Query) SELECT user_option_value.*,user_avatar.*,user_rank.*, session.pageID, session.pageObjectID, session.lastActivityTime AS sessionLastActivityTime, user_table.* FROM wcf1_user user_table LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user_rank user_rank ON (user_rank.rankID = user_table.rankID) LEFT JOIN wcf1_session session ON (session.userID = user_table.userID) WHERE user_table.userID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY user_table.username
Execution time: 0.0013s
(SQL Query) SELECT thread.threadID AS objectID FROM wbb1_thread thread WHERE thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL AND thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.threadID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY thread.lastPostTime DESC,thread.threadID DESC LIMIT 5
Execution time: 0.019s
(SQL Query) SELECT like_object.likes, like_object.dislikes, thread.* FROM wbb1_thread thread LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 268 AND like_object.objectID = thread.firstPostID) WHERE thread.threadID IN (?,?,?,?,?) ORDER BY thread.lastPostTime DESC,thread.threadID DESC
Execution time: 0.0007s
(SQL Query) SELECT user_option_value.*,user_avatar.*,user_rank.*, session.pageID, session.pageObjectID, session.lastActivityTime AS sessionLastActivityTime, user_table.* FROM wcf1_user user_table LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user_rank user_rank ON (user_rank.rankID = user_table.rankID) LEFT JOIN wcf1_session session ON (session.userID = user_table.userID) WHERE user_table.userID IN (?,?) ORDER BY user_table.username
Execution time: 0.0015s
(SQL Query) SELECT * FROM wcf1_box_content WHERE boxID = ?
Execution time: 0.0005s
(SQL Query) SELECT thread.threadID, thread.boardID FROM wbb1_thread thread WHERE isDisabled = ? AND isDeleted = ? AND movedThreadID IS NULL AND time < UNIX_TIMESTAMP() ORDER BY ((((thread.replies + .1) * 50 + thread.views) * 1000000000000) / POWER(UNIX_TIMESTAMP() - thread.time, 1.5)) DESC, thread.time DESC LIMIT 50
Execution time: 0.1385s
(SQL Query) SELECT thread.threadID AS objectID FROM wbb1_thread thread WHERE thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL AND thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.threadID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY ((((thread.replies + .1) * 50 + thread.views) * 1000000000000) / POWER(UNIX_TIMESTAMP() - thread.time, 1.5)) DESC,thread.time DESC LIMIT 5
Execution time: 0.0083s
(SQL Query) SELECT like_object.likes, like_object.dislikes, thread.* FROM wbb1_thread thread LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 268 AND like_object.objectID = thread.firstPostID) WHERE thread.threadID IN (?,?,?,?,?) ORDER BY ((((thread.replies + .1) * 50 + thread.views) * 1000000000000) / POWER(UNIX_TIMESTAMP() - thread.time, 1.5)) DESC,thread.time DESC
Execution time: 0.0006s
(SQL Query) SELECT user_option_value.*,user_avatar.*,user_rank.*, session.pageID, session.pageObjectID, session.lastActivityTime AS sessionLastActivityTime, user_table.* FROM wcf1_user user_table LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user_rank user_rank ON (user_rank.rankID = user_table.rankID) LEFT JOIN wcf1_session session ON (session.userID = user_table.userID) WHERE user_table.userID IN (?) ORDER BY user_table.username
Execution time: 0.0005s
(SQL Query) SELECT * FROM wcf1_box_content WHERE boxID = ?
Execution time: 0.0002s
(SQL Query) SELECT user_option_value.userOption19 AS canViewOnlineStatus, session.userID FROM wcf1_session session LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = session.userID) WHERE session.lastActivityTime > ? AND session.spiderID IS NULL
Execution time: 0.0005s
(SQL Query) SELECT user_avatar.*, user_option_value.*, user_group.userOnlineMarking, user_table.*, session.* FROM wcf1_session session LEFT JOIN wcf1_user user_table ON (user_table.userID = session.userID) LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user_group user_group ON (user_group.groupID = user_table.userOnlineGroupID) WHERE session.lastActivityTime > ? AND session.userID IS NOT NULL ORDER BY user_table.username
Execution time: 0.0011s
(SQL Query) SELECT * FROM wcf1_box_content WHERE boxID = ?
Execution time: 0.0002s

Alles anzeigen

Und gerade wieder.

Was macht die Abfrage denn genau?

ernesto.che

Das ist die Abfrage, die dafür sorgt, dass im Footer die Summe aller Beiträge angezeigt wird. Also nichts komplexes, lediglich ein Durchzählen aller Beiträge.

Das muss jetzt noch ein bisschen näher betrachtet werden. Sieht aber erstmal nach wie vor so aus als müsste der Hoster etwas machen.

ernesto.che

Kurzes Zwischenfazit: Um nicht mit langen Ladezeiten zu nerven, habe ich die Anzeige erstmal deaktiviert.

Ein Duplikat der Datenbank habe ich bei einem anderen Hoster eingespielt - da flutscht sie deutlich besser als hier.

Mit ein paar Hinweisen vom wirklich guten Support von Woltlab habe ich mich gerade erneut an den Host Europe Support gewandt.

LoB

Mal ganz ehrlich: Die Anzeige dieser Zahl ist auch so sinnvoll wie... gar nichts, oder?

Ich denke die dürfte keiner vermissen...

ernesto.che

Da stimme ich dir generell zu. Allerdings hat mich, ohne jetzt weiter ins Detail gehen zu wollen, die Art des Supports von Host Europe im sportlichen Sinne motiviert.

Das war ganz schlecht und ganz schlechtes Niveau.

LoB

DAS kann ich nachvollziehen.

Löschzwerg

Danke fürs Dranbleiben, Ernesto

ernesto.che

Zwischenstand: Jetzt hat sich ein 2nd Level Support gemeldet. Es wird vermutet, dass es sich vermutlich um einen "bekannten Bug in MySQL" handele. Wann das behoben würde, sei leider noch unklar.

Leider nicht so richtig konkret, jedoch konkreter als zuvor.

GrandAdmiralThrawn

Ist der Datenbankserver auch shared? Weil dann würde ich verstehen wenn sie nicht einfach Mal so ein Upgrade fahren können. Falls es das wirklich ist.

ernesto.che

Da es ein shared Hosting ist, gehe ich davon aus, dass das auf den DB-Server ebenfalls zutrifft.

Ich bin aufgrund meiner vorherigen Supporterfahren auch nicht vollends überzeugt, dass das so sein muss.

LoB

Insgesamt ist es aber schon extrem unwahrscheinlich, dass man auf einen Bug im DBMS stößt. Sowas tritt eher auf, wenn man ganz spezielle Queries macht, in Hochlastumgebungen oder sonstwas.

Ich würde das als Ausrede bewerten.