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

Enhancement request: add --dont-create flag to allow mysqlslap to reuse an auto-generated database

    XMLWordPrintable

Details

    Description

      The scenario I have in mind is to generate a big table once and then subsequently query it using distinct auto-generated workloads. While the no-drop option leaves the auto-generated mysqlslap database in the server, when one wants to subsequently auto-generate a query- only load, this is not possible since auto-generate-sql tries to create mysqlslap again. So, with a dont-create flag, the flow would be:

      mysqlslap -a --auto-generate-sql-write-number=10000000 --no-drop

      mysqlslap -a --dont-create --auto-generate-sql-load-type=read --concurrency=50 ...

      mysqlslap -a --dont-create --auto-generate-sql-load-type=update --concurrency=50 ...

      ...

      Attachments

        Activity

          People

            Unassigned Unassigned
            ivotron Ivo Jimenez
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.