…which can be very well taken care of RAID Battery Backed Up cache and when sequentially … innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB…can run to show any table / index fragmentation, without having to run the OPTIMIZE? HT: Since …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… sda | [deadline] 128 # RAID Controller ############################################ Controller…performance without …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_size = 64M innodb…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…IO Subsystem – directly attached storage with plenty of spindles and RAID with battery… 8 is decent start innodb_flush_method=O_DIRECT Avoid double buffering and …innodb performance tunings you will be better of when majority of Innodb users which take MySQL with defaults run it on hardware without…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
…than typical directly-attached server-grade RAID storage. Since they have a lot of tables, InnoDB uses over 3…buffer pool. But we have to do this without death-by-swapping, which would be extremely slow…My chosen strategy for this was to set innodb_flush_method=O_DIRECT. We could also tune the OS, but…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
… some nice benchmarks where InnoDB on SSD outperforms RAID 10, but …innodb_flush_method = O_DIRECT Actually most interesting one are innodb_flush_log_at_trx_commit=1 and innodb_flush_method = O_DIRECT (I tried also default innodb…another are for research 4. XFS without LVM is putting barrier option…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
…reading or writing a single InnoDB page RAID will only read or write… your current setup) using pvs -o +pe_start. Now let’s…sectors in a stripe element without a remainder. Let’s check …directly or add it as an LVM physical volume. This let’s you avoid any mistakes when working on partition table. RAID…
Comment: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… anyway. If you’re speaking about unbuffered IO to device (O_SYNC, O_DIRECT) they must not be lost after call returns. If… on the RAID without BBU) and this is exactly what should be avoided as loss in this case will corrupt Innodb database and… system cache is removed from equation because of use of O_DIRECT which bypasses OS cache for reads and writes. 256MB cache…
Post: Living with backups
November 6, 2008 By 28 Comments
… with the fastest drives or RAID configurations, the performance gains are…without one-liners) On Linux there is also a utility called ionice. It allows to affect how I/O…the system cache. By specifying O_DIRECT flag when opening a file,…€™s always the case for InnoDB tablespaces, other MySQL data …
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… servers are compiled without the PERFORMANCE_…128M Rationale: Since O_DIRECT is not used… 4 disk 7200RPM RAID 10 array with…INNODB_BUFFER_POOL_READS | 191571 | | INNODB_DATA_PENDING_READS | 0 | | INNODB_DATA_READ | 3140882432 | | INNODB_DATA_READS | 191581 | | INNODB_PAGES_READ | 191570 | | INNODB…
Comment: Linux schedulers in tpcc like benchmark
January 31, 2009 By 19 Comments
… enough, RAID 10 + BBU is probably the most common and …using O_DIRECT to move data from sequentially written log files to the more write-costly spreaded/random innodb data …without interruptions. Having a nicely interactive ajax interface stuck because some bulk thing does fill the BBU cache, the I/O…
