Linux中使用mysqladmin extended-status配合Linux命令查看MySQL运行状态(3)

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

反正也不简单了，那就更复杂一点，这样让输出结果更友好点，因为awk不支持动态变量，所以代码看起来比较复杂：

复制代码 代码如下: