Mytop of MySQL Performance tuning tool

Mysql mytop of performance tuning tools installation and use of

1. 1. Mytop of the

http://yunpan.cn/cVG3uSs2Jtt9h access Password 7ef1

1. 2. Install Mytop first Necessary Components .

Yum-y Install Perl-dbd-mysql Perl-dbiperl-termreadkey

If you are prompted to locate the installation package , you can first install

Yum–y Install Epel-release

Epel-release This can be used to the latest yum source.

if installing yum-y install Perl-dbd-mysql perl-dbi perl-termreadkey

after that, install or execute mytop when also reported is wrong, use cpan command to reinstall DBI,term::readkey,dbd::mysql, These several components.

Yum Install Perl-cpan

Cpan

Install DBI

Install Term::readkey

Install Dbd::mysql

3. Installing mytop

[Email protected] software]# TAR-ZXVF mytop-1.6.tar.gz

[Email protected] software]# CD mytop-1.6

[Email protected] mytop-1.6]# Perl makefile.pl

[[email protected] mytop-1.6]# make && make install

4. parameter explanation:

Mytop Command Parameters

-U/--user : Specify username, default is root

-P/--pass/--password : Specify password, default is none

-H/--host : Specify MySQL server 's hostname, default is localhost

-P/--port : Specify port to connect to MySQL server, default is 3306

-S/--delay : Updated number of seconds, preset is 5 seconds

-d/--db/--database : Specify connected repositories, default is test

-b/--batch/--batchmode: Specified as batchmode, each update does not clear the old display results, the update data is displayed on the top, the preset is unset

-S/--socket : Specifies to use mysqlsocket direct connection without TCP/IP connection, default is none ( when mytop and MySQL can be used at the same time )

--header Or-noheader: If you want to display the header, the default is header

--color or--nocolor: If you want to use a color, the preset is color

-I/-idle or-noidle:idle thread whether to appear on the list, preset is idle

Mytop shortcut Keys

S: Set update Time

P: Pause screen Update

Q: Leave

U: See thread of a user only

o: Reverse the order of arrangement

5.mytop the Use

mytop-uroot [email protected]-h10.136.67.20

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/AF/wKioL1U0ntmgbb5fAAJct3OB9Js244.jpg "title=" 1 "alt= "Wkiol1u0ntmgbb5faajct3ob9js244.jpg"/>

The Mytop and Linux top commands show similar results. The following shows the current state of each thread and is a dynamic change.

Qps: Requests per second

Slow: Number of slow queries

Se/in/up/de (%): Read and write ratio

Key Efficiency:myisam Cache usage ratio

BPS: Network traffic

The first part is the state of each thread,

This article is from the "SQL Server MySQL" blog, so be sure to keep this source http://dwchaoyue.blog.51cto.com/2826417/1636023

Mytop of MySQL Performance tuning tool