Re: MySQL 5.6 update doubled IOs

[Christian Meisinger]

+-------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
| 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 |
+-------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
| ip2location | MyISAM | 10 | Dynamic | 8498157 | 109 | 929375092 | 281474976710655 | 121502720 | 0 | NULL | 2013-03-28 08:25:20 | 2013-03-28 08:26:01 | 2013-03-28 09:11:50 | latin1_swedish_ci | NULL | | |
+-------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+



CREATE TABLE `ip2location` (
`ip_begin` int(10) unsigned NOT NULL,
`ip_end` int(10) unsigned NOT NULL,
`country_code` char(2) NOT NULL,
`country_name` varchar(64) NOT NULL,
`region` varchar(128) NOT NULL,
`city` varchar(128) NOT NULL,
`latitude` double NOT NULL,
`longitude` double NOT NULL,
`zip_code` varchar(8) NOT NULL,
`time_zone` varchar(8) NOT NULL,
`isp` varchar(128) NOT NULL,
`domain` varchar(128) NOT NULL,
`netspeed` varchar(8) NOT NULL,
KEY `ipeb` (`ip_end`,`ip_begin`)
) ENGINE=MyISAM;