MySQL as Analytical Storage

You are looking at an older version of the documentation. The latest version is found here.

The Data Virtuality Server's Analytical Storage can also be powered by MySQL. Here are several points to keep in mind:

1. Only MySQL 8 and later support window functions that are often relevant for BI purposes. For older versions, the Data Virtuality Server must emulate the functionality since it does not exist in MySQL. This leads to degraded performance and higher resource consumption. Support for MySQL 8 in the Data Virtuality Server is currently still under development.
2. Poor performance of DELETE queries. MySQL shows very poor performance of certain DELETE queries when used in conjunction with subqueries since it fails to remember subquery results and instead re-evaluates it for every row considered for deletion. This can cause severe load problems and runtime issues on the server for large tables, thus burdening administrators.