With this post I want to start the practice of writing short weekly summaries of QOT activities.

This week I was able to work on some bug reports: #12 #13 #14 #15. Some trivial crashes, some of which were already fixed before. As I wrote in my previous post, I have changed the way I do the releases so if you want to have all the latest features and fixes be sure to use the latest Launchpad version of QOT.

Besides the bugs I started to rework my testing environment. Earlier I had a set of C++ - based unit-tests. I used while-box …

Sorry for the downtime of this site - until around a week ago I hosted my home page on a trusty Genesi Pegasos II system (powered by a PowerPC G4 Processor clocked at 1GHz, using Debian 4.0 PPC with 512 MB of RAM), serving these pages from my home DSL connection. Unfortunately this system provided no means of redundancy - the hard disk drive died.

Luckily I perform frequent backups, so I moved most parts of the site to a shared hosting space now - the picture gallery is unfortunately too big to fit into the space that I have there. I'll try to move the pictures into my Flickr account instead, but this will take some time.

Note that the primary domain name of this site is now lenzg.net - lenzg.org, (the …

I don’t think I’ll be attending the MySQL Conference & Expo this year (I didn’t manage to get a session accepted), but I just learned from Twitter that Don MacAskill is delivering a keynote I would have liked to attend.

He’s planning to talk on MySQL and SSD-based storage. SmugMug is using Sun’s new 7000 series storage servers to great success and I am interested in seeing the benefits that from from SSD storage from someone who knows.

I’ll just have to bribe …

General

Being quite busy with my full-time job at PrimeBase Technologies and quite limited in time for QOT development I was looking for ways to optimize the process around QOT.

I came to a conclusion that instead of preparing and releasing milestone binary releases it will be more optimal to declare the main project trunk to be the permanent release place and “release” the new features and bug-fixes by simply pushing them to the main trunk. This way I will be able to make individual features and bug fixes available as soon as possible. So

to install QOT for the first time you do:

1. install Bazaar

2. run “bzr branch lp:qot” from the shell to get the latest stable QOT sources

3. follow the usual QOT …

Hi,

We are pleased to announce MONyog 3.0 - a major new release. MONyog is rapidly becoming a cost-effective alternative to expensive proprietary tools for MySQL monitoring.

Unlike databases like SQL Server & Oracle, MySQL does not provide powerful APIs to gather extensive profiling information about each and every query. MySQL developers and DBAs have largely used on a combination of the following techniques to find problem SQL:

1. SHOW PROCESSLIST
2. Slow Query Log and General Query Log
3. SHOW PROFILES (available from MySQL Community version 5.0.37)
4. Capturing and filtering tcpdump output

To overcome the shortcomings of profiling features in the MySQL server, MySQL Proxy was introduced which allows developers to route queries via MySQL Proxy and then extract profiling information from MySQL Proxy. (It also provides other features like load balancing, query rewriting, …

This is the first public release. Features:

• Top Queries - See which queries are being run the most on your server.
• Top Users - See which users are using your server the most.
• Top Tables - See which database tables are opened the most.
• Top States - See which states your database is most busy doing, such as creating temp tables.
• Replication Profiling - You can measure how much capacity you have left on the replication SQL thread on slaves. If you are using MyISAM a lot, a MyISAM lock analysis will help discover any locks associated with replication, as well as lock-prone queries in general.
• Query Ratings and Visualization - You can get your queries rated using EXPLAIN and see which queries are …

All of us here at Percona warmly invite you to Percona Performance Conference 2009 on April 22 and 23, 2009 in the Hyatt Regency in Santa Clara, California. The theme for the conference is Performance Is Everything. This conference is about application performance overall, not just databases. Attendance is free of charge for everyone. Experts in many types of technologies -- databases, search, cloud computing, massively parallel computing, client-side optimization -- will present their real-life experience.

In order to forestall speculations and prevent people from jumping to unwarranted negative conclusions, I'd like to take a moment and explain the story behind this event. Some of you have noticed that there were no sessions from Percona this year on the schedule for the …

I’ve said before that Message Systems is the best place I’ve worked so far, and we’re looking for more people to join the team.

We’re looking for the following roles:

• Product Manager, Mobile Messaging
• QA Lead/QA Manager
• Professional Services Engineer
• Software Engineer
• Support/Maintenance Engineer
• …

Hi,

SQLyog 8.0 is a major new version of SQLyog introducing major features like Query Profiler, SQL Formatter and vastly improved look and feel.

Query Profiler:

MySQL has always lacked the sophisticated profiling tools shipped with proprietary databases like SQL Server, etc. MySQL developers have largely depended on EXPLAIN for tuning queries. The SHOW PROFILE patch by Jeremy Cole was introduced in the MySQL Community version 5.0.37 and it provided much more insight into where the query spends its time. However, to take advantage of this feature, MySQL developers were supposed to switch on profiling, run their queries and then filter the profiling data from a table that contained the profiling results of the last few profiled queries. A lot of manual book-keeping is required to take advantage of …

Dear Mac users,

There have been a number of issues with configuring XAMP on the Mac for use with NetBeans IDE, most significantly that XAMP sets the owners of MySQL databases to "nobody", blocking Apache access. Therefore I have changed the Mac OS setup tutorial to use MAMP instead of XAMP. In my opinion, the MAMP setup is more straightforward than the one for XAMP, anyway.