…mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… working set outstrips the available buffer pool memory but still fits into the cache…mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… allocation of memory for the MySQL process using the numactl utility, drop the file cache and pre-allocate the innodb buffer pool with the innodb_buffer_pool_populate… create files of 5GB since the backup size is about 28GB and the file upload size limit is 5GB. So, about 28GB…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…choosing proper innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description. Innodb Buffer Pool is…do different VM memory adjustments. You may want to make MySQL to use Large Pages for allocating Innodb Buffer Pool and few other buffers, which …
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
…of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row *************************** Name: sbtest Engine: InnoDB Version: 10 …column for 128M buffer pool, sized to illustrate the case of index being significantly larger than amount of memory. Blue Columns …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…Innodb_buffer_pool_pages_latchedblogpercona.commanual Innodb_buffer_pool_pages_miscblogpercona.commanual Innodb_buffer_pool_pages_totalblogpercona.commanual Innodb_buffer_pool_read_aheadblogpercona.commanual Innodb_buffer_pool_read_ahead_evictedblogpercona.commanual Innodb_buffer_pool…_memory_…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
… the proper innodb_buffer_pool_size estimations when the system has a lot of RAM and you want to have the largest possible innodb_buffer_pool_size. Do… with an 80 GB buffer pool. Apparenly OpenSUSE defaults are set in proportion to physical memory to keep the memory-hungry applications from taking…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… now allowing MySQL to handle larger queries. Makes sense as amount of memory available is much larger these days. join_buffer_size have been… default. innodb_old_blocks_time now set to 1000 making Innodb Buffer Pool Size scan resistant by default. Very welcome change ! thread_cache_size is enabled…
Post: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 12 Comments
… away by other queries. MySQL Server does not provide …size, 2) fit_pct FROM (SELECT index_id, COUNT(*) cnt, SUM(dirty = 1) dirty, SUM(hashed = 1) hashed FROM innodb_buffer_pool…buffer pool for given table (cnt), how many of them are dirty (dirty), and what is the percentage of index fits in memory…
Post: How Much memory do you use to run MySQL
November 2, 2012 By 8 Comments
… problems with large size Query Cache to bad drop table performance with large Innodb Buffer Pool size. As such I wonder how much memory do we really use to run MySQL Server these days ? [poll…
