…_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…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… and in turn, load that data into and pollute the buffer pool. Note that this can be somewhat mitigated using innodb_old… operation (redo logs, binlogs, etc) as well further polluting the buffer pool. Enter Xtrabackup… As a quick refresher, Xtrabackup works by copying…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… decent size server where I have 6GB innodb_buffer_pool_size split into 3 innodb_buffer_pool_instances. The entire main db would be…
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 look…
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… similar for every single graph, each chunk warmed up the buffer pool for the next one. As an additional experiment we tried…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… dataset to check server behavior when data fully fits buffer pool(size of buffer pool is 30GB). So basically this is a CPU-bound… how to run benchmark: [mysqld] user=root port=3306 innodb_buffer_pool_size = 30G innodb_flush_method = O_DIRECT innodb_log_file… = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer_pool_instances=1 innodb_adaptive_flushing_method=keep_average innodb_flush…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… of data (32 tables, 10M rows each) and a 4GiB buffer pool. The cache devices were flushed to disk immediately prior to… speak for themselves. When the working set outstrips the available buffer pool memory but still fits into the cache device, vCache shines…_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb_log_buffer…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… undo tablespace, 5.6-style buffer pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced… similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup directory during…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… undo tablespace, 5.6-style buffer pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced… similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup directory during…
Comment: How long Innodb Shutdown may take
May 14, 2013 By 9 Comments
…:00 InnoDB: Initializing buffer pool, size = 4.0G 130514 8:12:29 InnoDB: Completed initialization of buffer pool Why initializing innodb buffer pool (size 4.0G…
