IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    MySQL使用AWS SSD效能測試

    阿維发表于 2014-04-23 14:12:00
    love 0

    AWS某些instance有提供SSD,下面是使用m3.medium,並且將MySQL安裝在SSD上面的測試數據

    [root@ip-172-31-17-67 ssd]# time sysbench --test=oltp --mysql-table-engine=innodb --mysql-user=$dbUser --mysql-password=$dbPassword --db-driver=mysql --mysql-db=test --oltp-table-size=1000000 --oltp-table-name=t1 --oltp-nontrx-mode=insert --mysql-socket=/mnt/ssd/mysql/mysql.sock run
    sysbench 0.4.12: multi-threaded system evaluation benchmark
    
    Running the test with following options:
    Number of threads: 1
    
    Doing OLTP test.
    Running mixed OLTP test
    Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
    Using "BEGIN" for starting transactions
    Using auto_inc on the id column
    Maximum number of requests for OLTP test is limited to 10000
    Threads started!
    Done.
    
    OLTP test statistics:
    queries performed:
    read: 140000
    write: 50000
    other: 20000
    total: 210000
    transactions: 10000 (169.49 per sec.)
    deadlocks: 0 (0.00 per sec.)
    read/write requests: 190000 (3220.29 per sec.)
    other operations: 20000 (338.98 per sec.)
    
    Test execution summary:
    total time: 59.0009s
    total number of events: 10000
    total time taken by event execution: 58.8980
    per-request statistics:
    min: 2.65ms
    avg: 5.89ms
    max: 111.90ms
    approx. 95 percentile: 15.02ms
    
    Threads fairness:
    events (avg/stddev): 10000.0000/0.00
    execution time (avg/stddev): 58.8980/0.00
    
    real 0m59.107s
    user 0m4.027s
    sys 0m9.246s
    Twitter
    Google+


沪ICP备19023445号-2号
友情链接