… ## 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_…innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer pool…
Comment: Side load may massively impact your MySQL Performance
May 15, 2012 By 7 Comments
http://bugs.mysql.com/bug.php?id=45015 (InnoDB buffer pool can be severely affected by table scans)
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… ran it on TPC-H dataset (InnoDB tables) with a Scale Factor of 2 (InnoDB dataset size ~5G). Note that query …23049 23221 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 …
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…Suppose you have the following query executed on the InnoDB table: SELECT non_key_column FROM tbl WHERE key…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…
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: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… am facing major issues with slow query output. The tables are in InnoDB with MySQL 5 and RHEL 5. Its a 32…:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 65M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… speedier joins, faster subqueries, and elimination of useless tables in joins Thread pooling and a segmented key cache for improved scalability That…, better diagnostics, improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB 5.5 might be here pretty…
Comment: High Rate insertion with MySQL and Innodb
March 29, 2012 By 16 Comments
… records are 1.9 million, the table has parent child relationship and the engine type is InnoDB. The process is very slow…, otherwise it first inserts parent and then child, after setting innodb_buffer_pool_instances to 8, I don’t see any difference. I…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…INNODB STATUS and look for memory information block, which can use like this: ———————- BUFFER POOL AND MEMORY ———————- Total memory allocated 132183490560; in additional pool…
Comment: Performance problem with Innodb and DROP TABLE
March 15, 2012 By 23 Comments
… have a pool english ^_^. according to your view, when you set innodb_table_per_file=1 and then you drop the table, so the… associate with that tablespace in the buffer pool must be discarded too? in my opinion, when the table is droped ,then no statement… the useless pages in the buffer pool can be discared when buffer pool is full or other situation, not at the time when drop table.
