Shulou(Shulou.com)06/01 Report--

This article is about how to view the mysql log, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

How to view mysql logs

Mysql has the following types of logs:

Query log:-log

Error log:-log-err

Slow log:-log-slow-queries

Update log:-log-update

Binary log:-log-bin

Steps:

1. Enable logging so that the value is ON

two。 View the current log: mysql > show master status

3. Query log: log

Log=C:/backend/MySQL/MySQL Server 5.5/log.txt

4. Error log: log-error

Log-error=C:/backend/MySQL/MySQL Server 5.5/log-error.txt

5. Binary log: log-bin

Log-bin=C:/backend/MySQL/MySQL Server 5.5/log-bin

MySQL is a relational database management system developed by the Swedish company MySQL AB and belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In the aspect of WEB application, MySQL is one of the best RDBMS (Relational Database Management System) application software. MySQL is a relational database management system in which relational databases store data in different tables instead of all data in one large warehouse, which increases speed and flexibility.

The above is how to view the mysql log, the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.