rendered paste body+----+-------------+-----------+------+-----------------+---------+---------+-------+------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------+------+-----------------+---------+---------+-------+------+----------------------------------------------+
| 1 | SIMPLE | data | ref | uidtime,idx_uid | idx_uid | 4 | const | 1 | Using where; Using temporary; Using filesort |
+----+-------------+-----------+------+-----------------+---------+---------+-------+------+----------------------------------------------+
CREATE TABLE `data` (
`id` int(255) unsigned NOT NULL auto_increment,
`uid` int(255) unsigned NOT NULL default '0',
`ip` varchar(16) NOT NULL default '',
`DAY` int(2) unsigned NOT NULL default '0',
`MONTH` int(2) unsigned NOT NULL default '0',
`year` int(4) unsigned NOT NULL default '0',
`bytes` bigint(255) unsigned NOT NULL default '0',
`bytes_local` bigint(20) unsigned NOT NULL default '0',
`timestamp` int(255) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `uidtime` (`uid`,`timestamp`),
KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=300000000 |