Install Mtools on a 64-bit Windows Server R2

Install Mtools on a 64-bit Windows Server R2

The Installation Wizard provides step-by-steps guidance for installing Mtools on Microsoft Windows Server R2.

Prerequisites

• Windows PowerShell needs to be installed.

• The host must have access to the Internet.

Installation Steps

1. Download and install Python 2.7.x (current version 2.7.10)

A) Enter https://www.python.org/downloads/

b) Select the latest 2.7.x catalog.

c) Download Windows x86-64 MSI Installer (not 32-bit Windows x86 MSI Installer).

d) include the "Add Python.exe to Path" option during the installation process (default is disabled).
Note: The PATH environment variable can be verified and set through PowerShell, as detailed in the PowerShell environment variables section.
Displays the value of the PATH environment variable:
ps> $env:P Ath
Set the value of the PATH environment variable on the host:
ps> [Environment]::setenvironmentvariable ("PATH", "; C:\Python27; C:\Python27\Scripts "," User ")
ps> [Environment]::getenvironmentvariable ("PATH", "User")
Verify that the environment variable is configured successfully:
650) this.width=650; "title=" clip_image002 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image002 "src=" http://s3.51cto.com/wyfs02/M02/70/9A/wKiom1W52LTiExS1AABT3mHQJc0833.jpg "border=" 0 "height=" 37 "/ >

2. Download and install Matplotlib 1.4.x (current version 1.4.3)

A) Enter http://matplotlib.org/downloads.html and download Matplotlib-1.4.3.win-and64-py2.7.exe

b) Install the matplotlib.

3. Download and install NumPy 1.9.x (current version 1.9.2)

A) There is no available 64-bit binary installation package (see here for reasons), but an unofficial binary can find the http://www.lfd.uci.edu/%7Egohlke/pythonlibs/#numpy here.

b) Download NUMPY-1.9.2+MKL-CP27-NONE-WIN_AMD64.WHL.

c) in PowerShell, modify to download path, install:
Pip.exe Install NUMPY-1.9.2+MKL-CP27-NONE-WIN_AMD64.WHL
650) this.width=650; "title=" clip_image004 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image004 "src=" http://s3.51cto.com/wyfs02/M00/70/9A/wKiom1W52LSBQCPmAAD_WFPVwIA484.jpg "border=" 0 "height=" 119 "/ >

4. Install pyparsing via PIP

A) in PowerShell, run:
Pip.exe Install pyparsing
650) this.width=650; "title=" clip_image006 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image006 "src=" http://s3.51cto.com/wyfs02/M01/70/9A/wKiom1W52LXg_ssxAADXlO9JkVU604.jpg "border=" 0 "height=" 119 "/ >

5. Install Mtools via PIP

A) in PowerShell, run:
Pip.exe Install Mtools
650) this.width=650; "title=" clip_image008 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image008 "src=" http://s3.51cto.com/wyfs02/M01/70/9A/wKiom1W52LaQcRfpAAKYq5KAeyE108.jpg "border=" 0 "height=" 279 "/ >

usage

You can now run Mtools script Tools Mloginfo.exe, Mlogfilter.exe, Mplotqueries.exe, and Mlogvis.exe from PowerShell. Note Mlaunch currently does not support the Windows platform.

Example PowerShell command:

Ps> Mlogfilter.exe. \mongod.log–slow | Mplotqueries.exe

It will discover all the slow queries in the log file and display as charts.
650) this.width=650; "title=" clip_image010 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image010 "src=" http://s3.51cto.com/wyfs02/M00/70/97/wKioL1W52qfSnkSUAARJFMgsY40184.jpg "border=" 0 "height=" 616 "/ >

650) this.width=650; "title=" clip_image012 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "alt=" clip_image012 "src=" Http://s3.51cto.com/wyfs02/M01/70/97/wKioL1W52qjyJvaFAAKMedavB70810.jpg "border=" 0 "height=" 589 "/>

This article is from the SQL Server deep dives blog, so be sure to keep this source http://ultrasql.blog.51cto.com/9591438/1680156

Install Mtools on a 64-bit Windows Server R2