This table contains more than 2.5 million records. I
created index on column hari. It needs more than 3797
secs, and have not finished yet.
Anybody has advice?
mysql> describe tb_trafik_bulanan;
+---------------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default
| Extra |
+---------------+----------------------+------+-----+---------+-------+
| thn | smallint(5) unsigned | YES | | NULL |
|
| bln | tinyint(3) unsigned | YES | | NULL |
|
| hari | tinyint(3) unsigned | YES | | NULL |
|
| id_hari | int(10) unsigned | YES | | NULL |
|
| kd_link | char(4) | YES | | NULL | |
| ip_asal | int(10) unsigned | YES | MUL | NULL |
|
| sip_asal | char(19) | YES | | NULL | |
| port_asal | smallint(5) unsigned | YES | MUL | NULL
| |
| ip_tujuan | int(10) unsigned | YES | MUL | NULL |
|
| sip_tujuan | char(19) | YES | | NULL | |
| port_tujuan | smallint(5) unsigned | YES | MUL |
NULL | |
| jml_byte | int(10) unsigned | YES | | NULL |
|
| jml_flow | smallint(5) unsigned | YES | | NULL
| |
| jml_packet | int(10) unsigned | YES | | NULL |
|
| kd_neg | char(2) | YES | MUL | NULL | |
| id_pelanggan | char(8) | YES | MUL | NULL |
|
| kd_jasa | char(2) | YES | MUL | NULL | |
| arah_dan_tipe | tinyint(3) unsigned | YES | MUL |
NULL | |
| kd_server | char(2) | YES | MUL |
NULL | |
| kd_non_server | char(2) | YES | MUL |
NULL | |
+---------------+----------------------+------+-----+---------+-------+
mysql> show processlist;
+----+--------+-----------+----------+---------+------+----------------------+-----------------------------------------------+
| Id | User | Host | db | Command | Time
| State | Info
|
+----+--------+-----------+----------+---------+------+----------------------+-----------------------------------------------+
| 31 | netmon | localhost | tracemon | Query | 3797
| Repair with keycache | create index hari on
tb_trafik_bulanan (hari) |
| 40 | netmon | localhost | tracemon | Query | 0
| NULL | show processlist
|
+----+--------+-----------+----------+---------+------+----------------------+-----------------------------------------------+
2 rows in set (0.00 sec)
regards
-ilham-
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
