search

NUWCDIVNPT / stig-manager

An API and client for managing STIG assessments
Other
112 stars 29 forks source link

innodb lock table size is exceeded when calculating statistics #1316

Open csmig opened 3 months ago

csmig commented 3 months ago

Importing a reference STIG that is assigned to many assets errors in dbUtils.updateStatsAssetStigs()

image

Originally posted by @cd-rite in https://github.com/NUWCDIVNPT/stig-manager/issues/1315#issuecomment-2218226394

csmig commented 3 months ago

Common advice is to increase innodb_buffer_pool_size to 8GB if that is possible.

This article has a discussion of how to minimize the number of table locks at the query level.