Can I use mysqlslap on an existing database?

Can I use mysqlslap to test specific databases/tables? Or just the mysqlsla开发者_C百科p database?

Thanks

To test a specific database

mysqlslap --create-schema=yourdatabase --user=myuser -p

The option's name "create-schema" is misleading, it won't modify your existing schema unless your queries insert data or do modifications (I'm not 100% sure about this)

Yes, you can use it to test any databases