FYI Monthy PKP Usage statistics report causes mysql 10.4 buffer overflow

Any solutions to this?
We are running into problems to upgrade our OJS 3 test.
It’s running latest Linux (Ubuntu or Debian) PHP and MySQL (8).
The sort_buffer variable does not exist in MySQL 8.
We created it but made no difference.
I’ll post our problem as a different post, anyway.