by Peter Zaitsev | Aug 30, 2012 | Insight for DBAs, MySQL
I got the message in the morning today about the bug being fixed in MySQL 5.6.6…. which I reported in Early 2006 (while still being with MySQL) and running MySQL 4.1 I honestly thought this issue was fixed long ago as it was indeed pretty annoying. I must say...
by Aurimas Mikalauskas | Aug 29, 2012 | Insight for DBAs, MySQL
If you ever had a replication slave that is severely behind, you probably noticed that it’s not catching up with a busy master at a steady pace. Instead, the “Seconds behind master” is going up and down so you can’t really tell whether the...
by Justin Swanhart | Aug 28, 2012 | Insight for DBAs, MySQL
As an instructor with Percona, I’m sometimes asked about the differences between the REPEATABLE-READ and READ-COMMITTED transaction isolation levels. There are a few differences between them, and they are all related to locking. Extra locking (not gap locking)...
by Aurimas Mikalauskas | Aug 28, 2012 | Insight for DBAs, Insight for Developers
Spoiler alert: If your boss does not need an elephant, he is definitely NOT going to buy one from you. If he will, he will regret it and eventually you will too. I must appologize to the reader who was expecting to find an advice on selling useless goods to his boss....
by Roman Vynar | Aug 28, 2012 | Insight for DBAs, MySQL
You can use pt-query-digest to process a MySQL slow query log and store historical values for review trend analysis into query_review_history table. According to its official documentation you can populate many columns in that table but there are other important ones...
by Bill Karwin | Aug 24, 2012 | Insight for Developers, MySQL, Percona Events
I presented a webinar this week to give an overview of several Full Text Search solutions and compare their performance. Even if you missed the webinar, you can register for it, and you’ll be emailed a link to the recording. During my webinar, a number of attendees...
by Tim.Callaghan | Aug 23, 2012 | MySQL
The challenge of handling massive data processing workloads has spawned many new innovations and techniques in the database world, from indexing innovations like our Fractal Tree® technology to a myriad of “NoSQL” solutions (here is our Chief Scientist’s perspective)....
by Hrvoje Matijakovic | Aug 23, 2012 | MySQL
Percona is glad to announce the release of Percona Server 5.5.27-28.0 on August 23rd, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.27, including all the bug fixes in it, Percona Server 5.5.27-28.0 is now the...
by Peter Zaitsev | Aug 22, 2012 | MySQL, Percona Events
Call for papers is still open for Percona Live London 2012, but only for few more days. We’re looking for great talks relevant for MySQL Ecosystem it could be about MySQL and its variants as well as technologies which are used together with MySQL. Please...
by Tokutek | Aug 22, 2012 | MySQL
Businesses increasingly operate in a 24×7 environment, where complex analytics must be performed on live, continuously incoming “Big Data.” To address this, TokuDB has developed Fractal Tree® technology, a revolutionary new indexing capability that enables...
by Aleksandr Kuzminsky | Aug 22, 2012 | MySQL
In a very popular data loss scenario a table is dropped and empty one is created with the same name. This is because mysqldump in many cases generates the “DROP TABLE” instruction before the “CREATE TABLE”: DROP TABLE IF EXISTS `actor`;...
by Bill Karwin | Aug 21, 2012 | Insight for Developers, MySQL, Percona Events
Tomorrow, August 22 at 10:00am PDT, I’ll present a webinar called Full Text Search Throwdown. This is a no-nonsense performance comparison of solutions for full text indexing for MySQL applications, including: LIKE predicates and regular expressions MyISAM...
by Jay Janssen | Aug 17, 2012 | MySQL, Percona Software
Percona XtraDB Cluster (PXC) and the technology it uses (Galera) is an exciting alternative to traditional MySQL replication. For those who don’t know, it gives you: Fully Synchronous replication with a write latency increase equivalent to a ping RTT to the...
by Stewart Smith | Aug 16, 2012 | MySQL
I just posted this to the MySQL Internals mailing list: Hi all, Like many of you, I’m disappointed that the bzr trees for MySQL are out of sync with the tarball source and binary releases from Oracle. Since Oracle has been silent on this, and this is a recurring...
by Peter Zaitsev | Aug 16, 2012 | Insight for DBAs, MySQL
I had a lot of questions on my MySQL Indexing: Best Practices Webinar (both recording and slides are available now) We had lots of questions. I did not have time to answer some and others are better answered in writing anyway. Q: One developer on our team wants to...
by kuszmaul | Aug 14, 2012 | MySQL
Next week I (Bradley) will be traveling to FROSCON near Bonn, Germany, and then on to VLDB in Istanbul. At FROSCON I’ll be talking about fast data structures for maintaining indexes. The talk will share some content with my upcoming MySQL Connect talk. At VLDB,...
by Stewart Smith | Aug 14, 2012 | Percona Software
We are very happy to announce our first alpha of Percona Server 5.6. Based on MySQL 5.6.5 and all the improvements contained within, this is the first step towards a full Percona Server 5.6 release. Binaries are available to download from our downloads site...
by Stewart Smith | Aug 14, 2012 | Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.0.2 on August 13th, 2012. Downloads are available from our download site here and Percona Software Repositories. This release is the current GA (Generally Available) stable release in the 2.0 series. Bugs...
by David Hildebrandt | Aug 13, 2012 | MySQL, Percona Events
Ensuring that everyone has a chance to attend Percona’s training for MySQL, we are announcing the following dates for Europe. The dates for Europe are: Live Virtual Training: Developer Training for MySQL Begins Monday, August 27, 2012 , 9am – 11am,...
by Aleksandr Kuzminsky | Aug 10, 2012 | Insight for DBAs, MySQL
Recently I had a case when a customer deleted the InnoDB main table space – ibdata1 – and redo logs – ib_logfile*. MySQL keeps InnoDB files open all the time. The following recovery technique is based on this fact and it allowed to salvage the...
