Home
  •  

MySQL Server Sorgu Önbelleği İsabet Yüzdesi Toplaması

Microsoft.MySQLServer.ManagedServer.Unix.QueryCacheHitPct.Collection (Rule)

Bu kural, Sorgu Önbelleği'ndeki isabetlerin güncel yüzdesini toplar

Knowledge Base article:

Özet

Bu kural, MySQL Server\ Sorgu Önbelleği İsabet Yüzdesi performans sayacının performans verilerini toplar. Toplanan değerlere performans görünümlerinden erişilebilir. Bu ölçüm, MySQL Server'ın sorgu önbellek isabetlerinin toplam yüzdesini ortaya çıkarır.

Element properties:

TargetMicrosoft.MySQLServer.ManagedServer.Unix
CategoryPerformanceCollection
EnabledTrue
Alert GenerateFalse
RemotableTrue

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.Oss.WSMan.PerfCounterProvider Default
WriteToDB WriteAction Microsoft.SystemCenter.CollectPerformanceData Default
WriteToDW WriteAction Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData Default

Source Code:

<Rule ID="Microsoft.MySQLServer.ManagedServer.Unix.QueryCacheHitPct.Collection" Target="Microsoft.MySQLServer.ManagedServer.Unix" Remotable="true" Enabled="onStandardMonitoring">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Oss!Microsoft.Oss.WSMan.PerfCounterProvider">

      <Interval>300</Interval>

      <TargetSystem>$Target/Host/Property[Type="Unix!Microsoft.Unix.Computer"]/NetworkName$</TargetSystem>

      <Uri>http://schemas.microsoft.com/wbem/wscim/1/cim-schema/2/MySQL_ServerStatistics?__cimnamespace=root/mysql</Uri>

      <Filter/>

      <SplitItems>true</SplitItems>

      <ObjectName>MySQL Server</ObjectName>

      <CounterName>Query Cache Hit Pct</CounterName>

      <InstanceName>$Data/WsManData/*[local-name(.)='MySQL_ServerStatistics']/*[local-name(.)='InstanceID']$</InstanceName>

      <Value>$Data/WsManData/*[local-name(.)='MySQL_ServerStatistics']/*[local-name(.)='QCacheHitPct']$</Value>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>

    <WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>

  </WriteActions>

</Rule>