Hallo,
bei mir ist mysql ziehmlich langsam.
Hier der Log:
/usr/sbin/mysqld-5, Version: 5.0.51b-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /sandbox/var/lib/mysql/mysql5.sock
Time Id Command Argument
Time: 090301 12:30:38
User@Host: db115824_39[db115824_39] @ local3 [127.0.0.3]
Query_time: 5 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use db115824_39;
DELETE FROM cache_pages;
Time: 090301 12:31:12
User@Host: db115824_39[db115824_39] @ local3 [127.0.0.3]
Query_time: 33 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
DELETE FROM tx_realurl_urlencodecache;
Time: 090302 1:19:21
User@Host: root[root] @ localhost []
Query_time: 25 Lock_time: 0 Rows_sent: 56338 Rows_examined: 56338
SELECT /*!40001 SQL_NO_CACHE */ * FROM index_phash;
Time: 090302 1:27:50
User@Host: root[root] @ localhost []
Query_time: 509 Lock_time: 0 Rows_sent: 56338 Rows_examined: 56338
SELECT /*!40001 SQL_NO_CACHE */ * FROM index_fulltext;
Time: 090302 1:30:28
User@Host: root[root] @ localhost []
Query_time: 158 Lock_time: 0 Rows_sent: 4422247 Rows_examined: 4422247
SELECT /*!40001 SQL_NO_CACHE */ * FROM index_rel;
Time: 090303 0:16:31
User@Host: root[root] @ localhost []
Query_time: 7 Lock_time: 0 Rows_sent: 264 Rows_examined: 264
use db115824_6;
SHOW TABLE STATUS FROM db115824_33;
Time: 090303 0:17:40
User@Host: root[root] @ localhost []
Query_time: 8 Lock_time: 0 Rows_sent: 212 Rows_examined: 212
use db115824_44;
SHOW TABLE STATUS FROM db115824_45;
Time: 090303 1:19:38
User@Host: root[root] @ localhost []
Query_time: 24 Lock_time: 0 Rows_sent: 56563 Rows_examined: 56563
use db115824_39;
SELECT /*!40001 SQL_NO_CACHE */ * FROM index_phash;
Time: 090303 1:27:59
User@Host: root[root] @ localhost []
Query_time: 501 Lock_time: 0 Rows_sent: 56563 Rows_examined: 56563
SELECT /*!40001 SQL_NO_CACHE */ * FROM index_fulltext;
Time: 090303 1:30:39
User@Host: root[root] @ localhost []
Query_time: 159 Lock_time: 0 Rows_sent: 4438625 Rows_examined: 4438625
SELECT /*!40001 SQL_NO_CACHE */ * FROM index_rel;
Time: 090304 1:09:23
User@Host: root[root] @ localhost []
Query_time: 6 Lock_time: 0 Rows_sent: 949 Rows_examined: 949
SELECT /*!40001 SQL_NO_CACHE */ * FROM cache_pages;
Time: 090304 1:09:48
User@Host: root[root] @ localhost []
Query_time: 24 Lock_time: 0 Rows_sent: 56996 Rows_examined: 56996
SELECT /*!40001 SQL_NO_CACHE */ * FROM index_phash;
Time: 090304 1:18:35
User@Host: root[root] @ localhost []
Query_time: 527 Lock_time: 0 Rows_sent: 56996 Rows_examined: 56996
SELECT /*!40001 SQL_NO_CACHE */ * FROM index_fulltext;
Time: 090304 1:21:14
User@Host: root[root] @ localhost []
Query_time: 158 Lock_time: 0 Rows_sent: 4485366 Rows_examined: 4485366
SELECT /*!40001 SQL_NO_CACHE */ * FROM index_rel;
Time: 090305 1:15:52
User@Host: root[root] @ localhost []
Query_time: 7 Lock_time: 0 Rows_sent: 1181 Rows_examined: 1181
SELECT /*!40001 SQL_NO_CACHE */ * FROM cache_pages;
Time: 090305 1:16:17
User@Host: root[root] @ localhost []
Query_time: 24 Lock_time: 0 Rows_sent: 57186 Rows_examined: 57186
SELECT /*!40001 SQL_NO_CACHE */ * FROM index_phash;
Time: 090305 1:26:09
User@Host: root[root] @ localhost []
Query_time: 592 Lock_time: 0 Rows_sent: 57186 Rows_examined: 57186
SELECT /*!40001 SQL_NO_CACHE */ * FROM index_fulltext;
Time: 090305 1:29:01
User@Host: root[root] @ localhost []
Query_time: 171 Lock_time: 0 Rows_sent: 4499159 Rows_examined: 4499159
SELECT /*!40001 SQL_NO_CACHE */ * FROM index_rel;
Time: 090305 1:29:14
User@Host: root[root] @ localhost []
Query_time: 7 Lock_time: 0 Rows_sent: 36925 Rows_examined: 36925
SELECT /*!40001 SQL_NO_CACHE */ * FROM tx_realurl_urlencodecache;
Time: 090305 9:38:49
User@Host: db115824_39[db115824_39] @ local3 [127.0.0.3]
Query_time: 6 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
DELETE FROM cache_pages
WHERE
page_id IN (193,187,230,186,224,205,196,241,200,239,201,202,231,203,204,209,210,165,211,212,164);
Ist das Problem bekannt bzw. wie wird es gefixt?
cu,
hans