I moved all the QOT code to Launchpad. This includes code for the tool, tests and a small experimental utility qot-predictor, which based on query analysis tries to predict which queries are likely to be executed next. Project URL for branching is lp:qot. If you want to push your own changes just create a new project branch.

The MySQL database server can display a lot of performance statistics. However, most of them relate to general server parameters, such as buffer sizes and query cache settings. Of course, such settings are important to get right, and can make a huge difference in performance. Once you've tuned them however, you need to start looking at the tables and queries. When a single bad query can cost 90 - 99% of the total performance, server tuning doesn't fix the problem. But obtaining query profiling information from MySQL can be tricky. Here are some of the options:Slow query logYou can use the built-in slow_query_log from within the server. It will show you queries that take more than a second. Such queries typically don't use indices properly and are important to address. But only slow queries end up there, and many performance problems aren't caused by slow queries, but by queries that are run very often (for example, for-loops in the code …

Today we released Jet Profiler for MySQL for beta testing!

Jet Profiler for MySQL is a query profiling tool, focusing on running queries and processes. It can provide top lists of the most frequent queries, tables, schemas, users and more. Such top lists help you identify bottlenecks and fix the worst performing parts of your application.

We are looking for 20 people who would like to beta test it and give us feedback. If you like profiling MySQL databases, or are curious to know what bottlenecks your site might have, please go to our beta page to receive download links and key. Use the following promotion code:

I LIKE MYSQL


2 Comments

Last week I attended the International PHP Conference 2008 in Mainz in Germany. The conference was well prepared and I would like to say thanks to organizers. There was just one thing, which could be better. It was raining for all my stay, but this nobody can influence:).

As I expected, almost nobody from the attendees knew the PHP support in NetBeans or NetBeans itself. PHP support in NetBeans is still new and the first version of the PHP support will be released with NetBeans 6.5, probably next week. Because our tool is still new for PHP developer, no surprise for me. I met probably less people than I have fingers, who knew NetBeans. Sun was one of the Gold sponsors and during opening ceremony the audience was asked whether there is someone who knows the PHP support in NetBeans. I think that there was  6 people who put up hand.

On Wednesday I had one session, where I did demonstration of features that are available in …

Today, the site was officially launched!

Soon, we will make the beta version of Jet Profiler for MySQL available to selected users! Contact us if you are interested.


Comments

I have accepted invitation from David Van Couvering to attend his session and present the PHP features in NetBeans. The session will take place this Thursday, 23rd October and will start at 9:00 Pacific Time (18:00 CET, 17:00 BST). We will use DimDim presentation system so everybody can attend. But  the session has limited capacity of attendees. More info about the session you can find here.

If you are interested, attend the session.

Hey everyone, I try to get the magazine out every three months on the 15th. Sometimes life gets in the way. Imagine that! The next issue is looking great and will be out very soon.

Not to early to start thinking about what you want in the next issue. I will be asking for article ideas very soon.

Keith

Last month I went to the Sun Microsystems / MySQL Developer Conference in Riga Latvia. Along with about 250 other people. The majority were MySQL developers, but as usual we had several attendees from MySQL support and administration, and a few non-MySQL people came to talk about Google, Drizzle, and PBXT. This was one of our annual “internal” conferences, so lots of stuff that we talked about in Riga will only be publicly announced around, say, the time of the next MySQL User Conference . I’ll just talk about the stuff that’s already leaked, and about my own involvements.

First let me give my impression of ‘morale’. It’s up, way up, since two years ago. I attribute this to two causes: removal of a problem, and a better team.

Huh? Haven’t I read non-MySQLers’ blogs about people leaving the team? …

The two big developments in the SQL world this summer are the pending arrival of the SQL:2008 ANSI standard, and my (Peter Gulutzan’s) attendance on Sun’s behalf at an ANSI meeting. Okay, I concede that the events have unequal importance, but sometimes I slip in a bit about personal involvements.

What’s a standard?

Review: ANSI (which stands for “INCITS Technical Committee H2 on Database”), and its counterparts in many other countries, produce official standards for many things, including SQL. The international co-ordinating body is ISO (International Organization for Standards), so there’s an ANSI standard and an ISO standard, and they’re practically the same. There’s a partially-restricted site containing ISO papers here.

The current edition is ANSI/ISO SQL:2003. But SQL:2008 is only a few days or weeks away. I’m taking a risk here by …

Did you know that many parts of the MySQL web sites provide news and updates via RSS Feeds? Markus Popp from our web team did a great job on making some of these more visible by adding RSS icons to the respective pages. If you want to keep up with what's happing at MySQL, consider adding the following feeds to your feed reader:

• New downloads on dev.mysql.com
  
• New DevZone articles
• PlanetMySQL (You probably knew that one already)
• MySQL Forge - All New Items
• …