MySQL Forums
Forum List  »  General

Re: Mysql 5.5 and 5.6 slower than 5.0 and 5.1 on selected query
Posted by: Alex Voytsekh
Date: May 12, 2013 01:49AM

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

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.