… have to have innodb_flush_logs_at_trx_commit=1 so transactions are truly durable. You have to have log-bin enabled to… – because paying customers would normally have enough money to get BBU unit which is great for performance anyway. Of course you… Binary Logging This allows to get group commit back but obviously you loose point in time recovery and replication. Use innodb_flush_log…
Post: Maximal write througput in MySQL
February 28, 2010 By 10 Comments
… no binary logs trx_commit=1 : innodb_flush_log_at_trx_commit = 1 and no binary logs trx_commit=0 & binlog : innodb_flush_log_at_trx_commit = 0 and binary logs trx_commit=1 & binlog : innodb_flush_log_at_trx… tps as we switch to innodb_flush_log_at_trx_commit = 1. As we use RAID10 with BBU, I did not expect the…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… | MegaRAID SAS 8704EM2, PCIE interface, 8 ports Cache | 128MB Memory, BBU Present BBU | 100% Charged, Temperature 34C, isSOHGood= VirtualDev Size RAID Level… innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
… not realize is MySQL has to deal with multiple logs and perform multiple flushes if operating in maximum safety configuration, which is… not use MySQL replication instead. So assuming you have innodb_flush_log_at_trx_commit=1 and sync_binlog=1 you will… looking for less overhead for DRBD with fast storage (ie BBU) you should be looking at low latency network communications. It…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… good performance is to set innodb_flush_log_at_trx_commit=2, that is, to flush the log to the disk only once per… being broken. Most do not have RAID with BBU. With good RAID with BBU you can get 2000 fsync/sec or more…. Sergei Golubchik serialized the MySQL binlog write and the InnoDB log flush with a mutex in 5.1, to implement XA, and…
Comment: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… not get much benefit from BBU. The benefits from BBU comes in number of ways – your Innodb log writes will be faster (of course if you do not care much about transactions and running with innodb_flush_logs_at_trx_commit=0 it does not apply much) and it will make flushes from buffer pool…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… helps. The next problem to deal with is log flushes. If you have innodb_flush_log_at_trx_commit=0 or 2 or if… you have innodb_flush_log_at_trx_commit=1 log flushes can well be the problem – even with BBU thousands of log flushes per second may cause… all updates from the chunk in single transaction saving on log commits significantly. I mentioned you can use MyISAM or HEAP…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… cover different combination. My couple cents: you may use innodb_flush_log_at_trx_commit=2/sync_binlog=0 in single node… necessary that single host performs with innodb_flush_log_at_trx_commit=1. And RAID with BBU is must have for high performance setups, so it rules out problems with innodb_flush_log_at_trx_commit…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… 2950 with 8CPU cores and RAID10 on 6 disks with BBU, and 32GB RAM on board with CentOS 5.2 as…_concurrency = 16 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_file_size = 256M innodb_log_files_in_group = 3 innodb_max_dirty_pages_pct = 90 innodb_flush…
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
… (16 cores, 8 disks in RAID10, controller Perc/6i with BBU) to compare cfq, deadline, noop and anticipatory (last one just…_table=1 innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=128M innodb_thread_concurrency=0 innodb_flush_method…
