Detailed introduction to log settings

This article mainly introduces the MySQL log settings and viewing methods. Friends in need can refer to the following MySQL logs: Error log: -log-err query log: -log slow query log: -log-slow- queries update log: -log-update Binary log: -log-bin By default, all logs are created in the mysqld data directory. By flushing the log, you can force mysqld to close and reopen the log file (or in some cases switch to a new log). Log refresh 1 occurs when you execute a FLUSH LOGS statement or execute mysqladmin flush-logs or mysqladmin refresh. Error log Use the --log-error[=file_name] option to specify the location where mysqld saves the error log file. If no file_name value is given, mysqld uses the error log name host_name.err and writes the log file in the data directory. If you execute FLUSH LOG

1. Introduction to log settings and viewing methods in MySQL

Introduction: This article mainly introduces the MySQL log settings and viewing methods. Friends in need can refer to

2. Nginx record request Distribution log settings

Introduction:: This article mainly introduces the Nginx record request distribution log settings. Students who are interested in PHP tutorials can refer to it.

3. How to set the maximum number of days to save when the log in laravel is daily, laraveldaily_PHP tutorial

Introduction: laravel How to set the maximum number of days to save when the log is daily, laraveldaily. How to set the maximum number of days to save when the log is daily in laravel, laraveldaily In laravel, when the log is set to daily, logs for seven days will be saved by default. If the log exceeds seven days, the logs from seven days ago will be cleared. Can

4. How to set the maximum number of days to save when the log in laravel is daily, laraveldaily

Introduction: laravel How to set the maximum number of days to save when the log is daily, laraveldaily. How to set the maximum number of days to save when the log is daily in laravel, laraveldaily In laravel, when the log is set to daily, logs for seven days will be saved by default. If the log exceeds seven days, the logs from seven days ago will be cleared. Can

5. MySQL log setting optimization

Introduction: Linux Commune (www.linuxidc.com) is a professional Linux system Portal website that publishes the latest Linux information in real time, including Linux, Ubuntu, Fedora, RedHat, Red Flag Linux, Linux tutorials, Linux certification, SUSE

6. Oracle Nologging and Append Classic Summary

Introduction: The understanding of logging is always that if the log of the table is set to NO, it will not generate logs. Yes, actually it is not. Below are some explanations and experiments on logging. Logging introduction can be

7. MySQL slow log

##Introduction: What is the use of slow query? It can record all SQL statements that execute longer than long_query_time, help you find slow-executing SQL, and facilitate us to optimize these SQLs. Test MySQL version. Server version: 5.6.10-log Source distribution without any slow log settings. mysql show variables like "%que

##8.

Mysql table fragmentation cleaning_MySQL

Introduction: Recently, the operation of mysql in the production environment has declined, and some sql executions are also slow. First, check whether the slow query log is turned on, show variables like 'slow_query_log%', and then look at the slow log settings. time show variables like 'long_query_time%'

The above is the detailed content of Detailed introduction to log settings. For more information, please follow other related articles on the PHP Chinese website!