Previous Topic: Identify optionsNext Topic: Changing MySQL Sizing on Linux


Perform Sizing

Consider two factors when sizing the product server:

  1. Number of business indicators configured
  2. Maximum number of concurrent users actively requesting data

The number of BIs you configure has a direct effect on the size and performance of the MySQL database and therefore on the CA Executive Insight server.

For more information, see the MySQL guide at http://dev.mysql.com/.

Number of Business Indicators

MySQL
CPU Cores

MySQL
Memory
(See Important Note)

MySQL
Disk I/O
Per Second

CA Executive Insight CPU Cores

MySQL Disk Space

< 500

1

1 GB

100

1

1 GB

500 – 1000

2

1 GB

200

1

2 GB

1000 – 2000

2

1.5 GB

300

2

4 GB

2000 – 3000

3

1.5 GB

400

2

8 GB

3000 - 5000

4

2 GB

600

3

12 GB

5000 - 10000

4

2.4 GB

800

4

16 GB

Important! For optimal memory performance, configure the MySQL property innodb_buffer_pool_size with 150 MB of memory for each 1000 business indicators.