PlanetMysql.ru — информация о СУБД MySQL

Available immediately Flexviews 1.6.0-RC2.

This release is a bugfix release.  This is the second Flexviews release candidate.  If no major bugs are discovered the next release will be the GA release.

Flexviews is a stored procedure managed materialized view system for MySQL 5.1 or greater. 

What is fixed in Flexviews 1.6.0-RC2?

• Numerous performance fixes. 
  • Flexviews uses fewer temporary tables and subqueries
  • A full table scan of the view is no longer required (only changed GB keys are scanned)
  • Dead code has been removed
• Bug fixes
  • Removing tables and adding them to a view again could result in the WHERE clause being generated in the wrong order
  • Fix a problem with applying deltas to views which use PERCENTILE
  • Improved error messages
• FlexCDC Bug fixes
  • Bulk insert mode did not work when a transaction changed rows in more than one table

Please note that I am not currently making separate FlexCDC releases.  If you are only interested in FlexCDC, you will find it in the consumer/ subdirectory of the Flexviews tarball.  I will package FlexCDC up as a standalone release along with the GA release of Flexviews.
PlanetMySQL Voting: Vote UP / Vote DOWN

Whats new in Flexviews 1.6.0RC1

• This is the first release candidate before the final release.  If no major bugs are uncovered, then the next release will be the first GA release. 
• Flexviews now has a test suite for all major features.  The creation of these tests uncovered a number of issues which have been resolved in this release. 
• All MySQL aggregate functions except GROUP_CONCAT are now supported. 
• A special aggregate function called PERCENTILE is now also supported.  The calculation uses a modified version of the GROUP_CONCAT based solution suggested by Roland Bouman for percentiles.  This function should be considered experimental.  Please report bugs if you find any.
• You can add indexes to enabled materialized views using SQL_API/add_expr
• Adding PRIMARY KEY indexes is no longer supported.  All views get an auto_incrementing primary  key.  You can add additional UNIQUE indexes instead.
• There is an upgrade process from 1.5.3b (see UPGRADE and upgrade.sql)

Significant bug fixes

• Views with aggregate functions but no GROUP BY columns now work properly for all supported aggregate function types
• NULL values in GROUP BY columns are now properly supported
• NULL values now work properly with distributive aggregate functions
• There is a wrapper script around run_consumer.php which can restart the consumer if it stops running

As always, get it at:
http://sourceforge.net/projects/Flexviews
PlanetMySQL Voting: Vote UP / Vote DOWN