Monitor MySQL DB Activity

One way to monitor DB activity in MySQL is to enable logging and then tail the log file.

mysql -u root -p

You can check the status of logging and get the path of the log file with:

SHOW VARIABLES LIKE "general_log%";

And then enable logging with:

SET GLOBAL general_log = 'ON';

Finally, tail the log:

tail -f /usr/local/var/mysql/MUSPB250049-419.log

Monitoring MySQL logs
Monitoring MySQL logs

Tested on: MacOS Catalina, MySQL v8.019

Sharing is caring!

2 thoughts on “Monitor MySQL DB Activity”

  1. I watched the LG Dispenser video. Nicely done. I have a similar model of LG Refrigerator LFX25991ST. I was hoping to see a list of suggested repair parts. My dispenser (water and ice) work but I believe that one of the springs has gone bad or is broken. This tends to drop more ice than I need and I’m worried that this might develop into a bigger problem one day. I could clearly see the springs in your video. Do you have the part number and a supplier I can order from and have you done a video on this type of repair?
    Thanks

    1. When making that video, I had a spring pop off & had to get it back in there correctly.. they just kind of sit in these little seats / guides. Maybe one of yours has shifted out of the guides? I can’t imagine them breaking, really. But I would check the service manual for the part #s.

Leave a Comment

Your email address will not be published. Required fields are marked *


Notice: Undefined index: total_count_position in /var/www/wordpress/wp-content/plugins/social-pug/inc/functions-frontend.php on line 46
shares