Bug #70063 | create table is slower in 5.6 | ||
---|---|---|---|
Submitted: | 16 Aug 2013 19:47 | Modified: | 17 Jan 2014 18:52 |
Reporter: | Arnaud Adant | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DDL | Severity: | S5 (Performance) |
Version: | OS: | Any | |
Assigned to: | CPU Architecture: | Any |
[16 Aug 2013 19:47]
Arnaud Adant
[16 Aug 2013 19:50]
Arnaud Adant
Oups set global innodb_stats_persistent = 1; to start with !
[16 Aug 2013 20:47]
MySQL Verification Team
related: Bug 17193801 - DICT_TABLE_SCHEMA_CHECK CALLS DTYPE_SQL_NAME NEEDLESSLY - WASTING A LOT OF CPU
[17 Jan 2014 18:52]
Daniel Price
Fixed as of 5.6.17, 5.7.4, and here's the changelog entry: When creating a table there are a minimum of three separate inserts on the "mysql.innodb_index_stats" table. To improve "CREATE TABLE" performance, there is now a single "COMMIT" operation instead of one for each insert. Thank you for the bug report.
[25 Feb 2014 19:54]
Sveta Smirnova
Bug #35918 was marked as duplicate of this one.
[28 Mar 2014 19:11]
Laurynas Biveinis
5.6$ bzr log -r 5758 -n0 ------------------------------------------------------------ revno: 5758 committer: Thirunarayanan B<thirunarayanan.balathandayuth@oracle.com> branch nick: test-5.6 timestamp: Fri 2014-01-17 10:00:21 +0530 message: Bug #17323202 CREATE TABLE IS SLOWER IN 5.6 Analysis: ======== While creating a table, there will be minimum of 3 inserts in innodb_index_stats table. Instead of committing for each insert separately , we can commit for a innodb_index_stats table as a whole. This will make creation of table faster. Approved by Jimmy [rb#4220]
[28 Mar 2014 19:12]
Laurynas Biveinis
5.6$ bzr log -r 5760 -n0 ------------------------------------------------------------ revno: 5760 committer: Vasil Dimov <vasil.dimov@oracle.com> branch nick: mysql-5.6 timestamp: Fri 2014-01-17 20:58:35 +0200 message: Followup to thirunarayanan.balathandayuth@oracle.com-20140117043021-02qex25bae6ac1ew : add a comment explaining why we sort by index name when saving stats.