mytop fork to support MySQL 8.0 & MariaDB 10.3 or newer releases

fevangelou

As a sysadmin, I have used mytop daily for many many years.

As I gradually moved my fleet to Ubuntu Server 24.04, mytop was no longer an apt install away.

Plus, manually installing it did not really work.

Innotop also does not work properly (e.g. EXPLAIN fails, defaults are bad etc.).

So I vibe coded it with Claude (as Perl is not really my domain) and will plan on maintaining it and even porting it to another language in the future.

This version also adds quality of life improvements like better defaults & helpful messages for required dependencies (previously missing). On Debian/Ubuntu systems it just works, with zero configuration.

Just sharing it with the world as other sysadmins may miss mytop on newer systems.

https://github.com/fevangelou/mytop

P.S. It was based off v1.91 (see https://www.mysqlfanboy.com/mytop-3/). Running diff will reveal the changed parts.

Levi

It is good that you spent precious claude tokens on this. A bit better would be to disclose which parts was modified/added by llm. That way contributors may help you to identify potential haliucinations and over complications.

Non-the-lesa thank you, a nice tool.

fevangelou

It was based off v1.91 (see https://www.mysqlfanboy.com/mytop-3/). Running diff will reveal the changed parts. Claude actually caught valid syntax errors in v1.91.

raindog308

@fevangelou said: https://www.mysqlfanboy.com/mytop-3/

"mytop is very wicked."

Well then I'm not going to use it. Shame on mytop.

ScreenReader

screenshot where?

fevangelou

@ScreenReader I haven't uploaded one, but it's identical to previous versions. The only slight difference is I've added the proper database name (MySQL or MariaDB) top left, followed by mytop's version. This way, future versions will prompt you to upgrade (there is no such mechanism right now though). The code is open for a reason. It's easy to compare to mytop v1.91 (previous version, released years ago).

Here's a sample (with some requests shown)

amarc

So this is just fancy "show full processlist" ?

ScreenReader

@fevangelou said:
@ScreenReader I haven't uploaded one, but it's identical to previous versions. The only slight difference is I've added the proper database name (MySQL or MariaDB) top left, followed by mytop's version. This way, future versions will prompt you to upgrade (there is no such mechanism right now though). The code is open for a reason. It's easy to compare to mytop v1.91 (previous version, released years ago).

Here's a sample (with some requests shown)

please include those screenshot in the github repository. at very least one image after first description in readme file. it's convenient for anyone want to check visually how the output looks like. if you want to upload recording of terminal session you can use https://asciinema.org/

fevangelou

@ScreenReader Check.