MySQL Utilities 1.6 Manual  /  ...  /  mysql.utilities.parser — Parse MySQL Log Files

Beta Draft: 2016-09-16

6.4.1 mysql.utilities.parser — Parse MySQL Log Files

This module provides classes for parsing MySQL log files. Currently, Slow Query Log and General Query Log are supported.

Classes

class mysql.utilities.parser.GeneralQueryLog(stream)

This class parses the MySQL General Query Log. Instances support iteration, but the class does not provide multiple independent iterators.

For example, to read the log and print the entries:

>>> general_log = open("/var/lib/mysql/mysql.log")
>>> log = GeneralQueryLog(general_log)
>>> for entry in log:
...     print entry
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)

This class parses the MySQL Slow Query Log. Instances support iteration, but the class does not provide multiple independent iterators.

For example, to read the log and print the entries:

>>> slow_log = open("/var/lib/mysql/mysql-slow.log")
>>> log = SlowQueryLog(slow_log)
>>> for entry in log:
...     print entry
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

User Comments
Sign Up Login You must be logged in to post a comment.