Displaying 1 result from an estimated 1 matches for "mysqldata3".
2009 Apr 15
3
MySQL On ZFS Performance(fsync) Problem?
..._at_trx_commit=2*
~4500 qps when sync_binlog=10 & innodb_flush_log_at_trx_commit=2
~13000 qps when sync_binlog=0 & innodb_flush_log_at_trx_commit=2
When sync_binlog=1 & innodb_flush_log_at_trx_commit=1, qps is too...
And i collect some stats data when qps < 1000:
[root at ssd /data/mysqldata3]#truss -c -p 13968
^C
syscall seconds calls errors
read .649 90816 30265
write .770 57157
open .000 4
close .000 4
time .368 83358
lseek .000...