… TABLE `test`.`test` DROP INDEX `col2`; # ######################################################################## # Summary of indexes # ######################################################################## # Size Duplicate Indexes 5 # Total Duplicate Indexes 1 # Total Indexes 3 Additionally, pt…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
….7[/caption] Percona is glad to announce the release of Percona Server 5.1.69-14.7 on June 10, 2013. A…-source and free, all the details of the release can be found in the 5.1.69-14.7 milestone at Launchpad… dependencies when installing Percona Server 5.1. Bug fixed #893860. The log tracker thread was unaware of the situation when the oldest…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… readiness. There have been some unfortunate performance regressions compared to 5.5, such as bug #69258, and bug #69318, and I think… that in the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might…, honestly, why would you ever want to use MySQL on top of something like that? I can’t imagine the performance being…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… is glad to announce the first Release Candidate release of Percona Server 5.6.11-60.3 on June 3rd, 2013 (Downloads… is the first RC release in the Percona Server 5.6 series. All of Percona’s software is open-source and free, all the details of the release can be found in the 5.6.11-60.3 milestone at Launchpad…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… are expected. This is the second post of a series of articles focused on MySQL 5.6 GTIDs. You can find part one… = 1? Let’s hope so, as it is one of the ideas of GTIDs: having for each event across the cluster a… mysqlfailover from the MySQL Utilities (this will be the topic of a future post). Unfortunately, this will not work for every…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
…-engineered, poorly-performing, and/or various other flavors of suboptimal. On Wednesday, June 5, at 10 a.m. PDT (1700 UTC), I… technical and non-technical in nature, beginning with a discussion of some general HA principles and some common misconceptions. We will then explore some of the more well-known MySQL HA tools and technologies available…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…[/caption] Percona is glad to announce the release of Percona Server for MySQL 5.5.31-30.3 on May 24, 2013 (Downloads… 5.5 series. All of Percona’s software is open-source and free, all the details of the release can be found in the 5.5…. Bug fixed #1179978. Release notes for Percona Server for MySQL 5.5.31-30.3 are available in our online documentation. Bugs…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… the database optimizer. The SSB benchmark consists of four sets of queries. Each set is known as a “flight… when the database is cold, but uses less CPU time when the database is hot. I am …at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema …
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make the life of DBAs…. This post is the first one of a series of articles focused on the implications of enabling GTIDs on a production setup. The… two slaves, all running MySQL 5.6 with GTIDs disabled. First try: configure only one of the servers with GTIDs Let’s…
Comment: Converting Character Sets
June 12, 2013 By 22 Comments
…/doc/refman/5.1/en/alter-table.html “For a column that has a data type of VARCHAR or one of the TEXT… characters as the original column.” [followed by a complete explanation of why TEXT coverts to MEDIUMTEXT] Maybe something changed since this…
