… table: 58GB and 244.980.192 records TokuDB table: 15GB and 232.927.460 records So TokuDB looks better in this workload…_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache… Specific options key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL… similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup… can prevent XtraBackup failures that are caused by the log records in the transactional log being overwritten before they are copied…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL… similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup… can prevent XtraBackup failures that are caused by the log records in the transactional log being overwritten before they are copied…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…. (The last 2-3 partitions tend to stay in the buffer_pool.) If I recall correctly, any INSERT/DELETE/etc always… rambled on about things as a preface to rebutting “delete records from this table, those will be quicker, as they will… (if partitioned), (2) drill down the BTree, (3) remove one record. PARTITIONing makes very little difference. * If it cannot prune, then…
Post: Some little known facts about Innodb Insert Buffer
January 13, 2009 By 12 Comments
… ways of insert buffer merge is happening. First is on demand merge – if accessed page contains unmerged records in insert buffer the merge is performed before page is made available. This means insert buffer can slow down… number of inserts to insert buffer since start and number of merged records is number of records which were merged to their appropriate…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
… Fill join cache with packed records 14178 Records are stored in tab->cache.buffer and last record in 14179 last record is stored with pointers to blobs to support very big 14180 records 14181 ******************************************************************************/ 14182…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… key_buffer=750M join_buffer=10M max_heap_table_size=50M tmp_table_size=64M max_allowed_packet=16M table_cache=1800 record_buffer=10M sort_buffer_size=24M read_buffer_size=9M max_connect_errors=10 thread_concurrency=4 myisam_sort_buffer_size=950M…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
… updates buffer pool pages in memory and records page operations in the transaction (redo) log. Behind the scenes those updated (dirty) buffer pool… log. Dirty Buffer Pool Pages On the other side, we have dirty buffers. These two numbers are relevant from the BUFFER POOL AND… optimize IO and to obey the LRU in the buffer pool. Since buffers can and will be flushed out of order, it…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
… every time it is needed. The problem with the sort buffer comes from the way Linux allocates memory. Monty Taylor (here… while varying the size of the sort_buffer. It is my understanding that the sort_buffer is used when no index are… to observe. I varied the sort_buffer_size by steps of 32 KB and I recorded the time required to perform 12…
Post: What is stored InnoDB buffer pool
September 28, 2008 By 8 Comments
… * from information_schema.INNODB_BUFFER_POOL_CONTENT; +———–+——-+——–+———+———-+————+———–+————–+————–+—————-+—————–+————–+——————+ | BLOCK_NUM | SPACE | OFFSET | RECORDS | DATASIZE | FLUSH_TYPE | FIX…
