A customer had an interesting (and rather urgent) request recently. I thought I'd share as it might be of interest to someone else.
The issue was something a lot of us have run into, a query that was never supposed to be run. This time, it was a rather devestating "DELETE FROM table_a;".
The only backup available was made several hours AFTER the erronous statement, so what we had left to work from was the table_a.idb file. Based on file size alone, it should contain most of the data, so we set to work.
This was a job suited for the Percona InnoDB Data Recovery Tool.
Getting the table definition from my customer, I created an identical table on a local mysql server then used the create_defs.pl script to create a table_defs.h file.
$ ./create_defs.pl --host=localhost --user=root --db=test --table=table_a > table_defs.h …

I've got interviewed on authentication API :)

Read all about it here

I've got interviewed on authentication API :)

Read all about it here

Percona is sponsoring RailsConf again this year, and we’ll be at booth #110 in the expo hall. Use our discount code to save 20% off the ticket price: rc11mysql. We hope to see you there! (Sadly, we didn’t get any sessions accepted this year, so we won’t be speaking. Maybe next year.)

There are plethora of thrilling business software trends on the horizon as the summer of 2011 starts. Many of these will significantly impact IT organizations seeking to align IT operations with business objectives. Awareness of such trends can help you to keep ahead of the competition. What better way to get abreast of these trends in a nutshell than the Log Buffer? Log Buffer #219 is in your hands to enjoy.

Oracle:

When Arup writes it, it stays written. In a very refreshing post, he is sure to convince anybody why he or she needs Tanel Poder’s class.

…

The Open DB Camp in Sardinia 2011 has had a number of sessions on varying topics. Topics range from MySQL over MongoDB to replication and High Availability.

I decided to tap into the database expert resources present here at Sardegna Ricerche by discussing a non-database issue, where one can expert database experts to have insights beyond those of end users. And they did.

The topic was the particular case of information overload many of us suffer from on our hard disks: Too many files, too hard to find.

• How do we find the bank statement from April 2007 from the more-seldom-used account?
• What are the ten best work-related pictures from last year?
• Is this the most current …

In March I posted a series of blog posts on my paternity leave MepSQL project, which I called MepSQL. There was still one piece created in the MepSQL buildsystem that I didn't publish or blog about. Since it is generally useful, I wanted to generalize and polish it and publish it separately. I finally had that done last week, when I also found that somebody else, namely alestic.com already published a similar solution 2 years ago. So yesterday I ported my BuildBot setup to use that system instead and am happy to publish it at the Open DB Camp 2011 in Sardinia.

Ok, so let's go back a little... What is the problem we are solving?

Let's …

Permalink: http://bit.ly/QuBLVB



Read part 1 for the rationale behind the code.

As discussed in the first part of this blog entry, we'll be utilizing a statement that uses base 36 to generate the random name. We will be adding the $ and _ characters using the ELT function. Here is a true random database and table name generator:

DELIMITER $$
DROP FUNCTION IF EXISTS `randomNameGenerator` $$
CREATE DEFINER=`root`@`localhost` FUNCTION `randomNameGenerator`(
 ) RETURNS varchar(64) CHARSET utf8
BEGIN
 DECLARE numberOfChars, charDiceRoll TINYINT(2);
 DECLARE charCount TINYINT DEFAULT 0;
 DECLARE randomChar CHAR(1);
 DECLARE randomName VARCHAR(64) DEFAULT '';
 …

Shard-Query is an open source tool kit which helps improve the performance of queries against a MySQL database by distributing the work over multiple machines and/or multiple cores. This is similar to the divide and conquer approach that Hive takes in combination with Hadoop. Shard-Query applies a clever approach to parallelism which allows it to significantly improve the performance of queries by spreading the work over all available compute resources. In this test, Shard-Query averages a nearly 6x (max over 10x) improvement over the baseline, as shown in the following graph:

One significant advantage of Shard-Query over Hive is that it works with existing MySQL data sets and queries. Another advantage is that it works with all MySQL …

We’ve given discount coupon codes to all of our Percona Live sponsors, so watch the Twitter tag #perconalive to find discount announcements. Here’s the list of sponsoring organizations: Clustrix Vork Continuent Fusion-io Infobright Pentaho Schooner Information Technology SkySQL Virident …