May 25, 2013

Presentations Announcement: 2010 O’Reilly MySQL Conference & Expo

April 29, 2010 By 4 Comments

The Percona team participated at this year’s O’Reilly MySQL Conference & Expo held April 12-15, 2010 in Santa Clara, California. We gave a lot of talks on…

Author: Peter Zaitsev, Justin Swanhart

MySQL Graphing and Trending with Cacti

Author: Baron Schwartz

Percona‘s Performance and Feature Enhancements to MySQL and InnoDB

Author: Bill Schuler, Baron Schwartz…a Bottleneck

Author: Morgan Tocker

XtraBackup Hot Backups and More

Author: Vadim Tkachenko, Morgan Tocker

You can also read more about this conference on Percona site.

Filed Under: Events and Announcements Tagged With: , , , , ,

Percona sessions at the MySQL conference

March 15, 2010 By 6 Comments

Many Percona employees will be at the 2010 MySQL conference. We’ll be giving a lot of informative technical talks on various topics. Here’s a list: Morgan Tocker, Baron Schwartz: Diagnosing and Fixing MySQL Performance Problems Peter Zaitsev: Scaling Applications with Caching, Sharding and Replication Baron Schwartz: EXPLAIN Demystified Vadim Tkachenko: An Overview of Flash Storage [...]

Filed Under: Events and Announcements, MySQL Tagged With: , , , ,

xtrabackup-0.8

July 1, 2009 By 8 Comments

Dear community, The release 0.8 of the opensource backup tool for InnoDB and XtraDB is available for download. Key features: New mode of innobackupex –stream=tar4ibd; new command tar4ibd based on libtar-1.2.11 Experimental option –export is added (see Vadim’s post “Impossible – possible, moving InnoDB tables between servers”for details) tar4ibd is made to be sure that [...]

Filed Under: Percona Software Tagged With:

Using INFORMATION_SCHEMA instead of shell scripting

November 24, 2008 By 7 Comments

INFORMATION_SCHEMA, in particular by favorite TABLES table is not only helpful to understand tables you have on the system, but I have also found it to be very helpful as a scripting language for variety of database administration tasks. It can be more straightforward compared to using shell or Perl when the operation is database [...]

Filed Under: Insight for DBAs Tagged With:

Recovery beyond data restore

August 2, 2008 By 11 Comments

Quite frequently I see customers looking at recovery as on ability to restore data from backup which can be far from being enough to restore the whole system to operating state, especially for complex systems. Instead of looking just at data restore process you better look at the whole process which is required to bring [...]

Filed Under: Insight for DBAs Tagged With: ,

Recovering Innodb table Corruption

July 4, 2008 By 21 Comments

Assume you’re running MySQL with Innodb tables and you’ve got crappy hardware, driver bug, kernel bug, unlucky power failure or some rare MySQL bug and some pages in Innodb tablespace got corrupted. In such cases Innodb will typically print something like this: InnoDB: Database page corruption on disk or a failed InnoDB: file read of [...]

Filed Under: Insight for DBAs Tagged With:

Monty unviels Maria and starts Blogging

January 29, 2008 By 4 Comments

This weekend we’re hearing great news from Michael “Monty” Widenius – one of the Fathers of MySQL. Monty finally found a time to create his own blog with very descriptive name Monty Says. At the same time Monty finally announces Maria – the MyISAM successor storage engine he has been working for last few years. [...]

Filed Under: Events and Announcements Tagged With: ,

Innodb Undelete and Sphinx Support

November 12, 2007 By 4 Comments

At Percona we are pleased to announce couple of services which should be helpful to MySQL Community and which are not offered by MySQL, Oracle and other companies I know about. First we now do Data Recovery for MySQL. We’re mainly focused on Innodb with this one because it has distinct page structure which allows [...]

Filed Under: Insight for DBAs Tagged With:

Add an option to Fail on Innodb Initialize failure, Please ?

October 11, 2007 By 9 Comments

I already wrote about this issue but as I is third team I’m helping customers to resolve this “frm corruption” issue it is the time to return to it again. During MySQL 5.0 release cycle the change was made so now MySQL does not stop if Innodb storage engine failed to initialize but starts properly… [...]

Filed Under: Insight for DBAs Tagged With:

Innodb Recovery Update – The tricks what failed.

May 24, 2007 By 3 Comments

As I wrote we had been recovering corrupted Innodb Tablespace and it is finally done now. As this was over than 1TB worth of data we really tried to avoid dumping the data and find some other way to recovery. Examining Innodb page content and crash information we figured out it should be page of [...]

Filed Under: Insight for DBAs Tagged With:
« Older Posts
Newer Posts »