- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "xutian" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, December 19, 2001 12:27 PM
Subject: Re: Mysql query it too slow in big table
> In the last episode (Dec 1
In the last episode (Dec 19), xutian said:
> ###COLL_DATA's index
> mysql> show index from COLL_DATA;
>
>+---+++--+-+---+-+--++-+
>
> | Table | Non_unique | Key_name | Seq_in_index | Column_
> ###query the last time where ip='172.017.011.253'
> mysql> select max(THE_TIME) from COLL_DATA where
IP_ADDR='172.017.011.253';
> +-+
> | max(THE_TIME) |
> +-+
> | 2001-11-26 14:35:18 |
> +-+
> 1 row in set (6.77 sec)
> It's too
###table struct of COLL_DATA
mysql> desc COLL_DATA;
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-+---+
| TASK_ID | bigint(20) | YES | | NULL | |
| E_TYPE_ID | int(11) | YES
