… using only the InnoDB storage engine. In my testing I discovered that innodb_old_blocks_time had an effect on performance of the…. A star schema presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets of queries. Each… InnoDB. Like the queries in Flight #3 that are faster using MyISAM, Q4.3 examines very little data. It seems that InnoDB performs…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer improvements. However, I…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…volume. So, in effect, you’re adding performance hit to performance hit. The other reason is because virtual…with a virtual-machine approach, but for the optimal production deployment you want two identical physical …-tables and insert a few rows into an InnoDB table, but trying to run a simple …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…of descriptors optimization. Server Configuration: [mysqld] user=root port=3306 innodb_status_file=0 innodb_data_file_path=ibdata1:100M:autoextend innodb_flush_…= 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
One major problem in terms of MySQL performance that still stands in the way of InnoDB scalability is the trx_list scan… not always applicable or possible in practice. The “trx descriptors” optimization in Percona Server attacks this problem from a different (and… alpha stage. We are going to blog about other MySQL performance improvements introduced in our latest Percona Server release, stay tuned…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… there is another issue in InnoDB transaction processing that notably affects MySQL performance – for every transaction InnoDB creates a read view and allocates…goes through the InnoDB heap layer – so InnoDB allocates heap area and then creates requested block(s) there. That optimization helps to …
Post: What I'm looking forward to at Percona Live (MySQL Users Conference)
April 4, 2013 By 1 Comment
… Panel sessions I will give an Innodb and Performance Optimization Tutorial as well as talk about Goal-Driven Performance Optimization and Choosing storage systems for…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… C appeared to produce the most optimal results, I moved on to reviewing FlashCache performance versus that of vCache, and …#####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table… Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table… Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would…
