Discussion on:

Message 6 of 6
0 Votes
+ -
WRT the --create-schema option:
i want to run this: /usr/bin/mysqlslap -u traffic2 -p traffic2 query="select * from rc_profile_table;" -vv --concurrency=100 --iterations=5
if i add the --create-schema option what will this do? because i get an error:
/usr/bin/mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'

when i run: /usr/bin/mysqlslap -u traffic2 -p traffic2 --auto-generate-sql -vv --concurrency=100 --number-of-queries=1000 --number-char-cols=4 --number-int-cols=7 >> ~/Documents/DBLoadTest.log

i have no problems but i want to run this test on one of my actual tables please?
thank you
Posted by helloise
31st Oct