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.
|
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 … |
A new build of the Tungsten Replicator is now available. As you
probably know from reading this blog Tungsten Replicator provides
advanced open source replication for MySQL. There is also a
commercial extension to support Oracle. Tungsten Replicator 1.0.1
includes a number of important improvements.
- Much better performance -- Current benchmark results show
throughput of up to 650 inserts per second using a single slave
apply thread. We are well on the way to our goal of 1000 inserts
per second.
- Simplified management -- Replicator administration has been
largely reduced to two commands: online and offline. There is an
option to go online automatically at startup, which further
simplifies operation and makes it easy for the replicator to
operate as a service.
- Easy-to-use consistency checks. You just type …
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]“If you keep doing what you’ve always done, you’ll keep getting what you’ve always gotten.”
Jim Rohn
Motivational speaker and author
I wasn't able to spend the whole day at the Drizzle Developer Day, which was held at the Sun campus on the day after the MySQL Conference, but it was interesting none the less.I enjoyed discussing stuff with Monty Taylor and Stewart Smith and was able to show them some ideas which I hope will inspire more innovation in Drizzle. I would have liked to have had some time to chat with Brian Aker some