… about the importance of performance at low concurrency. The SSB The SSB tests a database’s ability to optimize queries for a…/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…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…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…with a virtual-machine approach, but for the optimal production deployment you want two identical physical boxes… want to use MySQL on top of something like that? I can’t imagine the performance being all… server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table… fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table… fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance…mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is… XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps… are thousands of tables and slow IO then XtraBackup can spend a lot of time opening all the tablespaces. Optimization has been…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… produce the most optimal results, I moved on to reviewing FlashCache performance versus that …mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…mysql> show table status like “post_channel” \G *************************** 1. row *************************** Name: post_channel Engine: InnoDB…TABLE on this table which essentially performs data and indexes scan which will be reflective to large full table…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… indexing space. Is this a reasonable performance optimization. (Keep in mind that the prefix…TABLE LINK (id1 int unsigned not null ,id2 int unsigned not null, PRIMARY KEY(id1,id2), KEY K(id2)) engine=INNODB; when table… also would note there are some MySQL optimizer restrictions in how well it can…
