… 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: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 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: 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…
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: Innodb Double Write
August 4, 2006 By 23 Comments
… writes and failure happens just between their execution. Reasons for splitting could be file fragmentation – most file systems use 4K block… term log file allocated inside Innodb tablespace – it contains space for 100 pages. When Innodb flushes pages from Innodb buffer pool it does so by…
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… use 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 storage engine release 1.0.3-6
July 20, 2009 By 6 Comments
… estimate innodb_stats – the implementation of the fix forMySQL Bug#30423 expand-import Support of import InnoDB / XtraDB tables from another server split-bufpool-mutex-3 New patch to split buffer pool mutex g-style-io-thread Google’s fixes to InnoDB…
Post: Index lock and adaptive search - next two biggest InnoDB problems
February 25, 2010 By 12 Comments
… this way because write operation may cause B-Tree page split, and InnoDB needs to move records between pages to finish operation… need to perform some additional IO to bring page into buffer_pool. What could be done there internally: there is B-Tree… variable), but it rarely helps actually. With disabled adaptive index InnoDB needs to perform much more operations reading secondary keys. How…
