Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
10.0.9
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.
Few examples:
On a RelWithDebInfo build, fulltext test, with --mem:
innodb_fts.fulltext 'xtradb' [ pass ] 2154
|
innodb_fts.fulltext 'xtradb' [ pass ] 2417
|
innodb_fts.fulltext 'xtradb' [ pass ] 2264
|
innodb_fts.fulltext 'xtradb' [ pass ] 3487
|
innodb_fts.fulltext 'xtradb' [ pass ] 2864
|
innodb_fts.fulltext 'xtradb' [ pass ] 1880
|
innodb_fts.fulltext 'xtradb' [ pass ] 2806
|
innodb_fts.fulltext 'xtradb' [ pass ] 3358
|
innodb_fts.fulltext 'xtradb' [ pass ] 2536
|
innodb_fts.fulltext 'xtradb' [ pass ] 2458
|
--------------------------------------------------------------------------
|
The servers were restarted 0 times
|
Spent 26.224 of 32 seconds executing testcases
|
innodb_fts.fulltext 'innodb_plugin' [ pass ] 453
|
innodb_fts.fulltext 'innodb_plugin' [ pass ] 459
|
innodb_fts.fulltext 'innodb_plugin' [ pass ] 470
|
innodb_fts.fulltext 'innodb_plugin' [ pass ] 453
|
innodb_fts.fulltext 'innodb_plugin' [ pass ] 497
|
innodb_fts.fulltext 'innodb_plugin' [ pass ] 444
|
innodb_fts.fulltext 'innodb_plugin' [ pass ] 384
|
innodb_fts.fulltext 'innodb_plugin' [ pass ] 259
|
innodb_fts.fulltext 'innodb_plugin' [ pass ] 263
|
innodb_fts.fulltext 'innodb_plugin' [ pass ] 440
|
--------------------------------------------------------------------------
|
The servers were restarted 0 times
|
Spent 4.122 of 10 seconds executing testcases
|
On a Debug build, innodb_fts_stopword_charset test, with --mem:
innodb_fts.innodb_fts_stopword_charset 'xtradb' [ pass ] 10652
|
innodb_fts.innodb_fts_stopword_charset 'xtradb' [ pass ] 11193
|
innodb_fts.innodb_fts_stopword_charset 'xtradb' [ pass ] 11409
|
innodb_fts.innodb_fts_stopword_charset 'xtradb' [ pass ] 11774
|
innodb_fts.innodb_fts_stopword_charset 'xtradb' [ pass ] 10810
|
innodb_fts.innodb_fts_stopword_charset 'xtradb' [ pass ] 10562
|
innodb_fts.innodb_fts_stopword_charset 'xtradb' [ pass ] 10616
|
innodb_fts.innodb_fts_stopword_charset 'xtradb' [ pass ] 10682
|
innodb_fts.innodb_fts_stopword_charset 'xtradb' [ pass ] 10424
|
innodb_fts.innodb_fts_stopword_charset 'xtradb' [ pass ] 10399
|
--------------------------------------------------------------------------
|
The servers were restarted 0 times
|
Spent 108.521 of 117 seconds executing testcases
|
innodb_fts.innodb_fts_stopword_charset 'innodb_plugin' [ pass ] 7189
|
innodb_fts.innodb_fts_stopword_charset 'innodb_plugin' [ pass ] 7306
|
innodb_fts.innodb_fts_stopword_charset 'innodb_plugin' [ pass ] 7225
|
innodb_fts.innodb_fts_stopword_charset 'innodb_plugin' [ pass ] 7403
|
innodb_fts.innodb_fts_stopword_charset 'innodb_plugin' [ pass ] 7195
|
innodb_fts.innodb_fts_stopword_charset 'innodb_plugin' [ pass ] 7221
|
innodb_fts.innodb_fts_stopword_charset 'innodb_plugin' [ pass ] 7318
|
innodb_fts.innodb_fts_stopword_charset 'innodb_plugin' [ pass ] 7684
|
innodb_fts.innodb_fts_stopword_charset 'innodb_plugin' [ pass ] 7311
|
innodb_fts.innodb_fts_stopword_charset 'innodb_plugin' [ pass ] 7055
|
--------------------------------------------------------------------------
|
The servers were restarted 0 times
|
Spent 72.907 of 81 seconds executing testcases
|
I find it an ominous sign, worth looking into.