MySQL has long built a great database. It's increasingly also building a great database business.

MySQL made two big announcements on Wednesday, one product-related (the final release of MySQL 5.1) and the second licensing model-related (improvements to the subscription-only MySQL Enterprise Monitor service with Query Analyzer). Of the two, I believe the latter is the more important as it helps Sun to monetize the research and development investments it has been making in the MySQL product.

The product announcement is that MySQL 5.1 will ship on or before December 6. Sun announced MySQL 5.1 back in April, but now it's ready for release. MySQL 5.1 is not important because it adds transactions capabilities (MySQL has had this functionality for years), but rather because it augments MySQL's sweet spot: industry-beating scalability and …

By moving the sorting out of the database and back into the application, plus putting a limit on how many stories would be returned to any first request, Freund watched query execution time drop from an average 5.27 seconds down to 2.54 seconds. In other words, Clickability chopped 48% of the time it took to execute each query out of his overhead. The new tool "gave us a snapshot. We learned more about query usage in two minutes than we could gain in two years of ad hoc log analysis and guessing,"

http://www.informationweek.com/news/software/database/showArticle.jhtml?articleID=212100690

Sun considered a merger or acquisition with Apple on three occasions in the past ... is it time for Sun to open that door again? READ MORE

Wow, it's so cool when something you've worked and worked on finally sees the light of day and goes GA. There's lots in this release, but one of the area's I'm most excited about is the PHP support. Our editor teams produce awesome stuff, and this is no exception, IMHO.

Of course there is also the cool stuff we've done in the databases area:

• SQL code completion
• SQL history
• Editable, pageable results
• Export results as SQL INSERT statements
• Easy installation of Sakila sample database
  

Go get the bits, have fun.

Very interesting review of the new MySQL Query Analyzer that comes with MySQL Enterprise Monitor. I installed Quan (Query Analyzer) and within about 20 minutes it became clear I had a query that was averaging 14 seconds to run. This query doesn't get run all that often, every 5 minutes or so, but it uses a table that is the most active table on our system.

OK, click on the query and it pops up a full view, showing the query with literals replaced by place holders. If you have Example Queries configured, you can check to see if there is an example showing all of the data, and if you have Example Explain configured, you will also be able to …

An excellent question was posted in a MySQL group in LinkedIn the other day that I had to post it here.What is your "Top 10 List for Programmers Working with MySQL"?I started mine... Let me know your thoughts on my list, and feel free to add other items to the list. I interface with programmers on a daily basis, and our experience lends us to help them in certain ways, but I think a "Top 10"

Download NetBeans IDE 6.5

NetBeans IDE 6.5 offers simplified and rapid development of web, enterprise, desktop, and mobile applications with PHP, JavaScript, Java, C/C++, Ruby, and Groovy.

New features include a robust IDE for PHP, JavaScript debugging for Firefox and IE, and support for Groovy and Grails. The release also delivers a number of enhancements for Java, Ruby on Rails, and C/C++ development. Java highlights include: built-in support for Hibernate, Eclipse project import, and compile on save. Combining excellent out of the box experience, compelling features, and a great plugin ecosystem, NetBeans IDE 6.5 is a must-download for all developers.

NetBeans IDE 6.5 is currently available in English, Japanese, Simplified Chinese and Brazilian Portuguese. There are several community contributed localization efforts underway to support …

If you ever used svn command line, you know it is not optimal to type in your password every time you do checkout, checkin, info, etc.  In linux world, it is very easy to setup keys to get around this.  Of course in the world of Windows it is not as easy.  Here are the steps you need to follow to get private/public keys working with your SVN under Windows using ssh tunneling.

Assumptions:  you will be connecting as user “root” to svn server located at “10.0.0.1”.  All your files will be saved at c:\ including your svn command line utility

First we will have to generate a key.  We can accomplish this by using a free utility called …

This is the first post on this brand new blog. We will be writing periodic blog posts here on topics covering MySQL and related services in detail. We hope they will be of great use to you and we welcome any and all to comment, ask questions, make suggestions for topics, etc.

This Thursday, Martin "MC" Brown will explain how to use memcached in MySQL deployments.

MC is the author of the memcached section of the MySQL Reference Manual, and does all other memcached documentation in the Sun Database Group, too.

This MySQL University session will start at 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow). The virtual meeting room will open 15 minutes before the hour. Point your browser to this address.

Here's the updated MySQL University schedule for the rest of this …