search for: innodb_flush_log_at_trx_commit

...QL''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_at_trx_commit=0 ~15000 qps when sync_bin...

...| | binlog_optimize_thread_scheduling | ON | | binlog_stmt_cache_size | 32768 | | expire_logs_days | 0 | | general_log | OFF | | general_log_file | pdone-prod.log | | innodb_flush_log_at_trx_commit | 1 | | innodb_locks_unsafe_for_binlog | OFF | | innodb_log_block_size | 512 | | innodb_log_buffer_size | 8388608 | | innodb_log_file_size | 5242880 | | innodb_log_files_in_group |...

Hi. I started mysqld.exe using Wine and it seems to work. But when I try to connect the server seems to answer somehow (connection is established, telnet works) but it seems that no communication takes place. mysql freezes and in telnet no response is shown. Any idea what this could mean? Running in Windows without an installer works so it has to be some problem with wine somehow. Using Ubuntu

Hi, I''m running multiple vservers and have some aspects managed via puppet. I noticed that puppetd consumes from 20 to 60 mb RAM and the longer the process runs, the more RAM it takes. It looks like 60MB is the top what I measured. Having a couple of vservers (11 in my case) this can already take up to 500MB just for puppet! I''m wondering if there''s any downside in