Mysql performance monitoring tool Innotop, mysql monitoring innotop

Mysql performance monitoring tool Innotop, mysql monitoring innotop

Mysql monitoring management tool-innotop

1. innotop Installation
Reference Official Website: http://innotop.googlecode.com/svn/html/installing.html

# Wget http://innotop.googlecode.com/files/innotop-1.9.0.tar.gz
# Tar-zxvf innotop-1.9.0.tar.gz
# Cd innotop-1.9.0

Installing the INNOTOP tool is very simple. It is written by PERL. Of course, the PERL environment and related toolkit are required. Before installation, make sure that your system has installed four packages: Time: HiRes, Term: ReadKey, DBI, DBD: mysql.

# Perl-MCPAN-eshell
CPAN> install Time: HiRes
CPAN> install Term: ReadKey
CPAN> install DBI
CPAN> install DBD: mysql

Install the Help file in the decompressed source code path as follows:

# Perl Makefile. PL

If no error is reported, use
# Make install

In this way, innotop is installed. After installation, the system will have an additional command, innotop

Get help
# Innptop -- help

Reference Official Website: http://innotop.googlecode.com/svn/html/manual.html

 

Innotop details-very detailed: http://wenku.baidu.com/link? Url = required _

 

The query list contains an SLOW parameter, which can be configured and used in the/etc/my. cnf configuration file.

It records all SQL statements that have been executed longer than long_query_time, and helps you find slow SQL statements to optimize these SQL statements.

----- How to enable mysql slow query -----

1.First, enter mysql and enter the command show variables like '% quer % ';

The log_slow_queries status is OFF and long_query_time is 10;

2.Edit the/etc/my. cnf File

Add two lines under [mysqld:

Log-slow-queries =/var/lib/mysql/mysql-slow.log
Long_query_time = 3

Log-slow-queries is the log storage directory, and long_query_time is the maximum number of query seconds (set as needed ).

3.Restart the service to make the configuration take effect

/Etc/init. d/mysqld restart

Enter the database query log_slow_queries status ON again.

 

What tools are used to monitor mysql? We recommend that you monitor a website that runs on a 7x24 basis.

You can use Navicat For MySQL. There are many Baidu tools. It is best to use version 9.0. After installation, there is a server monitoring option in the tool.
 
What monitoring tools are available for mysql in windows?

Same question. The answer is too short.