Here at 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… or a foreign key. This is the output of our tool when run on the same table, correctly identifying the redundancy…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… of the MySQL Community: Vadim Tkachenko, Percona co-Founder and CTO, will talk about Percona XtraDB Cluster, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of… using pt-table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch will share with how MySQL can be used to…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
…the others, the resulting system may be over-engineered, poorly-performing, and/or various other flavors of suboptimal. On Wednesday, June…-known MySQL HA tools and technologies available today (largely grouped into those which use traditional MySQL replication, those which use some other MySQL-level…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… see bellow how to perform this action [root@percona1 percona]#…MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…your cluster using cman_tool or clustat (if you have …
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
…. This time I want to target an opposite question: why MySQL performance at low concurrency is important for you. I decided to… posts and articles look at MySQL performance starting with certain concurrency as the low point. For example, MySQL 5.6 DBA and Developer… 1 and the same tool is not possible. Want to talk more about performance? Come to Percona Live MySQL Conference and Expo April…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… Percona Toolkit Tools for MySQL That Could Save Your Day.” In this presentation you’ll learn how to perform typical but challenging MySQL database… Tools for MySQL That Could Save Your Day”Percona Toolkit for MySQL is a must-have set of tools that can help serious MySQL administrators perform…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… MySQL on April 9, 2013. Downloads are available from our download site and Percona Software Repositories. Percona Playback for MySQL is a tool for replaying the load of one database server to another. Currently it can read queries from MySQL query… or schema change can affect the overall performance of your MySQL database server. Percona Playback for MySQL can also help evaluate new server…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
…their database server, leading to degraded application performance, and sometimes even short moments of downtime….of connections. Enter pt-query-digest. The tool supports its share of format parsers, … regularly work with MySQL databases, getting familiar with Percona Toolkit for MySQL will let you do…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… templates, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added performance data to Nagios plugins (bugs 1090145, 1102687) * Added UTC option to pmp-check-mysql-replication-delay to be… of Percona’s Remote DBA installation and setup of these tools are included with our services. You can find links to…
Comment: Webinar: MySQL 5.6 Performance Schema
May 16, 2013 By 5 Comments
… slides to reference/search in directly while trying out the MySQL Performance Schema tool myself. Thanks for your help 
Zoe
