… 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb_read…idea File IO benchmark results Sequential read results are expectedly the least interesting. Read-ahead kicked in immediately giving ~9’600…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… are in big units, so it’s hard to read. If the InnoDB buffer pool is set to 22GB, it’s much easier to… might find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA… some number of hours, such as 3 hours. Knowing this ahead of time gives us a framework within which we have…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…innodb_additional_mem_pool_size 2097152 innodb_autoextend_increment 8 innodb_autoinc_lock_mode 1 innodb_buffer_pool_size 55050240000 innodb_change_buffering inserts innodb_checksums ON innodb_commit_concurrency 0 innodb…
Comment: Is there room for more MySQL IO Optimization?
January 9, 2013 By 11 Comments
…/innodb-performance.html ” Random read-ahead is a technique that predicts when pages might be needed soon based on pages already in the buffer pool… which those pages were read. If 13 consecutive pages from the same extent are found in the buffer pool, InnoDB asynchronously issues a request…
