mysql> select * from test.ip20090101 where ip_in='192.168.1.3' limit 10; +---------+-------------+------------+----------------+-------------+--------+ | ip_time | ip_in | ip_in_port | ip_out | ip_out_port | ip_id | +---------+-------------+------------+----------------+-------------+--------+ | 1448 | 192.168.1.3 | 50982 | 84.223.85.225 | 54308 | 358238 | | 1448 | 192.168.1.3 | 51954 | 77.20.125.193 | 49192 | 360509 | | 1448 | 192.168.1.3 | 50982 | 84.223.85.225 | 54308 | 364429 | | 1448 | 192.168.1.3 | 45732 | 65.110.228.44 | 32156 | 368922 | | 1448 | 192.168.1.3 | 38536 | 77.111.76.122 | 6969 | 387672 | | 1448 | 192.168.1.3 | 56410 | 189.82.25.146 | 21205 | 388351 | | 1448 | 192.168.1.3 | 59922 | 152.23.203.100 | 48818 | 388509 | | 1448 | 192.168.1.3 | 56120 | 86.48.51.91 | 35337 | 388833 | | 1448 | 192.168.1.3 | 58060 | 88.134.60.48 | 17177 | 388863 | | 1448 | 192.168.1.3 | 43672 | 208.78.98.251 | 38052 | 398613 | +---------+-------------+------------+----------------+-------------+--------+ 10 rows in set (0.00 sec) mysql> select * from test.ip20090101 where ip_in='192.168.1.3' limit 10; +---------+-------------+------------+----------------+-------------+--------+ | ip_time | ip_in | ip_in_port | ip_out | ip_out_port | ip_id | +---------+-------------+------------+----------------+-------------+--------+ | 1448 | 192.168.1.3 | 50982 | 84.223.85.225 | 54308 | 358238 | | 1448 | 192.168.1.3 | 51954 | 77.20.125.193 | 49192 | 360509 | | 1448 | 192.168.1.3 | 50982 | 84.223.85.225 | 54308 | 364429 | | 1448 | 192.168.1.3 | 45732 | 65.110.228.44 | 32156 | 368922 | | 1448 | 192.168.1.3 | 38536 | 77.111.76.122 | 6969 | 387672 | | 1448 | 192.168.1.3 | 56410 | 189.82.25.146 | 21205 | 388351 | | 1448 | 192.168.1.3 | 59922 | 152.23.203.100 | 48818 | 388509 | | 1448 | 192.168.1.3 | 56120 | 86.48.51.91 | 35337 | 388833 | | 1448 | 192.168.1.3 | 58060 | 88.134.60.48 | 17177 | 388863 | | 1448 | 192.168.1.3 | 43672 | 208.78.98.251 | 38052 | 398613 | +---------+-------------+------------+----------------+-------------+--------+ 10 rows in set (0.00 sec) mysql> select * from test.ip20090101 where ip_in='208.78.98.251' limit 10; +---------+---------------+------------+-------------+-------------+--------+ | ip_time | ip_in | ip_in_port | ip_out | ip_out_port | ip_id | +---------+---------------+------------+-------------+-------------+--------+ | 1448 | 208.78.98.251 | 38052 | 192.168.1.3 | 43672 | 398559 | | 1448 | 208.78.98.251 | 38052 | 192.168.1.3 | 43672 | 750033 | | 1448 | 208.78.98.251 | 38052 | 192.168.1.3 | 43672 | 117563 | | 1448 | 208.78.98.251 | 38052 | 192.168.1.3 | 43672 | 464925 | | 1448 | 208.78.98.251 | 38052 | 192.168.1.3 | 43672 | 731613 | | 1448 | 208.78.98.251 | 38052 | 192.168.1.3 | 43672 | 111364 | | 1448 | 208.78.98.251 | 38052 | 192.168.1.3 | 43672 | 881045 | | 1448 | 208.78.98.251 | 38052 | 192.168.1.3 | 43672 | 361748 | | 1448 | 208.78.98.251 | 38052 | 192.168.1.3 | 43672 | 860086 | | 1448 | 208.78.98.251 | 38052 | 192.168.1.3 | 43672 | 295591 | +---------+---------------+------------+-------------+-------------+--------+ 10 rows in set (0.01 sec) mysql> select * from test.ip20090101 where ip_in='208.78.98.251'; ERROR 1030 (HY000): Got error 124 from storage engine mysql> select * from test.ip20090101 where ip_in='208.78.98.251'; ERROR 1030 (HY000): Got error 124 from storage engine mysql> select * from test.ip20090101 where ip_in='208.78.98.251'; ERROR 1030 (HY000): Got error 124 from storage engine mysql> select * from test.ip20090101 where ip_in='208.78.98.251'; ERROR 1030 (HY000): Got error 124 from storage engine mysql> select * from test.ip20090101 where ip_in='208.78.98.251'; ERROR 1030 (HY000): Got error 124 from storage engine mysql> select * from test.ip20090101 where ip_in='208.78.98.251'; ERROR 1030 (HY000): Got error 124 from storage engine mysql> select * from test.ip20090101 where ip_in='208.78.98.251'; ERROR 1030 (HY000): Got error 124 from storage engine mysql> select * from test.ip20090101 where ip_in='208.78.98.251'; ERROR 1030 (HY000): Got error 124 from storage engine mysql> select * from test.ip20090101 where ip_in='208.78.98.251'; ERROR 1030 (HY000): Got error 124 from storage engine mysql>