…. If you try to do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE…`.`test` DROP INDEX `col2`; # ######################################################################## # Summary of indexes # ######################################################################## # Size Duplicate Indexes 5 # Total Duplicate Indexes 1 # Total Indexes 3 Additionally, pt-duplicate…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… [root@percona1 percona]# cat /etc/redhat-release CentOS release 6.4 (Final) [root@percona1 ~]# rpm -q pacemaker pacemaker-1.1.8…_mysql:2 ] Now we can upgrade all servers to 6.4 [root@percona2 percona]# yum -y update [root@percona3 percona]# yum… nodes that were updating, they are now updated to 6.4: [root@percona3 percona]# cat /etc/redhat-release CentOS release 6…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
…, and/or various other flavors of suboptimal. On Wednesday, June 5, at 10 a.m. PDT (1700 UTC), I will be…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.5.31-30.3[/caption] Percona is glad to announce the… here and from the Percona Software Repositories). Based on MySQL 5.5.31, including all the bug fixes in it, Percona Server…. Bug fixed #1179978. Release notes for Percona Server for MySQL 5.5.31-30.3 are available in our online documentation. Bugs…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
…mathew: Wrong, it’s still the same in 5.5. Here is the related output from show engine innodb status: —… rows, thread declared inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row… NULL) group by ld.label_id, cai.inventory_id All 4 tables in the query are locked!
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only… substantially faster than InnoDB both cold and hot. SSB Flight #4 There is one query in this flight, Q4.3, which… better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make… configuration with one master and two slaves, all running MySQL 5.6 with GTIDs disabled. First try: configure only one of…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 11, 2013 By 3 Comments
… dir. But check http://www.percona.com/doc/percona-server/5.1/compatibility.html if you’re planning to switch back… of compared features: http://www.percona.com/doc/percona-server/5.1/feature_comparison.html 3) we’re not planning to…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… versions I was using on my test VM: Percona Server 5.5.30 Xtrabackup 2.0.6 Some other use cases that…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… Monday, June 17, 2013 , 9am – 5pm Eastern Moving to MySQL 5.6 – Manchester, UK Begins Monday, June 17, 2013 , 9am – 5pm In July we have: Moving to MySQL 5.6 – Utrecht, Netherlands Begins Monday, July 1, 2013 , 9am – 5pm… Begins Monday, July 22, 2013 , 9am – 5pm Moving to MySQL 5.6 – Belfast, IE Begins Thursday, August 1, 2013 , 9am – 5pm…
