MaxDB by MySQL 7.6.00.34 review

Download
by rbytes.net on

MaxDB is a heavy-duty, SAP-certified open source database for OLTP and OLAP usage which offers high reliability, availability, scalab

License: GPL (GNU General Public License)
File size: 72219K
Developer: MySQL AB
0 stars award from rbytes.net

MaxDB is a heavy-duty, SAP-certified open source database for OLTP and OLAP usage which offers high reliability, availability, scalability and a very comprehensive feature set. MaxDB by MySQL is targetted for large mySAP Business Suite environments and other applications that require maximum enterprise-level database functionality and complements the MySQL database server.

Today, about 6,000 customer installations are using MaxDB technology globally, including Toyota, Intel, DaimlerChrysler, Braun-Gillette, Bayer, Colgate, Yamaha, and Deutsche Post (the German Post Office).

Here are some key features of "MaxDB by MySQL":
Reduced cost of your SAP implementation
Easy configuration and low administration
Elaborate backup and restore capabilities
Continuous operation, no scheduled downtimes required
Designed for large number of users and high workloads
Scales to database sizes in the terabytes
High availability through cluster and hot-standby support
Synchronization Manager to control enterprise-wide data replication
Easy-to-use graphical database tools
Available for all enterprise HW/OS platforms
Supports all major SAP solutions

High performance, availability, operational reliability, scalability, ease of use, and low total cost of ownership are just a few of the demands that enterprise environments place on a DBMS infrastructure. MaxDB helps you meet these demands. It is a powerful, state-of-the-art DBMS built for enterprise usage scenarios.

Some other features of MaxDB;

Description Maximum Value
Database size 32 TB (with 8 KB page size)
Number of files/volumes per database 64...4096, specified by a configuration parameter
File/volume size (data) 518 ...8 GB (dependent on operating system limitations)
File/volume size (log) 16 TB (dependent on operating system limitations)
SQL statement length >= 16 KB (Default value 64 KB, specified by a system variable)
Identifier length 32 characters
Numeric precision 38 places
Number of tables unlimited
Number of columns per table (with KEY) 1024
Number of columns per table (without KEY) 1023
Number of primary key columns per table 512
Number of columns in an index 16
Number of foreign key columns per table 16
Number of columns in an ORDER or a GROUP clause 128
Number of columns in a SELECT statement 1023
Number of columns in an INSERT statement 1024
Number of columns in a result table 1023
Number of join tables in a SELECT statement 64
Number of triggers per Basis table 3
Number of indexes per table 255
Number of referring CONSTRAINT definitions (foreign key dependencies) per table unlimited
Number of references per table unlimited
Number of rows per table limited by database size
Internal length of a table row 8088 Bytes
Total of internal lengths of all primary key columns 1024 Bytes
Total of internal lengths of all foreign key columns 1024 Bytes
Total of internal lengths of all columns belonging to an index 1024 Bytes
Internal length of a LONG column 2 GB
Length of columns in an ORDER or a GROUP clause 1020 Bytes
Nested trigger levels unlimited
Nested subqueries 127
Number of join conditions in a WHERE clause of a SELECT statement 128
Number of correlated columns in an SQL statement 64
Number of correlated tables in an SQL statement 16
Number of parameters in an SQL statement 2000

What's New in This Release:
This maintenance release features some important bugfixes.

MaxDB by MySQL 7.6.00.34 keywords