… and in turn, load that data into and pollute the buffer pool. Note that this can be somewhat mitigated using innodb… operation (redo logs, binlogs, etc) as well further polluting the buffer pool. Enter Xtrabackup… As a quick refresher, Xtrabackup works by…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… size server where I have 6GB innodb_buffer_pool_size split into 3 innodb_buffer_pool_instances. The entire main db would…
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… a MySQL dba to steal 20GB memory from the Innodb buffer pool to give it to the filesystem. I took a…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… any bugs at http://bugs.percona.com/ key_buffer_size=52428800 read_buffer_size=131072 max_used_connections=13 max_threads=2002… possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4432877 K bytes of memory…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… cost difference. ZFS provides built in checksumming and double write buffering, so make sure these are turned off in InnoDB.
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 22, 2013 By 32 Comments
Does Percona have improvements to keep the InnoDB insert buffer from getting full (as in do background reads for ibuf merges when it is getting full)? That is the key to sustaining good throughput for InnoDB on iibench.
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine…
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… would be heavily I/O bound after failover as the buffer pool pages were loaded from disk. Replaying Queries Working with… similar for every single graph, each chunk warmed up the buffer pool for the next one. As an additional experiment we…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data…_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache…id = 101 key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… set is significantly larger than the InnoDB buffer pool (thus leading to a lot of buffer pool disk reads) but still small…
