zfrank
11.07.2003, 20:37
Ab und an hab ich noch Probleme, das der Serverload kurzzeitig extrem ansteigt. Ein Problem war der "who voted"-query, das ist jetzt behoben.
Jetzt hatte ich wieder kurzfristig hohe serverload, vielleicht kann mal jemand nen Blick drauf werfen, was das sein könnte:
Auffällig ist die Time, über 18 Sekunden für mehrere Querys.. das kommt nur ganz selten vor, echt merkwürdig..
--------+-------+-----------+-------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+-------+-----------+-------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 756289 | forum | localhost | forum | Query | 18 | Sorting result |
SELECT
thread.threadid
FROM
thread
WHERE
thread.visible= |
| 756293 | forum | localhost | forum | Query | 18 | Sorting result |
SELECT
thread.threadid
FROM
thread
WHERE
thread.visible= |
| 756321 | forum | localhost | forum | Query | 18 | Sorting result |
SELECT
thread.threadid
FROM
thread
WHERE
thread.visible= |
| 756324 | forum | localhost | forum | Query | 16 | Sorting result |
SELECT
thread.threadid
FROM
thread
WHERE
thread.visible= |
| 756362 | forum | localhost | forum | Sleep | 5 | | |
| 756367 | forum | localhost | forum | Sleep | 7 | | |
| 756371 | forum | localhost | forum | Query | 16 | Sending data | SELECT COUNT(*) AS threads FROM thread
WHERE thread.visible=1 AND 1=1 AND NOT (thre |
| 756378 | forum | localhost | forum | Query | 17 | Sending data | SELECT COUNT(*) AS threads FROM thread
WHERE thread.visible=1 AND 1=1 AND NOT (thre |
| 756383 | forum | localhost | forum | Query | 17 | Sending data | SELECT COUNT(*) AS threads FROM thread
WHERE thread.visible=1 AND 1=1 AND NOT (thre |
| 756401 | forum | localhost | forum | Query | 14 | Sending data | SELECT COUNT(*) AS threads FROM thread
WHERE thread.visible=1 AND 1=1 AND NOT (thre |
| 756424 | forum | localhost | forum | Sleep | 3 | | |
| 756428 | forum | localhost | forum | Query | 3 | Locked | UPDATE thread SET lastpost='1057948584',replycount=replycount+1,lastposter='desbloqueo' WHERE thread |
| 756442 | forum | localhost | forum | Query | 3 | Locked |
SELECT
thread.threadid
FROM thread
WHERE thread.forumid = 117
AND thread.sticky=0
AND th |
| 756443 | forum | localhost | forum | Query | 3 | Locked | SELECT COUNT(*) AS threads
FROM thread
WHERE thread.forumid = 117
AND thread.stic |
| 756449 | forum | localhost | forum | Query | 2 | Locked | SELECT COUNT(*) AS threads
FROM thread
WHERE thread.forumid = 140
AND thread.stic |
| 756451 | forum | localhost | forum | Query | 2 | Locked | SELECT COUNT(*) AS threads FROM thread
WHERE thread.visible=1 AND 1=1 AND NOT (thre |
| 756453 | forum | localhost | forum | Query | 1 | Locked | SELECT * FROM thread WHERE threadid=16245 |
| 756455 | forum | localhost | forum | Query | 1 | Locked | SELECT * FROM thread WHERE threadid=91746 |
| 756459 | forum | localhost | forum | Sleep | 0 | | |
| 756460 | admin | localhost | | Query | 0 | | show processlist |
+--------+-------+-----------+-------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
Jetzt hatte ich wieder kurzfristig hohe serverload, vielleicht kann mal jemand nen Blick drauf werfen, was das sein könnte:
Auffällig ist die Time, über 18 Sekunden für mehrere Querys.. das kommt nur ganz selten vor, echt merkwürdig..
--------+-------+-----------+-------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+-------+-----------+-------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 756289 | forum | localhost | forum | Query | 18 | Sorting result |
SELECT
thread.threadid
FROM
thread
WHERE
thread.visible= |
| 756293 | forum | localhost | forum | Query | 18 | Sorting result |
SELECT
thread.threadid
FROM
thread
WHERE
thread.visible= |
| 756321 | forum | localhost | forum | Query | 18 | Sorting result |
SELECT
thread.threadid
FROM
thread
WHERE
thread.visible= |
| 756324 | forum | localhost | forum | Query | 16 | Sorting result |
SELECT
thread.threadid
FROM
thread
WHERE
thread.visible= |
| 756362 | forum | localhost | forum | Sleep | 5 | | |
| 756367 | forum | localhost | forum | Sleep | 7 | | |
| 756371 | forum | localhost | forum | Query | 16 | Sending data | SELECT COUNT(*) AS threads FROM thread
WHERE thread.visible=1 AND 1=1 AND NOT (thre |
| 756378 | forum | localhost | forum | Query | 17 | Sending data | SELECT COUNT(*) AS threads FROM thread
WHERE thread.visible=1 AND 1=1 AND NOT (thre |
| 756383 | forum | localhost | forum | Query | 17 | Sending data | SELECT COUNT(*) AS threads FROM thread
WHERE thread.visible=1 AND 1=1 AND NOT (thre |
| 756401 | forum | localhost | forum | Query | 14 | Sending data | SELECT COUNT(*) AS threads FROM thread
WHERE thread.visible=1 AND 1=1 AND NOT (thre |
| 756424 | forum | localhost | forum | Sleep | 3 | | |
| 756428 | forum | localhost | forum | Query | 3 | Locked | UPDATE thread SET lastpost='1057948584',replycount=replycount+1,lastposter='desbloqueo' WHERE thread |
| 756442 | forum | localhost | forum | Query | 3 | Locked |
SELECT
thread.threadid
FROM thread
WHERE thread.forumid = 117
AND thread.sticky=0
AND th |
| 756443 | forum | localhost | forum | Query | 3 | Locked | SELECT COUNT(*) AS threads
FROM thread
WHERE thread.forumid = 117
AND thread.stic |
| 756449 | forum | localhost | forum | Query | 2 | Locked | SELECT COUNT(*) AS threads
FROM thread
WHERE thread.forumid = 140
AND thread.stic |
| 756451 | forum | localhost | forum | Query | 2 | Locked | SELECT COUNT(*) AS threads FROM thread
WHERE thread.visible=1 AND 1=1 AND NOT (thre |
| 756453 | forum | localhost | forum | Query | 1 | Locked | SELECT * FROM thread WHERE threadid=16245 |
| 756455 | forum | localhost | forum | Query | 1 | Locked | SELECT * FROM thread WHERE threadid=91746 |
| 756459 | forum | localhost | forum | Sleep | 0 | | |
| 756460 | admin | localhost | | Query | 0 | | show processlist |
+--------+-------+-----------+-------+---------+------+----------------+------------------------------------------------------------------------------------------------------+