We are pleased to announce that we are now able to release MONyog 2.5 FINAL.

First: for the overall concepts and considerations with this release please refer to this BLOG post (from the release of first beta).

Details for this release (as compared to version 2.06) are:

Features:

MySQL Server Log Analysis: MONyog is now able to retrieve (completely or partially) the General Query Log and the Slow Query Log (whether stored as files or tables on the server) from the MySQL servers it connects to and analyze them.

Query Sniffer: A ‘query sniffer’ is implemented that will record a ‘pseudo log’ on the client (MONyog) side. The sniffer is useful when ‘real logs’ are …

With 5.1 having officially been in Release Candidate status since September 2007 and soon approaching GA status, the MySQL Community Team launches a competition for the users of new features of MySQL 5.1:

Submit your MySQL 5.1 Use Case Report to community(at)mysql.com by 31 August 2008 and have a chance of winning one of our prizes:

• 1st-3rd prize: A MySQL Conference & Expo 2009 Pass, including a dinner with MySQL co-founder Michael “Monty” Widenius
• 4th-10th prize: MySQL …

Earlier this week I posted how OpenJDK was knock, knock, knockin' on Lenny's door.  At that time I also mentioned how it was already in Ubuntu and Fedora.

What I failed to mention, however, and was right under my very nose was that fact that OpenJDK had already made it into OpenSUSE 11.  Thanks to MySQL Euro-community manager and former SUSE employee Lenz Grimmer, I was …

Earlier this week I posted how OpenJDK was knock, knock, knockin' on Lenny's door.  At that time I also mentioned how it was already in Ubuntu and Fedora.

What I failed to mention, however, and was right under my very nose was that fact that OpenJDK had already made it into OpenSUSE 11.  Thanks to MySQL Euro-community manager and former SUSE employee Lenz Grimmer, I was …

Question: Do you think you have what it takes to take a service from a few hundred thousand users to tens of millions of users in 1 year flat? If you do read on and perhaps become the next beloved scalability rockstar of our age.

We are looking for a data charmer. A mysql magician. A code hack. A funny man. A mad man. A passionate man. Or perhaps a woman who does all these things and more.

Here’s what you gotta do:

• Pro-active and reactive performance analysis, monitoring and general database plumbing of all leaky issues.
• Work with others on the team to help maintain/improve and support the infrastructure for a high traffic, high growth site
• Optimize and tune the database day to day
• Algorithmic bent. Develop algos to quicken search times, response times, find shortest paths between various connections on site.
• Have solid low level …

MySQL Community Team launches a competition for the users of new features of MySQL 5.1.

Submit your MySQL 5.1 Use Case Report to community(at)mysql.com by 31 August 2008 and win!

The answer is yes.

In this face off we have two numeric MySQL data types, both Integer. In fact MySQL has 9 different numeric data types for integer, fixed precision and floating point numbers, however we are just going to focus on two, BIGINT and INT. This design consideration is part of my recent presentation Top 20 Design Tips for Data Architects.

What is the difference?
We turn to the MySQL Reference Manual first, in 10.1.1. Overview of Numeric Types we see the following.

INT[(M)] [UNSIGNED] [ZEROFILL]

A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295.

BIGINT[(M)] [UNSIGNED] [ZEROFILL]

A large integer. The signed range is …

I will be heading to my first OSCON next week where I will be presenting MySQL Proxy: from Architecture to Implementation in conjunction with Giuseppe Maxia .

As was written by Colin Charles Our booth is yours? Sun at OSCON, Sun/MySQL would appear to also have a reasonable turnout. So it will be good to see some old colleagues and friends, and hopefully meet some new contacts.

While I am based on the East Coast, I do also provide expert MySQL consulting for clients in any location. Should you like to find …

Already scheduled for some time, but since it's a new location for MySQL training it's probably worth an extra mention. Ye that's right, MySQL itself has never held a training course in Canberra either (I know since I was the trainer ;-) except for some custom stuff. The DBA days are pretty soon but there are still some seats.

MySQL DBAsMon 4 Aug: MySQL Installation, Security and User Management ($475)
Tue 5 Aug: MySQL Backup and Recovery ($475)
Wed 6 Aug: MySQL InnoDB Performance Tuning ($575) You can pick individual days if you want. For …