Bu kural, Tablo Önbelleği'ndeki isabetlerin güncel yüzdesini toplar
Bu kural, MySQL Server\ Tablo Ö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 tablo önbelleği isabetlerinin toplam yüzdesini ortaya çıkarır.
Target | Microsoft.MySQLServer.ManagedServer.Unix |
Category | PerformanceCollection |
Enabled | True |
Alert Generate | False |
Remotable | True |
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 |
<Rule ID="Microsoft.MySQLServer.ManagedServer.Unix.TableCacheHitPct.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 Hit Pct</CounterName>
<InstanceName>$Data/WsManData/*[local-name(.)='MySQL_ServerStatistics']/*[local-name(.)='InstanceID']$</InstanceName>
<Value>$Data/WsManData/*[local-name(.)='MySQL_ServerStatistics']/*[local-name(.)='TCacheHitPct']$</Value>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>
<WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>
</WriteActions>
</Rule>