Do you remember Guy Adams? He was one of the winners of the “5.1 Use Case Competition”, ending up on position #2. Guess what: He has a webinar coming up tomorrow, by the title Deploying MySQL in a High Performance Satellite Network Management Environment by Parallel.
 
Guy works with Parallel Ltd. in Milton Keynes in the UK. You may also want to read up on Guy’s DevZone article. This is what you can expect of the webinar:

Join us for this informative technical webinar with Guy Adams, CTO at Parallel, whose flagship product SatManage is the worldwide …

Last week we had a team meeting, where we could discuss and plan various issues and ideas for current and upcoming versions of our project.

But finally it’s time to publish new material to show what we were up to in the past weeks. We have our first dual-platform-release of the MySQL Workbench 5.1.7 alpha version.

Please note, that in terms of UI linux- and OSX- version aren’t yet on the same level of completeness. While we are nearly done having all features onboard for the linux-build, we still have some more checkmarks to fill on the osx checklist - but we are catching up. Nevertheless it’s the same codebase - especially the backend-code is the same for all platforms.

Some of you might be missing a release - 5.1.6 for Linux. No, you didn’t miss an announcement: For the purpose of unifying the releases for Linux and mac we simply didn’t publish 5.1.6 last week. It was considered an internal release only and now …

There are plenty of new databases coming out, aiming to tackle the massively scalable domain that Google's BigTable pioneered. On the Radar mailing list, Jesse pointed out Cassandra (Facebook's offering) and Mike Loukides countered with Hypertable, asking "We're sort of being overrun with BigTable-style databases; I wonder what's going to win?". (Artur observed, "Cassandra is less like BigTable and more like a distributed column store with autocreating and searching in column namespace, but lacks a lot of indexing needed for BigTable.")

Jesse replied it'd be the one that's easiest for developers to use quickly, and I expanded that to:

• language and platform integration (e.g., Ruby, Rails, Django) so it can be used in the language you use to get stuff done
• higher abstractions available …

Quick DB Setups With MySQL Sandbox

There are various reasons to set up quick "sandbox" instances of MySQL. You can use them to test different types of replication (such as master-master or various slave topologies), to test your code against different versions of MySQL, or to setup instances of MySQL on a per developer basis where each person has their own database running on a different port so they can breakdown/setup the DB easily or make schema changes without affecting other team members. A perfect tool to do all of these things easily is MySQL Sandbox.

How can you write good multi-threaded code without using condition variables?

On most flavors of unix you have the pthread api which gives you pthread_cond_t structures and the related API functions. However on all version of Windows before Windows Vista and Windows Server 2008, the Windows API's did not come with any kind of condition variables. This makes it really hard to write multi-threaded code that works on both Windows and Unix systems especially if you want the code to behave in a similar way on all platforms.

Well Mysql developers solved this issue by writing their own version pthread_cond_t and related functions which can be found in the codebase in the files my_wincond.c. The code is #ifdef enabled on Windows platforms otherwise the standard pthread api is used. The implementation of condition variables in the mysql code base utilizes one CRITICAL_SECTION variable, and 3 arrays of Windows' Event objects. The …

Like a number of other Sun people, whether MySQLers or not, I will travel to Brussels next weekend, for FOSDEM ‘09, an acronym which stands for the Free and Open Source Software Developer’s European Meeting.  

If you think you’re late in registering, or if you don’t have a budget, don’t worry. Entrance is free, and registration isn’t necessary. “Just come to the campus and enjoy the conference”, the FOSDEM site stresses.

As for MySQL, we have a developers room on Sunday as follows:

I was looking for some info on liveblogging art this am because I never did a similar activity and was wondering if I am able to do it in the next confs I’m gonna taking.

Liveblogging means taking notes about a conference session you are listening and share the main concepts of the talk with people who are not present in the room.

I’ve found some tips on how to start a successful liveblogging session and tested a cool platform: http://www.coveritlive.com.

You know, liveblogging at a conference is very important for people who can’t attend it. It helps, among with pics and videos, to smell the great atmosphere you can breathe in a community event.

I think things are evolving well from this side.

If I am not mistaken, the most easy way to liveblogging is to create a short blog post during the speech and publish it at the conclusion of the …

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 …

Have you ever been upset by the Linux tendancy to swap… Especially when trying to allocate a large InnoDB buffer pool.. Look at the following output:

yves@yves-laptop:~$ free
total used free shared buffers cached
Mem: 2041888 1991096 50792 0 52 954592
-/+ buffers/cache: 1036452 1005436
Swap: 975200 1308 973892

There is still 50792 + 52 + 954592 = 1005436 of free memory and Linux starts to swap!!! The reason is hidden here:

yves@yves-laptop:~$ cat /proc/sys/vm/swappiness
60

The swappiness controls the Linux to swap for the File cache. For a file server or a web server or even MySQL with MyISAM tables, the file cache is interesting but for InnoDB or NDB Cluster it is close to useless. Only put a “0″ in that proc entry (echo 0 > /proc/sys/vm/swappiness) and add …

I received an email from Tarus Balog, CEO of OpenNMS Group, on Friday, taking issue with the language I had used to describe two open source vendors (and I use that term deliberately).

Essentially Tarus objected to me using the term “open source vendor” to describe two companies with Open Core licensing strategies. His email raises a valid point about how we determine which companies are considered “open source vendors” and I wanted to use the opportunity to outline the rules I use to make that decision.

As a technical snafu at our end had prevented Tarus from leaving a comment on the blog I hope he won’t mind me using his words to explain the issue he raised.

He wrote:

“You …