As promised, here are more results running memcached on Sun's X2270 (Nehalem-based server). In my previous post, I mentioned that we got 350K ops/sec running a single instance of memcached at which point the throughput was hampered by the scalability issues of memcached. So we ran two instances of memcached on the same server, each using 15GB of memory and tested both 1.2.5 and 1.3.2 versions. Here are the results :

The maximum throughput was 470K ops/sec using 4 threads in memcached 1.3.2. Performance of 1.2.5 was just very slightly lower. At this throughput, the network capacity of the single 10gbe card was reached as the benchmark does a lot of small packet transfers. See my earlier post for a description of the server configuration and the benchmark. At the …

jHeidi alpha 4r2 has been released to support the open source database Drizzle. Just use the slider on the connection dialog and the Drizzle profile will appear. Support extends to almost all of jHeidi's MySQL functionality, except for some import/export functionality and there is no user manager due to the plugin model that Drizzle uses.

Note that the JDBC driver for Drizzle is beta but is nonetheless pretty stable.

Dear Kettle fans,

As expected there was a lot of interest in cloud computing at the MySQL conference last week.  It felt really good to be able to pass the Bayon Technologies white paper around to friends, contacts and analysts.  It’s one thing to demonstrate a certain scalability on your blog, it’s another entirely to have a smart man like Nicholas Goodman do the math.

Sorting massive amounts of rows is hard problem to take on.  Making it scale on low-cost EC2 instances is interesting as it …

Last week we did a Workbench tutorial and three workshops at the MySQL Users Conference. One reason for that was to get people familiar with schema design principles and MySQL Workbench in general. The other reason was to watch people using the tool and learn how we can improve in the UI. We learned a lot and already made some improvements in the next releases that are due this week.

Thanks for everybody attending our sessions and also a big thank you to Mike Hillyer who did a very good job presenting the material.

The material for this workshop as well as a live recording can be found here.

Enjoy!

Just quickly dropping the PDF version of the slides of my presentation at this year's MySQL Conference.
Enjoy!

I decided to give a try to slideshare. So I uploaded the slides from my most recent talks, and will eventually catch up with the old ones. My slides repository is http://www.slideshare.net/datacharmer.

If you are looking for the slides from MySQL Conference 2009, here are the shortcuts:

• MySQL 5.1 Partitions tutorial
• MySQL 5.1 event scheduler
• Boost performance with MySQL 5.1 partitions
• …

I decided to give a try to slideshare. So I uploaded the slides from my most recent talks, and will eventually catch up with the old ones. My slides repository is http://www.slideshare.net/datacharmer.

If you are looking for the slides from MySQL Conference 2009, here are the shortcuts:

• MySQL 5.1 Partitions tutorial
• MySQL 5.1 event scheduler
• Boost performance with MySQL 5.1 partitions
• …

Hi all,

If you expand a database connection node in the Services window of the IDE, you'll notice a new look. What are all of these nodes under the connection nodes? They're schemas. For the most part, if you're using Java DB, the only schema you'll need to worry about is the app schema. I'd be interested in knowing what developers have used the other schemas for.

When you expand the MySQL conect node, what you get is a list of databases you've created in MySQL. These database are actually schemas you've created in your MySQL database.

There you have it.

Cheers!

--James

The presentations from the sessions MySQL Cluster 7.0 - New Features and LDAP For MySQL Cluster - back-ndb, and all other sessions on MySQL Cluster, are available for download from www.mysqlconf.com.