Topics for this podcast:

*EC pauses Oracle-Sun over MySQL
* Open source licenses debated
* Red Hat growth opportunities and Summit roundup
* Reductive Labs seeking cloud role for Puppet software
* VMware-SpringSource analyzed

iTunes or direct download (26:04, 5.9 MB)

It's almost two weeks now since FrOSCon and the OpenSQL Camp subconference have taken place in Sankt Augustin, Germany — about time for a summary and update from my side!

First off, I would like to thank all of the participants and supporters, particularly my colleagues Regina Steyer and Iris Musiol for the perfect logistics and co-sponsoring as well as Uli Graef, Thorsten Frueauf, Matthias Schmidt, Alexander Rubin and Joerg Moellenkamp for manning the Sun booth and the help on site.

Another big Thank You goes out to my team mates …

There are seven new INFORMATION_SCHEMA tables (plugins) available with the InnoDB plugin.  They need to be loaded to be used.

New InnoDB Plugins contain information on: Compressed InnoDB tables Compressed InnoDB buffer pool Current InnoDB transactions Transaction Locks Blocking transactions

These INFORMATION_SCHEMA plugins are available by setting the plugin-load parmeter:

plugin-load=

Welcome to the 160th edition of Log Buffer, the weekly review of database blogs.

MySQL

Blame it on MyISAM, says Mark Callaghan of High Availability MySQL, on considering sql_mode and type coercion. “I think that MyISAM has its place,” writes Mark. “It does fast table scans, but InnoDB is much faster on just about everything else. I am just not thrilled with the impact it has had on MySQL.”

Not that those other engines are without flaw. Peter Zaitsev reports on an InnoDB performance gotcha with larger queries.

Here on the …

 Here is the set of new parameters available with the InnoDB Plugin 1.0.4

NameScopeDynamicDefault

innodb_adaptive_flushingGLOBALYESTRUE innodb_change_bufferingGLOBALYESinserts innodb_file_formatGLOBALYESAntelope innodb_file_format_checkGLOBALYESON innodb_io_capacityGLOBALYES200 innodb_read_ahead_thresholdGLOBALYES56 innodb_read_io_threadsGLOBALNO4 innodb_spin_wait_delayGLOBALYES6

From 1.1.0 on, Connector/C++ can optionally use run-time dynamic linking to access the MySQL Client Library (AKA libmysql). If you make use of this new feature, it will not only change the application binary interface (ABI) but also has some impact on your client applications. The new expert setting is not enabled by default. By default, you will not notice any differences.

The next version of MySQL Connector/C++ will be numbered 1.1.0. 1.1.0 marks the successful end of the first year of development. The driver finally offers everything needed by its two "internal customers". Also, feedback from MySQL Workbench and Connector/OpenOffice.org and the bug inflow demonstrated the maturity that has been reached making it a logical step to bump up the version number.

While MySQL Workbench has been happy with the feature set for a while, we implemented a couple of changes in 1.1.0 to also …

From 1.1.0 on, Connector/C++ can optionally use run-time dynamic linking to access the MySQL Client Library (AKA libmysql). If you make use of this new feature, it will not only change the application binary interface (ABI) but also has some impact on your client applications. The new expert setting is not enabled by default. By default, you will not notice any differences.

The next version of MySQL Connector/C++ will be numbered 1.1.0. 1.1.0 marks the successful end of the first year of development. The driver finally offers everything needed by its two "internal customers". Also, feedback from MySQL Workbench and Connector/OpenOffice.org and the bug inflow demonstrated the maturity that has been reached making it a logical step to bump up the version number.

While MySQL Workbench has been happy with the feature set for a while, we implemented a couple of changes in 1.1.0 to also …

The InnoDB Plugin (1.0.4) is  pretty straight forward configuration. These instructions are for MySQL 5.1.38.  There is a new release of InnoDB Plugin with the 5.1.41 release. With MySQL you can use the default version of InnoDB or the new Plugin but not both.  If using a non-default configuration make sure and set the plugin_dir variable to point to the ha_innodb_plugin library for your system.

Red Hat round-up. EC to review Oracle-Sun. Dedicated Ubuntu support. 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.”

Red Hat announcements round-up
Red Hat announced a whole heap of products and projects this week. They should have organized an event to coincide with all the announcements. Or something. The biggest news was probably the launch of Red Hat Enterprise Linux 5.4 including KVM and other virtualization capabilities, while Red Hat and HP partnered to optimize Red Hat Enterprise Virtualization for HP BladeSystem Matrix. The company also revealed that Red Hat Network Satellite …

This is very relevant in the context of the EU probe of the Oracle-Sun takeover. MySQL’s share of the database market, which is usually measured by revenue, is of course peanuts and estimated range from half a percent to something slightly more. Peanuts.

This is not surprising, considering an estimated 999 out of every 1000 MySQL users does not pay Sun/MySQL anything (although some might be Open Query clients and while MySQL has been targeting higher-end clients and corresponding higher revenue, its pricing is still far lower than the premium-cost of Oracle, DB2 and the like.

All this proves very clearly something which I’ve been saying for years (do scan back in my blog , the definition of market share is borked when it comes to Open Source and low-end disruptors (MySQL has been both although it might no longer be a low-end disruptor, having overshot the needs of a significant chunk of its users). The market …