… decent size server where I have 6GB innodb_buffer_pool_size split into 3 innodb_buffer_pool_instances. The entire main db would be around…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… server does not process query traffic except for replication. The buffer pool and adaptive hash index on the standby server will not… would be heavily I/O bound after failover as the buffer pool pages were loaded from disk. Replaying Queries Working with Groupon… faster than an actual database write. The slow logs were split into chunks, each containing roughly 1M queries. We warmed the…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…, drop the file cache and pre-allocate the innodb buffer pool with the innodb_buffer_pool_populate option. That solves most of the swapping… of free memory but the push to S3 involves a split operation to create files of 5GB since the backup size… a short while. Here’s the vmstat output during the split process, the cron job started at 10am. Fri Mar 22…
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 opens… a BTree is only (about) 5 levels deep. If you split that table into 100 partitions, the BTree in each partition…
Post: Quickly preloading Innodb tables in the buffer pool
May 1, 2008 By 9 Comments
… preload table to Innodb buffer pool, which would simply go through .ibd file sequentially and inject pages in the buffer pool. This would make preload done using sequential file scan even if indexed suffered a lot of page splits. Now lets continue to the hacks 
So As I mentioned you can load Innodb Table Clustered Index in the buffer pool…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… approach with using a write-through cache? A: The InnoDB buffer pool is effectively a type of write-through cache. That is… is persisted immediately, but the page also resides in the buffer pool and it can serve subsequent queries. This allow you speedy…, as long as the page remains in the buffer pool. But the read/write split solution is intended for cases where the query…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
… slower than Monty results show. Mmap allocation process can be split to two parts – first is finding the free region of… buffers are allocated from the pools rather than mmap. This though will at least increase memory consumptions as deallocating of these large buffers… large pages. These already can be used for Innodb Buffer Pool and Key Buffer but could be used for other large allocations. Finally…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…. Main difference XtraDB-rel2 it contains additional scalability fixes for buffer_pool (split_buffer_pool_mutex patch). my.cnf is [mysqld] user=root binlog_cache…=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size=16M innodb_buffer_pool_size=15G innodb_data_file_path=ibdata1:10M… this is mostly because fixes to rw_locks and to buffer_pool mutex (in rel2). Conclusion: As read-only workload seems fine…
Post: XtraDB storage engine release 1.0.2-2 (New Year edition)
December 29, 2008 By 20 Comments
… engine. Here is a list of enhancements: split-buffer_pool_mutex The patch splits global InnoDB buffer_pool mutex into several and eliminates waitings on flush IO and mutex when there is no enough free buffers…
Post: XtraDB storage engine release 1.0.3-6
July 20, 2009 By 6 Comments
… import InnoDB / XtraDB tables from another server split-bufpool-mutex-3 New patch to split buffer pool mutex g-style-io-thread Google’s…
