… fits in the buffer pool and has been loaded by the cold test already. The buffer pool and adaptive hash index are…=justin 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…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…Indexes 3 Additionally, pt-duplicate-key-checker will detect subtle redundancies that are engine-dependent, like redundant suffixes for secondary keys in InnoDB…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS…name components in a bitmap file name could stop the server starting if the innodb_…. Under very rare circumstances, deleting a zero-size bitmap file at the right moment …
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…REFERENCES `parent` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Notice that in the case of child_A…sizes and an easy way to use the search feature of your browser to zero in… indexes, columns flagged ‘nullable’ and ‘must be unique’ (woops!), single column tables, incrementing column names in …
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…. Under very rare circumstances, deleting a zero-size bitmap file at the right moment …name components in a bitmap file name could stop the server starting if the innodb_… for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…innodb_buffer_pool_size = 30G innodb_flush_method = O_DIRECT innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit = 1 innodb…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…, pad CHAR(60) DEFAULT ” NOT NULL, PRIMARY KEY (id) ) CREATE INDEX k on sbtest$I(k) and tables sbtest$I_r10…_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_block_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per…-test-mode=nontrx –oltp-read-only=off –oltp-index-updates=0 –oltp-non-index-updates=0 run POINT_SELECT + UPDATE QPS test…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
… or another index in InnoDB … you had to calculate it yourself by multiplying size of row (which I should add is harder in the case… key index are random – which leads to a lot of page splits. One helpful new feature to address this is in XtraDB/InnoDB plugin – fast index creation. With this feature, InnoDB creates indexes by sort, so page fill factor…
Post: InnoDB TABLE/INDEX stats
March 20, 2010 By 7 Comments
… in InnoDB internal style (‘database/table’) | | rows | estimated number of all rows | | clust_size | cluster index (table/primary key) size in number of pages| | other_size | other index (non primary key) size in number of pages| | modified | internal counter to judge whether statistics recalculation should be done | INNODB_INDEX_STATS…
