CMake is a cross-platform, open-source build system, maintained by Kitware, Inc.

From the CMake.org home page:

CMake is a family of tools designed to build, test and package software. CMake is used to control the software compilation process using simple platform and compiler independent configuration files. CMake generates native makefiles and workspaces that can be used in the compiler environment of your choice.

It has been used for building the MySQL Server on Windows since MySQL 5.0 – the initial CMake build support was added in August 2006.

For …

I spend the last couple days playing with InnoDB page compression on the latest Percona build.

I’m pretty happy so far with Percona and the latest InnoDB changes.

Compression wasn’t living up to my expectations though.

I think the biggest problem is that the compression can only use one core in replication and ALTER TABLE statements.

We have an 80GB database that was running on 96GB boxes filled with RAM.

I wanted to try to run this on much smaller instances (32GB-48GB boxes) by compressing the database.

Unfortunately, after 24 hours of running an ALTER TABLE which would only use one core per table, the SQL replication thread went to 100% and started falling behind fast.

I think what might be happening is that the InnoDB page buffer is full because it can’t write to the disk fast enough which causes the insert thread to force compression of the pages in the foreground.

…

Novell’s Q1. The future of OpenSolaris. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca

“Tracking the open source news wires, so you don’t have to.”

# Novell reported Linux platform revenue of $37.5m in Q1, up 6.4%.

# Internet.com reported that Novell’s Linux business broke even as Microsoft deal revenues fade.

# As the H reported Oracle exec Dan Roberts confirmed that OpenSolaris has a future at Oracle.

# Citrix acquired Paglo, launched GoToManage service.

# StatusNet …

There’s been a fair amount of attention – both positive and negative – on dual licensing in recent weeks. A few days ago Brian Aker wrote: “The fact is, there are few, and growing fewer, opportunities to make money on dual licensing.”

It is a sweeping statement, but one that is worth further consideration, especially since, as Stephen O’Grady noted it is directly contradicted by Gartner’s prediction that: “By 2012, at least 70% of the revenue from commercial OSS will come from vendor-centric projects with dual-license business models.”

Success?

I remember reading this prediction back in December but dismissing it as …

Just a quick notice to let everyone know that there is a new version of Kontrollkit available. There are two new scripts included as well as some good updates to the my.cnf files. You can download the new version here: http://kontrollsoft.com/software-downloads kt-mysql-systemcheck – generates a report for point-in-time system status that is useful for troubleshooting MySQL [...]

This is a simple matter with a simple solution that might help someone save time and confusion. Emacs wasn’t coloring my comments correctly so I went ahead and had it change them to red-italic. If you are having similar issues you can drop the following into your home directory’s .emacs file. Enjoy. Keep in mind that if you are using emacs in a terminal session as opposed to the X-server gui then you will not see the italics.


(global-font-lock-mode 1)
(custom-set-variables
'(gud-gdb-command-name "gdb --annotate=1")
'(large-file-warning-threshold nil))
(custom-set-faces
'(font-lock-comment-face ((((class color) (background light)) (:foreground "red" :slant italic)))))


It is a pleasure to announce that Kontrollbase – the MySQL analytics and performance monitoring webapp for MySQL servers – has a new sponsor. Network Redux is located in Portland, Oregon and offers enterprise quality dedicated and managed hosting as well as cloud services. Thomas Brenneke contacted me to discuss his interest in utilizing the [...]

Topics for this podcast:

*Jacobsen v. Katzer and open source impact
*Intel, Nokia team up for MeeGo open source OS
*Open source continues in embedded space
*MongoDB and the advent of the NoSQL databases
*Copyrights, complexities, control and conflict

iTunes or direct download (21:48, 6.07 MB)

We have published a new beta release of Version 5.2.16 Workbench Beta 6 build includes fixes for 67 bugs.

In Beta 6 we’ve also responded to great community ideas and feedback with various new convenience and security features:

1. Saving your profile/connection passwords in OSX keychain, gnome-keyring or – for windows – in a encrypted password-vault-file.
2. New rapid development features for generating complete SQL Select/DML statements or names for selected objects in Query Editor to either the query area or clipboard.
3. New in the Windows version (coming to Mac and Linux soon) the ability to set a preference for the placement of the sidebar in the Query Editor (left or right side.)
4. And last but not least, we put a good bit of focus on optimizing and stabilizing the administrator components.

We want to thank all the people who have been testing MySQL Workbench 5.2 alphas …

When I saw Shlomi's post on why not to use apt-get or yum for MySQL, I thought immediately that his conclusions are quite reasonable. What you get from the Linux distributions is not the same thing that you find in the official MySQL downloads page. Now, whether you value more the completeness of the server or the ease of administration through the distribution installation tools, it's up to you and your business goals. We at the MySQL team have organized a meeting with the Linux distributions with the intent of finding out which differences and problems we may have with each other, and to solve them by improving communication. What follows is a summary of what happened in Brussels during the meeting.

…