Hallo!
Seit dem neuen WCF Update läuft das Clan Verwaltung's Plugin nur noch sehr langam bis garnicht.
Woran könnte das liegen?
Der Link zu den Clans (Squads): https://tos-xbox.net/squads/clan-li…ndicate-squads/
MfG LatroX
Hallo!
Seit dem neuen WCF Update läuft das Clan Verwaltung's Plugin nur noch sehr langam bis garnicht.
Woran könnte das liegen?
Der Link zu den Clans (Squads): https://tos-xbox.net/squads/clan-li…ndicate-squads/
MfG LatroX
Kannst du mir vielleicht malö das Benchmark Log von einer Clanseite zukommen lassen?
Gehe hierzu in dein ACP, aktiviere die Optionen Kongiguration > Module > Entwicklung > "Debug-Modus aktivieren" und "Benchmark aktivieren". Wenn du nun die Seite einmal aufrufst erscheint ganz unten in der Seite ein kleiner Text alla "Execution time: xs (x% PHP, x% SQL) | SQL queries: x | Memory-Usage: x MB. Den bräuchte ich, sowie den Log, wenn du auf den Link klickst.
gruß
Marcel
Vielen Dank für die Antwort, im Anhang findest du die gewünschten Informationen.
Log:
(SQL Query) SELECT * FROM wcf1_session WHERE sessionID = ?
Execution time: 0.0004s
#0 wcf\system\benchmark\Benchmark->start() (line 87)
#1 wcf\system\database\statement\PreparedStatement->execute() (line 65)
#2 wcf\data\DatabaseObject->__construct() (line 380)
#3 wcf\system\session\SessionHandler->getExistingSession() (line 172)
#4 wcf\system\session\SessionHandler->load() (line 28)
#5 wcf\system\session\ACPSessionFactory->load() (line 345)
#6 wcf\system\WCF->initSession() (line 143)
#7 wcf\system\WCF->__construct() (line 25)
#8 /var/www/vhosts/tos-xbox.net/httpdocs/squads/global.php: require_once() (line 6)
#9 /var/www/vhosts/tos-xbox.net/httpdocs/squads/index.php: require_once() (line 2)
(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
#0 wcf\system\benchmark\Benchmark->start() (line 87)
#1 wcf\system\database\statement\PreparedStatement->execute() (line 77)
#2 wcf\data\user\User->__construct() (line 386)
#3 wcf\system\session\SessionHandler->getExistingSession() (line 172)
#4 wcf\system\session\SessionHandler->load() (line 28)
#5 wcf\system\session\ACPSessionFactory->load() (line 345)
#6 wcf\system\WCF->initSession() (line 143)
#7 wcf\system\WCF->__construct() (line 25)
#8 /var/www/vhosts/tos-xbox.net/httpdocs/squads/global.php: require_once() (line 6)
#9 /var/www/vhosts/tos-xbox.net/httpdocs/squads/index.php: require_once() (line 2)
(SQL Query) SELECT * FROM wcf1_session_virtual WHERE sessionID = ? AND ipAddress = ? AND userAgent = ?
Execution time: 0.0003s
#0 wcf\system\benchmark\Benchmark->start() (line 87)
#1 wcf\system\database\statement\PreparedStatement->execute() (line 50)
#2 wcf\data\session\virtual\SessionVirtual::getExistingSession() (line 387)
#3 wcf\system\session\SessionHandler->getExistingSession() (line 172)
#4 wcf\system\session\SessionHandler->load() (line 28)
#5 wcf\system\session\ACPSessionFactory->load() (line 345)
#6 wcf\system\WCF->initSession() (line 143)
#7 wcf\system\WCF->__construct() (line 25)
#8 /var/www/vhosts/tos-xbox.net/httpdocs/squads/global.php: require_once() (line 6)
#9 /var/www/vhosts/tos-xbox.net/httpdocs/squads/index.php: require_once() (line 2)
(SQL Query) SELECT * FROM wcf1_user_storage WHERE userID IN (?)
Execution time: 0.0003s
#0 wcf\system\benchmark\Benchmark->start() (line 87)
#1 wcf\system\database\statement\PreparedStatement->execute() (line 58)
#2 wcf\system\user\storage\UserStorageHandler->loadStorage() (line 113)
#3 wcf\system\user\storage\UserStorageHandler->getField() (line 158)
#4 wcf\data\user\User->getGroupIDs() (line 603)
#5 wcf\system\session\SessionHandler->loadGroupData() (line 566)
#6 wcf\system\session\SessionHandler->getPermission() (line 93)
#7 wcf\system\menu\TreeMenu->checkMenuItem() (line 88)
#8 wcf\system\menu\page\PageMenu->checkMenuItem() (line 113)
#9 wcf\system\menu\TreeMenu->checkMenuItems() (line 34)
#10 wcf\system\menu\page\PageMenu->init() (line 27)
#11 wcf\system\SingletonFactory->__construct() (line 56)
#12 wcf\system\SingletonFactory::getInstance() (line 37)
#13 clan\system\CLANCore->__run() (line 476)
#14 wcf\system\WCF->initApplications() (line 148)
#15 wcf\system\WCF->__construct() (line 25)
#16 /var/www/vhosts/tos-xbox.net/httpdocs/squads/global.php: require_once() (line 6)
#17 /var/www/vhosts/tos-xbox.net/httpdocs/squads/index.php: require_once() (line 2)
(SQL Query) SELECT slideshow.* FROM wcf1_slideshow slideshow ORDER BY orderID
Execution time: 0.0003s
#0 wcf\system\benchmark\Benchmark->start() (line 87)
#1 wcf\system\database\statement\PreparedStatement->execute() (line 200)
#2 wcf\data\DatabaseObjectList->readObjects() (line 28)
#3 wcf\system\event\listener\SlideshowTopListener->execute() (line 141)
#4 wcf\system\event\EventHandler->executeInheritedActions() (line 173)
#5 wcf\system\event\EventHandler->fireAction() (line 108)
#6 wcf\page\AbstractPage->readParameters() (line 102)
#7 clan\page\AbstractClanPage->readParameters() (line 99)
#8 wcf\page\AbstractPage->__run() (line 58)
#9 wcf\system\request\Request->execute() (line 139)
#10 wcf\system\request\RequestHandler->handle() (line 3)
(SQL Query) SELECT clan.*, tracked_visit.visitTime FROM clan1_clan clan LEFT JOIN wcf1_tracked_visit tracked_visit ON (tracked_visit.objectTypeID = 566 AND tracked_visit.objectID = clan.clanID AND tracked_visit.userID = 15) WHERE clanID = ?
Execution time: 0.0003s
#0 wcf\system\benchmark\Benchmark->start() (line 87)
#1 wcf\system\database\statement\PreparedStatement->execute() (line 97)
#2 clan\data\clan\Clan->__construct() (line 107)
#3 clan\page\AbstractClanPage->readParameters() (line 99)
#4 wcf\page\AbstractPage->__run() (line 58)
#5 wcf\system\request\Request->execute() (line 139)
#6 wcf\system\request\RequestHandler->handle() (line 3)
(SQL Query) SELECT * FROM clan1_clan_visitor WHERE clanID = ? AND userID = ?
Execution time: 0.0002s
#0 wcf\system\benchmark\Benchmark->start() (line 87)
#1 wcf\system\database\statement\PreparedStatement->execute() (line 33)
#2 clan\data\clan\visitor\ClanVisitor::getObject() (line 230)
#3 clan\page\AbstractClanPage->show() (line 100)
#4 wcf\page\AbstractPage->__run() (line 58)
#5 wcf\system\request\Request->execute() (line 139)
#6 wcf\system\request\RequestHandler->handle() (line 3)
(SQL Query) UPDATE clan1_clan_visitor SET time = ? WHERE visitorID = ?
Execution time: 0.0184s
(SQL Query) SELECT like_object.*, CASE WHEN like_table.userID IS NOT NULL THEN like_table.likeValue ELSE 0 END AS liked FROM wcf1_like_object like_object LEFT JOIN wcf1_like like_table ON (like_table.objectTypeID = like_object.objectTypeID AND like_table.objectID = like_object.objectID AND like_table.userID = ?) WHERE like_object.objectTypeID = ? AND like_object.objectID IN (?)
Execution time: 0.0003s
#0 wcf\system\benchmark\Benchmark->start() (line 87)
#1 wcf\system\database\statement\PreparedStatement->execute() (line 142)
#2 wcf\system\like\LikeHandler->loadLikeObjects() (line 130)
#3 clan\page\AbstractClanPage->readData() (line 18)
#4 clan\page\ClanPage->readData() (line 273)
#5 wcf\page\AbstractPage->show() (line 245)
#6 clan\page\AbstractClanPage->show() (line 100)
#7 wcf\page\AbstractPage->__run() (line 58)
#8 wcf\system\request\Request->execute() (line 139)
#9 wcf\system\request\RequestHandler->handle() (line 3)
(SQL Query) SELECT tag.*, tag_to_object.objectID FROM wcf1_tag_to_object tag_to_object LEFT JOIN wcf1_tag tag ON (tag.tagID = tag_to_object.tagID) WHERE tag_to_object.objectTypeID = ? AND tag_to_object.objectID IN (?)
Execution time: 0.0003s
#0 wcf\system\benchmark\Benchmark->start() (line 87)
#1 wcf\system\database\statement\PreparedStatement->execute() (line 175)
#2 wcf\system\tagging\TagEngine->getObjectsTags() (line 140)
#3 wcf\system\tagging\TagEngine->getObjectTags() (line 165)
#4 clan\page\AbstractClanPage->readData() (line 18)
#5 clan\page\ClanPage->readData() (line 273)
#6 wcf\page\AbstractPage->show() (line 245)
#7 clan\page\AbstractClanPage->show() (line 100)
#8 wcf\page\AbstractPage->__run() (line 58)
#9 wcf\system\request\Request->execute() (line 139)
#10 wcf\system\request\RequestHandler->handle() (line 3)
(SQL Query) SELECT user_table.username, user_table.email, user_table.disableAvatar, user_table.enableGravatar, user_table.gravatarFileExtension, user_avatar.*, clan_visitor.* FROM clan1_clan_visitor clan_visitor LEFT JOIN wcf1_user user_table ON (user_table.userID = clan_visitor.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) WHERE clan_visitor.clanID = ? ORDER BY clan_visitor.time DESC LIMIT 10
Execution time: 0.0004s
#0 wcf\system\benchmark\Benchmark->start() (line 87)
#1 wcf\system\database\statement\PreparedStatement->execute() (line 200)
#2 wcf\data\DatabaseObjectList->readObjects() (line 192)
#3 clan\page\AbstractClanPage->readData() (line 18)
#4 clan\page\ClanPage->readData() (line 273)
#5 wcf\page\AbstractPage->show() (line 245)
#6 clan\page\AbstractClanPage->show() (line 100)
#7 wcf\page\AbstractPage->__run() (line 58)
#8 wcf\system\request\Request->execute() (line 139)
#9 wcf\system\request\RequestHandler->handle() (line 3)
(SQL Query) SELECT * FROM wcf1_message_embedded_object WHERE messageObjectTypeID = ? AND messageID IN (?)
Execution time: 0.0003s
#0 wcf\system\benchmark\Benchmark->start() (line 87)
#1 wcf\system\database\statement\PreparedStatement->execute() (line 124)
#2 wcf\system\message\embedded\object\MessageEmbeddedObjectManager->loadObjects() (line 30)
#3 clan\page\ClanPage->readData() (line 273)
#4 wcf\page\AbstractPage->show() (line 245)
#5 clan\page\AbstractClanPage->show() (line 100)
#6 wcf\page\AbstractPage->__run() (line 58)
#7 wcf\system\request\Request->execute() (line 139)
#8 wcf\system\request\RequestHandler->handle() (line 3)
(SQL Query) SELECT COUNT(*) AS count FROM clan1_clan_visitor clan_visitor WHERE clan_visitor.clanID = ?
Execution time: 0.0002s
#0 wcf\system\benchmark\Benchmark->start() (line 87)
#1 wcf\system\database\statement\PreparedStatement->execute() (line 152)
#2 wcf\data\DatabaseObjectList->countObjects() (line 217)
#3 clan\page\AbstractClanPage->assignVariables() (line 276)
#4 wcf\page\AbstractPage->show() (line 245)
#5 clan\page\AbstractClanPage->show() (line 100)
#6 wcf\page\AbstractPage->__run() (line 58)
#7 wcf\system\request\Request->execute() (line 139)
#8 wcf\system\request\RequestHandler->handle() (line 3)
(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.0006s
#0 wcf\system\benchmark\Benchmark->start() (line 87)
#1 wcf\system\database\statement\PreparedStatement->execute() (line 77)
#2 wcf\data\user\User->__construct() (line 469)
#3 clan\data\clan\Clan->getUserProfile() (line 592)
#4 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/template/TemplateEngine.class.php: include() (line 323)
#5 wcf\system\template\TemplateEngine->display() (line 305)
#6 wcf\page\AbstractPage->show() (line 245)
#7 clan\page\AbstractClanPage->show() (line 100)
#8 wcf\page\AbstractPage->__run() (line 58)
#9 wcf\system\request\Request->execute() (line 139)
#10 wcf\system\request\RequestHandler->handle() (line 3)
(SQL Query) SELECT COUNT(*) AS count FROM wcf1_user_group_leader WHERE leaderID = ?
Execution time: 0.0003s
#0 wcf\system\benchmark\Benchmark->start() (line 87)
#1 wcf\system\database\statement\PreparedStatement->execute() (line 57)
#2 wcf\data\user\group\ModeratedUserGroup::isGroupLeader() (line 21)
#3 wcf\system\menu\user\ModeratedUserGroupsMenuItemProvider->isVisible() (line 33)
#4 wcf\system\menu\user\UserMenu->checkMenuItem() (line 113)
#5 wcf\system\menu\TreeMenu->checkMenuItems() (line 115)
#6 wcf\system\menu\TreeMenu->checkMenuItems() (line 44)
#7 wcf\system\menu\TreeMenu->init() (line 27)
#8 wcf\system\SingletonFactory->__construct() (line 56)
#9 wcf\system\SingletonFactory::getInstance()
#10 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/WCF.class.php: call_user_func() (line 688)
#11 wcf\system\WCF::__callStatic() (line 659)
#12 wcf\system\WCF->__call() (line 789)
#13 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/template/TemplateEngine.class.php: include() (line 323)
#14 wcf\system\template\TemplateEngine->display() (line 305)
#15 wcf\page\AbstractPage->show() (line 245)
#16 clan\page\AbstractClanPage->show() (line 100)
#17 wcf\page\AbstractPage->__run() (line 58)
#18 wcf\system\request\Request->execute() (line 139)
#19 wcf\system\request\RequestHandler->handle() (line 3)
Alles anzeigen
Execution time:
Könnte es vielleicht auch an Ordner Berechtigungen liegen?
MfG
LatroX
Der SQL Teil läuft bei dir schon mal gut durch. Das was bei dir Resourcen frisst, ist der PHP Teil der Anwendung (um genau zu sein 99,96% der Ladezeit). Fangen wir mal ganz einach an. Welches Cache System und welche PHP Version nutzt du?
Cache-Methode: Dateisystem (Standard)
PHP Version: 7.1.17 FPM-Anwendung von Apache bedient
Konnte das Problem lösen.
Das Plugin verwendet bzw. verweist auf die Domain und die Domain konnte intern nicht von meinem Webserver nicht aufgelöst werden, wegen NAT und interner IP, etc.
Konnte das ganze mit einem Eintrag in der hosts Datei am Server lösen.
Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!