Monolith: MySQL server monitoring. I only have servers that run Redhat/Debian/Ubuntu Linux x86 and x86_64. I don’t have machines to test MySQL monitoring for the following OSes. Perhaps you would like to be a test candidate for the new version of Monolith? If so, let me know and you’ll be on the list, as well as get beta testing credit.

OSX Server: PPC and Intel

AIX

FreeBSD / OpenBSD / NetBSD

Windows Server

Solaris: Intel & Sparc

Linux servers that are NOT Intel based.

What this involves: testing the client script, perl modules, snmp stats, and other functions that may require a custom client script for that architecture.

Welcome to the 126th edition of Log Buffer, the weekly review of database blogs. Just to be different, let’s start with PostgreSQL this time.

The Postgres OnLine Journal offers their PostgreSQL 8.3 PLPGSQL Cheatsheet.

The ever-reliable Hubert Lubaczewski of select * from depesz; has a couple posts this week. He has a howto for recovering from a lost PostgreSQL password. Thanks, Hubert. We’ve all been there. He also introduces …

IBM picks Ubuntu for virtual desktop. Nokia acquires Symbian and prepares for open source. SourceForge gets a new CEO. Microsoft finds some old TCO numbers down the back of the couch. And more.

Official announcements
IBM and Business Partners Introduce a Linux-Based, Virtual Desktop IBM

Novell Reports Financial Results for Fourth Fiscal Quarter and Full Fiscal Year 2008 Novell

SourceForge Appoints Scott L. Kauffman President and Chief Executive Officer SourceForge

…

i ran some simple stats on mysql releases

*** mysql-4.1..mysql-5.0
commits: 7790
diffstat: 4424 files changed, 1271855 insertions(+), 199555 deletions(-)
 /sql      255 files changed,  129725 insertions(+),  41964 deletions(-)
 /test    1509 files changed,  954053 insertions(+),  15940 deletions(-)

*** mysql-5.0..mysql-5.1
commits: 6411
diffstat: 10244 files changed, 2172077 insertions(+), 1349098 deletions(-)
 /sql       243 files changed,  151483 insertions(+),   69799 deletions(-)
 /test     3862 files changed, 1258333 insertions(+),  206729 deletions(-)

*** mysql-5.1..mysql-6.0
commits: 3546
diffstat: 3574 files changed, 679669 insertions(+), 82131 deletions(-)
 /sql      226 files changed,  63619 insertions(+), 16469 deletions(-)
 /test    1772 files changed, 292884 insertions(+), 33553 deletions(-)
 /storage 1184 files changed, 281298 insertions(+),  9179 …

European Court of Human Rights orders the DNA records of 850,000 people, who were suspected of a crime but later cleared, to be wiped from a U.K. database.

The FOSDEM 2009 organizers have been very kind to us this year: in addition to a Developer Room on Sunday, we now also have a project desk (1 table) on both days! Thank you very much! In summary, this means that there will be the following MySQL-related activities:

• We will have a Project Stand (one table) on both days
• On Sunday, we will have a MySQL Developer Room, allowing us to schedule our own track of talks about MySQL and related projects
• I have been invited to give a talk about "MySQL High Availability Solutions" in the main conference track
• I also submitted two proposals for lightning talks ("What's new in MySQL 5.1" and "Why you should use Bazaar for maintaining your OSS …

The FOSDEM 2009 organizers have been very kind to us this year: in addition to a Developer Room on Sunday, we now also have a project desk (1 table) on both days! Thank you very much! In summary, this means that there will be the following MySQL-related activities:

• We will have a Project Stand (one table) on both days
• On Sunday, we will have a MySQL Developer Room, allowing us to schedule our own track of talks about MySQL and related projects
• I have been invited to give a talk about "MySQL High Availability Solutions" in the main conference track
• I also submitted two proposals for lightning talks ("What's new in MySQL 5.1" and "Why you should use Bazaar for maintaining your OSS …

There has been a lot of hoopla with regards to the GA release of MySQL 5.1. I’ve been using it on and off for quite a number of things, and during all my demonstrations, I make extensive use of it.

My advice?

1. Test it. If something’s not right, report a bug
2. See your fix, probably go into 5.1.31 or 5.1.32

The 5.1.31 tree is already quite busy. It can only be even better, with more extensive testing. And if history shows anything, people tend to only start using things when they’re GA (not even RC). A point of note: MySQL 5.1 release schedule - please read it.

Yesterday (December 4th), Sergey Petrunia gave a presentation on what's new in MySQL Optimizer. Unfortunately, the slides didn't show up in the Dimdim presentation area, which also means that the recorded session only has Sergey's voice but not the slides. (I've filed a bug in Dimdim's issue tracker.) However, Sergey kept referring to slide numbers in his talk, so it should be fairly easy (just not as convenient as usual) to follow his recorded presentation.

The slides, together with links to the recording and the chat transcript, can be found on the MySQL University session page.

Next week …

Changes (as compared to 2.83) includes:

Features:

* This release adds a ‘base time’ setting in MONyog. This setting (if defined by user) will be used for calculation of uptime-based counters. The reason for this implementation is that if FLUSH STATUS is executed with a MySQL server, specific server status variables will be reset to the same value as would be after a server restart. However the ‘uptime’ status variable itself is not affected by FLUSH STATUS. And as uptime-based counters will relate the value of cumultive status variables with some intial time, using the ‘uptime’ variable as the initial time will result in calculation of misleading values if FLUSH STATUS was executed. So to get true uptime-based counters in MONyog with servers that do not support the ‘uptime_since_flush_status’ variable (and currently only 5.0 COMMUNITY servers from 5.0.37 do - not ENTERPRISE servers …