- Platform information:
- Hardware: Raspberry 4 8GB
- OS: Openhabian 3.3
- Java Runtime Environment: Standard Openhabian 3.3
- openHAB version: 3.3
- Persistence: MariaDB
- Issue of the topic:
I get each second multiple log entries in OpenHAB.log that are in relation to the persistence. These entries look like the below and whilst they are nice for statistical reasons, i do not see any add value other then they filling up my log files and soon a hardware provider can sell a new USB disk
Has anyone an idea where i can switch off logging this information?
2022-08-19 12:03:46.403 [INFO ] [persistence.jdbc.internal.JdbcMapper] - JDBC::logTime: 'storeItemValue':
afterAccess = 3 ms
timeAverage50 = 67 ms
timeAverage100 = 67 ms
timeAverage200 = 56 ms
afterAccessMin = 2 ms
afterAccessMax = 4120 ms
1000Statements = 497 sec
statementCount = 79
2022-08-19 12:03:46.410 [INFO ] [persistence.jdbc.internal.JdbcMapper] - JDBC::logTime: 'storeItemValue':
afterAccess = 4 ms
timeAverage50 = 51 ms
timeAverage100 = 67 ms
timeAverage200 = 56 ms
afterAccessMin = 2 ms
afterAccessMax = 4120 ms
1000Statements = 497 sec
statementCount = 80
2022-08-19 12:03:46.417 [INFO ] [persistence.jdbc.internal.JdbcMapper] - JDBC::logTime: 'storeItemValue':
afterAccess = 2 ms
timeAverage50 = 51 ms
timeAverage100 = 67 ms
timeAverage200 = 52 ms
afterAccessMin = 2 ms
afterAccessMax = 4120 ms
1000Statements = 497 sec
statementCount = 81
2022-08-19 12:03:46.423 [INFO ] [persistence.jdbc.internal.JdbcMapper] - JDBC::logTime: 'storeItemValue':
afterAccess = 3 ms
timeAverage50 = 51 ms
timeAverage100 = 67 ms
timeAverage200 = 52 ms
afterAccessMin = 2 ms
afterAccessMax = 4120 ms
1000Statements = 497 sec
statementCount = 82