by Jervin Real | Feb 2, 2012 | Insight for DBAs
DELETE IGNORE suppresses errors and downgrades them as warnings, if you are not aware how IGNORE behaves on tables with FOREIGN KEYs, you could be in for a surprise. Let’s take a table with data as example, column c1 on table t2 references column c1 on table t1...
by Tim.Callaghan | Feb 2, 2012 | MySQL
I’ll be speaking on April 11th at 4:30 pm in Room 4 in at the Percona Conference and Expo Talk. The topic will be “Creating a Benchmark Infrastructure That Just Works.” Throughout my career I’ve been involved with maintaining the performance of...
by Baron Schwartz | Feb 1, 2012 | Insight for DBAs, MySQL
An attendee to Espen’s recent webinar asked how to check tables for corruption. This kind of ties into my recent post on InnoDB’s handling of corrupted pages, because the best way to check for corruption is with CHECK TABLES, but if a page is corrupt,...
by Peter Zaitsev | Jan 30, 2012 | MySQL, Percona Events
I’ll be presenting at MySQL Meetup in Raleigh,NC February 21,2012. The talk with be about Optimizing MySQL Configuration which I believe is a great topic for my first talk at this meetup group as it covers something every MySQL user has to deal with, also being...
by Tim.Callaghan | Jan 26, 2012 | MySQL
iiBench measures the rate at which a database can insert new rows while maintaining several secondary indexes. We ran this for 1 billion rows with TokuDB and InnoDB starting last week, right after we launched TokuDB v5.2. While TokuDB completed it in 15 hours, InnoDB...
by Baron Schwartz | Jan 26, 2012 | Insight for DBAs, MySQL
We’ve released an updated version of the MySQL Configuration Wizard we announced at the end of last year. If you don’t remember that announcement, here’s the short version: this is a tool to help you generate my.cnf files based on your server’s...
by Miguel Angel Nieto | Jan 25, 2012 | Insight for DBAs, MySQL, Percona Software
Sometimes we need to restore only some tables from a full backup maybe because your data loss affect a small number of your tables. In this particular scenario is faster to recover single tables than a full backup. This is easy with MyISAM but if your tables are...
by Peter Zaitsev | Jan 25, 2012 | MySQL, Percona Events
I am pleased to announce the schedule for Percona Live: MySQL Conference And Expo 2012 is now published. This is truly great selection of talks with something for MySQL Developers, DBAs, Managers, people just starting to use MySQL as well as looking for advanced...
by Stewart Smith | Jan 24, 2012 | Insight for DBAs, Insight for Developers
I spent last week at linux.conf.au in Ballarat, Victoria (that’s the Victoria in Australia, not wherever else there may be one) which is only a pleasant two hour drive from my home town of Melbourne (Australia, not Florida). I sent an email internally to our...
by Espen Braekken | Jan 24, 2012 | MySQL, Percona Events
On the 25th of January at 10 am PST, I will present a webinar on preventing MySQL emergencies titled “Preventing Downtime in Production MySQL Servers”. The material I will present is based on in-depth research done by Percona across many production servers. We...
by Peter Zaitsev | Jan 20, 2012 | MySQL, Percona Events
If you’ve missed Percona Live in Washington,DC and even if you did not you should be happy to know we have now published slides from majority of talks at this conference. Enjoy! This conference had great talks, whenever you’re Beginner or Advanced when it...
by Martin.FarachColton | Jan 19, 2012 | MySQL
TokuDB® v5.2, the latest version of Tokutek’s flagship storage engine for MySQL and MariaDB, is now available. This version offers performance enhancements over previous releases, especially for multi-client scale up and point queries, and extends the cases...
by Vadim Tkachenko | Jan 19, 2012 | Insight for DBAs, MySQL, Percona Software
This is about the second great feature – Multi-Master replication, what you get with Percona XtraDB Cluster. It is recommended you get familiar with general architecture of the cluster, described on the previous post. By Multi-Master I mean the ability to write...
by Tamas Kozak | Jan 18, 2012 | Insight for DBAs, MySQL
Backing up binary logs are essential part of creating good backup infrastructure as it gives you the possibility for point in time recovery. After restoring a database from backup you have the option to recover changes that happend after taking a backup. The problem...
by Vadim Tkachenko | Jan 17, 2012 | Benchmarks, Insight for DBAs, MySQL
In our recent release of Percona Server 5.5.19 we introduced new value for innodb_flush_neighbor_pages=cont. This way we are trying to deal with the problem of InnoDB flushing. Actually there is also the second fix to what we think is bug in InnoDB, where it blocks...
by Vadim Tkachenko | Jan 17, 2012 | Insight for DBAs, MySQL, Percona Software
There and in coming posts I am going to cover main features of Percona XtraDB Cluster. The first feature is High Availability. But before jumping to HA, let’s review general architecture of the Percona XtraDB Cluster. 1. The Cluster consists of Nodes....
by Laurynas Biveinis | Jan 13, 2012 | MySQL
Percona is glad to announce the release of Percona Server 5.5.19-24.0 on January 13th, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.19, including all the bug fixes in it, Percona Server 5.5.19-24.0 is now the...
by patrick.crews | Jan 13, 2012 | Benchmarks, MySQL
The announcement of Percona XtraDB Cluster seems to have generated a fair bit of interest : ) Although the documentation contains more formal instructions for setting up a test cluster, I wanted to share a quick way to set up an ad-hoc cluster on a single machine to...
by Vadim Tkachenko | Jan 12, 2012 | Insight for DBAs, MySQL, Percona Software
I understand that the new technology can be scaring and this makes entry barriers to try and get familiar with it. That’s why I created simple set of scripts which setup N nodes cluster on running EC2 instances. The script assumes that you have running N EC2...
by Vadim Tkachenko | Jan 11, 2012 | Insight for DBAs, MySQL, Percona Software
In this post I want to show new possibilities which open with Percona XtraDB Cluster. We will create 3 nodes Cluster with nodes on different continents (Europe, USA, Japan) and each node will accept write queries. Well, you theoretically could create 3 node...
