Linux中使用mysqladmin extended-status配合Linux命令查看MySQL运行状态(2)
使用awk，同时输出时间信息： 复制代码 代码如下: mysqladmin -uroot -p -h127.0.0.1 -P3306 -r -i 1 ext |\ awk -F"|" '{\ if($2 ~ /Variable_name/){\ print " ------------- " strftime("%H:
使用awk，同时输出时间信息：
复制代码 代码如下:
mysqladmin -uroot -p -h127.0.0.1 -P3306 -r -i 1 ext |\
awk -F"|" '{\
if($2 ~ /Variable_name/){\
print " <------------- " strftime("%H:%M:%S") " ------------->";\
}\
if($2 ~ /Questions|Queries|Innodb_rows|Com_select |Com_insert |Com_update |Com_delete |Innodb_buffer_pool_read_requests/)\
print $2 $3;\
}'
<------------- 12:38:49 ------------->
Com_delete 0
Com_insert 0
Com_select 0
Com_update 0
Innodb_buffer_pool_read_requests 589
Innodb_rows_deleted 0
Innodb_rows_inserted 2
Innodb_rows_read 50
Innodb_rows_updated 50
Queries 105
Questions 1
<------------- 12:38:50 ------------->
Com_delete 0
Com_insert 0
Com_select 0
Com_update 0
Innodb_buffer_pool_read_requests 1814
Innodb_rows_deleted 0
Innodb_rows_inserted 0
Innodb_rows_read 8
Innodb_rows_updated 8
Queries 17
Questions 1
4. 配合复杂一点的awk
- 上一篇：深入探寻mysql自增列导致主键重复问题的原因
- 下一篇：mysql的启动过程详解
精彩图集
精彩文章