huginn / huginn / 30390126980

88%

Pull #3704

github

Raise MySQL sort_buffer_size for JSON columns

With NATIVE_JSON_COLUMNS enabled, ORDER BY queries on events include
the JSON payload column in filesort rows, and MySQL 8 fails with "Out
of sort memory" (ER 1038) at the default sort_buffer_size of 256K.
Observed with AgentReceiveJob on a DataOutputAgent under MySQL 8.4.

- Set sort_buffer_size = 4M for the MySQL server bundled in the
  multi-process Docker image.
- Recommend the same in .env.example and the installation manual for
  self-managed MySQL servers.

0 of 50 branches covered (0.0%)

Branch coverage included in aggregate %.

8030 of 9036 relevant lines covered (88.87%)

940.12 hits per line