…index build operation has to use excessive sort merge passes significantly slowing down index…is using “fast_index_creation=0″ which allows to disable fast index creation in…building index by sort with small buffer – this comes from building index on long character field with very short length, Innodb…
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 is now publicly released we’ll try… with this release (which you can blame both MySQL and Innodb for) – for example neither of standard data load tools (mysqldump… INFILE or ALTER TABLE from other storage engine) would use Fast Innodb Index creation. Keep it in mind if you decide to benchmark…
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… index build speed is however not only reason I can’t wait for this feature to be available. Building index by sort allows to build…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row *************************** Name: sbtest Engine: InnoDB Version: 10 … with expand_fast_index_creation=1 which builds table with primary key only when creating a table and when builds all indexes by …
Post: Percona Server 5.5.11-20.2 Stable Release
April 28, 2011 By 1 Comment
…. InnoDB fast index creation now works with mysqldump, ALTER TABLE and OPTIMIZE TABLE. (Alexey Kopytov) Variable Changes Variable innodb_extra… Downloads: Binary distributions, Percona Software Repositories and Experimental build for MacOS Installation instructions Consulting, support, training, and…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…indexes with Innodb (with index built by sort) this is when this should be helpful the most. Q3: Does Innodb secondary Indexes…performing INSERT with multiple values? We build up INSERTS on our clients …index is required for fast lookups: it can be used if the columns are the first columns in an index…
Post: Countless storage engines
May 3, 2007 By 6 Comments
… I heard of on Conference and main impression about. InnoDB On the conference InnoDB presented two new interesting features – transparent ZIP of… tasks with intensive I/O load a lot. Second feature – fast index build. Both should be available in 5.2 MySQL. PBXT Interesting… to handle in very fast way aggregative functions on massive data sets. As I understood they use special index to store pre…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
…builds optimized for Cisco UCS B250/C250 servers, which come with a lot of memory (up to 384GB). Mentioned above, “Permanent InnoDB… variable innodb_flush_log_at_trx_commit. (Yasufumi Kinoshita) innodb_fast_index_creation – Allows disabling of fast index creation. (Yasufumi Kinoshita) innodb_use_…
Post: Percona Server 5.1.56-12.7
April 18, 2011 By Leave a Comment
… applicability of InnoDB fast index creation to mysqldump, ALTER TABLE and, OPTIMIZE TABLE. (Alexey Kopytov) Variables Changed Variable innodb_stats_…InnoDB, including adding a column to table INNODB_SYS_STATS. Bug fixed: #733317. (Yasufumi Kinoshita) Added README-windows with basic command to build…
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
… now. There is Innodb Plugin which has significant architectural changes such as new storage format, compression and fast index build. Innodb plugin 1.0.3 got some Google changes for CPU scalability but not IO patches. I expected Innodb to announce…
