… data does not fit in the buffer pool, fast index creation provides even better performance as compared to the default method, because it… this case InnoDB picks such an index as the clustered one. References: Peter’s post MySQL bug #57583 MySQL bug #49120 Fast Index Creation page in…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
…indexes to the same tables. We had a suspicion that it had something to do with Fast index creation in Innodb…performance impact, but it seems to be the most stable. In this case, it turned out that the indexes…
Post: Interested to learn about New Innodb Plugin Performance ?
April 15, 2008 By 2 Comments
… 24 hours) as well as performance improvements to compression and fast index build functionality. As it … this release (which you can blame both MySQL and Innodb for) – for example neither of standard … from other storage engine) would use Fast Innodb Index creation. Keep it in mind if you decide …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… space. Fast Index Creation This is another feature which I was asking Heikki about probably since my first days as Innodb user when I found out ALTERing Innodb tables may take a lot of time. Fast Index creation will allow Innodb to build indexes by… some of them to MySQL 5.0+ Heikki also mentioned there are more things inside Innodb to unleash performance such as multiple purge…
Post: Performance improvements in Percona 5.0.83 and XtraDB
July 14, 2009 By 27 Comments
…: – Moving InnoDB tables between servers – Improve InnoDB recovery time and rest time we played with performance trying to align XtraDB performance with MySQL 5.4… the same performance, let me refresh: – XtraDB is based on InnoDB plugin 1.0.3, with all its benefits like FAST INDEX CREATION, table…
Post: Great work Innodb Team
November 30, 2009 By 8 Comments
…Performance And Scalability. Innodb Plugin 1.0.4 had a lot of great performance…Innodb plugin documentation now seems to be merged with MySQL Documentation which makes it much more usable and Innodb Plugin is shipped with MySQL… on Innodb plugin features such as compression or Online index creation…
Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
May 24, 2008 By Leave a Comment
… InnoDB pluggable storage engine, which Innobase released at the MySQL conference last month. We’ve written posts ourselves about its fast index creation capabilities and the compressed row format, and how that affects performance. One of the nice things they added in this InnoDB…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…Innodb performance counters, statistics, information about transaction processing and all kinds of other things. In MySQL 5 number of Innodb performance…Innodb. You can see current log sequence number – which is amount of bytes Innodb has written in log files since system tablespace creation…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL…innodb_buffer_pool_size. Also Innodb buffer pool caches both data and index…innodb_additional_mem_pool_size This one does not really affect performance…_cache Thread creation/destructions can …
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
… 10 enhancements that XtraDB has over the built-in InnoDB included in MySQL 5.0 and 5.1. Building this list… index creation (as opposed to recreating the whole table!) and page compression. Adaptive Checkpointing – The built-in InnoDB can have erratic dips in performance…
