… on MySQL 5.6 config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on’ optimizer_switch=’mrr_cost_based=off’ optimizer_switch=’…are the join optimizations when the workload fits entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool …
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… the MySQL config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on’ optimizer_switch=’mrr_sort_keys=on’ (only on MariaDB 5.5) optimizer… when the workload fits entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one… post is aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…are key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, …_size is rather maximum amount of memory MySQL will allocate for this operation. Note…optimization needs memory. This is usually small to be ignored but certain queries can have very large memory…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… other problems. The pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as contention that crosses… server is allocating too much memory. A runaway server process, or poorly optimized queries, can consume too much memory and cause the server…
Post: Time for Zero Administration effort at MySQL ?
January 8, 2012 By 4 Comments
…Optimizing MySQL Configuration talk for Percona Live in Washington,DC I noticed how many Variables did MySQL get…options (like much of Performance Schema configuration). Innodb settings alone push 100. True you do… about other components in MySQL which makes it hard to manage memory, a lot of resource…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…to about 6 tables, what version of Innodb/MySQL would you recommend? I’ve been …innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB… fragmentation, without having to run the OPTIMIZE? HT: Since OPTIMIZE rebuilds the whole table, it …
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well for wide range of applications, though the optimal… not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer_pool_size 70-80% of memory is a safe…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_change_bufferingblogpercona.commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb…memory…
Post: How InnoDB handles REDO logging
February 3, 2011 By 18 Comments
…InnoDB tries to keep the working set in memory (InnoDB Buffer Pool), therefore the changes made by transactions will occur in volatile memory…MySQL configuration and hardware will affect the speed at which InnoDB can log. You can request that InnoDB…apply algorithms to optimize those writes during …
