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`flexbi_private%`.* TO 'eazybiflexbi_private'@'%' IDENTIFIED BY 'secret';

(Replace secret with yur chosen password). When you will specify the database connection parameters in eazyBI then eazybiflex.bi then a flexbi_private database will be created. Later when additional eazyBI accounts will be created then flex.bi accounts are created each account will store its data will be stored in a separate databases database with names eazybinames flexbi_jira_dwh_N where  (where N is account ID number).

In addition you should download MySQL JDBC driver and copy the included mysql-connector-java-*.jar to eazybi to the flexbi_private/lib directory (MySQL JDBC driver is not included in Private eazyBI flex.bi 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

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