…to 6.4, upgrading your distribution to 6.4 may break your cluster. In this post I will explain you how to…to update all nodes to Pacemaker 1.1.8 but to avoid again issues with the next distribution update, I prefer to use…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql-connector-java… to his wife 
Finally don’t forget to automate SchemaSpy via crontab once you’re done. What are some ERD tools you use and how…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
…, our VP of Consulting, will explain how to work with BigData effectively Justin Swanhart, our Senior MySQL Instructor, will continue the topic of… detail about using pt-table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch will share with how MySQL can be used to provide access to government…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… tools for MySQL. In this presentation, you will learn how you can use some of these tools to solve typical, real-world MySQL database administration challenges, such as: Selecting which queries you should try to optimize to get better response times How to…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… do we need a new tool anyway? It is absolutely critical to have an accurate table definition to ensure a successful recovery. Even… it is still zero. If you know how InnoDB uses `PREC` please let me know. mysql> select * from SYS_COLUMNS WHERE TABLE_ID… the dictionary tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA INFILE ‘/path/to/SYS_FIELDS’ REPLACE INTO…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…. In practice, it’s slightly more complicated. To manage this process, we use a tool co-developed with Percona. “Warm standby server”? Did…, via HTTP, by mysql_slowlogd. This daemon is similar to running `tail -f slow.log`, except that it knows how to follow the log… to prevent INSERTs, UPDATEs, and DELETEs from corrupting the data on the standby server. You will need Percona Server in order to use…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
…MySQL is a tool for replaying the load of one database server to another. Currently it can read queries from MySQL query-log and MySQL…used for dispatching queries to MySQL database servers. This feature introduces new –thread-pool-threads-count option, which can be used to…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… and versions. When you upgrade to MySQL 5.6, be sure to upgrade to Percona Toolkit 2.2, too…simpler and far easier to use. It’s basically what you expect from such a tool. Moreover, it …to limit how long they run. There are more changes in addition to those highlights. For example, three tools were…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… the best response times (MySQL server does not use multiple threads to execute query in parallel at … be compared with this baseline to see how they are affected and how the system scales with… the same tool is not possible. Want to talk more about performance? Come to Percona Live MySQL Conference …
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…
