Some InnoDB tests, at least those from innodb_fts suite, are 20-100+% slower when they are executed with XtraDB than with InnoDB plugin.
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Triaged
|
Medium
|
Unassigned | |||
5.7 |
Triaged
|
Medium
|
Unassigned |
Bug Description
Some InnoDB tests, at least those from innodb_fts suite, are 20-100+% slower when they are executed with XtraDB than with InnoDB plugin.
Absolute numbers can vary a lot between the machines, but the difference still holds; same for executing them normally vs --mem; same for debug vs non-debug builds.
Oracle MySQL 5.6.16
jan@jan-
Logging: ./mysql-test-run --repeat=10 --mem innodb_fts.fulltext
2014-03-27 12:40:10 6708 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
2014-03-27 12:40:10 6708 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)
2014-03-27 12:40:10 6708 [Note] Plugin 'FEDERATED' is disabled.
2014-03-27 12:40:10 6708 [Note] Binlog end
2014-03-27 12:40:10 6708 [Note] Shutting down plugin 'MyISAM'
2014-03-27 12:40:10 6708 [Note] Shutting down plugin 'CSV'
MySQL Version 5.6.16
Checking supported features...
- SSL connections supported
Collecting tests...
Removing old var directory...
Creating var directory '/home/
- symlinking 'var' to '/dev/shm/
Installing system database...
Using server port 51642
=======
TEST RESULT TIME (ms) or COMMENT
-------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
innodb_fts.fulltext [ pass ] 379
innodb_fts.fulltext [ pass ] 293
innodb_fts.fulltext [ pass ] 325
innodb_fts.fulltext [ pass ] 323
innodb_fts.fulltext [ pass ] 331
innodb_fts.fulltext [ pass ] 298
innodb_fts.fulltext [ pass ] 311
innodb_fts.fulltext [ pass ] 299
innodb_fts.fulltext [ pass ] 292
innodb_fts.fulltext [ pass ] 303
-------
The servers were restarted 0 times
Spent 3.154 of 11 seconds executing testcases
Completed: All 10 tests were successful.
====
Percona Server 5.6:
jan@jan-
Logging: ./mysql-test-run --repeat=10 --mem innodb_fts.fulltext
2014-03-27 13:23:08 1241 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
2014-03-27 13:23:08 1241 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)
2014-03-27 13:23:08 1241 [Note] Plugin 'FEDERATED' is disabled.
2014-03-27 13:23:08 1241 [Note] Binlog end
2014-03-27 13:23:08 1241 [Note] Shutting down plugin 'MyISAM'
2014-03-27 13:23:08 1241 [Note] Shutting down plugin 'CSV'
MySQL Version 5.6.16
Checking supported features...
- SSL connections supported
Collecting tests...
Removing old var directory...
Creating var directory '/home/
- symlinking 'var' to '/dev/shm/
Installing system database...
Using server port 39227
=======
TEST RESULT TIME (ms) or COMMENT
-------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
innodb_fts.fulltext [ pass ] 1776
innodb_fts.fulltext [ pass ] 1165
innodb_fts.fulltext [ pass ] 1078
innodb_fts.fulltext [ pass ] 2337
innodb_fts.fulltext [ pass ] 1295
innodb_fts.fulltext [ pass ] 1149
innodb_fts.fulltext [ pass ] 1165
innodb_fts.fulltext [ pass ] 1207
innodb_fts.fulltext [ pass ] 1088
innodb_fts.fulltext [ pass ] 1226
-------
The servers were restarted 0 times
Spent 13.486 of 20 seconds executing testcases
Completed: All 10 tests were successful.
description: | updated |
tags: | added: performance regression xtradb |
Changed in percona-server: | |
assignee: | Krunal Bauskar (krunal-bauskar) → nobody |
status: | In Progress → Triaged |
Relates to: https:/ /mariadb. atlassian. net/browse/ MDEV-5808