Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13669

Some MyRocks test take a long time (in debug?) (on windows?)

    XMLWordPrintable

    Details

      Description

      This is based on the observations of Elena Stepanova and Vladislav Vaintroub. It is not immediately clear if there is some issue, or tests are really that big, etc.

      I picked a few MyRocks and non-MyRocks tests and collected a sample:

      http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/9993/steps/test_2/logs/stdio

      innodb.innodb_bug30423        1393
      innodb.innodb_bug12902967     2717
      main.alter_table              1394
      main.count_distinct2          1120
      main.mysql_client_test_comp  33391
      

                                  
      rocksdb.cardinality          25322
      rocksdb.drop_table2          80187
      rocksdb.drop_table3           9401 
      rocksdb.singledelete         12128
      

      https://buildbot.askmonty.org/buildbot/builders/winx64-debug/builds/5035/steps/test/logs/stdio

      innodb.innodb_bug30423        56543
      innodb.innodb_bug12902967      6405
      main.alter_table              36630
      main.count_distinct2          15793
      main.mysql_client_test_comp   56441
      rocksdb.cardinality           558667
      rocksdb.drop_table2           346562
      rocksdb.drop_table3           186081
      rocksdb.singledelete          117123
      

      http://buildbot.askmonty.org/buildbot/builders/winx64-packages/builds/4631/steps/test/logs/stdio

      innodb.innodb_bug30423       1883
      innodb.innodb_bug12902967     2822
      main.alter_table               4256
      main.count_distinct2           1441
      main.mysql_client_test_comp   37063
      rocksdb.cardinality           56590
      rocksdb.drop_table2           92738
      rocksdb.drop_table3           32669
      rocksdb.singledelete          26345
      

      http://buildbot.askmonty.org/buildbot/builders/p8-rhel71-bintar-debug/builds/2147/steps/test/logs/stdio

      innodb.innodb_bug30423        34027
      innodb.innodb_bug12902967      4174
      main.alter_table              16342
      main.count_distinct2           4832
      main.mysql_client_test_comp   40623
      rocksdb.cardinality           193451
      rocksdb.drop_table2           131493
      rocksdb.drop_table3           46349
      rocksdb.singledelete          65065
      

        Attachments

        1. chart.png
          chart.png
          132 kB
        2. mdev13669-test-times.ods
          30 kB
        3. Relative slowdown.png
          Relative slowdown.png
          145 kB
        4. testing-time-bintar-trusty.png
          testing-time-bintar-trusty.png
          30 kB
        5. test-time-fulltest.png
          test-time-fulltest.png
          31 kB
        6. test time on winx64-debug.png
          test time on winx64-debug.png
          30 kB

          Activity

            People

            Assignee:
            psergey Sergei Petrunia
            Reporter:
            psergey Sergei Petrunia
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: