Starting ps-top fails with error XXX'Error 1146 'XXX

[nikolaps]

Hello,
Trying to run ps-top on mysql 5.6, but it fails with the following error:
2023/06/29 13:47:28 mylog.go:45: Unexpected errorXXX'Error 1146 'XXX

Checked the code memoryusage/rows.go the missing table is performance_schema.memory_summary_global_by_event_name, and indeed I don't have one. How can I ignore this check if I don't need the memory statistics anyway?

Thank you.

[sjmudd]

I've just noticed your comment.
I really haven't looked back at MySQL 5.6 as that's not just old but very old and not really supported.
I will see if I can fix behaviour to handle this problem in 5.6.
However, I'd really encourage you to move to a later version of MySQL especially given that MySQL 5.7 is also end of life now.
Ideally you should be using MySQL 8.0 or later.

[sjmudd]

I had a look and found the error was due to changes in https://github.com/go-sql-driver/mysql reporting of errors.
I think this should work now.
Please check on v1.1.8 or later.