Spotlight on MySQL monitor MySQL server

First step : Download and install mysql-connector-3.5x

Spotlight on MySQL connection mysql must use the mysql-connector-3.5x,5.3.2 version I tried it, and I was interested to try.

1. Download

Website

http://dev.mysql.com/downloads/connector/odbc/

mysql-connector-3.5x

Http://yunpan.cn/QiV5FC6QE7cxT Access Password 78a6

2. Installation

Default installation.

Step two : Download and install quest_spotlight-on-mysql_80.exe

1. Download

Website

https://www.quest.com/common/registration.aspx?requestdefid=35381

Need to register an account before downloading, very simple 1 minutes to finish. Free!

Monitoring effect is good!

2. Installation

3. Installation Start:

4. Fill in the registration code, crack

Registration code:

295710059649205163750

Bergelmir/core

5. Installing sysstat

Installing the MySQL Linux Server installation sysstat

Potlight on MySQL monitoring Linux operating system, you need to execute the iostat command, so you need to ensure that the target Linux installed on the server Iostat

Yum Install-y sysstat.x86_64

Otherwise the error will be the Yo ~

6. Establish a MySQL server connection

Double-click: Add New Connection

7. Click Connect and the monitoring interface is as follows:

Fifth step: Related monitoring introduction

1.MySQL related

1.1 Activity->mutex corresponds to Show engine InnoDB Mutex

1.2 Activity->innodb status corresponds to show engine InnoDB status;

1.3 Activity->error Log shows the most recent error for the current connection, including the creation of the database, startup, creation of a table or the check && repair, and a creation of logfile

1.4 Activity->general Log shows a client connection and disconnected records in a tabular format, along with each SQL statement

Note:my.cnf need to set parameters log_output=table

1.5 Activity->slow Query Log presents a slow-querying SQL statement in tabular form

2 system-related

2.1 OS Details->os Performance displays the operating system's CPU, disk I/O,memory and other monitoring information

2.2 OS details-> OS Processes shows the currently active process

Summary: What do you think of Spotlight on MySQL? No, you are the development, testing or operation, with it you will be more effective, to have a little advantage, encounter bottlenecks and pressure he will be real-time alarm, alarm level can be customized, the rest or rely on everyone to explore. Spotlight on Unix and Spotlight on MySQL it's over, and it's all about Oracle when you're free.

Http://www.cnblogs.com/Javame/p/3713143.html

Spotlight on MySQL monitor MySQL server