MySQL 서버가 미친듯이 느려질 때... 

+-----+----------+-----------+-------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id  | User     | Host      | db          | Command | Time | State          | Info                                                                                                 |
+-----+----------+-----------+-------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 421 | gallery2 | localhost | gallery2    | Query   | 22   | init           | INSERT INTO
          g2_ImageBlockCacheMap
        SELECT DISTINCT
          6, 2, g2_Entity.g_creationTimestamp, g2_Ent |
| 429 | root     | localhost | drupal_root | Query   | 0    | Opening tables | SELECT dst FROM url_alias WHERE src = 'blog/1'                                                       |
| 432 | root     | localhost | drupal_root | Query   | 13   | closing tables | SELECT i.* FROM aggregator_category_item ci LEFT JOIN aggregator_item i ON ci.iid = i.iid WHERE ci.c |
| 433 | root     | localhost | drupal_root | Query   | 3    | closing tables | SELECT * FROM variable WHERE name like 'event_nodeapi_%'                                             |
| 435 | barosl   | localhost | barosl      | Query   | 2    | closing tables | SELECT
              g2_ChildEntity.g_parentId,
              COUNT(g2_ChildEntity.g_id)
            FROM
              g2_Child |
| 436 | barosl   | localhost | barosl      | Sleep   | 0    |                |                                                                                                      |
| 437 | barosl   | localhost | barosl      | Query   | 3    | closing tables | SELECT COUNT(*)
                FROM tt_Entries e
                WHERE e.blogid = 1 AND e.draft = 0 AND e.visibility > 0 AND e |
| 438 | barosl   | localhost | barosl      | Query   | 0    | Opening tables | UPDATE tt_SubscriptionStatistics SET referred = UNIX_TIMESTAMP() WHERE blogid = 1 AND ip = '218.36.6 |
| 439 | barosl   | localhost | barosl      | Query   | 3    | init           | DELETE FROM tt_SubscriptionLogs WHERE referred < UNIX_TIMESTAMP() - 604800                           |
| 440 | barosl   | localhost | barosl      | Query   | 3    | closing tables | SELECT name FROM tt_Users WHERE userid = 1                                                           |
| 441 | barosl   | localhost | barosl      | Sleep   | 13   |                |                                                                                                      |
| 442 | barosl   | localhost | barosl      | Query   | 3    | closing tables | SELECT * FROM mbbs_plugin WHERE name='RawHtml'                                                       |
| 443 | barosl   | localhost | barosl      | Sleep   | 0    |                |                                                                                                      |
| 444 | root     | localhost |             | Query   | 0    |                | show processlist                                                                                     |
+-----+----------+-----------+-------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+

랜덤여신님... 덕분에 Gallery2 를 설치했어요. 더 이상 DB를 괴롭히지 말아주세요.

Submitted by jachin on Thu, 2009-01-01 01:48.