…InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… are some specific techniques to use. Do push concurrency too high Many developers will test script with multiple level of concurrency…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…Innodb_buffer_pool_read_ahead 0 20920 23669 20920 23734 Innodb_buffer_pool_read_requests 1361851 1264739 1235472 1263290 1235781 Innodb_buffer_pool_reads 120548 102948 76882 102672 76832 Innodb_data_read…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…Innodb_buffer_pool_read_ahead 1152 23231 130919 23228 130731 131497 Innodb_buffer_pool_read_requests 12947073 10228611 7816154 10251697 9319281 9393396 Innodb_buffer_pool_reads 327963 332092 12889 335080 14067 13384 Innodb… by the high numbers of Innodb_buffer_pool_read_ahead when the buffers are …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…it wrong. Q10: When Innodb decides to schedule sequential read-ahead, random read ahead ? HT: InnoDB schedules a sequential read-ahead when it notices an…: INNODB uses it’s own internal buffer pool but it’s in conflict with the Linux kernel’s buffer pool. In high load situations where INNODB is…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
… those updated (dirty) buffer pool pages are flushed down the to the tablespace. If Innodb stops (read: crashes) with dirty buffer pool pages, Innodb recovery must be… also can quickly starve data reads and writes to the transaction log if you set this too high. innodb_write_io_threads: Controls…
Post: How long Innodb Shutdown may take
September 2, 2010 By 8 Comments
…innodb_log_buffer_size and can be anywhere from 10 to 90% in the real life workloads. Innodb_buffer_pool…buffer pool per hard drive. Baron has written a nice post how to decrease innodb shutdown time which you may want to read…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
…Buffer pool fixes Improvements of buffer_pool scalability. documentation innodb_buffer_pool_pages Information about content of buffer_pool…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
…innodb_buffer_pool_size=24G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer…innodb_thread_concurrency=16 innodb_flush_method = O_DIRECT innodb_write_io_threads=8 innodb_read_io_threads=8 innodb_io_capacity=500 innodb…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… only contain any entries if you’re running in high concurrency envinronment, so Innodb has to fall back to OS waits frequently… buffer pool also stores lock information, adaptive hash indexes and some other system structures. Pending reads and writes are pending requests on buffer pool level. Innodb…
