… how the patches contribute to the improvements in this case. split_buf_pool_mutex_fixed_optimistic_safe.patch The patch splits global InnoDB buffer_pool…pages tries to to the buffer pool and merge the ibuf contents to them. innodb_ibuf_contract_const is used during run a batch of insert buffer merge…
Comment: Another scalability fix in XtraDB
January 24, 2009 By 13 Comments
… lot of cores a lot of these contentions become exposed. Some in particular contention on buffer pool pages fixed by Innodb team and I expect more to… general mistake to think developers of the popular software should have all simple issues worked out. Look at MySQL itself – how could it…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…of things like how to build for massive scalability, how to do read-write splitting without breaking the user experience, how to…buffer pool is set to 22GB, it’s much easier to see 22GB than 23622320128, especially since that number is buried next to a lot of…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…non-obvious to make. A few of the common ones I see are not configuring the InnoDB buffer pool size…you have query cache contention, DNS problems, or very slow I/O. In addition to unlikely circumstances, …’s a wise investment of time to take a deeper look at the server, including how the data, schema,…
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
…of 4 sysbench tables(50M rows each) ~50G data / CPU bound case innodb_buffer_pool…caused by some contention in the lib. All variations of glibc …good, results are very similar to lockless/jemalloc-3.0/tcmalloc…how mysqld footprint is changed during the test cycle and what is the impact of disabling of…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… memory content including buffer pool which can be tens on even hundreds GB of disk space. It can also take very long time to write this amount of… this Fromdual page it has a lot of good information. Now as I explained how you can get core files from MySQL…
Comment: Disaster: MySQL 5.5 Flushing
September 19, 2011 By 27 Comments
…to start reading its contents from beginning, propagating changes back into buffer pool (ok, they already are in buffer pool) and flushing those buffer pool pages back to…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…, cause tons of I/O, etc. In reality, it can be completely unusable for a long time. To measure how much this really… roles switch.) After a day or so of doing this, I re-sampled the buffer pool contents on the passive server. With all three… in the pool. Same table, same size of data doesn’t mean same buffer pool contents. An insert-only workload will probably fill the buffer pool with…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… buffer pool, which is larger than the data. Very little tuning was done. The goal was to see how MySQL 5.6 performs out-of… sec) Here are the contents of the buffer pool in pages afterwards: mysql> select sq.*, pages / (@@innodb_buffer_pool_size / 16384) * 100 pct_buffer_pool from ( select table…
Comment: COUNT(*) vs COUNT(col)
April 25, 2007 By 45 Comments
…pool allocated 714496 Buffer pool size 32768 Free buffers 14104 Database pages 18664 Modified db pages 0 restart mysql and check the count of…content…
