…innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… the amount of system memory. We just deployed a new Linux/Mysql server for a client, upgrading their main database (from… server is: set innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB‘s buffer pool… large Innodb table (150GB) that is showing poor performance for full table scans. using O_DIRECT, we are seeing individual 16KB paged I/O…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… – run 64bit operating system. We still see people running 32bit Linux on 64bit capable boxes with plenty of memory. Do not… unless you’re piping large blobs to Innodb in this case increase it a bit. innodb_flush_log_at_trx_commit=2 If… your application and default which is 8 is decent start innodb_flush_method=O_DIRECT Avoid double buffering and reduce swap pressure, in most cases…
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
… innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=128M innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_write_io_threads=4 innodb_read_io_threads=4 innodb_io_capacity=800 innodb_adaptive…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…. You do not want OS to cache what Innodb is caching already. Innodb cache is more efficient compared to OS cache because… other things and if you will not make Innodb to bypass OS buffering Innodb TableSpace IO will wipe out cache because it… do not need to do anything. On Linux, FreeBSD, Solaris you need to set innodb_flush_method=O_DIRECT. On other Operating Systems you may be…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… = 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_method=O_DIRECT innodb_file_per_table = 1 And for XtraDB I additionally used: innodb_io_capacity = 10000 innodb_adaptive_checkpoint = 1 innodb_write_io_threads = 16 innodb… just giant one. And it is important to remember as Linux kernels 2.6.18+ (which are used on CentOS / RedHat…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
I prefer to run MySQL with innodb_flush_method=O_DIRECT in most cases – it makes sure there is no overhead ….05 System | Supermicro; PDSMi; v0123456789 (Other) Service Tag | 0123456789 Platform | Linux Release | Ubuntu 12.04.1 LTS (precise) Kernel | 3.2…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
… storage. main common settings innodb_buffer_pool_size = 2048M innodb_thread_concurrency = 0 innodb_max_dirty_pages_pct = 70 innodb_flush_method = O_DIRECT The next graphs show… IO threads on Unix/Linux and makes the threads to be used equally for parallel using. By default InnoDB uses 1 insert…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…irrelevant information): # Aspersa System Summary Report ############################## Platform | Linux Release | Ubuntu 10.04.2 LTS (lucid) …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…
Comment: 5.0.83-build17 Percona binaries
August 6, 2009 By 19 Comments
… raid. Raid cards these days are rarely as good as linux in maximising throughput, even the PCI-E x8 variants. We…=/var/lib/mysqlnonssd/ innodb_log_arch_dir=/var/lib/mysqlnonssd/ 8) Make sure you bypass the OS caches innodb_flush_method=O_DIRECT 9) We get the best results with filepertable. Especially if you find your tables fragment a lot. innodb_file…
