Giuseppe Maxia spoke at the May 2009 Boston MySQL User Group about MySQL 5.4 and what it can do, the new performance features, etc.
May
15
2009
May
14
2009
So in my previous post I showed some benchmarks showing a large drop off in performance when you fill the x-25e. I wanted to followup and say this: even if you do everything correctly ( i.e. leave 50%+ space free, disable controller cache etc ) you may still see a drop in performance if your workload is heavily write skewed. To show this I ran a 100% random read sysbench fileio test over a 12GB dataset (37.5% full ) , the tests were run back-to-back over a several hours , here is what we see:
*Note the scale is a little skewed here ( i start at 2500 reqs ).
Each data point represents 2 million IO’s, so somewhere after about 6 million IO’s we start to drop. At the end it looks like we stabilize around2900-3000 requests per second, an overall drop of about 25%.
May
12
2009
|
|
The session at the Boston MySQL User Group was very enjoyable. There was a full room, and the presentation was followed with attention and curiosity. The slides I used for this presentation include the deck used by Allan Packer and Mikael Ronström at the MySQL Conference 2009, followed by a testimony of my own experience with 5.4. Here is the final deck: MySQL 5.4 theory and practice |
While preparing the slides, I realized that, for the first time,
we have a product that allows a painless performance gain. Unlike
all the tuning and technological improvements that you can use to
improve …
May
09
2009
Everyone loves SSD. It’s a hot topic all around the MySQL community with vendors lining up all kinds of new solutions to attack the “disk io” problem that has plagued us all for years and years. At this year’s user conference I talked about SSD’s and MySQL. Those who follow my blog know I love IO and I love to benchmark anything that can help overcome IO issues. One of the most exciting things out their at this point are the Intel x-25e drives. These bad boys are not only fast but relatively inexpensive. How fast are they? Let’s just do a quick bit of review here and peak at the single drive #’s from sysbench. Here you can see that a single X25-e outperforms all my other single drive test.
Yep you have probably seen this type of chart on other sites… The great thing about the Intel drives is their performance on writes, this difference gives …
[Read more]
May
07
2009
|
|
The MySQL Boston User group will meet on May 11 at 7pm. I will speak about my experience using MySQL 5.4, with some general information on the release. BTW, you know that there has been some trouble about MySQL meetup groups. We are looking into the matter, and we will release information as soon as possible. For now, I can tell you that the current agreement between MySQL and Meetup is valid at least until June 10, 2009. |
Apr
29
2009
|
|
At the MySQL
Conference 2009 I attended a session about the Spider
storage engine, an engine with built-in sharding
features. The talk was notable for the speaker wearing a spiderman costume, and for some language barrier that made the talk less enjoyable than it should be. That's a pity, because the engine is very intriguing, and deserves some exploration. |
What is the Spider engine, then? In short, it's an extension to
the partitioning engine with the ability of connecting to remote
servers. Basically, partitions + federated, except that Federated
is explicitly removed during the …
Apr
28
2009
While I can not consider myself a member of MySQL's community of
developers, I've been watching those developments the same way I
follow the development of Linux and many of the Java and Apache
projects our own services depend on. It was great to meet many of
the core members of the development community and get some
insight into their thoughts about the future.
Baron
Schwartz called in his Percona Performance Conference keynote on Thursday for a new, active MySQL
community to take the driver's seat in the development of the
database, not just in the incremental improvements way of bug
fixing and performance improvement, but also by setting a vision
for the next generation …
Apr
27
2009
|
|
About a month ago, I published the results of MySQL 5.x performance with logging. The results covered several versions, from 5.0.45 to 5.1.33. Among the conclusions of the post was the consideration that MySQL 5.0.x is faster than MySQL 5.1 in read only operations. I hinted that better results may come for MySQL 5.1. When I wrote that post I had, in fact, an ace up my sleeve, because I had already benchmarked the performance of MySQL 5.4, using the same criteria shown in my previous post. The results, as you can see from the charts below, tell that … |
Apr
27
2009
If MySQL's core server development and release process has been somewhat of a frustration to the userbase over the past few years, clearly another part of the ecosystem has thrived in ways which brought exciting fruit to the Expo part of this year's conference. MySQL has become a hub of innovation in both transactional and analytics databases in ways which have turned many of my concerns to enthusiasm.
I've already discussed the technologies for data analytics on MySQL, in particular Infobright's storage engine technology. This year I took the opportunity to learn a bit more about their appliance-based competitor Kickfire as well, and it certainly looks like a solid product. I still don't completely understand what the "SQL chip" in their appliance does, but certainly the combination of a special-purpose columnar …
[Read more]
Apr
23
2009
Video for the presentation at the 2009 MySQL Conference:
Optimizing MySQL Performance with ZFS
Allan Packer (Sun Microsystems), Neelakanth Nadgir (Sun
Microsystems)
The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7121
Watch the video at