As the part of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance results I’ve been looking at changes ….30 | 5.6.10 | | INNODB_CONCURRENCY_TICKETS | 500 | 5000 | | INNODB_PURGE_THREADS | 0 | 1 | | INNODB_OPEN_FILES | 300 | 2000 | | INNODB_DATA_FILE_PATH | ibdata1… | | INNODB_PURGE_BATCH_SIZE | 20 | 300 | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE…
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 13 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: 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: 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…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
… 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…. Profiling MySQL 5.0 vs MySQL 4.1 couple years ago, I have seen biggest performance hit comes from query parser. In MySQL 5…
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 … compute number of latched pages in Innodb Buffer Pool, which is called when you run SHOW INNODB STATUS and SHOW STATUS. In… 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…
