Home >Database >Mysql Tutorial >linux下使用命令行监控MYSQL_MySQL

linux下使用命令行监控MYSQL_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:47:441114browse

bitsCN.com

  第1条Linux指令:watch -n 5 -d "mysqladmin extended-status | egrep -i innodb_data"

  

/

 

  第2条Linux指令如下:

  首先:vi /path/my.cnf,在[mysqld]中添加"innode_status_file=1"

  其次:watch -d -n 5 "egrep MySQL thread|Log|Modified db pages innodb_status.pid";

  

/

 

bitsCN.com
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn