I have created a zenfs file system on nvme device,
following steps:“Installing and configuring Percona Server for MySQL with ZenFS support”.
how to use sysbench to test for percona mysql? thanks
Prep for the test, prep only needs to be run once.
sysbench /usr/share/sysbench/oltp_read_write.lua --mysql-db=YOURDB --threads=4 --mysql-host=YOURHOST --mysql-user=YOURUSER --mysql-password= --tables=10 --table-size=250000 prepare
Set the threads to equal you cores to start. Increase till you find right number.
sysbench --db-driver=mysql --report-interval=2 --threads=4 --time=300 --mysql-host=YOURHOST --mysql-user=YOURUSER --mysql-password= --mysql-db=$db /usr/share/sysbench/oltp_read_write.lua run
I don’t know how to create mysql-db on nvme device, because znefs is not general file system ,it is can’t mount partition. Is there any methods can to create mysql-db on device of zenfs file system to use sysbench?thanks.
Can you connect to mysql? If you can, can you issues a create database command?
Yes, I can connect to mysql and create db, this is commands show :
Perfect. Then use testdb1 in the examples I gave you above. --mysql-db=testdb1
Another tip would be to run sysbench from a machine where MySQL is not running. If that an option for you.
Make sure you configure sysbench to create MyRocks tables. (Check the --help) The default is to make InnoDB tables which CANNOT take advantage of the ZenFS. Only MyRocks tables can do this.
It can work on localhost(device:sda) by testdb1, If I would like sysbench running on nvme device how to do it ? (nvme is ZenFS drive which can’t mount partition)
check the storage command
#zenfs df --zbd=nvme0n1
Free: 29696 MB
Used: 0 MB
Reclaimable: 0 MB
Space amplification: 0%
I have no experience with the ZenFS.