…to 6.4, upgrading your distribution to 6.4 may break your cluster. In this post I will explain you how to…to 1.18. You can also follow the official documentation here. The version…
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…impact on how SchemaSpy identifies the relationship, and whether you need to provide … I used to properly link child_A to parent table: version=”1.0″… is basically a quick sanity check of your schema for any…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… HTTP, by mysql_slowlogd. This daemon is similar to running `tail -f slow.log`, except that it knows how to follow the…features to Percona Playback to make it work better for this use case. You will need version 0.6 or later to…of the graph lines up with the blue part. Check back Thursday for Part 2!…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… for it. Check out the Percona Toolkit supported platforms and versions. When you upgrade to MySQL 5.6, be sure to upgrade to Percona Toolkit 2… specify –iterations or –run-time to limit how long they run. There are more changes in addition to those highlights. For example, three…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…New Features: This version of Percona XtraBackup has implemented full support for new MySQL 5.6…Making the interval configurable allows to reduce the time between checks which can prevent XtraBackup…MySQL and Percona Server 5.6 with the GTID mode enabled. Example of how this information can be used to…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…New Features: This version of Percona XtraBackup has implemented full support for new MySQL 5.6…Making the interval configurable allows to reduce the time between checks which can prevent XtraBackup…MySQL and Percona Server 5.6 with the GTID mode enabled. Example of how this information can be used to…
Post: How to check MySQL Config files
February 12, 2008 By 7 Comments
… SET GLOBAL command to do it in run time) but either because option is misspelled or because given version does not support such option the server when would refuse to start when it restarted, either… nasty. Unlike Apache MySQL service control script does not have “configtest” option so there is no straight way to check MySQL config file for…
Comment: Where to get recent MySQL version ?
December 29, 2006 By 86 Comments
You can easily find your MySQL’s version number using any of the different methods explained in this tutorial –> http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/how_to_check_mysql_version_number.php
Post: MongoDB Approach to Availability
April 30, 2010 By 2 Comments
… compare it to technologies in MySQL space. First I think MongoDB is best compared no to MySQL Server but MySQL Cluster, especially in newer versions which… for them to stabilize as well as later develop tools around them. How to check if 2 MongoDB nodes are indeed in sync ? How to do…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… and check cardinality) Different stats can often cause different plans. Run ANALYZE TABLE on both MySQL Versions to see if you can get statistics to… changing how query is written and provide the hints. Check Query Execution If query execution plan looks the same it is good to check…
