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 …

Yes, I have turned into the stereotype called a scrum-master. I haven't really done the infamous 2 day course on it to be certified, but apparently I read enough about it and practiced some of the principles to know a few things (or at least to think I know).


In my company..

In my company, we do use scrum with our development team. In most cases it works very well and the management are very happy. In some cases, where emergency support is involved, not so much, but they still like the structure of it and the fact that people commit to finishing things.

In all cases, very little testing is being applied and almost no documentation is written. I do realize that in the case of documentation, agile is suppose to cut down on those, but some form of documentation or changing some charts will be fine by me. In the case of testing, I think since I made a fuss about it, more testing has been done. But, …

I got some really awesome feedback from Giuseppe (the Data Charmer) in my preivous post and it gave me a few ideas I thought I would share. One of the really nice things he did in his article about partitioning was to test partitions with the ARCHIVE engine. His results were mixed (and, actually, so were mine), but I did want to give it a spin. Here is what I ended up with:

DROP TABLE IF EXISTS Logger;
CREATE TABLE `Logger` (
  `timestampOccurred` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `dateOccurred` date NOT NULL,
  `session` char(32) DEFAULT NULL,
  `host` varchar(255) DEFAULT NULL,
  `sslMode` enum('enabled','disabled') DEFAULT 'enabled', …

“There are 10 types of people in the world — those who understand binary, and those who don’t.”

The term “binary” in MySQL has many different meanings. How many can you come up with? I have 6, but I am willing to believe there are more!

0) “Binary distribution” is the name for the package that contains a binary. Another use is “binary installation” but that’s pretty much the same usage pattern as “binary distribution”, so I won’t count “binary installation” as a separate usage.
1) “Server binary” or “client binary” is the actual program (mysqld, mysql).
2) “Binary format” is a compressed format. For example, DECIMAL is stored in a “binary format” — each group of nine digits is compressed into 4 bytes.
3) “Binary log” is the change log. You can argue that this is an extension of #3, because the binary log is a compressed …