Re: Mysql 5.5 and 5.6 slower than 5.0 and 5.1 on selected query
Ok, what i have done
1) add primary key on main database (5.1)
2) Drop test database (5.6)
3) Make SQL dump from main database and import to test one
Time for SQL query:
create temporary table norepl_t1 engine=myisam select amount, price, money, id_product from scj_tt_ships where scj_ships_id between 200000 and 400000;
5.1 = 15.19 sec
5.6 = 22.83 sec
CREATE TABLE `scj_tt_ships` (
`scj_ships_id` int(11) NOT NULL,
`id_product` smallint(5) unsigned NOT NULL,
`amount` decimal(12,6) NOT NULL DEFAULT '0.000000',
`price` decimal(12,6) NOT NULL DEFAULT '0.000000',
`id_client_tt` int(11) NOT NULL,
`id_ta` mediumint(8) unsigned NOT NULL DEFAULT '0',
`money` decimal(16,6) NOT NULL DEFAULT '0.000000',
`p_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`p_id`),
KEY `scj_ships_id` (`scj_ships_id`),
KEY `id_client_tt` (`id_client_tt`),
KEY `id_product` (`id_product`)
) ENGINE=InnoDB