Есть таблица :
mysql> SHOW CREATE TABLE `raw`;
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| raw | CREATE TABLE `raw` (
`unix_secs` int(11) unsigned NOT NULL DEFAULT '0',
`unix_nsecs` int(11) unsigned NOT NULL DEFAULT '0',
`sysuptime` int(11) unsigned NOT NULL DEFAULT '0',
`exaddr` varchar(15) NOT NULL DEFAULT '0',
`dpkts` int(11) unsigned NOT NULL DEFAULT '0',
`doctets` int(11) unsigned NOT NULL DEFAULT '0',
`srcaddr` varchar(15) NOT NULL DEFAULT '0',
`dstaddr` varchar(15) NOT NULL DEFAULT '0',
`srcport` smallint(5) unsigned NOT NULL DEFAULT '0',
`dstport` smallint(5) unsigned NOT NULL DEFAULT '0',
`prot` tinyint(3) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.02 sec)


делаю запрос: select srcaddr and SUM(doctets) from raw where srcaddr = 'x.x.x.x';

И он выполняется 10 минут. Почты любой запрос выполняется 10 минут (select).
Как диагностировать проблему? Заранее всем спасибо.