[MDEV-9776] Enhancement request: add --dont-create flag to allow mysqlslap to reuse an auto-generated database Created: 2016-03-22 Updated: 2017-05-29 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Scripts & Clients, Tests |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | Ivo Jimenez | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| 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 ... ... |