… 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: 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 17 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…
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
… XtraDB has over the built-in InnoDB included in MySQL 5.0 and 5.1. Building this list was not really… ten times faster (see docs). InnoDB Plugin Features – XtraDB is derived from the InnoDB plugin, which has fast index creation (as opposed to recreating the whole table!) and page compression. Adaptive Checkpointing – The built-in InnoDB…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… is pretty much insert buffer efficiency. Adaptive hash index is hash index Innodb builds for some pages to speed up row lookup …, and being sequential writes these logs writes are pretty fast. ———————- BUFFER POOL AND MEMORY ———————- Total memory allocated 4648979546; in …
