sysbench 安装及生成模拟数据

hitxueliang 2020-01-07

wget --content-disposition https://packagecloud.io/akopytov/sysbench/packages/el/6/sysbench-1.0.19-1.el6.x86_64.rpm/download.rpm

rpm -ivh sysbench-1.0.19-1.el6.x86_64.rpm

生成5张表,每张表100万行

sysbench oltp_common  --tables=5 --table-size=1000000 --db-driver=mysql  --mysql-db=yzxd --mysql-user=root --mysql-password=ocm123 --mysql-socket=/tmp/mysql.sock  prepare

相关推荐