sysbench test oracleITeye - 超凡娱乐

sysbench test oracleITeye

2019年03月26日09时24分35秒 | 作者: 怀寒 | 标签: 测验,数据,生成 | 浏览: 1863

comp203 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = comp203)(PORT = 1527))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = CS)) 
    )
  ) 测验
生成数据
./sysbench test=oltp oltp-table-name=sysbench oltp-table-size=100000 oracle-db=comp203 oracle-user=dba_yangjian oracle-password=dba_yangjian db-driver=oracle  prepare

测验数据
./sysbench test=oltp oltp-table-name=sysbench oltp-table-size=100000 oracle-db=comp203 oracle-user=dba_yangjian oracle-password=dba_yangjian max-time=60 oltp-read-only=on max-requests=0 num-threads=2 db-driver=oracle run

./sysbench test=oltp oltp-table-name=sysbench oltp-table-size=100000 oltp-non-index-updates=50 oracle-db=comp203 oracle-user=dba_yangjian oracle-password=dba_yangjian max-time=60 oltp-read-only=on max-requests=0 num-threads=2 db-driver=oracle run

./sysbench test=oltp oltp-table-name=sysbench oltp-table-size=100000 oltp-index-updates=50 oracle-db=comp203 oracle-user=dba_yangjian oracle-password=dba_yangjian max-time=60 oltp-read-only=on max-requests=0 num-threads=2 db-driver=oracle run
版权声明
本文来源于网络,版权归原作者所有,其内容与观点不代表超凡娱乐立场。转载文章仅为传播更有价值的信息,如采编人员采编有误或者版权原因,请与我们联系,我们核实后立即修改或删除。

猜您喜欢的文章