mysqlsla安装使用
发布时间：2020-12-15 21:05:55 所属栏目：大数据 来源：网络整理
导读：Install wget http://hackmysql.com/scripts/mysqlsla-2.03.tar.gz tar zvxf mysqlsla-2.03.tar.gz ? ? cd mysqlsla-2.03 ? perl Makefile.PL ? make? make install? Usage: mysqlsla -lt slow slow_statement.log - top 10 - sort [t_avg|t_sum|c_sum] /tmp
|
Install wget http://hackmysql.com/scripts/mysqlsla-2.03.tar.gz tar zvxf mysqlsla-2.03.tar.gz ? ? cd mysqlsla-2.03 ? perl Makefile.PL ? make? make install? Usage: mysqlsla -lt slow slow_statement.log - top 10 - sort [t_avg|t_sum|c_sum] > /tmp/top10_time_avg.log t_sum total query execution time c_sum total number of times query appears t_avg avarage time of execution time mysqlsla -lt slow -sf "+select,update" -top 100 -sort c_sum -db ?dbname slow-slow.log > /tmp/c_sum.log --statement-filter (-sf) [+-][TYPE]
（编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |