Take the 2-minute tour ×  I have the following DB structure on
my MySQL 5.1.66:  ID         int(11) PRIMARY CID
varchar(255) INDEX V1         varchar(1500) DATE       datetime
IP_ADDR    varchar(255) V2         varchar(1000) USER_DELAY
int(11) M_ID       int(22) REFERER    varchar(255) BRAND
varchar(255) LANG       varchar(255) USER       varchar(255)  I
have almost 9,000,000 rows in the DB and here are some of my
more important my.cnf properties:  innodb_buffer_pool_size =
256M innodb_log_buffer_size = 16M key_buffer_size = 128M
bulk_insert_buffer_size = 128M max_heap_table_size = 128M
sort_buffer_size = 8M tmp_table_size = 128M  The problem is,
when running a simple query such as:  SELECT * FROM table WHERE
CID = 123456  It takes over 60 seconds to get a response (CID is
an indexed field and the query has only 10 results).  EXPLAIN
output for the above query:  |  1 | SIMPLE      | table | ALL  |
CID           | NULL | NULL    | NULL | 9193357 | Using where |
EDIT: I just noticed something, when