Page Comparison

MySQL

You can create a separate flexbi_private user and grant it access to all MySQL databases which start with the flexbi_private prefix:

GRANT ALL PRIVILEGES ON `eazybi_private%`.* TO 'eazybi_private'@'%' IDENTIFIED BY 'secret';

(Replace secret with chosen password). When you will specify the database connection parameters in eazyBI then eazybi_private database will be created. Later when additional eazyBI accounts will be created then each account data will be stored in separate databases with names eazybi_jira_dwh_N where N is account ID number.

In addition you should download MySQL JDBC driver and copy included mysql-connector-java-*.jar to eazybi_private/lib directory (MySQL JDBC driver is not included in Private eazyBI distribution due to GPL license restrictions).

Please also tune MySQL memory settings to speed up both data import and data queries. The following my.cnf settings are recommended:

innodb_buffer_pool_size = 1024M
innodb_log_file_size = 256M
query_cache_size= 16M
query_cache_type = 1

innodb_buffer_pool_size will specify how much database data MySQL can store in memory - adjust it to your available server memory (the more data MySQL will store in memory the less disk input/output operations will be performed). If you will change innodb_log_file_size then it will require that you delete existing MySQL log files before starting MySQL server.