Spotlight on MySQL monitoring MySQL Server

The previous chapter details how Spotlight on Unix monitors Linux servers. Let's take a look at how Spotlight on MySQL monitors MySQL servers.

Note: http://www.cnblogs.com/Javame/p/3685512.html

Step 1

Spotlight on MySQL

 

1

 

Official Website

 

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

Mysql-connector-3.5x

 

Http://yunpan.cn/QiV5FC6QE7cxT access password 78a6

2. Installation

Installation By a fool, you know ....

 

Step 2

1

 

 

 

2. Installation

It is also a dumb installation, but it is worth mentioning that it can be installed independently. If you have installed Spotlight on Unix before, you can install it with him. After the installation, the two options can be selected as needed.

3. Enter the registration code to crack

Crack registration code download: http://yunpan.cn/QiVeRzPNQNaLy access password 48d8

Step 3: Install MySQL

 

Potlight on mysql

 

yum install -y sysstat.x86_64

Otherwise, an error will be reported ~

Step 4: establish a connection

Click

Step 5: related monitoring overview

1

 

1.1 Activity-> Mutex

 

1.2 Activity-> InnoDB Status

1.3 Activity-> Error Log

1.4 Activity-> General Log displays the connection and disconnection records of a client in a table

Note:

1.5 Activity-> Slow Query Log displays a Slow Query in a table

2

 

2.1 OS Details-> OS Performance

2.2 OS Details-> OS Processes

Conclusion: What do you think of Spotlight on MySQL? It doesn't matter whether you are developing, testing, or O & M. If you have it, you will get twice the result with half the effort. However, if you encounter bottlenecks and pressure, they will trigger alarms in real time. The alarm level can be customized, the rest depends on everyone to explore. Spotlight on Unix and Spotlight on MySQL are finished. If you have time, let's talk about Oracle. O (∩) O Haha ~