… this, a subsequent run of chef-client is done to update the cnf files with IP address of members (excluding itself… (we are adding one in 5.5.31), looking for optimizations with HAProxy to account for high connection rates, and using…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… SQL can produce an infinite variety of queries. The query optimizer analyzes queries for common patterns the MySQL designers know can… amount of engineer-years spent developing and testing the query optimizer. The developers have to make a decision about which query… another column, and reinitializing the sequence after making certain insert/update/delete operations. If you have a dataset that changes infrequently…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…. The SSB The SSB tests a database’s ability to optimize queries for a star schema. A star schema presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets of queries. Each… risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off [mysqld_safe] log-error=/var/log/mysqld.log pid…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… list when creating read views. However, the more general descriptors optimization in Percona Server showed fairly close results in our tests… on our tests setup and clarifies the scope of descriptors optimization. Server Configuration: [mysqld] user=root port=3306 innodb_status_file… –oltp-read-only=off –oltp-index-updates=0 –oltp-non-index-updates=0 run POINT_SELECT + UPDATE QPS test sysbench –num-threads=<1…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… after the upgrade was completed regardless of its state before updating. This caused some problems for some users, especially if automatic… and omitting the corresponding secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
…, TokuDB supports an upsert optimization that is applicable to your second test. Typically, the “insert on dup key update” statements do a… row exists, then the row is updated. Otherwise, the row is inserted. TokuDB has an optimization in which the point query is… since the cost of reads is amortized. TokuDB currently detected update expressions like x=x+c, where c is a constant…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… and omitting the corresponding secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was… fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would… documentation. Bugs can be reported on the launchpad bug tracker. UPDATE[18-04-2013]: There was a RPM packaging regression introduced…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
… cases. This optimization was not used in the benchmark. Since TokuDB does not currently support the VALUES update expression, the optimization was turned…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…-new pt-upgrade was written once long ago and not updated since. Now that we have four base versions of MySQL…). This feature is still in development while we determine the optimal JSON structure. Version check is on by default In 2…’s like a lot of software that automatically checks for updates, but it’s also more: it’s a free service…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… MySQL ecosystem is far from fragmenting, but 451 Research’s updated survey of database users indicates that the center of gravity… 10.0 & What’s New With the Project” Sergei Petrunia, Optimizer Developer, and Colin Charles, Chief Evangelist, MariaDB, for Monty Program…
