MySQL Performance Blog

Yesterday I had a chance to speak to Igor – head of MySQL optimizer team and Timur – both of them expressed concern with TPC-H run results I posted and notes about little gains in MySQL 6.0.

Do not get this post wrong. I’m not saying MySQL 6.0 SubQuery optimizations are non existent or priorities were wrong, what I’m saying is just they do not seems to be apply to most of TPC-H Queries. I personally (before doing what exactly queries are part of TPC-H) was expecting to see gains in TPC-H and I think this is what other users would expect as well because this is well known set of complex queries which use SubQueries.

So what is the reason ? Why TPC-H queries are not targeted ?
[read more...]

Yesterday we started the conference early with MySQL Community Dinner which was quite a success with about 30-50 people showing up (hard to count as people come and go) even though it was conflicting with Silicon Valley MySQL Meetup and which at least prevented Jeremy and his team showing up.
UPDATE: What I was thinking… There the meetup is today, but still I did not see Jeremy on the party yesterday.

To my surprise Jonathan Schwartz (Sun CEO) and Rich Green (VP of Software – boss of Marten Mickos) showed up and showed up at exactly right time – when we were discussing how the bill should be handled for such event. Rich Green introduced himself with something like “We just bought the company for 1 Billion so we can afford to pay for community dinner” and earned a round of applause.
[read more...]

Percona, the company maintaining MySQL Performance Blog has a good presence on the conference this year. We have me (Peter), Vadim, Aurimas, Baron and Andrew attending the show. Alexey had to stay because he could not get Visa in time and Maciek is staying to be able to reliably service emergencies arising with our customers.
[read more...]