June 18, 2013

Post: Implementing SchemaSpy in your MySQL environment

…5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610… properly link child_A to parent table: version=”1.0″ encoding=”UTF-8″?> check of your schema for any significant errors or…

Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4

…percona1 – partition with quorum Version: 1.1.7…Checking if cluster has been disabled at boot… [ OK ] Checking Network …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

Post: The small improvements of MySQL 5.6: Duplicate Index Detection

… 1 row in set (0.00 sec) In previous versions of MySQL, you can create two indexes with the same columns (in… be disallowed in a future release” means. In MySQL 5.7 the checks will be stricter: in the default SQL mode, a… query optimizer and the MySQL version, we always recommend to check manually the optimizations proposed by Percona Toolkit. The MySQL server, of course, cannot…

Post: Percona Server 5.6.11-60.3 first Release Candidate now available

… id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona is glad to… available here and from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it… fixed #1186831. Reduced the overhead from the Handle Corrupted Tables check as it was missing branch predictor annotations. Bug fixed #1176864…

Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

… to export databases, you can use the existing mysql data dir. But check http://www.percona.com/doc/percona-server/5.1….html 3) we’re not planning to release the windows versions of Percona Server at the moment

Post: Percona Server for MySQL 5.5.30-30.2 now available

… Server for MySQL version 5.5.30-30.2[/caption] Percona is glad to announce the release of Percona Server for MySQL 5…. Bug fixed #710799 (Alexey Bychko). Debian packages included the old version of innotop. Fixed by removing innotop and its InnoDBParser Perl… Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed…

Post: Is your MySQL buffer pool warm? Make it sweat!

…3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-…work better for this use case. You will need version 0.6 or later to get these features. …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

…. Now that MySQL 5.6 is GA, so is our support for it. Check out the Percona Toolkit supported platforms and versions. When you upgrade to MySQL 5.6, be sure… are two versions of the DBD::mysql Perl module that have problems. And there are certain versions of MySQL that have critical bugs. Version check will…

Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download

… time of writing). New Features: This version of Percona XtraBackup has implemented full support for new MySQL 5.6 features (GTID, remote… either automatically on startup or on demand. Time interval between checks done by log copying thread is now configurable by innobackupex… fixed #1169726. For the Debian and the Linux binaries, the –version message which should include the revision was showing “undefined”. Bug…

Post: Percona XtraBackup 2.0.7 for MySQL available for download

… 2.0 series. New Features: This version of Percona XtraBackup has implemented full support for new MySQL 5.6 features (GTID, remote… either automatically on startup or on demand. Time interval between checks done by log copying thread is now configurable by innobackupex… fixed #1169726. For the Debian and the Linux binaries, the –version message which should include the revision was showing “undefined”. Bug…