简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

linux下使用命令行监控MYSQL_MySQL

WBOY
Release： 2016-06-01 13:47:44
Original
1009 people have browsed it

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
Related labels：
linux monitor
source：php.cn
Previous article：MySQL高级特性之集合函数_MySQL Next article：在MySQL中使用更新日志文件_MySQL
Statement of this Website
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
Latest Articles by Author
Latest Issues
Install/enable php8.1's sqlsrv and pdo_sqlsrv drivers on ubuntu20.0 I'm trying to enable the sqlsrv driver for php8.1 on Ubuntu20.0. It doesn't show the exten...
From 2023-11-01 11:06:13
0
2
283
Embracing UTF-8 from start to finish I'm setting up a new server and want full UTF-8 support in my web application. I've tried ...
From 2023-10-15 12:36:31
0
2
280
Full UTF-8 I'm setting up a new server and want full UTF-8 support in my web application. I've tried ...
From 2023-10-15 11:44:00
0
2
324
Undefined variable in component My server works in Linux via apache2, but works fine in the development environment via ar...
From 2023-09-06 10:48:25
0
1
346
Search Json objects using "AND", "OR" operators I have a problem where I need to search a JSON object using conditional operator strings. ...
From 2023-09-06 10:23:16
0
1
182
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！