Posted by Morgan Tocker |
Following on from our earlier announcement, Paul McCullagh has responded with the answers to your questions – as well as a few I gathered from other Percona folks, and attendees of OpenSQL Camp. Thank you Paul!
What’s the “ideal” use case for the PBXT engine, and how does it compare in performance? When would I use PBXT instead of a storage engine like MyISAM, InnoDB or XtraDB?
[read more...]
Posted by Morgan Tocker |
I forwarded on a list of questions about PBXT to Paul McCullagh today. While Paul’s busy answering them, I’d like to announce that Robert Dempsey (InfiniDB storage engine) and Bradley C. Kuszmaul (TokuDB storage engine) have also accepted an interview. If you have any questions about either storage engine, please post them here by Friday 20th November.
Posted by Morgan Tocker |
We’ve been busy expanding our training curriculum to include training for developers building applications with MySQL. We have reached the point where we’re ready for a pilot teach – and it brings me great pleasure to announce that we’re opening it up for blog readers to attend, free of charge.
The details:
San Francisco
4th December
9:30AM – 5PM
Spaces are limited, so to give everyone a fair chance we’re delaying registration to open at noon tomorrow (Friday) Pacific Time. It’s strictly first in first served, so be quick! The registration link is here.
Posted by Morgan Tocker |
A recent photo from Highload.ru
I said in my last post, that we’re interested in speaking at MySQL meetups, and I’m happy to say that the Los Angeles MySQL Meetup has taken us up on the offer.
On November 18th, I’ll be giving an introductory talk on InnoDB/XtraDB Performance Optimization. I will be the second speaker, with Carl Gelbart first speaking on Infobright.
What brings me to LA? On the same day (18th Nov) I’ll be teaching a one day class on Performance Optimization for MySQL with InnoDB and XtraDB. If you haven’t signed up yet – spaces are still available.
Posted by peter |
I’m going to give a talk on Goal Driven Performance Optimization next Tuesday. This is one of my favorite talks as it goes beyond MySQL to the principles you can apply to performance optimizations of the complex systems, especially when you have to do a lot in limited time or budget and so you can’t just fix everything what can be fixed.
Please RSVP if you’re planning to attend as space is limited.
Thanks to Sam Ghods and Box.Net for organizing the event.
Posted by Morgan Tocker |
I wanted to provide an update on two things:
- Firstly, we have opened registration for InnoDB/XtraDB training in Los Angeles (Nov 18th).
- The second is that while I am in New York City for training (Oct 29th), I’ll be giving a (free) talk at the MySQL Meetup group there (Oct 28th).
We love to speak at Meetup groups. If you are an organizer feel free to let us know you are interested. There’s no guarantee that we can get schedules to align – but there are a number of Percona consultants that travel regularly.
Posted by Morgan Tocker |
Today’s the day I fly to Los Angeles to teach a private training class, en route to Santa Clara/San Francisco for our public training workshops next week.
Our Montreal practice teach at Station-C went great – it was an opportunity to do a road test and iron out any kinks in the delivery.
What did I learn in the process?
- Solid examples provide context. I didn’t have the best SHOW GLOBAL STATUS data for the practice teach, but I’ve edited my slides and our official classes will have much better information.
- Operational issues are one of the most important things people want to hear more information on. A fair number of students know that dropping an index is not as painless as it should be, but not everyone knows about tools like Flipper and MMM. It’s not the main focus of our InnoDB/XtraDB workshop, but we will cover how to solve these sorts of problems.
- Not everyone knows what a mutex or secondary key index is. It was great to have a crowd that was very quick to give vocal feedback, and the material flowed much nicer once I stopped and spent 2 minutes to explain each of these.
We’ve still got tickets available to both Santa Clara (14th) and San Francisco (16th), but there is a fair chance San Francisco will be full by the weekend. If you’re coming, see you next week!
Posted by Aleksandr Kuzminsky |
Dear Community,
Today we are announcing XtraDB release 7.
This is the last release based on InnoDB plugin version 1.0.3, as you might know Innobase has released 1.0.4.
The release includes following new features:
- MySQL 5.1.37 as a base release
- speed hack for buf_flush_insert_sorted_into_flush_list controlled by the new variable innodb_fast_recovery
Fixed bugs:
The builds for RedHat4,5 and Debian are located on http://www.percona.com/mysql/xtradb/5.1.37-7/
The latest source code of XtraDB, including development branch you can find on LaunchPAD.
Please report any bugs found on Bugs in Percona XtraDB Storage Engine for MySQL.
For general questions use our Pecona-discussions group, and for development question Percona-dev group.
For support, commercial and sponsorship inquiries contact Percona
Posted by peter |
As you might have seen Innodb Plugin 1.0.4 was released today. I am very excited to see this release which is released exactly 5 months after release of Innodb Plugin 1.0.3 (I honestly expected to see Innodb Plugin 1.0.4 to be released by MySQL Conference and Expo in April). This also is still “early adopter” version of a plugin which is a bit of disappointment as we can’t wait for Innodb plugin to become stable/GA but considering number of improvements this is probably good thing.
We’re also pleased to see some of Percona contributions made in this release (in modified form) while others were evaluated and given ideas for different implementations.
Among other changes I’m especially pleased with fixed Group Commit Bug which I reported about 4 years ago and which was known for about 5 years, since early MySQL 5.0 beta releases. We had semi-fix for this problem earlier this year but it is great to see solution with even less mutex code.
Now the fun part starts – we need to evaluate/benchmark/stress test Innodb Plugin 1.0.4 to integrate it with next XtraDB release.
Posted by peter |
I will be presenting at upcoming MySQL Meetup at San Francisco this Thursday, August 13. I will talk about Sphinx covering the new cool features this search engine has as well as showing the demo on how simple it is to use Sphinx to implement high performance full text search for your MySQL driven application.
We also will have the raffle for 2 tickets for Performance Optimization for MySQL with Innodb and XtraDB Single Day Intense Training Workshop for either Santa Clara or San Francisco locations.
del.icio.us
digg