Home
  •  

MySQL Server Tablo Önbelleği Kullanım Yüzdesi Toplaması

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

Bu kural, güncel tablo önbelleği kullanım yüzdesini toplar

Knowledge Base article:

Özet

Bu kural, MySQL Server\ Tablo Önbelleği Kullanım Yüzdesi performans sayacının performans verilerini toplar. Toplanan değerlere performans görünümlerinden erişilebilir. Bu ölçüm, MySQL Server tablo önbelleği kullanımının 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.TableCacheUsePct.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>Table Cache Use Pct</CounterName>

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

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

    </DataSource>

  </DataSources>

  <WriteActions>

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

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

  </WriteActions>

</Rule>