As you probably have already heard Innodb Announced new Plugin version for MySQL 5.1 So now you can see … Innodb for) – for example neither of standard data load tools (mysqldump import, using LOAD DATA INFILE or ALTER TABLE from other storage engine) would use Fast Innodb…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
One of the serious limitations in the fast index creation feature introduced in the InnoDB plugin is that it only works when indexes… adding the secondary indexes after the data is loaded.” mysqldump in Percona Server supports the new option –innodb-optimize-keys which does just…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
…fast SAS drives) with really interesting dataset on it. The only table customer has on this server is one huge innodb… convert customer’s data to Barracuda file format using new InnoDB plugin recently released by Oracle…data file (from 60Gb) ~5% I/O load according to iostat (from 99%) ~5% CPU load …
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
…InnoDB scalability problems seem fixed in InnoDB-plugin-1.0.3 and I expect InnoDB-plugin …I would like to see soon: Fast recovery. Both recovery after crash …never catch up slave, but with small load warm up may take hours to…data and memory on servers they become critical. I do not know what is InnoDB…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 13 Comments
… maintenance, after start, the node has to load whole mysqldump, like it is new empty node…now is support of InnoDB-plugin, which as we know performs much better than standard InnoDB ®. So what … you read actual data. Although it also has serious drawback – our cluster is fast as fast the “weakest” …
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…_id`), KEY `block_id` (`block_id`) ) ENGINE=InnoDB Table has 11864696 rows and takes Data_length: 698,351,616 bytes on disk… key order. So notes to highlight: InnoDB fragmentation may hurt your query significantly, especially when data is not in buffer_pool and… really control it (tough it is possible in XtraDB / InnoDB-plugin with FAST INDEX creation) so be careful with queries scan many records…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Innodb_data_readblogpercona.commanual Innodb_data_readsblogpercona.commanual Innodb_data_writesblogpercona.commanual Innodb_data_writtenblogpercona.commanual Innodb_dblwr_pages_writtenblogpercona.commanual Innodb_dblwr_writesblogpercona.commanual innodb_doublewriteblogpercona.commanual innodb_fast…
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
… recovered ten times faster (see docs). InnoDB Plugin Features – XtraDB is derived from the InnoDB plugin, which has fast index creation (as opposed to recreating…). Â In XtraDB, adaptive checkpointing can smooth out the load, and checkpoint data more aggressively as you approach the end of a…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… buffer pool. In high load situations where INNODB is using most of… disk for throughput. INNODB uses fuzzy checkpointing to commit data to disk….innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN…). The index is required for fast lookups: it can be used…
Comment: Real-Life Use Case for "Barracuda" InnoDB File Format
April 24, 2008 By 11 Comments
… would love to see more details on the specific schema, data and workload. How many columns? Average length of each column… TABLE from MyISAM to InnoDB? LOAD DATA? Did you create the secondary indexes AFTER loading the table (to take advantage of “fast index create”? The more you can share, the more we’ll all know about the potential of the InnoDB Plugin to…
