sysbench crutial 64GB SSD

MySQL & MariaDB Other MySQL® Questions
1

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

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.