Detailed Spotlight on MySQL monitor MySQL server

Detailed Spotlight on MySQL monitor MySQL server

The previous chapter details the spotlight on Unix monitoring Linux server, and today again see spotlight on MySQL How to monitor MySQL server.

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

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

Spotlight on MySQL connection MySQL must use 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

Idiot installation, you know ....

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

1. Download

Website

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

Monitoring effect is good!

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

2. Installation

It is also a fool to install, but it is worth mentioning that he can be installed independently and if you have previously installed spotlight on Unix, you can install it with him and launch the two options at any option.

3, fill in the registration code, crack

Hack registration code Download: Http://yunpan.cn/QiVeRzPNQNaLy Access password 48d8

Step three: Install the MySQL linux server installation sysstat

Potlight on MySQL monitoring the Linux operating system, you need to execute the iostat command, so be sure to install on the target Linux server iostat

Yum Install-y sysstat.x86_64

Otherwise the error will be the Yo ~

Fourth step: Establish a connection

Click Connect to see the health effects ~

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 logfile the creation

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. O (∩_∩) o haha ~

Detailed Spotlight on MySQL monitor MySQL server