Announcement

Announcement Module
Collapse
No announcement yet.

sysbench crutial 64GB SSD

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • sysbench crutial 64GB SSD

    I just built a new buget system which is doing 4870 transactions/second with innodb sysbench.

    Motherboard MSI 870A-G54
    Processor AMD Phenom II X6 1055T @ 3.5GHZ
    Memory Patriot Sector 5 4GB DDR3-1600
    SSD Crutial 64GB C300

    OS Ubuntu 10.10
    Percona 5.1.52-rel11.6


    OLTP test statistics:
    queries performed:
    read: 1400028
    write: 0
    other: 200004
    total: 1600032
    transactions: 100002 (4870.13 per sec.)
    deadlocks: 0 (0.00 per sec.)
    read/write requests: 1400028 (68181.85 per sec.)
    other operations: 200004 (9740.26 per sec.)

    Test execution summary:
    total time: 20.5337s
    total number of events: 100002
    total time taken by event execution: 327.9838
    per-request statistics:
    min: 1.08ms
    avg: 3.28ms
    max: 20.94ms
    approx. 95 percentile: 7.88ms

    Threads fairness:
    events (avg/stddev): 6250.1250/76.81
    execution time (avg/stddev): 20.4990/0.00


    my.cnf customizations:
    innodb_buffer_pool_size = 2G
    innodb_log_file_size = 256M
    innodb_log_buffer_size=4M
    innodb_flush_log_at_trx_commit=2
    innodb_thread_concurrency=8
    innodb_flush_method=O_DIRECT
    innodb_file_per_table

    innodb_additional_mem_pool_size=20M


    Seems good for a system under $500. Is there room for improvement?

  • #2
    thgood wrote on Thu, 02 December 2010 16:37
    Seems good for a system under $500. Is there room for improvement?
    You tell us, you have done the most important configurations and your performance sounds very good.

    Question is how much more time you have that you can spend on this and if it's worth it at this moment.

    Comment

    Working...
    X