…innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… full tables and in turn, load that data into and pollute the buffer pool. Note that this can be somewhat mitigated using innodb_old_blocks… 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
… running select query. A query runs for say 300 seconds and because the resultset is huge, it eventually starts creating a…’; there are also some other which show state as ‘null’ and Info says ‘commit’ The ‘Table_locks_waited’ remains zero while… 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…
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
…whatever: I compared all compression algo with tpcc and found marginal difference so I was likely not hitting a … for 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 have… in order to use innodb_fake_changes. Thread pool Percona Playback added a connection pool option via –dispatcher-plugin-thread-pool that will allow…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…=256 innodb_buffer_pool_instances=16 # MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer_pool_instances=1 innodb_adaptive_flushing…
Comment: How long Innodb Shutdown may take
May 14, 2013 By 9 Comments
…innodb shutdown and startup both took long i.e. 7 mins each 130514 7:57:39 InnoDB: Starting shutdown… 130514 8:04:26 InnoDB……. 130514 8:05: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…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… range selects by `id`. However it will interesting how both InnoDB and TokuDB performs if PK is (`id`,`hid`,`mid`). This also…:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size = 4G innodb…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… stampedes can be mitigated through application approaches (semaphores, pre-expiring and populating, etc), but those approaches are more geared towards single… buffer pool, so there are no reads from disk. However, there is write activity stemming from the fact that this is using InnoDB…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…rows each) and a 4GiB buffer pool. The cache devices were flushed to disk immediately prior to and immediately …innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb_log_buffer…
