… index are random – which leads to a lot of page splits. One helpful new feature to address this is in XtraDB/InnoDB plugin – fast index creation. With this feature, InnoDB creates indexes by sort, so page fill factor should…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… the fast index creation feature introduced in the InnoDB plugin is that it only works when indexes are explicitly created using ALTER TABLE or CREATE INDEX….062s Caveats: As I mentioned previously, InnoDB fast index creation uses temporary files in tmpdir for all indexes being created. So make sure you…
Post: Interested to learn about New Innodb Plugin Performance ?
April 15, 2008 By 2 Comments
As you probably have already heard Innodb Announced new Plugin version for MySQL 5.1 So now you can see … 24 hours) as well as performance improvements to compression and fast index build functionality. As it is now publicly released we’ll… INFILE or ALTER TABLE from other storage engine) would use Fast Innodb Index creation. Keep it in mind if you decide to benchmark…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
… ( InnoDB with Percona patches). As benchmark engine I used tpcc-mysql with 1000 warehouses ( which gives around 90GB of data + indexes) on… for InnoDB-plugin. Here we observe innodb_adaptive_flushing in action (which is ON by default), and I think innodb_adaptive_flushing in InnoDB-plugin is…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin could… with fast SAS drives) with really interesting dataset on it. The only table customer has on this server is one huge innodb… in addition to index pages compression (by default it is trying to compress 16kb pages down to 8kb) new innodb plugin performs TEXT…
Post: Percona Server 5.5.11-20.2 Stable Release
April 28, 2011 By 1 Comment
… HandlerSocket, a NoSQL plugin for MySQL, has been updated to the latest stable version as April 11th, 2011. InnoDB fast index creation now works… an InnoDB table to a MEMORY table could fail due to a bug in innodb_expand_fast_index_creation.patch. (Alexey Kopytov) Bug #764395 – InnoDB…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…: 11569733 # InnoDB_IO_r_ops: 38530 InnoDB_IO_r_bytes: 631275520 InnoDB_IO_r_wait: 0.204893 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB_pages… really control it (tough it is possible in XtraDB / InnoDB-plugin with FAST INDEX creation) so be careful with queries scan many records by…
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 will run fine on 16-… of features I would like to see soon: Fast recovery. Both recovery after crash and recovery from…=29847, with ETA MySQL-6.0 Preload table / index into buffer_pool. You can use custom queries …
Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
May 24, 2008 By Leave a Comment
… new InnoDB pluggable storage engine, which Innobase released at the MySQL conference last month. We’ve written posts ourselves about its fast index… InnoDB locks even in the older versions of InnoDB, but it’s not really easy.) These tables are fully documented in the InnoDB plugin…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Innodb_data_writesblogpercona.commanual Innodb_data_writtenblogpercona.commanual Innodb_dblwr_pages_writtenblogpercona.commanual Innodb_dblwr_writesblogpercona.commanual innodb_doublewriteblogpercona.commanual innodb_fast_shutdownblogpercona.commanual innodb_file_formatblogpercona.commanual innodb…
