Displaying 2 results from an estimated 2 matches for "sync_binlog".
2009 Apr 15
3
MySQL On ZFS Performance(fsync) Problem?
...some test about MySQL''s Insert performance on ZFS, and met a big
performance problem,*i''m not sure what''s the point*.
Environment
2 Intel X5560 (8 core), 12GB RAM, 7 slc SSD(Intel).
A Java client run 8 threads concurrency insert into one Innodb table:
*~600 qps when sync_binlog=1 & innodb_flush_log_at_trx_commit=1
~600 qps when sync_binlog=10 & innodb_flush_log_at_trx_commit=1
~600 qps when sync_binlog=0 & innodb_flush_log_at_trx_commit=1
~900 qps when sync_binlog=1 & innodb_flush_log_at_trx_commit=0*
~5500 qps when sync_binlog=10 & innodb_flush_log_a...
2015 Nov 30
2
SOT: MariaDB 5.5.x-MariaDB logs are not going to desired .log file
...|
| relay_log_space_limit | 0
|
| slow_query_log | OFF
|
| slow_query_log_file | pdone-prod-slow.log
|
| sql_log_bin | ON
|
| sql_log_off | OFF
|
| sync_binlog | 0
|
| sync_relay_log | 0
|
| sync_relay_log_info | 0
|
+-------------------------------------------+----------------------------------------------------------------------------------------------------------...