# Query-Digest-UI

**Repository Path**: smgano/Query-Digest-UI

## Basic Information

- **Project Name**: Query-Digest-UI
- **Description**: 使用pt-query-digest分析慢查询日志并将查询分析数据保存到MySQL数据库表中.然后使用Query-Digest-UI来展示分析结果.
由于Query-Digest-UI是基于PHP的Web应用程序,因此需要LAMP环境的支持.

查询分析结果可视化步骤如下:
http://www.ttlsa.com/mysql/mysql-slow-query-log-analysis-and-visualization-of-results/
- **Primary Language**: PHP
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2019-03-14
- **Last Updated**: 2024-05-30

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

Query-Digest-UI
====

This is a advanced, but easy to install, ui for [pt-query-digest](http://www.percona.com/doc/percona-toolkit/pt-query-digest.html) or [mk-query-digest](http://www.maatkit.org/doc/mk-query-digest.html).

Features
====
-   Dynamic filtering and searching of queries
-   Colorized and normalized SQL syntax
-   Explain the query dynamically
-   Integrated [pt-query-advisor](http://www.percona.com/doc/percona-toolkit/2.0/pt-query-advisor.html) support
-   Detailed query historic stats, support for [log_slow_verbosity](http://www.percona.com/doc/percona-server/5.5/diagnostics/slow_extended_55.html#log_slow_verbosity).

Requirements
====
Apache, mod_php, php_pdo

Install
====
Clone to a docroot, copy config.php.example to config.php and edit.
Head to the root url in your browser and away you go!


[![Bitdeli Badge](https://d2weczhvl823v0.cloudfront.net/kormoc/query-digest-ui/trend.png)](https://bitdeli.com/free "Bitdeli Badge")