… 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: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… 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: 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: 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: MySQL/Innodb scalability tests after fix
January 3, 2007 By 1 Comment
… something obvious in MySQL settings as well as to let them know the fix is now out for Innodb scalability bug and… any difference. Recently Tweakers.net published comparison of MySQL 5.0.20a vs 5.0.32bk as well as matching PostgreSQL 8… Innodb scalability patch. 2) Speedup for 5.0.32 for large number of CPUs (2x quad line) is significant – 350 tps vs…
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: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
… wanted to check how MySQL / InnoDB performs here. For benchmark I took MySQL 5.1.42 with built-in InnoDB, InnoDB-plugin 1.0.6…/docs/wiki/benchmark:fusionio:mysql:start, here are my thoughts and interesting facts. First, chart with results for InnoDB vs InnoDB-plugin during runs… ( about 88% worse than all files on FusionIO) To summarize MySQL InnoDB/InnoDB-plugin/XtraDB is not fully able to utilize throughput of…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… run in production relaying on MySQL Replication for HA I often have 15+ minutes reply of Innodb Transactional log which would be…. First – hot vs cold. If you’re using decent hardware and care about performance you use O_DIRECT with Innodb which makes… transaction loss and automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to have some compromises.
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…
