… a fairly 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
…process query traffic except for replication. The buffer pool and adaptive hash index on the … innodb_fake_changes. Thread pool Percona Playback added a connection pool option via –dispatcher-plugin-thread-pool… database write. The slow logs were split into chunks, each containing roughly 1M queries…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… how important is the file cache for Linux. Basically, with InnoDB, since the file cache is not important we add “vm… utility, drop the file cache and pre-allocate the innodb buffer pool with the innodb_buffer_pool_populate option. That solves most of the swapping issues… a short while. Here’s the vmstat output during the split process, the cron job started at 10am. Fri Mar 22…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… of Innodb on Solaris? HT: Yes, if your ‘write working set’ fits in 16 GB. I mean, if the database buffer pool can buffer… 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: 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…4 innodb_additional_mem_pool_size=16M innodb_buffer_pool_size=15G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush…
Post: Quickly preloading Innodb tables in the buffer pool
May 1, 2008 By 9 Comments
… Innodb would implement command to preload table to Innodb buffer pool, which would simply go through .ibd file sequentially and inject pages in the buffer pool… page splits. Now lets continue to the hacks 
So As I mentioned you can load Innodb Table Clustered Index in the buffer pool pretty…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…: The InnoDB buffer pool is effectively a type of write-through cache. That is, when you change data on a given InnoDB page, the change is persisted immediately, but the page also resides in the buffer pool and it can…, as long as the page remains in the buffer pool. But the read/write split solution is intended for cases where the query…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… chunks as though it were many small files, which avoided splitting the file and let us load with many transactions instead… make InnoDB behave like PostgreSQL If the undo log space grows really big, it won’t fit in the buffer pool and InnoDB essentially starts swapping between its buffer pool and the tablespace on disk. Most seriously…
Post: 5.0.83-build17 Percona binaries
July 28, 2009 By 19 Comments
… patch innodb_use_sys_malloc.patch is added The new patch innodb_split_buf_pool_mutex.patch is added This patch splits the single global InnoDB buffer pool… buffer pool mutex contention by examining the output of SHOW INNODB STATUS and looking at the first section, SEMAPHORES. Google’s style IO – innodb…
Post: XtraDB storage engine release 1.0.2-2 (New Year edition)
December 29, 2008 By 20 Comments
… storage 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. It…
