… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… other possibilities like InnoDB doing read_ahead by noticing the sequential access pattern. BKA is available in both MySQL 5.6 and…, and the only difference in query time is 48.78s vs 48.91s, so I don’t see Hash Join and… 2.2G vs 5G. However, there is one number in MariaDB 5.5 that is quite large as compared to MySQL 5…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
…. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous… It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount of threads does… another question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important?”, and it…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
… contains 8 indexes inside InnoDB, which is different from the number of indexes 7 defined in the MySQL This customer was running… the INFORMATION_SCHEMA.INNODB_SYS_INDEXES table, which exists in Percona Server 5.1, but doesn’t appear in MySQL until 5… Percona Server or MysqL 5.6. Another person (I’m looking at you, Baron) was adverse to trusting INNODB_SYS_INDEXES from…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… 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… parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb For Falcon ./configure –prefix=/usr/local/mysqltest/mysql- –with-falcon mysqld startup…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… our estimates. If we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb_os_log_fsyncs for your disk… 0 0 0 0 0 0 # String: # Databases # Hosts localhost # InnoDB trxID 3BBF3B55 (1/0%), 3BBF3B5A (1/0%)… 1753695 more # Last… performance, what kind of hardware provides better balance of CPU vs IO utilization as well as as simple as how much…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
Amazon’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on…-disk threshold, as famously happens in B-Tree inserts (see InnoDB vs TokuDB for example). This doesn’t mean that we weren… minute, and some samples of more data such as SHOW INNODB STATUS. But I was on the client’s time and…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
… and report MySQL Optimizer Bug 
But now lets see in the difference of behavior of ANALYZE TABLE for MyISAM vs Innodb. I used…. Now let us populate antest_innodb table which is same but uses Innodb format: mysql> insert into antest_innodb select * from antest; Query OK… Innodb couple of more times to see how values change: mysql> analyze table antest_innodb; +——————–+———+———-+———-+ | Table | Op | Msg_type | Msg_text | +——————–+———+———-+———-+ | test.antest_innodb…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
…/docs/wiki/benchmark:fusionio:mysql:start, here are my thoughts and interesting facts. First, chart with results for InnoDB vs InnoDB-plugin during runs (values are in new order transactions per minute, more is better) : As you see InnoDB-plugin…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… is : innodb_flush_neighbor_pages = 0 innodb_adaptive_flushing_method = keep_average innodb_log_block_size = 4096 innodb_log_file_size = 4G Versions: MySQL 5… is a way to improve throughput in Percona Server: increase innodb_log_file_size. There are stability timeline for Percona Server with innodb_log_file_size=8GB And to aggregate results and provide…
