… administrative tools for MySQL. With this release we introduce a new version of pt-online-schema-change, a tool that enables you to ALTER… Daniel will talk about using it to verify replication Peter will discuss using it to verify upgrades I’ll show how to use it to forecast scalability and…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… it is related to connections and identified application which causes excessive memory usage you might look at how it uses MySQL to identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements ? memory… complicated as good tools to detect memory leaks like valgrind are too slow to run in production. So the best thing to do in…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…to complete. Here is example how it can look: mysql> show processlist; …tools used by mysql client, so you might get a feel you can’t connect to the database at all (use mysql -A in this case, to…
Post: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference & Expo 2012 PRM is an… box I used in the previous post (Testing Percona XtraDB Cluster with Vagrant). In the follow “terminalcast” you can see how to deploy the setup and some basic commands to check and manage your cluster:
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… to the tools might be needed on other platforms. The rest of this blog post is about how to set up and use the tools. The tools… together some screencasts illustrating how to use these tools. I think that’ll be an easier and more fun way to learn them. I have… Percona.TV, our MySQL video/screencast blog site. Another interesting topic is how to examine a system that appears to be fine and determine…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
… question is when or how to use MySQL not just if it should be used or not. There are many applications when MySQL works great, when… one of mentioned reasons to use MySQL was MySQL simplicity and I’m afraid this is what is gradually leaving us. MySQL 4.0 was… tool set and DBAs which can resolve all MySQL issues with help of Google rather than MySQL Support Team. You also may want to…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
…doesn’t work. How can I recover deleted rows? We’re going to follow the …tool that we’re going to use to achieve this objetive is Percona Data Recovery Tool for InnoDB. This is the tool that we use…step is to import it in our database: mysql (employees) > LOAD DATA INFILE ‘/root/recovery-tool/data/…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
… long time to execute, for example if plan is different based on constants. How to use this tool set ? First be aware this patch to MySQL is not official and should be used with caution. We…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… need to include others as well. Here’s how you can use our new monitoring plugins to …tool, if you choose), and actual failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql… to a query. The pmp-check-mysql-status is also very flexible and can be used to…
Post: Three ways that the poor man's profiler can hurt MySQL
December 2, 2011 By 19 Comments
…, Domas’s technique of using GDB as a profiler has become a key tool in helping us analyze MySQL when customers are having… more users, and how much less intrusive they can be. Of course, I’m really waiting for MySQL 5.6 and the… technique such as using GDB. We’ll probably never stop using GDB completely, but hopefully we’ll be able to use such tools much less…
