…InnoDB doing read_ahead by noticing the sequential access pattern. BKA is available in both MySQL 5.6 and MariaDB 5.5…_tables 0 0 0 0 0 0 Created_tmp_tables 1 1 1 1 1 1 Handler_mrr_init N/A 112 3 1133 1 1 …vs 5G. However, there is one number in MariaDB 5.5 that is quite large as compared to MySQL 5…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… Index 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: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
…consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO… I see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually …id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d….
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…0 0 0 0 0 0 0 0 # rec lock wai 0 0 0 0 0 0 0 0 # String: # Databases # Hosts localhost # InnoDB trxID 3BBF3B55 (1/0%), 3BBF3B5A (1/0%)… 1753695 more # Last errno 0…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 27 Comments
… from record #10000 making MySQL to discard first 10000 records. 1) Results for ENUM:… performance of Innodb tables in this case: for VARCHAR it takes about 0.022… WHERE s.name=’Minnesota’ limit 10000,5 \G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: …
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…` varchar(8) NOT NULL default ”, `country_id` smallint(5) unsigned NOT NULL default ‘0‘, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), KEY… of RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5.1-falcon for…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…known new features in MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is activated HT: InnoDB flushes about … boost and it would write at 100MBps vs 33MBps. Any plans to enable tuning of …number of users who had serve regressions in 5.0 because of group commit being broken. Most …
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.6 All versions are vanilla MySQL, not Percona … MySQL 5.0 vs MySQL 4.1 couple years ago, I have seen biggest performance hit comes from query parser. In MySQL 5.0 grammar…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…InnoDB sessions: Test 1: Deadlock detection (deadlock is correctly detected): insert into test2 values (1,’Mysql‘),(2,’Solid’),(3,’MyISAM’); Session1: mysql> begin; Query OK, 0…
Post: More Gotchas with MySQL 5.0
July 27, 2007 By 23 Comments
Working on large upgrade of MySQL 4.1 running Innodb to MySQL 5.0 and doing oprofile analyzes we found very interesting issue of … much higher for MySQL 5.0 compared to MySQL 4.1 It was something like 2-3 for MySQL 4.1 vs 40-60 for MySQL 5.0 At the same… in MySQL 5.0 and 4.1 Hopefully this issue will be fixed sooner or later (I would be even happy to give up Innodb…
