Sheeri has posted an awesome list of talks with links to videos and slides from the MySQL conference. She did a lot of the video recording herself. I don’t know how she could have posted them so fast — it’s a lot of work.
Related posts:
The O’Reilly MySQL Conference & Expo 2010 is over. I hope all of you had a good time. I have plenty of blog posts and thoughts lined up about this, but first, I’d like to point out something that has become a tradition, that was continued in 2010: the O’Reilly MySQL Conference Community Award Winners.
Tim O’Reilly was kind enough to hand out the awards this year. In case people were wondering, the awards were pewter wine goblets from Royal Selangor.
Selection of the award winners happened via voting from the alumni of winners, and was all done in a rather short period of time. Kudos to the entire team that voted. Now for …
[Read more]
I did two talks on replication and clustering at the recent
MySQL
Conference in Santa Clara. Thanks to all of you who
attended as well as the fine O'Reilly folks who organized
everything. Slides are posted on the talk descriptions at
the following URLs:
Conferences like the MySQL UC are fun because you get to see all your virtual pals …
[Read more]Sheeri has posted an awesome list of talks with links to videos and slides from the MySQL conference. She did a lot of the video recording herself. I don’t know how she could have posted them so fast – it’s a lot of work.
I will try to tell you how we reduced mutex contention on LOCK_open. Corrections are welcome. This code is complex and in flux from 5.0 to 5.5. This change is in the Facebook patch for MySQL 5.1.
Table handler instances are needed for each table used in a query. They are either fetched from a cache or opened at the start of a query and then either closed or returned to the cache at the end of the query. Some of the work done to open a table handler instance is serialized. This is done by locking the LOCK_open mutex for the duration of the call to the handler::open method. Sometimes a lot of work is done during the call to handler::open. Index cardinality statistics must be computed the first time a table is opened for InnoDB tables as it does not store statistics on disk. Cardinality statistics are computed by sampling 8 leaf blocks …
[Read more]This is the first part of an ongoing series about my experiences while writing the MySQL Admin Cookbook for Packt Publishing. All parts can be found under the mysql-admin-cookbook label.
In a few past posts I wrote about different aspects of my book writing project already. However those posts were not very contiguous, and I was asked a few times what my general experiences were and what caveats to look out for when taking on such a project for the first time. It might be of interest to some if I write down my experiences in a little more structured form.
This will be a series of several posts, because for one I do not think it would be feasible to …
[Read more]Welcome to the 186th Edition of Log Buffer. Lots to report this week, so read on…
In Oracle news:
We begin with Gary Myers at the Sydney Oracle Lab who mixes GUI
and CLI and shows how to manage your database from EMACS.
You have to read a post that starts with: “There is a place of
shadow, a place between the dark lands of the command-line
interface, and the shining brightness of the GUI. In the days of
yore, many dwelled in the shadow lands, but almost all have been
attracted to the lights of SQL Developer…”
Tanel Poder gives a step by step tour of his …
The White House contributes to OSS. Growth for Pentaho and MuleSoft. And more.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca
“Tracking the open source news wires, so you don’t have
to.”
# The White House released some of the custom code it has developed for whitehouse.gov as open source.
# Pentaho reported 229% bookings growth and 177% Enterprise Edition customer growth in Q2.
# MuleSoft grew bookings by 140% in Q1.
# The beta of Red Hat Enterprise Linux 6 is now available, without Xen.
…
[Read more]We’re now about a week away from WordCamp San Francisco 2010. I am extremely excited about the speaker lineup this year (6-7 not listed yet), we’ll have a jazz performance, awesome shirts… best WordCamp SF yet. Get your tickets ASAP if you hope to attend.
We are pleased to announce the availability of the 1.1.1
Alpha Release of InfiniDB Community Edition. This is
our second alpha release for 1.1 and is not recommended for
production work.
We've been hard at work on 1.1 and we are excited to give you a
sneak peak at what we've been up to. This release includes
the following new functionality:
Improved performance for queries run during an active
transaction.
Bulk load (cpimport) support for imports vi...