…INDEX `redundant`, ADD INDEX `redundant` (`col2`); # ######################################################################## # Summary of indexes # ######################################################################## # Size Duplicate Indexes 9 # Total Duplicate Indexes 1 # Total Indexes…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…the more general descriptors optimization in Percona Server showed fairly close results in our tests. In…_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log… –oltp-read-only=off –oltp-index-updates=0 –oltp-non-index-updates=0 run POINT_SELECT +…
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… I also show 5-minute moving averages to TokuDB. So TokuDB shows about 2.8x better throughput, and on data size: InnoDB table… binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… depends only the size of the transactions, which translates into number of unique key lookups into the certification index, which is a… table. A small fc_limit does however keep the certification index smaller in memory. It keeps the certification interval small, which… tell flow control came from this node because ‘Flow snt’ shows a message sent as soon as flow control is engaged…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… 5.6.11 top mutexes is &buf_pool->mutex,&new_index->lock. I profiled 5.6.11 in this IO bound… Percona Server shows much better results Configurations and how to run benchmark: [mysqld] user=root port=3306 innodb_buffer_pool_size = 30G…-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer_pool_instances=1 innodb_adaptive_flushing…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…/read” shows average size of read requests. For random IO these should be 16K – page size, for full table scan or index scan read… index Innodb builds for some pages to speed up row lookup replacing btree search with hash search. This section shows hash table size, number of used cells and number of buffers used by adaptive hash index. You can also…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…_index_creation may also optimize index access for subsequent DML statements. In my test setup I got about 178 MB index size after fast index creation as reported by SHOW TABLE STATUS versus 265 MB index size with the optimization disabled…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…, which people do quite frequently with MySQL 
[+] Compact Indexes Compact Indexes are great. Huge indexes is where large portion of Innodb performance problems… “SHOW TABLE STATUS” is not showing index sized in the release we tested it is hard to see how small indexes really are. [-] No “using index…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… which would look as following in terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row *************************** Name: sbtest… the Index. First Lets look at results of Adding and Dropping column for 128M buffer pool, sized to illustrate the case of index…
Post: InnoDB TABLE/INDEX stats
March 20, 2010 By 7 Comments
… available in XtraDB: It is INNODB_TABLE_STATS INNODB_INDEX_STATS These table show statistics about InnoDB tables ( taken from InnoDB data… value], …) | | index_size | index size in pages | | leaf_pages | number of leaf pages | Using these stats you can estimate how big is index is, and…
