MySQL has simple but quite handy feature - slow query log, which allows you to log all queries which took over define number of seconds to execute. There is also an option to enable logging queries which do not use indexes even if they take less time (--log-queries-not-using-indexes)

Slow query log is great to spot really slow queries which are often good candidates for optimization but it has few serious problems which limits extent to which it is helpful. First - it only allows you to set slow query time in seconds, having 1 second minimum value. For most of interactive applications this is way too large - if you're developing Web application you probably want whole page to be generated less in 1 second, which issues many queries during generation. Second - if you enable option to log queries which do not use indexes it well can be flooded with fast and efficient queries, which just happen to do full table scans - for …

My thanks to Lenz Grimmer for the opportunity to present PrimeBase XT at the Hamburg MySQL September Meetup last Monday night. The meeting took place in a well equipped conference room belonging to the Chinese restaurant "Ni Hao" in Wandsbek. With over 20 attendees the venue was filled to capacity.

I must admit, I was a bit surprised (although I probably should not have been) by the highly technical nature of the questions and comments during the presentation and afterwards. As a result we had great time and spent quite a while discussing the various algorithms and implementation strategies used by XT.

I have posted the presentation as PDF on the PrimeBase XT home page. Among the topics of the presentation were: our motivation, a brief history of XT, future plans, …

People that write data integration solutions often have a tough job at hand. I can tell because I get to see all the questions and bugs that get reported.

That is the main reason I committed a first collection of 30 examples to the codebase to be included in the next GA release (2.3.1 will be released next Friday, more on that later).

Today I would like to talk about one of the more interesting examples on the de-normaliser step. What the de-normaliser step does is help you out with the lookup of key-value pairs so that you can attribute the value after lookup to a certain field. The step is a fairly recent addition to Pentaho Data Integration, but gets a lot of attention. I guess that’s because the use of a key-value pair system is often used in situations where programmers need a very flexible way of storing data in a relational database.

The …

Last night we had a number of keen souls at the Brisbane MySQL User Group. I was very impressed to see the majority of people with laptops at hand.

You can download my slides and code examples at my Articles page.

In our hands on Hackfest tutorial we created the new command SHOW USERGROUPS. Before anybody makes a comment, it was stated in the presentation that this command was made a dummy one, and is a poor candidate for two reasons.

1. The results should be more dynamic, rather then hardcoded into the source tree
2. USERGROUPS is not an ideal name due to comparisions to Users, Groups, Roles etc

Still it was productive, here was the outcome of our work for the evening.

mysql> SHOW USERGROUPS; …

See this article on InformationWeek.

Looks like an excellent development.
I just hope the EFF has picked the case carefully...

Version 0.1.149 of the innotop MySQL and InnoDB monitor is a major upgrade. As of this version I'm declaring innotop "stable," meaning I've put some work into making it deal with unexpected input. It should be very resistant to any sort of crash now. You can download innotop from the original article.

Orlando FL. ? Pentaho Corp., creator of the world?s most popular open source business intelligence (BI) suite, today announced that it will be presenting on Tuesday, September 19 at 10am PDT as part of MySQL?s popular ongoing educational web seminar series on www.mysql.com. The web seminar will focus on Pentaho Data Integration, formerly the Kettle project, showcasing the world?s most popular open source BI suite in tandem with the world?s most popular open source database platform.

Borland has decided to re-launch their development tools using the old Turbo brand name, perhaps as a precursor to a spin-out of the tools division.  The Turbo brand name was very well known among programmers in the 1980s and early 1990s and Borland stood out in the market for providing the fastest compilers and highest productivity tools with its then unique Integrated Development Environments (IDEs).  As the years went by, the Turbo name fell by the wayside as new products like Borland C++, Delphi and JBuilder raised the stakes for Windows development.  Delphi was a pretty amazing system in its day and it combined the best of Rapid Application Development and native code compiler performance in a way …

MySQL AB today announced the election of a new independent member to its board of directors: Dana Evan, CFO and executive vice president of Finance and Administration for VeriSign, Inc. (NASDAQ: VRSN).

The initial MySQL Build Farm scripts are now available on the Forge wiki. If you are interested in participating in the Build Farm initiative, feel free to download the scripts and trying them out. Right now, we are still working out how the scripts should interact with the main MySQL internal pushbuild system. But, we need folks to set the scripts up on their host computer and provide input on the scripts and test them.

Interested in participating? Enlist your spare machine on the Forge wiki.