view counter

MySQL Feed

Oracle MySQL resources, news, and support articles.

Book Review: OCA Oracle Database 11g: SQL Fundamentals I: A real-world Certification Guide

Good books on databases are rare. So permit me to step out of my normal MySQL-centric role and review a new book that is very good and covers a lot of generic relational database territory while also teaching the basics of Oracle 11g. I would estimate that 10% of the book is 11g and the rest would be valuable to new DBAs of other database systems. Besides, seeing how other databases perform some tasks differently may spur you to improve your own.

OCA Oracle Database 11g: SQL Fundamentals I: A real-world Certification Guide
Author: Steve Reis

MySQL 5.6 Partitons and Subpartititions

At yesterdays MySQL Tech Tour in Dallas, a gentleman asked how to not only partition data but also store the indexes on other disks as a way of reducing I/O contention on drives.That struck a chord with me and I was soon looking up the information in the MySQL manual.

Some pt-table-checksum FAQs

After the recent update to pt-table-checksum, I’ve seen a few FAQs about it.

Q: is it still multi-threaded/parallel? A: No, that was a pile of bugs and complexity. If you need to run the tool in parallel to take advantage of powerful hardware, you can run several instances, say, one per database.

Q: what chunk size should I use? A: None, let the tool adjust itself dynamically.

MySQL/QueryScript use case: DELETE all but top N records per group

Some administrative tasks can be simplified by using common_schema/QueryScript. I'm collecting a bunch of these for documentation. Here's one for example:

The DBA/developer has the task of retaining only top 3 most populated countries per continent. That is, she has to DELETE 4th, 5th, 6th, ... most populated counties in each continent.

I’m speaking at the MySQL conference in April

It might surprise you to hear this, but I had no idea whether my talks would be accepted. The committee decided on that, and neither I nor anyone else at Percona is on the committee.

Announcing Drizzle Day, Fri 13th April 2012

Percona is proud to sponsor the 4th Drizzle Day, this year being held on the 13th April, the day after the Percona Live MySQL Conference and Expo.

When: Friday, April 13th 2012 from 9:30 am

Where: Cypress room, Mezzanine Level, Hyatt Regency Santa Clara (5101 Great America Parkway)

Announcing Percona Server 5.5.20-24.1

Percona is glad to announce the release of Percona Server 5.5.20-24.1 on February 9th, 2012 (Downloads are available here and from the Percona Software Repositories).

Announcing Percona XtraBackup 2.0 Beta 1

Percona is glad to announce our first Beta release of what will become Percona XtraBackup 2.0. We’re releasing this beta to encourage testing of our upcoming 2.0 release of Percona XtraBackup.

Since this is a beta release, you should not rely on it for production workloads – use the stable 1.6 series of Percona XtraBackup instead.

In this beta we’re proud to add:

Successful Dallas Tech Tour

Bejanmin Wood

Benjamin Wood talks at the Dallas MySQL Tech tour on the history of MySQL

Dot-Org Pavilion at the Percona Live MySQL Conference

This is a cross-post from my personal blog. Are you involved with an open-source project that’s interesting to MySQL users, such as Nginx, PHPMyAdmin, Drupal, Jenkins, PHP, and so on? Percona just published the application form for dot-org groups to have a free expo hall booth in the Percona Live MySQL Conference in April.

view counter