table ddl ========= CREATE TABLE `fwlogger_mrg` ( `num` int(8) NOT NULL DEFAULT '0', `mgmt_svr` varchar(8) NOT NULL DEFAULT '', `datetime` datetime DEFAULT NULL, `orig_addr_oct1` tinyint(3) unsigned DEFAULT NULL, `orig_addr_oct2` tinyint(3) unsigned DEFAULT NULL, `orig_addr_oct3` tinyint(3) unsigned DEFAULT NULL, `orig_addr_oct4` tinyint(3) unsigned DEFAULT NULL, `logtype` varchar(20) DEFAULT NULL, `action` varchar(20) DEFAULT NULL, `interface_name` varchar(24) DEFAULT NULL, `interface_dir` varchar(20) DEFAULT NULL, `product` varchar(100) DEFAULT NULL, `rule` smallint(6) DEFAULT NULL, `rule_uid` varchar(40) DEFAULT NULL, `service_id` varchar(22) DEFAULT NULL, `src_addr_oct1` tinyint(3) unsigned DEFAULT NULL, `src_addr_oct2` tinyint(3) unsigned DEFAULT NULL, `src_addr_oct3` tinyint(3) unsigned DEFAULT NULL, `src_addr_oct4` tinyint(3) unsigned DEFAULT NULL, `dst_addr_oct1` tinyint(3) unsigned DEFAULT NULL, `dst_addr_oct2` tinyint(3) unsigned DEFAULT NULL, `dst_addr_oct3` tinyint(3) unsigned DEFAULT NULL, `dst_addr_oct4` tinyint(3) unsigned DEFAULT NULL, `protocol` varchar(6) DEFAULT NULL, `service` smallint(5) unsigned DEFAULT NULL, `s_port` smallint(5) unsigned DEFAULT NULL, `xlate_src_addr_oct1` tinyint(3) unsigned DEFAULT NULL, `xlate_src_addr_oct2` tinyint(3) unsigned DEFAULT NULL, `xlate_src_addr_oct3` tinyint(3) unsigned DEFAULT NULL, `xlate_src_addr_oct4` tinyint(3) unsigned DEFAULT NULL, `xlate_dst_addr_oct1` tinyint(3) unsigned DEFAULT NULL, `xlate_dst_addr_oct2` tinyint(3) unsigned DEFAULT NULL, `xlate_dst_addr_oct3` tinyint(3) unsigned DEFAULT NULL, `xlate_dst_addr_oct4` tinyint(3) unsigned DEFAULT NULL, `nat_rule_no1` smallint(5) unsigned DEFAULT NULL, `nat_rule_no2` smallint(5) unsigned DEFAULT NULL, `xlate_svc_dst_port` smallint(5) unsigned DEFAULT NULL, `xlate_svc_src_port` smallint(5) unsigned DEFAULT NULL, `icpm_desc` varchar(22) DEFAULT NULL, `icpm_type` tinyint(3) unsigned DEFAULT NULL, `icpm_code` tinyint(3) unsigned DEFAULT NULL, `tcp_pckt_out_state` varchar(60) DEFAULT NULL, `tcp_flags` varchar(60) DEFAULT NULL, `mesg_info` text, `encryption_fail_reason` varchar(256) DEFAULT NULL, `vpn_scheme` varchar(8) DEFAULT NULL, `vpn_method` varchar(32) DEFAULT NULL, `vpn_gateway_oct1` tinyint(3) unsigned DEFAULT NULL, `vpn_gateway_oct2` tinyint(3) unsigned DEFAULT NULL, `vpn_gateway_oct3` tinyint(3) unsigned DEFAULT NULL, `vpn_gateway_oct4` tinyint(3) unsigned DEFAULT NULL, `encryption_failure` varchar(128) DEFAULT NULL, `vpn_community` varchar(45) DEFAULT NULL, `user` varchar(96) DEFAULT NULL, `attack` varchar(60) DEFAULT NULL, `attack_info` varchar(60) DEFAULT NULL, `msg` varchar(128) DEFAULT NULL, `assigned_ip_oct1` tinyint(3) unsigned DEFAULT NULL, `assigned_ip_oct2` tinyint(3) unsigned DEFAULT NULL, `assigned_ip_oct3` tinyint(3) unsigned DEFAULT NULL, `assigned_ip_oct4` tinyint(3) unsigned DEFAULT NULL, `logs_suppressed` tinyint(3) unsigned DEFAULT NULL, PRIMARY KEY (`mgmt_svr`,`num`), KEY `rule_uid` (`rule_uid`), KEY `src_addr_oct1` (`src_addr_oct1`,`src_addr_oct2`,`src_addr_oct3`,`src_addr_oct4`), KEY `dst_addr_oct1` (`dst_addr_oct1`,`dst_addr_oct2`,`dst_addr_oct3`,`dst_addr_oct4`), KEY `xlate_src_addr_oct1` (`xlate_src_addr_oct1`,`xlate_src_addr_oct2`,`xlate_src_addr_oct3`,`xlate_src_addr_oct4`), KEY `xlate_src_addr_oct1_2` (`xlate_src_addr_oct1`,`xlate_src_addr_oct2`,`xlate_src_addr_oct3`,`xlate_src_addr_oct4`) ) ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8 UNION=(`fwlogger_070109`,`fwlogger_070209`,`fwlogger_070309`,`fwlogger_070409`,`fwlogger_070509`,`fwlogger_070609`,`fwlogger_070709`,`fwlogger_070809`,`fwlogger_070909`,`fwlogger_071009`,`fwlogger_071109`,`fwlogger_071209`,`fwlogger_071309`,`fwlogger_071409`,`fwlogger_071509`,`fwlogger_071609`,`fwlogger_071709`,`fwlogger_071809`,`fwlogger_071909`,`fwlogger_072009`,`fwlogger_072109`,`fwlogger_072209`,`fwlogger_072309`,`fwlogger_072409`,`fwlogger_072509`,`fwlogger_072609`,`fwlogger_072709`,`fwlogger_072809`,`fwlogger_072909`,`fwlogger_073009`,`fwlogger_073109`,`fwlogger_080109`,`fwlogger_080209`,`fwlogger_080309`,`fwlogger_080409`,`fwlogger_080509`,`fwlogger_080609`,`fwlogger_080709`,`fwlogger_080809`,`fwlogger_081309`,`fwlogger_081409`,`fwlogger_081509`,`fwlogger_081609`,`fwlogger_081709`,`fwlogger_081809`,`fwlogger_081909`,`fwlogger_082009`,`fwlogger_082109`,`fwlogger_082209`,`fwlogger_082309`,`fwlogger_082409`,`fwlogger_082509`,`fwlogger_082609`,`fwlogger_082709`,`fwlogger_082809`,`fwlogger_082909`,`fwlogger_083009`,`fwlogger_083109`,`fwlogger_090109`,`fwlogger_090209`,`fwlogger_090309`,`fwlogger_090409`,`fwlogger_090509`,`fwlogger_090609`,`fwlogger_090709`,`fwlogger_090809`,`fwlogger_090909`,`fwlogger_091009`,`fwlogger_091109`,`fwlogger_091209`,`fwlogger_091309`,`fwlogger_091409`,`fwlogger_091509`,`fwlogger_091609`,`fwlogger_091709`,`fwlogger_091809`,`fwlogger_091909`,`fwlogger_092009`,`fwlogger_092109`,`fwlogger_092209`,`fwlogger_092309`,`fwlogger_092409`,`fwlogger_092509`,`fwlogger_092609`,`fwlogger_092709`,`fwlogger_092809`,`fwlogger_092909`,`fwlogger_093009`,`fwlogger_100109`,`fwlogger_100209`,`fwlogger_100309`,`fwlogger_100409`,`fwlogger_100509`,`fwlogger_100609`,`fwlogger_100709`,`fwlogger_100809`,`fwlogger_100909`,`fwlogger_101009`,`fwlogger_101109`,`fwlogger_101209`,`fwlogger_101309`,`fwlogger_101409`,`fwlogger_101509`,`fwlogger_101609`,`fwlogger_101709`,`fwlogger_101809`,`fwlogger_101909`,`fwlogger_102009`,`fwlogger_102109`,`fwlogger_102209`,`fwlogger_102309`,`fwlogger_102409`,`fwlogger_102509`,`fwlogger_102609`,`fwlogger_102709`,`fwlogger_102809`,`fwlogger_102909`,`fwlogger_103009`,`fwlogger_103109`,`fwlogger_110109`,`fwlogger_110209`,`fwlogger_110309`,`fwlogger_110409`,`fwlogger_080909`,`fwlogger_081009`,`fwlogger_081109`,`fwlogger_081209`,`fwlogger_110509`,`fwlogger_110609`,`fwlogger_110709`,`fwlogger_110809`,`fwlogger_110909`,`fwlogger_111009`,`fwlogger_111109`,`fwlogger_111209`,`fwlogger_111309`,`fwlogger_111409`,`fwlogger_111509`,`fwlogger_111609`,`fwlogger_111709`,`fwlogger_111809`,`fwlogger_111909`,`fwlogger_112009`,`fwlogger_112109`,`fwlogger_112209`,`fwlogger_112309`,`fwlogger_112409`,`fwlogger_112509`,`fwlogger_112609`,`fwlogger_112709`,`fwlogger_112809`,`fwlogger_112909`,`fwlogger_113009`,`fwlogger_120109`,`fwlogger_120209`,`fwlogger_120309`,`fwlogger_120409`,`fwlogger_120509`,`fwlogger_120609`,`fwlogger_120709`,`fwlogger_120809`,`fwlogger_120909`,`fwlogger_121009`,`fwlogger_121109`,`fwlogger_121209`,`fwlogger_121309`,`fwlogger_121409`,`fwlogger_121509`,`fwlogger_121609`,`fwlogger_121709`,`fwlogger_121809`,`fwlogger_121909`,`fwlogger_122009`,`fwlogger_122109`,`fwlogger_122209`,`fwlogger_122309`,`fwlogger_122409`,`fwlogger_122509`,`fwlogger_122609`,`fwlogger_122709`,`fwlogger_122809`,`fwlogger_122909`,`fwlogger_123009`,`fwlogger_123109`,`fwlogger_010110`,`fwlogger_010210`,`fwlogger_010310`,`fwlogger_010410`,`fwlogger_010510`,`fwlogger_010610`,`fwlogger_010710`,`fwlogger_010810`,`fwlogger_010910`,`fwlogger_011010`,`fwlogger_011110`,`fwlogger_011210`,`fwlogger_011310`,`fwlogger_011410`,`fwlogger_011510`,`fwlogger_011610`,`fwlogger_011710`,`fwlogger_011810`,`fwlogger_011910`,`fwlogger_012010`,`fwlogger_012110`,`fwlogger_012210`,`fwlogger_012310`,`fwlogger_012410`,`fwlogger_012510`,`fwlogger_012610`,`fwlogger_012710`,`fwlogger_012810`,`fwlogger_012910`,`fwlogger_013010`,`fwlogger_013110`,`fwlogger_020110`,`fwlogger_020210`,`fwlogger_020310`,`fwlogger_020410`,`fwlogger_020510`,`fwlogger_020610`,`fwlogger_020710`,`fwlogger_020810`,`fwlogger_020910`,`fwlogger_021010`,`fwlogger_021110`,`fwlogger_021210`,`fwlogger_021310`,`fwlogger_021410`,`fwlogger_021510`,`fwlogger_021610`,`fwlogger_021710`,`fwlogger_021810`,`fwlogger_021910`,`fwlogger_022010`,`fwlogger_022110`,`fwlogger_022210`,`fwlogger_022310`,`fwlogger_022410`,`fwlogger_022510`,`fwlogger_022610`,`fwlogger_022710`,`fwlogger_022810`,`fwlogger_030110`,`fwlogger_030210`,`fwlogger_030310`,`fwlogger_030410`,`fwlogger_030510`,`fwlogger_030610`,`fwlogger_030710`,`fwlogger_030810`,`fwlogger_030910`,`fwlogger_031010`,`fwlogger_031110`,`fwlogger_031210`,`fwlogger_031310`,`fwlogger_031410`,`fwlogger_031510`,`fwlogger_031610`,`fwlogger_031710`,`fwlogger_031810`,`fwlogger_031910`,`fwlogger_032010`,`fwlogger_032110`,`fwlogger_032210`,`fwlogger_032310`,`fwlogger_032410`,`fwlogger_032510`,`fwlogger_032610`,`fwlogger_032710`,`fwlogger_032810`,`fwlogger_032910`,`fwlogger_033010`,`fwlogger_033110`,`fwlogger_040110`,`fwlogger_040210`,`fwlogger_040310`,`fwlogger_040410`,`fwlogger_040510`,`fwlogger_040610`,`fwlogger_040710`,`fwlogger_040810`,`fwlogger_040910`,`fwlogger_041010`,`fwlogger_041110`,`fwlogger_041210`,`fwlogger_041310`,`fwlogger_041410`,`fwlogger_041510`,`fwlogger_041610`,`fwlogger_041710`,`fwlogger_041810`,`fwlogger_041910`,`fwlogger_042010`) ; table status ============= mysql> show table status like 'fwlogger_mrg' ; +--------------+------------+---------+------------+------------+----------------+--------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +--------------+------------+---------+------------+------------+----------------+--------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------+ | fwlogger_mrg | MRG_MYISAM | 10 | Dynamic | 8746086512 | 3746 | 648140150772 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | +--------------+------------+---------+------------+------------+----------------+--------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------+ 1 row in set (0.08 sec) mysql>