Infobright IEE-MySQL 4.8.3p1 Release Notes

Introduction

We are happy to share the release notes for the Infobright IEE-MySQL 4.8.3p1.

Summary

The main changes in this release include performance improvements, bug fixes, and updates to configuration management.

Features

New licensing requirement for every instance of the Infobright server.
New configuration management via the infobright.cnf file.
Enhanced logging capabilities including log rotation and function execution time logging.
Replication is now supported for Infobright tables loaded using the Infobright loader.
Many Infobright components have been renamed for better clarity and consistency.

Bug Fixes

Resolved various performance issues affecting query execution times.
Fixed bugs related to query accuracy, including known issues with the TRUNCATE function and SELECT from SUBQUERY.
Addressed installation and configuration challenges, particularly regarding new parameter requirements.

Installation Notes

If upgrading from version 4.0.7 or older, please back up your data directories and contact Infobright Support to ensure all necessary steps are followed during the upgrade.

After upgrade, ensure to manually create and configure the infobright.cnf file in the data directory.

Key Changes in Configuration

The infobright.cnf replaces previous configuration files like .infobright and brighthouse.ini, which are now obsolete.
Three new parameters introduced: HandshakeTimeout, PeerCommitTimeout, and ConnectTimeout.
An updated log management system that includes log rotation and dynamic changes to logging levels.

Performance Improvements

DE3639: Loading of delete mask no longer blocks other queries.
DE3653: Improved performance for LOJ queries under certain circumstances.
DE3662: Improved performance for AGGREGATION/DISTINCT queries.
DE3770: Resolved deadlock issues.

Query Accuracy Fixes

DE3698: TRUNCATE function no longer performs rounding.
DE3748: SELECT from SUBQUERY now consistently returns correct results.
DE3751: CASE WHEN queries now produce correct results.
DE3761: BETWEEN conditions correct under all scenarios.

Release Notes

For the complete set of release notes, please refer to the documentation here: Infobright IEE-MySQL 4.8.3p1 Release Notes.