<commit_before>[![Project Status](http://opensource.box.com/badges/maintenance.svg)](http://opensource.box.com/badges)

Box Anemometer
--------------

This is the Box Anemometer, the MySQL Slow Query Monitor.  This tool is used to analyze slow query logs collected from MySQL instances to identify problematic queries.

### Documentation ###

1.	[What is Anemometer?](https://github.com/box/Anemometer/wiki)
2.	[Extra Features](https://github.com/box/Anemometer/wiki/Extra-Features)
3.	[Using PERFORMANCE_SCHEMA](https://github.com/box/Anemometer/wiki/Using-PERFORMANCE_SCHEMA-in-MySQL-5.6)
4.	[Collection Script](https://github.com/box/Anemometer/wiki/Anemometer-Collection-Script)
5.	[Development with Vagrant](https://github.com/box/Anemometer/wiki/Development-with-Vagrant)
6.	Installation: See Quickstart below

### Quickstart ###

If you're just completely itching to start using this tool, here's what you need:

1.	a MySQL database to store query analysis data in.
2.	[pt-query-digest](http://www.percona.com/doc/percona-toolkit/pt-query-digest.html).
	*	You may as well just get the whole [Percona Toolkit](http://www.percona.com/doc/percona-toolkit) while you're at it :)
3.	a slow query log from a MySQL server (see [The Slow Query Log](http://dev.mysql.com/doc/refman/5.5/en/slow-query-log.html) for info on getting one)
4.	a webserver with PHP


#### Setup DB ####

First up, grab the anemometer code from github. Navigate to the document root of your web server and snag a copy of the Box Anemometer code.

    $ git clone git://github.com/box/Anemometer.git anemometer 
Or, if you have 9418 port closed:

    $ git clone https://github.com/box/Anemometer.git anemometer 


Then change your current working directory to the Anemometer directory:

    $ cd anemometer
    <commit_msg>Update Readme with link to setup and run unit tests with PHPUnit<commit_after>[![Project Status](http://opensource.box.com/badges/maintenance.svg)](http://opensource.box.com/badges)

Box Anemometer
--------------

This is the Box Anemometer, the MySQL Slow Query Monitor.  This tool is used to analyze slow query logs collected from MySQL instances to identify problematic queries.

### Documentation ###

1.	[What is Anemometer?](https://github.com/box/Anemometer/wiki)
2.	[Extra Features](https://github.com/box/Anemometer/wiki/Extra-Features)
3.	[Using PERFORMANCE_SCHEMA](https://github.com/box/Anemometer/wiki/Using-PERFORMANCE_SCHEMA-in-MySQL-5.6)
4.	[Collection Script](https://github.com/box/Anemometer/wiki/Anemometer-Collection-Script)
5.	[Development with Vagrant](https://github.com/box/Anemometer/wiki/Development-with-Vagrant)
6.	Installation: See Quickstart below
7.  [Unit Testing](https://github.com/box/Anemometer/wiki/Unit-Testing)

### Quickstart ###

If you're just completely itching to start using this tool, here's what you need:

1.	a MySQL database to store query analysis data in.
2.	[pt-query-digest](http://www.percona.com/doc/percona-toolkit/pt-query-digest.html).
	*	You may as well just get the whole [Percona Toolkit](http://www.percona.com/doc/percona-toolkit) while you're at it :)
3.	a slow query log from a MySQL server (see [The Slow Query Log](http://dev.mysql.com/doc/refman/5.5/en/slow-query-log.html) for info on getting one)
4.	a webserver with PHP


#### Setup DB ####

First up, grab the anemometer code from github. Navigate to the document root of your web server and snag a copy of the Box Anemometer code.

    $ git clone git://github.com/box/Anemometer.git anemometer 
Or, if you have 9418 port closed:

    $ git clone https://github.com/box/Anemometer.git anemometer 


Then change your current working directory to the Anemometer directory:

    $ cd anemometer
    
{'fraction_non_alphanumeric': 0.12590799031476999, 'fraction_numerical': 0.009954264191552327, 'mean_word_length': 4.100137174211248, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 13, 'lorem ipsum': 0, 'www.': 4, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 4, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2510382', 'n_tokens_mistral': 1241, 'n_tokens_neox': 1191, 'n_words': 362}