How to query log paths by Mysql
Today, I would like to share with you the relevant knowledge about how to query the log path in Mysql. The content is detailed and the logic is clear. I believe most people still know too much about this, so share this article for your reference. I hope you can get something after reading this article. Let's take a look.
Methods: 1, "show variables like 'log_error'" query error log; 2, "... like' general_log_file'" query log; 3, "... like 'slow_query_log_file'" query slow log.
The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.
How to query log path by Mysql
Log in to mysql first
1. Find the error log file path
Show variables like 'log_error'
two。 Find the global log file path
Show variables like 'general_log_file'
3. Slow query log file path
Show variables like 'slow_query_log_file'
These are all the contents of the article "how to query log paths in Mysql". Thank you for reading! I believe you will gain a lot after reading this article. The editor will update different knowledge for you every day. If you want to learn more knowledge, please pay attention to the industry information channel.