… hash index is improving performance of InnoDB significantly during the hot run, as hash indexes are faster than a b-tree index. Also …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
…INDEX `redundant`, ADD INDEX `redundant` (`col2`); # ######################################################################## # Summary of indexes # ######################################################################## # Size Duplicate Indexes 9 # Total Duplicate Indexes 1 # Total Indexes…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… instead of using InnoDB heap allocation. This may improve write performance for high levels of concurrency…tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and …expand too fast around 500KB tablespace size. Bug fixed #1169494. Fixed the RPM …
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… of requested LSN range was missing. Bug fixed #1179974. Server would crash if an INNODB…Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER…. 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
… (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Notice that in the case of child_…of children, parents, count of columns, row counts, and comments — a great way for a high level overview of the table sizes… based on names, tables without indexes, columns flagged ‘nullable’ and ‘must be unique…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… ” NOT NULL, PRIMARY KEY (id) ) CREATE INDEX k on sbtest$I(k)…that InnoDB is faster, but you should look into the steady decline of InnoDB …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: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…the mutex protecting the list of transactions, its applicability is quite …innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb…-only=off –oltp-index-updates=0 –oltp-non-index-updates=0 run POINT…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…after load of data size of datadir ~10GB). We used this dataset to check server behavior when data fully fits buffer pool(size of …-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer_pool_instances=1 innodb_adaptive_flushing_method=keep_average innodb…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…ALTER TABLE statements to drop these indexes, an exercise left to the reader. 
Estimating the size of these indexes But, what if we want…index_total_size from information_schema.tables t join information_schema.statistics i using (table_schema, table_name) join information_schema.innodb_index_stats…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
… another index in InnoDB … you had to calculate it yourself by multiplying size of row (which I should add is harder in the case of…` (`from_message_id`,`link_id`) ) ENGINE=InnoDB AUTO_INCREMENT=26141165 DEFAULT CHARSET=utf8; And size of file is about 12.88 GB -rw… table by itself, as InnoDB is clustering data by primary key) takes 497839 pages ( 16KB each) and size of data 7492026403 bytes or…
