【nba买球】mysql DBA:mysqladmin常用命令总结

作者:计算机教程

1. 使用-r/-i参数使用mysqladmin extended-status命令可以获得所有MySQL性能指标,即show global status的输出,不过,因为多数这些指标都是累计值,如果想了解当前的状态,则需要进行一次差值计算,这就是mysqladmin extended-status的一个额外功能,非常实用。默认的,使用extended-status,看到也是累计值,但是,加上参数-r(--relative),就可以看到各个指标的差值,配合参数-i(--sleep)就可以指定刷新的频率,那么就有如下命令:复制代码 代码如下:mysqladmin -uroot -r -i 1 -pxxx extended-status ------------------------------------------ ---------------------- | Variable_name | Value | ------------------------------------------ ---------------------- | Aborted_clients | 0 || Com_select | 336 || Com_insert | 243 |......| Threads_created | 0 | ------------------------------------------ ---------------------- 2. 配合grep使用配合grep使用,我们就有:复制代码 代码如下:mysqladmin -uroot -r -i 1 -pxxx extended-status |grep "Questions|Queries|Innodb_rows|Com_select |Com_insert |Com_update |Com_delete "| Com_delete | 1 || Com_delete_multi | 0 || Com_insert | 321 || Com_select | 286 || Com_update | 63 || Innodb_rows_deleted | 1 || Innodb_rows_inserted | 207 || Innodb_rows_read | 5211 || Innodb_rows_updated | 65 || Queries | 2721 || Questions | 2721 |3. 配合简单的awk使用使用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 0Com_insert 0Com_select 0Com_update 0Innodb_buffer_pool_read_requests 589Innodb_rows_deleted 0Innodb_rows_inserted 2Innodb_rows_read 50Innodb_rows_updated 50Queries 105Questions 1------------- 12:38:50 -------------Com_delete 0Com_insert 0Com_select 0Com_update 0Innodb_buffer_pool_read_requests 1814Innodb_rows_deleted 0Innodb_rows_inserted 0Innodb_rows_read 8Innodb_rows_updated 8Queries 17Questions 14. 配合复杂一点的awk反正也不简单了,那就更复杂一点,这样让输出结果更友好点,因为awk不支持动态变量,所以代码看起来比较复杂:复制代码 代码如下:mysqladmin -P3306 -uroot -p -h127.0.0.1 -r -i 1 ext |awk -F"|" "BEGIN{ count=0; }"'{ if($2 ~ /Variable_name/ && count == 1){ print "----------|---------|--- MySQL Command Status --|----- Innodb row operation ----|-- Buffer Pool Read --"; print "---Time---|---QPS---|select insert update delete| read inserted updated deleted| logical physical";}else if ($2 ~ /Queries/){queries=$3;}else if ($2 ~ /Com_select /){com_select=$3;}else if ($2 ~ /Com_insert /){com_insert=$3;}else if ($2 ~ /Com_update /){com_update=$3;}else if ($2 ~ /Com_delete /){com_delete=$3;}else if ($2 ~ /Innodb_rows_read/){innodb_rows_read=$3;}else if ($2 ~ /Innodb_rows_deleted/){innodb_rows_deleted=$3;}else if ($2 ~ /Innodb_rows_inserted/){innodb_rows_inserted=$3;}else if ($2 ~ /Innodb_rows_updated/){innodb_rows_updated=$3;}else if ($2 ~ /Innodb_buffer_pool_read_requests/){innodb_lor=$3;}else if ($2 ~ /Innodb_buffer_pool_reads/){innodb_phr=$3;}else if ($2 ~ /Uptime / && count = 2){ printf(" %s |

本文由nba买球发布,转载请注明来源

关键词: