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

sjmudd / ps-top

ps-top - a top-like program for MySQL

BSD 2-Clause "Simplified" License

203 stars 31 forks source link

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

Closed nikolaps closed 10 months ago

nikolaps commented 1 year ago

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 commented 11 months ago

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 commented 10 months ago

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.