…5.0.* – xtrabackup_51 # MySQL 5.1.* – xtrabackup_51 # MySQL 5.1.* with InnoDB plugin – xtrabackup # MariaDB 5.1.* – xtrabackup # MariaDB 5.2.* – xtrabackup # MariaDB 5.3.* – xtrabackup # Percona Server 5…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… DEFAULT NULL, `SPACE` int(10) unsigned DEFAULT NULL, PRIMARY…SPACE | +————–+—–+——–+——+——–+———+————–+——-+ | sakila/actor | 741 | 4 | 1 | 0 | 0 | | 738 |… NULL, `first_name` VARCHAR(45) CHARACTER SET ‘utf8′ COLLATE…5,2) type sys_parser will generate DECIMAL(5…
Post: Percona Server security fix releases
May 23, 2010 By 4 Comments
…-5.0/Percona-Server-5.0.91-22/ Release Percona Server/XtraDB 5.1.45-rel10.2 is available also ( we backported patches from 5.1.47 to 5.1.45): http://www.percona.com/downloads/Percona-Server-5.1/Percona-Server-5.1.45-10.2…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0… As you can see on 100G data set MySQL 5.1 could only complete 10 out of 22 queries within 3hours run time… of queries it can execute in reasonable time frame. There 2 queries (Query8 and Query20) which MySQL 6.0 does better…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… dropped OS caches by `echo 1 > /proc/sys/vm/drop_caches` and restarting mysqld) 5.1 – time 1 hour 14 min 36.90 sec 6.0 – time 1 hour 6 min 2.21 sec So difference….23 0.62 2441.07 4.93 1220.53 2.46 8.10 1.02 3.39 3.39 102.18 Device: rrqm….00 0.21 1091.94 3.10 8763.64 26.45 4381.82 13.22 8.03 1.02 0.94 0.93…
Post: MyISAM mmap feature (5.1)
May 26, 2006 By 10 Comments
…same for Windows, but I did not test it). In 5.1 I implemented a new feature: memory mapping for the …15.ELsmp 4 x Intel(R) XEON(TM) MP CPU 2.00GHz with HyperThreading 4GB of RAM The results (queries/…10991.45 1.26 OLTP rw Threads Pread Mmap Mmap/pread ratio 1 183.48 234.36 1.28 4 180.00 243.10 1.35…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…; +—-+—————+——–+ | id | inserted_from | name | +—-+—————+——–+ | 2 | percona1 | lefred | | 3 | percona2 | kenny | | 5 | percona1 | liz | | 9 | percona1 | ewen | | 10 | percona2 | jay | +—-+—————+——–+ 5 rows in set (0… like this: 120723 23:45:30 [ERROR] WSREP: Local state seqno (6) is greater than group seqno (5): states diverged. Aborting to… from 0 (percona2) 120724 10:58:09 [Note] WSREP: Quorum results: version = 2, component = PRIMARY, conf_id = 2, members = 1/1 (joined/total), act_id…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
… 2.1 0.1 6.5 16% 0 …snip… 20.2 {10} 2.6 0.1 12.1 0.3 0.0 4.0 3% 0 21.2 {10} 2.3 0.2… in_prg 1.0 sdj1 0.6 4.1 228.3 0.0 0.1 45.3 11% 0 2.0 sdj1 0.5 1.4 90… 20.2 sdj1 0.2 0.1 14.1 0.0 0.0 3.7 2% 0 21.2 sdj1 0.2 0.1 10.2 0.0 0.0 2.5 2% 0 22.2…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what… WHERE condition defined as: l_partkey = x and l_quantity >= 1 and l_quantity = 1 and l_quantity
Post: Extending Index for Innodb tables can hurt performance in a surprising way
May 22, 2010 By 10 Comments
…often does not: CREATE TABLE `idxitest` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `a` int(11…, PRIMARY KEY (`id`), KEY `a` (`a`), KEY `a_2` (`a`,`b`) ) ENGINE=InnoDB AUTO_INCREMENT=6029313 …different MySQL versions. These tests were done with 5.1.45 though I’ve seen same behavior with MySQL 5.0…
