<section class="section context"> <p class="p">本文主要介绍如何对当前登录数据库中的实时SQL进行分析，显示热点SQL。</p> <p class="p"><strong class="ph b">注意事项</strong></p> <p class="p">仅RDS-MySQL支持SQL实时分析。</p> <p class="p"><strong class="ph b">操作步骤</strong></p> <ol class="ol" id="sql_analysis__ol_ukl_hhz_frb"> <li class="li">登录<a class="xref" href="https://www.ocftcloud.com/console/dms/login" target="_blank" rel="external noopener">DMS管理控制台</a>。</li> <li class="li">单击左侧导航栏选择<strong class="ph b">非托管实例</strong>。</li> <li class="li">选择目标数据库下的实例，选择<strong class="ph b">SQLConsole</strong>，填写<strong class="ph b">数据库名</strong>、<strong class="ph b">数据库账号</strong>以及<strong class="ph b">密码</strong>，单击<strong class="ph b">确定</strong>登录数据库，可参考<a class="xref" href="https://www.ocftcloud.com/ssr/help/database/DMS/quickstart.Login.rds_mysql.Unmanaged_mysql" target="_blank" rel="external noopener">登录数据库</a>。<p class="p"><strong class="ph b">说明: </strong>本文以RDS-MySQL为例。</p></li> <li class="li"><p class="p">在实例会话区域，单击<strong class="ph b">实时SQL分析</strong>，进入SQL分析页面。</p></li> </ol> <ul class="ul" id="sql_analysis__ul_wkl_hhz_frb"> <li class="li"><span class="ph" id="sql_analysis___Refd19e6371">在SQL统计区域，可查看热点SQL的模块、平均请求时长、SQL数、比例以及SQL语句示例等信息。</span></li> <li class="li">在SQL概览区域，可查看SQL类型、用户以及DB相关信息。<p class="p"><img class="image" id="sql_analysis__image_dqn_4vw_hrb" src="https://obs-cn-shanghai.ocftcloud.com/pacloud/20212010155605-1468e3ee94d2.png"></p></li> </ul> </section>