… on the query optimizer and the MySQL version, we always recommend to check manually the optimizations proposed by Percona Toolkit. The MySQL server, of course, cannot risk to block directly all cases. A set of MySQL utilities…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage… some unique challenge to the database optimizer. The SSB benchmark consists of four sets of queries. Each set is known as a “flight… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still register… about using a temporary table to store an interim result set, and then use that to ultimately produce the result you… an infinite variety of queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be improved. But there…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… nothing wrong with a virtual-machine approach, but for the optimal production deployment you want two identical physical boxes with at… it. One way is to set up replication filters on the slave, as described in the MySQL manual. You can configure the… the SQL nodes in a MySQL Cluster installation are going to be talking to the same set of data nodes on the…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built with YaSSL which could… with Perl and Python clients when plugin-dir option was set in the [client] section of the my.cnf. Bug fixed… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… presentation you’ll learn how to perform typical but challenging MySQL database administration tasks. My focus will be on the following… for MySQL That Could Save Your Day”Percona Toolkit for MySQL is a must-have set of tools that can help serious MySQL administrators… solve typical, real-world MySQL database administration challenges, such as: Selecting which queries you should try to optimize to get better response…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built with YaSSL which could… with Perl and Python clients when plugin-dir option was set in the [client] section of the my.cnf. Bug fixed… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… which set innodb_lock_wait_timeout because that now conflicts, or is at least confused with, lock_wait_timeout (introduced in MySQL 5.5) for metadata locks. Now –set-vars is used to set both of these (or any…). This feature is still in development while we determine the optimal JSON structure. Version check is on by default In 2…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… lot of time opening all the tablespaces. Optimization has been implemented and XtraBackup now avoids … dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from … innobackupex would fail if the SQL_MODE was set to ANSI_QUOTES. Bug fixed #945161. Missing …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… designed to look solely at vCache performance under some different sets of MySQL configuration parameters. For example, given that the front-end… more sense to configure MySQL as if it were using SSD storage or to just use an optimized HDD storage configuration? After creating a vCache device with the default configuration, I started with a baseline HDD configuration for MySQL…
