FEAT: Viewing MySQL CPU/RAM/Swap/Query Cache/etc. usage

[Nv7-GitHub]

Details:
phpMyAdmin has the ability to view CPU usage, RAM Usage, Swap usage, Query cache usage, etc. in a real-time updating graph. Is there a way to view this in my MySQL connection from beekeeper studio?

Screenshot / GIF [if appropriate]:
phpMyAdmin:

[Zerotask]

This would be awesome!

[rathboma]

This is definitely possible! It's not currently a high priority item on our roadmap.

If someone can provide the queries I need to run to pull this information from the server as a PR then I could hook it up to charts.

[Zerotask]

A quick search showed me this: https://dev.mysql.com/doc/refman/8.0/en/show-status.html

SHOW STATUS;

+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Bytes_received | 155372598 |
| Bytes_sent | 1176560426 |
| Connections | 30023 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 8340 |
| Created_tmp_files | 60 |
...
| Open_tables | 1 |
| Open_files | 2 |
| Open_streams | 0 |
| Opened_tables | 44600 |
| Questions | 2026873 |
...
| Table_locks_immediate | 1920382 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_created | 30022 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 80380 |
+--------------------------+------------+

Which also references: https://dev.mysql.com/doc/refman/8.0/en/mysqladmin.html

mysqladmin proc stat

+----+-------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+----+---------+------+-------+------------------+
| 51 | jones | localhost | | Query | 0 | | show processlist |
+----+-------+-----------+----+---------+------+-------+------------------+
Uptime: 1473624 Threads: 1 Questions: 39487
Slow queries: 0 Opens: 541 Flush tables: 1
Open tables: 19 Queries per second avg: 0.0268

And the second reference is for the table performance_schema: https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-variable-tables.html

[zeescriptdev]

Hey @rathboma, I've created a helper functions to get the details in the below PR -
#2617

please let me know if you anything else :)

[Gaurav-yadav-03]

Hi, I’d like to work on this. Please assign me.

[Sahilnegi-code]

I would like to work on the issue

[sirrodgepodge]

/try