Versions Compared

Old Version 26

changes.mady.by.user Otto Šteinbaums

Saved on

compared with

New Version 27

changes.mady.by.user Otto Šteinbaums

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel

MySQL

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

 

drfgrdgtdg

Code Block
innodb_buffer_pool_size = 1024M
innodb_log_file_size = 256M
query_cache_size= 16M
query_cache_type = 1
gtfdgf

f

tgh

fthfthf

Panel

PostgreSQL

You need to create a separate user flexbi_private with database creation rights for flex.bi:

Code Block
CREATE ROLE flexbi_private PASSWORD 'secret' LOGIN CREATEDB;

If you do not want to add the CREATEDB role to the flexbi_private user then manually create the flexbi_private database with flexbi_private user as the owner.

Each new flex.bi account will store data in a new flexbi_jira_dwh_N schema (where N is account ID number) in the same database.

Please tune PostgreSQL memory parameters. The following postgresql.conf settings are recommended:

Code Block
shared_buffers = 1024MB
wal_buffers = 32MB

The parameter shared_buffers will specify how much database data PostgreSQL can store in the memory - adjust it to your available server memory (the more data PostgreSQL will store in the memory the less disk input/output operations will be performed). The parameter wal_buffers affects the performance of writing transaction logs to disk.

...