请教这个测试结果是否可以再优化

Question

innodb_flush_log_at_trx_commit          = 2这个改成0

Answer 1

OLTP test statistics:
    queries performed:
        read:                            1400014
        write:                           500004
        other:                           0
        total:                           1900018
    transactions:                        100000 (1943.80 per sec.)
    deadlocks:                           1      (0.02 per sec.)
    read/write requests:                 1900018 (36932.46 per sec.)
    other operations:                    0      (0.00 per sec.)Test execution summary:
    total time:                          51.4457s
    total number of events:              100000
    total time taken by event execution: 1028.2740
    per-request statistics:
         min:                                  1.65ms
         avg:                                 10.28ms
         max:                                 91.65ms
         approx.  95 percentile:              25.49msThreads fairness:
    events (avg/stddev):           5000.0000/47.65
    execution time (avg/stddev):   51.4137/0.01倒是有点效果   但是也不是很大  会不会是机器台烂了