This provides more documentation for Online Schema Change (OSC) beyond part 1.

API

This is an extract from the source code:

The OnlineSchemaChange class encapsulates all the steps needed to do online schema changes. The public functions are:

• __construct - describe in the Constuctor section
• forceCleanup -  calls execute() method with OSC_FLAGS_FORCE_CLEANUP flag set.
• getOscLock,releaseOscLock, isOscLockHeld - to be used from other scripts (such as backup related scripts) that want to see if OSC lock is held or to get OSC lock to prevent OSC from running.
• getCleanupTables(), serverCleanup() - to be used on a db restored from a backup to check if there are OSC …

Spinn3r is hiring a cool Java engineer here in our San Francisco office.

It’s a great position with a super smart bunch of guys. Centrally located right in SOMA (2nd and Howard) and we have an AWESOME office (it’s 102 years old !)

Responsibilities:

* Maintain our current crawler.
* Monitor and implement statistics behind the current crawler to detect anomalies.
* Implement new features for customers
* Work on backend architecture to improve performance and stability.
* Implement custom protocol extension for enhanced metadata and site specific social media support.
* Work on new products and features using large datasets.

Requirements and Experience:

* Deep understanding of Java (Threads, IO, tuning, etc)
* Internet standards (HTTP, HTML, RSS, DNS, etc)
* SQL
* Basic understanding of distributed …

It looks like the good folks in Austin are keeping busy:

Announcing a new Meetup for The Austin MySQL Meetup Group!

What: GeekAustin Fall MySQL Happy Hour

When: Wednesday, September 22, 2010 6:30 PM

Where: Triumph Cafe
3808 Spicewood Springs Rd
Austin, TX 78759
512-343-1875

Mark and Boyd just finished GeekAustin's 10 week MySQL Associate Certification Study Group, and now we're wondering what should be next. Boyd would like to lead a study group for the MySQL Developer I exam, and Mark would like to host a few meetups on replication strategies and other topics of interest. …

Both primary and unique keys serve to identify one and only one row in a table. However, there are some differences that we are going to look at in this tutorial.

Dear Community,

Starting with this release, we introduce a new release model for Percona Server. From now on, we will have both Stable and Release Candidate releases. Release Candidates will introduce new features not yet available in Stable releases.

Along with new features, our new 5.1.49-12.0 RC contains a couple of patches from the Facebook-MySQL tree - https://launchpad.net/mysqlatfacebook . Of particular note is better integration with FlashCache.

We also introduce the very interesting new feature called ”Permanent InnoDB Buffer Pool”  (sponsored by a Well Known Social Network site). It allows you to keep the InnoDB buffer pool in memory between restarts of MySQL servers.
This can result in a significant decrease in warmup time after MySQL restarts.

Starting with this release, we will also provide special …

This is my first attempt at creating a plugin for MySQL Workbench.  As a first step, I’ve created a plugin that summarizes the slow query log if it’s output to the slow_log table, which is an option available in MySQL version 5.1 or newer.  It’s similar to the mysqldumpslow perl script, except that it doesn’t require perl, which should be more convenient on Windows.  In my next update, the plugin will provide the same summary statistics for the slow query log file on disk.

While the slow query log reports query time, lock time, rows sent and rows examined for each query; it’s often useful to group and aggregate similar queries for analysis.  For example, here’s a sample of the plugin output, which is sorted by count, after just a few clicks on a drupal6 site:

The plugin …

I love cool toys, don’t you? Especially when they help me optimize ugly, nasty, evil looking queries :)
I use mk-visual explain to help me understand better what the h*ll is happening on my MySQL servers and how they are being butchered, but today I discovered a small yet neat tool, which I think might have been overlooked. It uses mk-visual-explain, but does it visually, enabling you to open and close sections of the explain tree structure. I’m talking about http://explain.plosquare.com/.

Thank you Jan Ploski

Because Sharing is Caring

OSI Days 2010 is the 7th edition of the conference series that started as LinuxAsia 2004. The conference carries the legacy of being the premium confluence of the open source community and the industry in Asia, and has successfully been a platform for the promotion and growth of open source tools and technologies in India.

As the Organising Partner, OSSCube has led from the front, building the technical sessions and workshops for PHP, Drupal and Open Source Databases tracks at the conference. In addition to the strategic role played by OSSCube as the organising partners of the conference, OSSCube is also organising workshops on setting up and tuning MySQL …

OSI Days 2010 is the 7th edition of the conference series that started as LinuxAsia 2004. The conference carries the legacy of being the premium confluence of the open source community and the industry in Asia, and has successfully been a platform for the promotion and growth of open source tools and technologies in India.

As the Organising Partner, OSSCube has led from the front, building the technical sessions and workshops for PHP, Drupal and Open Source Databases tracks at the conference. In addition to the strategic role played by OSSCube as the organising partners of the conference, OSSCube is also organising workshops on setting up and tuning MySQL …

Thanks primarily to the efforts of Senko Rašić and Ante Karamatić, the Pacemaker cluster stack is being augmented with support for Upstart services. This is in addition to support for OCF resource agents and LSB/SysV init scripts, both of which have been supported in Pacemaker for years.

This is functionality now present in the upstream Mercurial trees, and we need testers to get in shape for release. Yes, that means you can help!

This is primarily relevant to you if you use a distribution with upstart as its default init daemon. This includes Ubuntu lucid, …