… perfect for sequential writes http://www.mysqlperformanceblog.com/2010/01/11/fusionio-320gb-mlc-benchmarks/ Full results I put on page… InnoDB-plugin-1.0.6 15299.333 NOTPM XtraDB-1.0.6-9 26160.551 NOTPM InnoDB-plugin is 1.6x times better InnoDB, and XtraDB is 1.7x times better InnoDB-plugin…
Post: Percona Server 5.1.47-rel11.0
June 21, 2010 By 13 Comments
… 5.1.47, and XtraDB is now based on InnoDB plugin 1.0.8. XtraDB now uses the fast recovery code released in InnoDB Plugin version 1.0.8, instead of Percona’s earlier fast-recovery code. Added the –percona_innodb_doublewrite_path option… compile 5.1.46 #573104 separate name in INNODB_SYS_TABLES table #580324 Security bug in upstream #586579 Percona Server 11 fails to…
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
Many InnoDB scalability problems seem fixed in InnoDB-plugin-1.0.3 and I expect InnoDB-plugin will run fine on 16-24 cores boxes for many…, when InnoDB takes probes during opening table, as it is slow operation. See also http://www.mysqlperformanceblog.com/2006/11/21/opening… our current plans about XtraDB with recent InnoDB-pluging release, as performance improvements in plugin may make XtraDB out of game – so…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…index creation feature introduced in the InnoDB plugin is that it only works when…, 4194304 rows affected (1 min 11.12 sec) Records: 4194304 Duplicates: 0 Warnings: 0 mysql> SHOW PROFILE; +——————————+———–+ | Status | Duration | +——————————+———–+ ….
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
… 12:09:32 INNODB TABLE MONITOR OUTPUT =========================================== ————————————– TABLE: name SYS_FOREIGN, id 0 11, columns 7, indexes 3, appr.rows 1 COLUMNS: ID: DATA… ID_IND, id 0 11, fields 1/6, uniq 1, type 3 root page 46, appr.key vals 1, leaf pages 1, size pages 1 FIELDS: ID… the latest Percona Server 5.1 in: storage/innodb_plugin/dict/dict0load.c: line 226, and again in: storage/innodb_plugin/dict/dict0dict.c: line…
Post: What is stored InnoDB buffer pool
September 28, 2008 By 8 Comments
…0 | 0 | 0 | 0 | 10 | 2 | undo_log | | | | | 9 | 0 | 50 | 0 | 0 | 0 | 0 | 11 | 2 | undo_log | | | | | 10 | 0 | 8 | 12 | 894 | 0 | 0 | 12 | 17855 | index | CLUST_IND | | SYS_TABLES | | 11 | 0 | 0 | 0 | 0 | 0 | 0….S. There is Jeremy Cole’s patch for InnoDB plugin MySQL 5.1, and main idea was taken from …
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
… right even though Innodb is able to drop indexes without rebuilding table since MySQL 5.1 (Innodb Plugin) dropping foreign …0.61 sec) mysql> show create table child \G *************************** 1. row *************************** Table: child Create Table: CREATE TABLE `child` ( `parent_id` int(11…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…-bound tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU specification: processor… cpu cores : 6 fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu vme de pse tsc msr pae… virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2-1, and XtraDB-1.0.2-2 (rel2). XtraDB-rel2 has not…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
…. Versions in question: MySQL 4.1 MySQL 5.0 MySQL 5.1 (with built-in InnoDB) MySQL 5.1 with InnoDB-plugin MySQL 5.5 MySQL 5…) threads MySQL 4.1 MySQL 5.0 MySQL 5.1 MySQL 5.1+InnoDB-plugin MySQL 5.5 MySQL 5.6.2 1 685.52 639.73… 2031.80 2042.51 1937.64 1830.80 8 3879.11 3746.29 3606.02 3681.36 3522.65 3320.10…
