… more about MySQL buffer pools or anything else that’s on your mind! There are numerous solutions for MySQL high availability. Many rely… server does not process query traffic except for replication. The buffer pool and adaptive hash index on the standby server will not… queries to playback. Read-only playback Using the –session-init-query command-line option, we set the option innodb_fake_changes to…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…. If you want a high-quality, generally available release, …buffer pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool…still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would…
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 4 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 19 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 10 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: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…: The InnoDB buffer pool is effectively a type of write-through cache. That is, when you change data on a given InnoDB page, the change is persisted immediately, but the page also resides in the buffer pool and it can… remains in the buffer pool. But the read/write split solution is intended for cases where the query load is too high for a…
Post: How long Innodb Shutdown may take
September 2, 2010 By 9 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 5 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…
