Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the wp-youtube-lyte domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/wordpress/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the wordpress-seo domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/wordpress/wp-includes/functions.php on line 6114
Monitor MySQL DB Activity - The Grok Shop

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 *