Skip to main content
Skip table of contents

MySQL as Analytical Storage

The CData 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 CData 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 CData 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.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close