Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > Storage Manager (STM) > SRM Profiler Administrator Guide > Advanced configuration of SRM Profiler > Modify database memory settings

Modify database memory settings

Table of contents
No headers

Updated: June 16, 2017

This is an advanced topic and if you feel uncomfortable performing any of the following steps please contact SolarWinds Support.

Most of the time, the database memory settings will not need adjusting. When SRM Profiler is initially installed it will check the specifications of the server and adjust itself given the resources provided. If you must adjust the memory settings for the database, this section will explain how.

SRM Profiler versions 5.6 and newer use MariaDB. For versions prior to 5.6, substitute MySQL for MariaDB.

Using a text editor, the my.cnf file can be modified to increase various memory settings for the database.

File Locations:

  • Windows: <installed drive>:\Program Files\SolarWinds\Storage Manager Server\mariadb\my.cnf
  • Linux: <installed path>/Storage_Manager_Server/mariadb/my.cnf

The values you may want to consider changing are:

  • key_buffer_size (size of the index buffers held in memory)
  • sort_buffer_size
  • read_buffer_size
  • myisam_sort_buffer_size
  • thread_concurrency
  • max_connections (be careful with this number, it should not exceed 700)
  • tmp_table_size (On a server with a lot of RAM this can dramatically help SQL performance. This should be set to the largest table size in the database)

Explanations of these variables can be found at the MariaDB website: https://mariadb.com/kb/en/mariadb/server-system-variables

The following table shows sample configurations referencing Small, Medium, and Large environments:

 

Small

Medium

Large

key_buffer

2048 MB

4096 MB

8192 MB

sort_buffer_size

2 MB

4 MB

16 MB

read_buffer_size

2 MB

4 MB

16 MB

myisam_sort_buffer_size

2048 MB

4096 MB

8192 MB

tmp_table_size

292 MB

585 MB

1170 MB

max_heap_table_size

292 MB

585 MB

1170 MB

thread_concurrency

4

8

16

max_connections

400

600

600

thread_concurrency= should always equal 2x the number of processors on the machine.

Once you have made all necessary changes, restart the database service, this will also force a restart of the Storage Manager Collector, Event Receiver, Web, Maintenance and Poller services.

After performing changes to database memory it is recommended to run Dbutil.

Dbutil is a script that ships with SRM Profiler that allows you to run maintenance routines to keep the database running smoothly. It also allows users to perform backups of the database. For more information, see dbutil.

 

 

Last modified
11:16, 26 Jun 2017

Tags

Classifications

Public