# mysql-log-parser

**Repository Path**: wang1352083/mysql-log-parser

## Basic Information

- **Project Name**: mysql-log-parser
- **Description**: mysql log parser (with percona slow query log format supper) (mostly stolen from Oracle's Mysql utilities)
- **Primary Language**: Python
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-11-27
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

Mysql Log parser
----------------

Retrieved from mysql-utilities (possibly bundled with MySQL workbench) and made
changes for Percona's slow log.

Usage
-----
Example file

```
# Time: 130131 11:09:34
# User@Host: det5mcxkw6dhenf6[det5mcxkw6dhenf6] @ localhost []
# Thread_id: 11441651  Schema: det5mcxkw6dhenf6
# Query_time: 6.058117  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0  Rows_affected: 0  Rows_read: 1
use det5mcxkw6dhenf6;
commit;
```

### Shell Example

```
In [1]: from mysql_log_parser.parser import SlowQueryLog

In [2]: f = open('mysql-slow-query.log')

In [3]: log = SlowQueryLog(f)

In [4]: log.next()
Out[4]: 
{'database': 'det5mcxkw6dhenf6;',
 'datetime': datetime.datetime(2013, 1, 31, 11, 9, 34),
 'host': 'localhost',
 'lock_time': Decimal('0.000000'),
 'query': 'use det5mcxkw6dhenf6;\ncommit;',
 'query_time': Decimal('6.058117'),
 'rows_affected': 0,
 'rows_examined': 0,
 'rows_read': 1,
 'rows_sent': 0,
 'schema': 'det5mcxkw6dhenf6',
 'session_id': None,
 'thread_id': '11441651',
 'user': 'det5mcxkw6dhenf6'}
```