Spotlight on mysql – Installation and Introduction

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

Spotlight on MySQL connection mysql must use mysql-connector-3.5x

1, download

Official website download address

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

Register an oracle beforeAccount, then download

2 Installation

All the way “next” is all you need

Step 2: Download and install Quest_Spotlight-on-MySQL_80.exe< /p>

1, download

Official website address-https://www.quest.com/common/registration.aspx?requestdefid=35381

Before Register an account first,then download

2, install

3. Fill in the registration code and crack

< p>

Authorization Key:

295710059649205163750< /p>

Site Message:

Bergelmir/CORE

Note: “Site Message” will pop up only when the “Authorization Key” is entered correctly.

Step 3: Install sysstat on the Linux server

When Spotlight on mysql monitors the Linux operating system, you need to execute the iostat command , So you need to ensure that iostat is installed on the target linux server

yum install -y sysstat.x86_64

Step 4: Establish a connection

Click connect to see the renderings

Step 5: Introduction to related monitoring

1, MySQL related

1.1 Activity->Mutex corresponds to Show engine innodb mutex

< img alt="Share a picture" src="/wp-content/uploads/images/os/macos/1626797492947.png" >

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

1.3 Activity->Error Log displays the latest error of the current connection, including the creation and startup of a database, the creation of a table or the check && repair, and a logfile Creation of

< p>

1.4 Activity->General Log Display the connection and disconnection records of a client in tabular form, and various SQL statements

Note: my.cnfneed to set the parameter log_output=table

1.5 Activity->Slow Query Log Display in table form one Slow query SQL statement

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 Detai ls-> OS Processes shows the currently active processes

Spotlight on MySQL Installation and configuration

< /p>