Problem: sort_buffer_size variable is not included in templates
mamedin opened this issue · 1 comments
mamedin commented
This variable is useful to fix the following mysql error (seen in AtoM 2.6 and percona 8):
2020/10/17 09:44:33 [error] 9559#9559: *547098 FastCGI sent in stderr: “PHP message: [wrapped: SQLSTATE[HY001]: Memory allocation error: 1038 Out of sort memory, consider increasing server sort buffer size]” while reading response header from upstream, client: XXXXXXXX, server: YYYYYYYYYY, request: “GET /jobs/browse HTTP/1.0", upstream: “fastcgi://unix:/var/run/php-fpm.ZZZZ.sock:“, host: “YYYYYYYYYYY”, referrer: “YYYYYYYYYYYYYYY/”
Default value is 256K