AutoPatrol, Bureaucrats, Administrators
481
edits
Difference between revisions of "Details about database connection"
Jump to navigation
Jump to search
m
Details about database connection (view source)
Revision as of 18:13, 13 September 2022
, 18:13, 13 September 2022Text replacement - "^" to "{{deprecated}}"
Tomas Kirnak (talk | contribs) (Created page with "==General info== NetXMS creates the following database connections: {| class="wikitable" |- ! ID !! Name !! Description |- | 1 || General purpose background writer || A singl...") |
m (Text replacement - "^" to "{{deprecated}}") |
||
| (5 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
{{deprecated}}==Note== | |||
In 2.0, connections 1, 4 and 5 were moved to the connection pool (6). | |||
All DB connection pool server config variables were also renamed to contain the "DB" prefix.<br> | |||
Example: "ConnectionPoolBaseSize" -> "DBConnectionPoolBaseSize", etc. | |||
==General info== | ==General info== | ||
NetXMS creates the following database connections: | NetXMS creates the following database connections: | ||
| Line 6: | Line 11: | ||
! ID !! Name !! Description | ! ID !! Name !! Description | ||
|- | |- | ||
| 1 || | | 1 || Bootstrap / general purpose connection || A single persistent dedicated connection<br> | ||
Used as an initial connection to retrieve other settings from DB. Also used minimally during server run-time. | |||
|- | |- | ||
| 2 || idata writer || A single persistent | | 2 || idata writer || A single persistent dedicated connection<br> | ||
Used to write collected data for each DCI | Used to write collected data for each DCI | ||
|- | |- | ||
| 3 || raw_dci_values writer || A single persistent | | 3 || raw_dci_values writer || A single persistent dedicated connection<br> | ||
Used to write raw last collected value for each DCI | Used to write raw last collected value for each DCI | ||
|- | |- | ||
| 4 || Syncer thread writer || A single persistent | | 4 || Syncer thread writer || A single persistent dedicated connection<br> | ||
Used by the syncer thread to write object changes to the DB | Used by the syncer thread to write object changes to the DB | ||
|- | |- | ||
| Line 39: | Line 45: | ||
| 3 || Server.DBWriter.Requests.RawData | | 3 || Server.DBWriter.Requests.RawData | ||
|- | |- | ||
| | | 5 || Server.DBWriter.Requests.Other | ||
|} | |} | ||
You can then use DCI delta calculation to get the number of per second or per minute queue insertions. | You can then use DCI delta calculation to get the number of per second or per minute queue insertions. | ||
| Line 52: | Line 58: | ||
| 3 || Server.AverageDBWriterQueueSize.RawData | | 3 || Server.AverageDBWriterQueueSize.RawData | ||
|- | |- | ||
| | | 5 || Server.AverageDBWriterQueueSize.Other | ||
|} | |} | ||