Skip to main content

A Python tool/library that traces a value in MySQL general logs.

Project description

query-log-tracer

PyPI PyPI - Python Version GitHub Repo Size GitHub Workflow Status GitHub License

A Python tool/library that traces a value in MySQL general logs.

Usage

Set up

$ pip install query-log-tracer

Example usage

./tests/files/general-query.log is a sample query log file of MySQL 5.7. Most of the queries are generated by EC-CUBE 4.

$ query-log-tracer --log-file=./tests/files/general-query.log --target-table=dtb_customer --target-column=point --filter-column=id --filter-value=1
=== Searching in ./tests/files/general-query.log ===

2020-02-02T07:19:51.127168Z dtb_customer.point (id = 1) is set: '0'
2020-02-02T07:20:19.927027Z dtb_customer.point (id = 1) is set: '0'
2020-02-02T07:20:26.901577Z dtb_customer.point (id = 1) is set: '100'
2020-02-02T07:20:31.034901Z dtb_customer.point (id = 1) is set: '1000'
2020-02-02T07:20:39.396236Z dtb_customer.point (id = 1) is set: '2000'
2020-02-02T07:20:46.379143Z dtb_customer.point (id = 1) is set: '0'
2020-02-02T07:26:37.443522Z dtb_customer.point (id = 1) is set: '0'
2020-02-02T07:26:55.216881Z dtb_customer.point (id = 1) is set: '0'
2020-02-02T07:27:13.008757Z dtb_customer.point (id = 1) is set: '50'
2020-02-02T07:28:01.128957Z dtb_customer.point (id = 1) is set: '0'
2020-02-02T07:28:09.995354Z dtb_customer.point (id = 1) is set: '0'
2020-02-02T07:28:14.172518Z dtb_customer.point (id = 1) is set: '27'
2020-02-02T07:33:41.745400Z dtb_customer.point (id = 1) changes: +500

For EC-CUBE 2, try the following command.

$ query-log-tracer --log-dir=your-directory --target-table=dtb_customer --target-column=point --filter-column=customer_id --filter-value=1

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

query-log-tracer-0.0.1.tar.gz (10.6 kB view hashes)

Uploaded Source

Built Distribution

query_log_tracer-0.0.1-py3-none-any.whl (15.7 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page