… (fsync) log: 0; buffer pool: 0 17909940 OS file reads, 22088963 OS file writes, 1743764 OS fsyncs 0.20 reads/s, 16384 avg bytes/read, 5… to separate tablespace related IO from log related IO so you can see how much IO your log file requires. Note depending on your innodb_flush_log…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…to very significant ones. Also do not forget you may need to increase size of your Innodb log files to be able to…to Reads because Flash requires “erase” cycle to…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… also elect to use in some cases): vmstat 5 5 iostat -dx 5 5 If you don’t know how to read these, there… to miss, as is the absence of innodb_log_file_size. I won’t give you a full rundown over every option in the file…, so it’s hard to read. If the InnoDB buffer pool is set to 22GB, it’s much easier to see 22GB than 23622320128, especially…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…log file size workload and even when crash happen (how many unflushed changes we had) Repeating test with innodb_open_files…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… purge thread will have to clean these up. This is how you make InnoDB behave like PostgreSQL 
If the undo log space grows really…). But how to do this without splitting the file? The answer lies in the Unix fifo. I created a script that reads lines out… script on the vmstat and mysqladmin log files to grab out the disk activity and rows-per-second to see what the progress was…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…wrote about testing writing to many files and seeing how this affects sequential read performance. I was very interested to see how it shows itself with…) and set innodb_buffer_pool_size=8G innodb_flush_logs_at_trx_commit=2 innodb_log_file_size=256M innodb_flush_method=O_DIRECT for Innodb. The tables…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
…InnoDB tries to read data from disk, but there are no free pages. In this case, InnoDB has to flush some data to be able to…innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size are important for tuning. Also, upgrading to…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
…Innodb log checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB STATUS\G — LOG — Log sequence number 9682004056 Log flushed up to…reads and writes to the transaction log if you set this too high. innodb_write_io_threads: Controls how… parallel writing to the same file by more than…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=512M innodb_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read… InnoDB, but nothing special to be proud of. We definitely we will look how to fix it as next step, read …
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM. The second goal of …size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread-concurrency=8 –max-connections=1500 –table-cache=512 –net_read_timeout=30…
