Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > MySQL错误日志(ErrorLog)_MySQL

MySQL错误日志(ErrorLog)_MySQL

WBOY
Release： 2016-06-01 13:02:46
Original
1083 people have browsed it

同大多数关系型数据库一样，日志文件是MySQL数据库的重要组成部分。MySQL有几种不同的日志文件，通常包括错误日志文件，二进制日志，通用日志，慢查询日志，等等。这些日志可以帮助我们定位mysqld内部发生的事件，数据库性能故障，记录数据的变更历史，用户恢复数据库等等。本文主要描述错误日志文件。

1、MySQL日志文件系统的组成 

2、错误日志

3、实战演示

#查看当前的错误日志配置,缺省情况下位于数据目录

#查看当前mysql server错误日志文件

#停止mysql服务器

#使用配置文件来设置log-error参数

#Author : Leshami

#修改my.cnf，删除skip-opt选项

#再次启动mysql服务器

从上面的错误日可以看出，错误日志文件的格式，通常如下

Related labels：
log mistake
source：php.cn
Previous article：解决mysql无法插入中文数据及插入后显示乱码的问题(亲测图文解说)_MySQL Next article：Mysql链接池超时断开解决方法探讨_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
PX automatic conversion to REM error  <style>html {   font-size: calc(100vw / 3.75);      }...
From 2024-04-16 09:34:16
0
0
4687
Sudoku checker not working? Can anyone help me identify the error? I tried everything on the online editor but still get the error. But when I do this on VSC...
From 2024-04-06 21:21:07
0
1
474
Unable to get input element from website So I'm trying to get an input element from Twitter, but when I run it it keeps giving me a...
From 2024-04-06 18:59:57
0
1
442
Invalid React child element (found: Object with key {clientVersion}). If you want to render a collection of child elements, use an array instead I have a multi-step form and when I try to submit it shows this error. However, if I use c...
From 2024-04-06 16:25:39
0
1
346
Submit form without button using Javascript/Jquery I'm trying to submit a form without a button by calling a JavaScript function and executin...
From 2024-04-06 14:54:03
0
2
421
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template