Skip to content

A convenient auto tool for database performance testing, integrate sysbench and tpcc-mysql

License

Notifications You must be signed in to change notification settings

mizhon/auto-db-tools

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

59 Commits
 
 
 
 
 
 
 
 

Repository files navigation

AutoDBTools

A convenient auto tool for database performance testing, integrate sysbench and tpcc-mysql. The tool can run database performance tools according to related config files, avoid to input a lot of parameters manually.

A sample sysbench command

sysbench --test=/usr/share/sysbench/tests/db/oltp.lua 
         --oltp-table-size=[table_size] 
         --oltp-tables-count=[table_counts] 
         --num-threads=[thread_numbers]
         --mysql-db=[database_name] 
         --mysql-host=[database_host_name] 
         --mysql-user=[user_name] 
         --mysql-password=[password] 
         --mysql-port=3306
         --db-driver=mysql
prepare

A sample tpcc-mysql command

./tpcc_start -h[database_host_name]
	     -d[database_name]
	     -u[user_name]
             -p[password]
	     -w[warehouse_numbers]
	     -c[threads_numbers]
	     -r[rampup_time]
	     -l[execution_time]

About

A convenient auto tool for database performance testing, integrate sysbench and tpcc-mysql

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages