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..

Code:
--------+-------+-----------+-------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 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                                                                                     |
+--------+-------+-----------+-------+---------+------+----------------+------------------------------------------------------------------------------------------------------+