New Features in this release

NuoDB 3.2 includes the following new features:

Improved Memory Management

Memory management has been improved to prevent a Transaction Engine (TE) or a Storage Manager (SM) from using more memory than the value specified by the --mem parameter. This new memory management capability allows NuoDB to ensure consistent performance. It is recommended that this value is set to the maximum memory available to the TE or SM in your environment. For more information see Tasks After Upgrading to Release 3.2 and Database Options.

Index Statistics for Partitioned Tables

Index statistics are now available for partitioned tables. This helps improve the selection of optimal query plans by the optimizer where partitioned tables are used. For more information on using partitioned tables, see Using Table Partitions and Storage Groups.

To assist with understanding statistics on a partitioned table, a new SPAN column has been added to the STATSCACHE table. This new column lists the partitions that are spanned by each of the cached statistics. Where tables are not partitioned, the SPAN column does not populate. For more information on this table, see STATSCACHE System Table Description.

NuoDB Manager Enhancements

The remove region and remove host commands include a database parameter which helps enable removal of all processes in a region or a host for the database specified. This database parameter is now optional. As a result, if not specified, all processes in the specified region or host are removed. For more information, see Remove Region and Remove Host.

Logging Updates

To track the SM recovery process, log messages are now created every five seconds during SM recovery. Each log message states: Processed X files, Y% bytes., where Y is the total number of bytes of all journal files being recovered from. For more information on logging, see Using Log Files.