…highest memory available, and memory is what really really matters. High-Memory Quadruple Extra Large Instance 68.4 GB of memory … 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: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… (0.00 sec) Innodb Memory Usage Finally it is often helpful to check how much memory Innodb has allocated. In …SHOW ENGINE INNODB STATUS and look for memory information block, which can use like this: ———————- BUFFER POOL AND MEMORY ———————- Total memory allocated …
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool was… are values for Innodb_buffer_pool_reads and Innodb_data_read. We can see that with appropriately sized buffers less no. of Innodb_buffer_pool_reads…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool was… 136163 136435 Innodb_buffer_pool_read_ahead 0 20920 23669 20920 23734 Innodb_buffer_pool_read_requests 1361851 1264739 1235472 1263290 1235781 Innodb_buffer_pool_reads…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Comment: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 23, 2012 By 10 Comments
… it would be to use the same random dives trick Innodb uses – You can do 100 partial random dives in the… in the buffer pool and so you stop just short of reading it. This would get you approximate in memory fit for… cases as frequently you would have only some portion in memory, but it is the portion which is queried the most…
Post: InnoDB memory usage
May 30, 2006 By 6 Comments
… innodb_additional_mem_pool_size innodb_log_buffer_size adaptive index hash, size= innodb_buffer_pool / 64 system dictionary hash, size = 6 * innodb_buffer_pool_size / 512 memory… * 216 and memory for locking system, size=5 * 4 * NBLOCKS So the final formula for innodb: innodb_buffer_pool_size + innodb_log_buffer_size + innodb_additional_mem…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… increase size of your Innodb log files to be able to use a lot of memory for write buffering efficiently. Q30: Question about… while googling.“What is the good way to split memory between INNODB buffers and OS?†Of course this depends on all…: set innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB‘s buffer pool. For…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…/s Buffer pool hit rate 999 / 1000 This section shows Buffer pool activity and memory usage. You can see total memory allocated by Innodb (sometimes it is higher than you anticipated), amount of memory…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… global buffers which are allocated at start and always where – these are key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size… tables as much as read_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size of memory might be allocated. But they…
