Today we glad to announce release 1.0.3-4 of our XtraDB storage engine.
Here is a list of enhancements in this release:
Grouping by varying conditions is something that is hard to accomplish using straight SQL, but is something that comes up from time to time with analysis. Perhaps consider it an extended version of the more famous “group-wise maximum” problem. Since the “real life” problem I recently addressed involves our internal systems that I can’t talk about here, I’ll give another example that deals with the same issues.
The scenario: You have a list of students and classes (and a mapping of student/class), and the students all have grades and some have scholarships.
students +------------+--------------+-----------------+ | student_id | student_name | has_scholarship | +------------+--------------+-----------------+ | 1234 | John | yes | | 1235 | Jane | no | | 1236 | Joe | no | | 1237 | Jennifer | yes | | 1238 | Jacob | no …[Read more]
One of the things we've been working on in Drizzle is having automated performance regressions run when we push new code. Although the fully automated system isn't quite there yet, one of the pieces is, which is a Drizzle-supporting version of sysbench.
I've pushed the code to:
lp:~drizzle-developers/sysbench/trunk
This new version of sysbench has a libdrizzle driver which can be used to run benchmarks against Drizzle, or, since libdrizzle can also talk to MySQL, to MySQL.
Getting started playing with it is pretty easy, just make sure you've installed a recent copy of libdrizzle first.
bzr init-repo sysbench
cd sysbench
bzr branch lp:~drizzle-developers/sysbench/trunk
cd trunk
./autogen.sh
./configure
make
make install
From that point, you should be able …
[Read more]Some unsettling things happened in MySQL in the past week or so. New storage engine not mentioned in the changelog There’s a bit of a storm brewing over at the MySQL Performance Blog, where Vadim reports discovering a new storage engine added without mention in the 5.1.33 changelog. This is in defiance of the policy of not making changes in a production release. And it certainly belongs in the changelog – but there is no sign that anyone will remedy this problem.
Everybody attending the MySQL Users Conference this year please mark your calenders! This is your chance to become a MySQL schema design expert as well as learn how to use Workbench from the experts.
We are going to do a free Workshop called “Introduction to Data Modeling with MySQL Workbench” on Tuesday - Thursday 3 - 4:30 PM in the Santa Clara Ballroom.
Some of the topics that will be covered:
MySQL
Workbench has already received some great accolades this year and there is more to
come!
Now, those attending the MySQL Users Conference will have a chance to become a MySQL schema design expert.
The Conference will include a free MySQL Workbench workshop called “Introduction to Data Modeling with MySQL Workbench” on Thursday (April 23, 2009) 3 - 4:30 PM in the Santa Clara Ballroom. According to Mike Zinner, MySQL Workbench …
[Read more]One of the things we've been working on in Drizzle is having automated performance regressions run when we push new code. Although the fully automated system isn't quite there yet, one of the pieces is, which is a Drizzle-supporting version of sysbench.
I've pushed the code to:
lp:~drizzle-developers/sysbench/trunk
This new version of sysbench has a libdrizzle driver which can be used to run benchmarks against Drizzle, or, since libdrizzle can also talk to MySQL, to MySQL.
Getting started playing with it is pretty easy, just make sure you've installed a recent copy of libdrizzle first.
bzr init-repo sysbench
cd sysbench
bzr branch lp:~drizzle-developers/sysbench/trunk
cd trunk
./autogen.sh
./configure
make
make install
From that point, you should be able …
[Read more]One of the things we've been working on in Drizzle is having automated performance regressions run when we push new code. Although the fully automated system isn't quite there yet, one of the pieces is, which is a Drizzle-supporting version of sysbench.
I've pushed the code to:
lp:~drizzle-developers/sysbench/trunk
This new version of sysbench has a libdrizzle driver which can be used to run benchmarks against Drizzle, or, since libdrizzle can also talk to MySQL, to MySQL.
Getting started playing with it is pretty easy, just make sure you've installed a recent copy of libdrizzle first.
bzr init-repo sysbench
cd sysbench
bzr branch lp:~drizzle-developers/sysbench/trunk
cd trunk
./autogen.sh
./configure
make
make install
From that point, you should be able …
[Read more]If you are a Mac developer, interested in a new professional challenge and like what we have done with MySQL Workbench so far, please consider applying for our open position in the Workbench team.We are looking for an Objective-C / UI coding wunderkind who is also not easily scared by C++.
You can be located anywhere around the world, only hard requirements are that you are comfortable with working from home, have a decent internet connection and are not too far from an airport.We would be happy to have you on the team.
More details about the job below. To speed up the hire process please send your CV to workbench@sun.com. We are preferring people with open source background so please do not forget to include links to your open source work.
Job Summary:
Sun Microsystems is looking for a strong Mac UI developer with in-depth knowledge of Objective-C, C++, X-Code and the …
[Read more]
Monday was my talk at Ames, Iowa at Iowa State University. To get
there, I took the Greyhound from Chicago to Ames, a nice lovely
eight hour bus ride across snowy, icy weather. And it is in Ames
that I discovered the wonderful reason to have an iPhone. For the
first time in the trip I had neglected to find out where it is I
would be dropped off, and neglected to take the phone number of
the hotel.
The bus station for Ames is in the middle of nowhere in an
industrial complex. At 2am on a cold night after a storm, there
was nobody about as the bus unceremoniously dropped me on the
street and sped off with me standing there baffled... no sign, no
taxi number nothing. I was suddenly picturing me using my
backpack as a windbreaker and huddling against a building trying
to make a fire with all the business cards that I had with
me.
An iPhone would have been very nice. Instead I used my "call a
friend" lifeline and woke up …