MySQL管理工具MySQL Utilities — 解析MySQL日志文件

mysql.utilities.parser  模块提供了解析MySQL日志文件的类。目前,慢查询日志和通用查询日志都是支持的。

class mysql.utilities.parser.GeneralQueryLog(stream)

这个类解析MySQL 通用查询日志。实例是可以迭代的,不过该类不提供多个独立的迭代器的。如读取日志并打印数目:

Parameters:
  • stream (file type) – a valid file type; for example, the result of the built-in Python function open()

version

Returns: Version of the MySQL server that produced the log
Return type: tuple

program

Returns: Full path of the MySQL server executable
Return type: str

port

Returns: TCP/IP port on which the MySQL server was listening
Return type: int

socket

Returns: Full path of the MySQL server Unix socket
Return type: str

start_datetime

Returns: Date and time of the first read log entry
Return type: datetime.datetime

lastseen_datetime

Returns: Date and time of the last read log entry
Return type: datetime.datetime

class mysql.utilities.parser.SlowQueryLog(stream)

这个类解析MySQL慢查询日志的。实例是可以迭代的,不过该类不提供多个独立的迭代器的。如读取日志并打印数目:

Parameters:
  • stream (file type) – a valid file type; for example, the result of the built-in Python function open()

version

Returns: Version of the MySQL server that produced the log
Return type: tuple

program

Returns: Full path of the MySQL server executable
Return type: str

port

Returns: TCP/IP port on which the MySQL server was listening
Return type: int

socket

Returns: Full path of the MySQL server Unix socket
Return type: str

start_datetime

Returns: Date and time of the first read log entry
Return type: datetime.datetime

lastseen_datetime

Returns: Date and time of the last read log entry
Return type: datetime.datetime

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: