… suite of administrative tools for MySQL. With this release we introduce a new version of pt-online-schema-change, a tool that enables you to ALTER large tables with no blocking or downtime. As you know, MySQL locks tables for most ALTER… these tools rapidly, for example, to support new types of RAID controllers. Percona Toolkit is a hot topic at the upcoming MySQL Conference…
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
… GUI tool. For the visual browsing of tables created by pt-query-digest you may want to use some kind of web tools… and post reviews. Box Anemometer Anemometer is a tool for visualizing collected data from the MySQL Slow Query Log. The name comes from… them into a database for reporting. Personally, I find this tool as an advanced instrument that could be useful for: * browsing queries with…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
… new version comes with some pretty cool news: Beta support for MySQL 5.6 (which as you might know is also in… plan on running the tools on Percona XtraDB Cluster or MySQL 5.6 are advised to upgrade. The following tools have been verified… regardless of the server or MySQL time zone. Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… good idea. It also often helps with monopolizing replication thread. For example if I need to delete old data instead of…
Post: Upcoming webinar on Data Recovery for MySQL
April 6, 2011 By 5 Comments
… minute long webinar on 26th of April on data recovery for MySQL. Almost every long serving DBA has been faced with the…. Attendance is free. What you can learn by attending: * Prepare for recovery (prerequisites) * Preparing your data * Identifying the structure and state… from recovered data During this Webinar the Percona-InnoDB-Recovery-Tool will be used on Linux. To register: https://percona-events…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… the Percona team members have built a good set of tools for doing this on Linux. It is no harder in principle… up and use the tools. The tools are all part of the Aspersa toolkit. There are three primary tools for troubleshooting intermittent problems: stalk…. There are many things that can cause a stall in MySQL, and they usually begin microscopically and get worse over time…
Page: Tools
May 30, 2008 By 31 Comments
… Toolkit is a great set of tools for MySQL Performance Analyses and maintainence. Must know and have for any MySQL User. mysqladmin mysqladmin extended -i100… pt-query-digest appeared. innotop Innotop is great top like tool for MySQL and is helpful even if you do not use Innodb…. These can be very different. drtace Dtrace is a great tool for system level performance analyses, with a catch of it being…
Post: Optimize Your SQL With Percona's Online Query Advisor!
February 15, 2012 By 23 Comments
… there’s a tool to help you find them. This is the second addition to our online suite of tools for MySQL users. You… tool uses the same account that you might have already created for our online MySQL Configuration Wizard, which helps you choose good settings for your server. Give it a try, and tell your friends! Enjoy hunting for…
Post: Percona Toolkit 2.0.1 and 1.0.2 released
January 3, 2012 By 5 Comments
… major step forward in our plans to create excellent free tools for MySQL administrators. There is one really big thing to talk about… to Daniel Nichter for his diligent coding as we spec’ed, revised, tested, spec’ed again, and tried the tool in some… a few minor bug fixes. For the next release, we’re completely redesigning and rewriting several other tools, which will be equally…
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
Running EXPLAIN for problematic queries is very powerful tool for MySQL Performance optimization. If you’ve been using this tool a lot you probably noticed… sort of key_cache as it can for MyISAM. EXPLAIN may take long time In MySQL 5.0 with addition of greedy… from other tables. No information about using disk for sort or temporary tables MySQL always calls it “filesort” even if it is…
