Microsoft MySQL Server Library

Microsoft.MySQLServer.Library :: 7.6.1085.0 (Management Pack)

This management pack discovers and monitors MySQL Servers

Summary

The Microsoft MySQL Server Library provides the monitoring features that are required to monitor MySQL Servers running on Linux computers.

Management Pack Elements

Show Management Pack References

TypeDefinitions

EntityTypes

ClassType (7)
RelationshipType (2)

ModuleTypes

ConditionDetectionModuleType (1)
DataSourceModuleType (1)
ProbeActionModuleType (2)
WriteActionModuleType (2)

UnitMonitorType (2)

Monitoring

Discovery (5)
Monitors

AggregateMonitor (6)
DependencyMonitor (2)
UnitMonitor (16)

Rule (18)
Task (2)

Presentation

FolderItem (4)
Folder (2)
ImageReference (2)
View (8)
Advanced

ComponentImplementation (6)
ComponentReference (6)
ComponentType (6)

Reporting

LinkedReport (5)

Classes (7)

System.Entity

System.ConfigItem

System.LogicalEntity

System.LocalApplication

Microsoft.MySQLServer.Database

Microsoft.MySQLServer.Database.Unix

Microsoft.MySQLServer.Installation

Microsoft.MySQLServer.Installation.Unix

Microsoft.MySQLServer.ManagedServer.Unix

System.Group

Microsoft.SystemCenter.InstanceGroup

	DisplayName	ID	Base Class	Abstract	Hosted	Singleton	Group	Extension	Accessibility
	MySQL Server Database	Microsoft.MySQLServer.Database	System.LocalApplication	True	False	False	False	False	Public
	Group of MySQL Databases	Microsoft.MySQLServer.Database.InstanceGroup	Microsoft.SystemCenter.InstanceGroup	False	False	True	True	False	Public
	MySQL Database (Linux)	Microsoft.MySQLServer.Database.Unix	Microsoft.MySQLServer.Database	False	True	False	False	False	Public
	MySQL Server Installation	Microsoft.MySQLServer.Installation	System.LocalApplication	True	False	False	False	False	Public
	MySQL Server (Linux)	Microsoft.MySQLServer.Installation.Unix	Microsoft.MySQLServer.Installation	False	True	False	False	False	Public
	Group of MySQL Servers	Microsoft.MySQLServer.ManagedServer.InstanceGroup	Microsoft.SystemCenter.InstanceGroup	False	False	True	True	False	Public
	Monitored MySQL Server (Linux)	Microsoft.MySQLServer.ManagedServer.Unix	Microsoft.MySQLServer.Installation.Unix	False	True	False	False	False	Public

Relationship Types (2)

	DisplayName	ID	Source	Target	Accessibility	Abstract
	Linux Computer Hosts MySQL Server Installation	Microsoft.MySQLServer.ComputerHostsInstallation.Unix	Microsoft.Unix.Computer	Microsoft.MySQLServer.Installation.Unix	Public	False
	Managed MySQL Server Hosts Database	Microsoft.MySQLServer.ServerHostsDatabases.Unix	Microsoft.MySQLServer.ManagedServer.Unix	Microsoft.MySQLServer.Database.Unix	Public	False

ConditionDetection Modules (1)

	DisplayName	ID	Isolation	Accessibility
	XML String To Data Item Mapper	Microsoft.Test.XmlStringToDataItemMapper	Any	Public

DataSource Modules (1)

	DisplayName	ID	Isolation	Accessibility
	MySQL Stored Procedure Performance Counter	Microsoft.MySQLStoredProcedure.WSMan.PerfCounterProvider	Any	Public

ProbeAction Modules (2)

	DisplayName	ID	Isolation	Accessibility
	MySQL Stored Procedure Row Perf	Microsoft.MySQLStoredProcedure.WSMan.RetrieveRowsPerf.ProbeAction	Any	Public
	Microsoft.MySQLStoredProcedure.WSMan.RetrieveRows.ProbeAction	Microsoft.MySQLStoredProcedure.WSMan.RetrieveRows.ProbeAction	Any	Public

WriteAction Modules (2)

	DisplayName	ID	Isolation	Accessibility
	MySQL Server Discover Provider Write Action	Microsoft.MySQLServer.DiscoverProvider.WriteAction	Any	Public
	MySQL Server credential write action	Microsoft.MySQLServerCredentials.WSMan.Invoke.WriteAction	Any	Internal

Unit Monitor Types (2)

	DisplayName	ID	Accessibility	Support Monitor Recalculate
	MySQL Stored Procedure Three State Monitor	Microsoft.MySQLStoredProcedure.ThreeState.MonitorType	Public	True
	MySQL Stored Procedure Threshold Monitor	Microsoft.MySQLStoredProcedure.ThresholdUnitMonitor.MonitorType	Public	True

Discoveries (5)

	DisplayName	ID	Target	Enabled
	MySQL Server Database Discovery (Linux)	Microsoft.MySQLServer.Database.Discovery.Unix	Microsoft.MySQLServer.ManagedServer.Unix	True
	Populate MySQL Server Databases Group	Microsoft.MySQLServer.Database.InstanceGroup.Discovery	Microsoft.MySQLServer.Database.InstanceGroup	True
	MySQL Server Installation Discovery (Linux)	Microsoft.MySQLServer.Installation.ScriptDiscovery.Unix	Microsoft.Linux.Computer	True
	Managed MySQL Server Discovery (Linux)	Microsoft.MySQLServer.ManagedServer.Discovery.Unix	Microsoft.Unix.Computer	True
	Populate MySQL Servers Group	Microsoft.MySQLServer.ManagedServer.InstanceGroup.Discovery	Microsoft.MySQLServer.ManagedServer.InstanceGroup	True

Aggregate Monitors (6)

	DisplayName	ID	Target	Algorithm	Category	Enabled	Alert Generate	Accessibility
	MySQL Server Connection Performance	Microsoft.MySQLServer.ConnectionsPerformanceRollup	Microsoft.MySQLServer.ManagedServer.Unix	WorstOf	PerformanceHealth	True	False	Public
	MySQL Server InnoDB Buffer Pool Performance	Microsoft.MySQLServer.InnoDBPerformanceRollup	Microsoft.MySQLServer.ManagedServer.Unix	WorstOf	PerformanceHealth	True	False	Public
	MySQL Server Key Cache Performance	Microsoft.MySQLServer.KeyCachePerformanceRollup	Microsoft.MySQLServer.ManagedServer.Unix	WorstOf	PerformanceHealth	True	False	Public
	MySQL Server Query Cache Performance	Microsoft.MySQLServer.QueryCachePerformanceRollup	Microsoft.MySQLServer.ManagedServer.Unix	WorstOf	PerformanceHealth	True	False	Public
	MySQL Server Row Operations Performance	Microsoft.MySQLServer.RowOperationsPerformanceRollup	Microsoft.MySQLServer.ManagedServer.Unix	WorstOf	PerformanceHealth	True	False	Public
	MySQL Server Table Cache Performance	Microsoft.MySQLServer.TableCachePerformanceRollup	Microsoft.MySQLServer.ManagedServer.Unix	WorstOf	PerformanceHealth	True	False	Public

Dependency Monitors (2)

	DisplayName	ID	Target	Algorithm	Source Monitor	Relationship	Category	Enabled	Alert Generate	Accessibility
	MySQL Server Availability	Microsoft.MySQLServer.ApplicationAvailabilityRollup	Microsoft.Unix.Computer	WorstOf	System.Health.AvailabilityState	Microsoft.MySQLServer.ComputerHostsInstallation.Unix	StateCollection	True	False	Public
	MySQL Server Performance	Microsoft.MySQLServer.ApplicationPerformanceRollup	Microsoft.Unix.Computer	WorstOf	System.Health.PerformanceState	Microsoft.MySQLServer.ComputerHostsInstallation.Unix	StateCollection	True	False	Public

Unit Monitors (16)

	DisplayName	ID	Target	Category	Enabled	Alert Generate	Accessibility
	MySQL Server Aborted Connection Percent Monitor	Microsoft.MySQLServer.ManagedServer.Unix.AbortedConnectionPct.Monitor	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceHealth	True	True	Public
	MySQL Server Connection Use Percent Monitor	Microsoft.MySQLServer.ManagedServer.Unix.ConnectionsUsePct.Monitor	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceHealth	True	True	Public
	MySQL Server Full Table Scan Percent Monitor	Microsoft.MySQLServer.ManagedServer.Unix.FullTableScanPct.Monitor	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceHealth	True	True	Public
	MySQL Server Buffer Pool Hit Percent Monitor	Microsoft.MySQLServer.ManagedServer.Unix.InnoDB_BufferPool_HitPct.Monitor	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceHealth	True	True	Public
	MySQL Server Buffer Pool Use Percent Monitor	Microsoft.MySQLServer.ManagedServer.Unix.InnoDB_BufferPool_UsePct.Monitor	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceHealth	True	True	Public
	MySQL Server Key Cache Hit Percent Monitor	Microsoft.MySQLServer.ManagedServer.Unix.KeyCacheHitPct.Monitor	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceHealth	True	True	Public
	MySQL Server Key Cache Use Percent Monitor	Microsoft.MySQLServer.ManagedServer.Unix.KeyCacheUsePct.Monitor	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceHealth	True	True	Public
	MySQL Server Key Cache Write Percent Monitor	Microsoft.MySQLServer.ManagedServer.Unix.KeyCacheWritePct.Monitor	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceHealth	True	True	Public
	MySQL Server Query Cache Hit Percent Monitor	Microsoft.MySQLServer.ManagedServer.Unix.QueryCacheHitPct.Monitor	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceHealth	True	True	Public
	MySQL Server Query Cache Prunes Percent Monitor	Microsoft.MySQLServer.ManagedServer.Unix.QueryCachePrunesPct.Monitor	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceHealth	True	True	Public
	MySQL Server Query Cache Use Percent Monitor	Microsoft.MySQLServer.ManagedServer.Unix.QueryCacheUsePct.Monitor	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceHealth	True	True	Public
	MySQL Server Server Status Monitor	Microsoft.MySQLServer.ManagedServer.Unix.ServerStatus.Monitor	Microsoft.MySQLServer.ManagedServer.Unix	AvailabilityHealth	True	True	Public
	MySQL Server Slow Query Percent Monitor	Microsoft.MySQLServer.ManagedServer.Unix.SlowQueryPct.Monitor	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceHealth	True	True	Public
	MySQL Server Table Cache Hit Percent Monitor	Microsoft.MySQLServer.ManagedServer.Unix.TableCacheHitPct.Monitor	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceHealth	True	True	Public
	MySQL Server Table Cache Use Percent Monitor	Microsoft.MySQLServer.ManagedServer.Unix.TableCacheUsePct.Monitor	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceHealth	True	True	Public
	MySQL Server Table Lock Contention Percent Monitor	Microsoft.MySQLServer.ManagedServer.Unix.TableLockContentionPct.Monitor	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceHealth	True	True	Public

Rules (18)

	DisplayName	ID	Target	Category	Enabled	Alert Generate
	MySQL Database Disk Space in Bytes collection	Microsoft.MySQLServer.Database.Unix.DiskSpaceInBytes.Collection	Microsoft.MySQLServer.Database.Unix	PerformanceCollection	True	False
	MySQL Database Number of Tables collection	Microsoft.MySQLServer.Database.Unix.NumberOfTables.Collection	Microsoft.MySQLServer.Database.Unix	PerformanceCollection	True	False
	MySQL Server Aborted Connection Percent Collection	Microsoft.MySQLServer.ManagedServer.Unix.AbortedConnectionPct.Collection	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceCollection	True	False
	MySQL Server Connection Use Percent Collection	Microsoft.MySQLServer.ManagedServer.Unix.ConnectionsUsePct.Collection	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceCollection	True	False
	MySQL Server Full Table Scan Percent Collection	Microsoft.MySQLServer.ManagedServer.Unix.FullTableScanPct.Collection	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceCollection	True	False
	MySQL Server Buffer Pool Hit Percent Collection	Microsoft.MySQLServer.ManagedServer.Unix.InnoDB_BufferPool_HitPct.Collection	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceCollection	True	False
	MySQL Server Buffer Pool Use Percent Collection	Microsoft.MySQLServer.ManagedServer.Unix.InnoDB_BufferPool_UsePct.Collection	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceCollection	True	False
	MySQL Server Key Cache Hit Percent Collection	Microsoft.MySQLServer.ManagedServer.Unix.KeyCacheHitPct.Collection	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceCollection	True	False
	MySQL Server Key Cache Use Percent Collection	Microsoft.MySQLServer.ManagedServer.Unix.KeyCacheUsePct.Collection	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceCollection	True	False
	MySQL Server Key Cache Write Percent Collection	Microsoft.MySQLServer.ManagedServer.Unix.KeyCacheWritePct.Collection	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceCollection	True	False
	MySQL Server Query Cache Hit Percent Collection	Microsoft.MySQLServer.ManagedServer.Unix.QueryCacheHitPct.Collection	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceCollection	True	False
	MySQL Server Query Cache Prunes Percent Collection	Microsoft.MySQLServer.ManagedServer.Unix.QueryCachePrunesPct.Collection	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceCollection	True	False
	MySQL Server Query Cache Use Percent Collection	Microsoft.MySQLServer.ManagedServer.Unix.QueryCacheUsePct.Collection	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceCollection	True	False
	MySQL Server Disk Use in Bytes	Microsoft.MySQLServer.ManagedServer.Unix.ServerDiskUseInBytes.Collection	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceCollection	True	False
	MySQL Server Slow Query Percent	Microsoft.MySQLServer.ManagedServer.Unix.SlowQueryPct.Collection	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceCollection	True	False
	MySQL Server Table Cache Hit Percent Collection	Microsoft.MySQLServer.ManagedServer.Unix.TableCacheHitPct.Collection	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceCollection	True	False
	MySQL Server Table Cache Use Percent Collection	Microsoft.MySQLServer.ManagedServer.Unix.TableCacheUsePct.Collection	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceCollection	True	False
	MySQL Server Table Lock Contention Percent Collection	Microsoft.MySQLServer.ManagedServer.Unix.TableLockContentionPct.Collection	Microsoft.MySQLServer.ManagedServer.Unix	PerformanceCollection	True	False

Agent Tasks (2)

	DisplayName	ID	Target	Accessibility	Category	Enabled
	Update Discovered Properties	Microsoft.MySQLServer.DiscoverServer.Task	Microsoft.MySQLServer.Installation.Unix	Public	Maintenance	True
	Set Default MySQL Credentials	Microsoft.MySQLServer.SetDefaultCred.Task	Microsoft.MySQLServer.Installation.Unix	Public	Maintenance	True

Folder Items (4)

	ID	FolderName	ElementID
	Microsoft.MySQLServer.Alerts.View.FolderItem	Microsoft.MySQLServer.Folder	Microsoft.MySQLServer.Alerts.View
	Microsoft.MySQLServer.Database.View.FolderItem	Microsoft.MySQLServer.Folder	Microsoft.MySQLServer.Database.View
	Microsoft.MySQLServer.Installation.View.FolderItem	Microsoft.MySQLServer.Folder	Microsoft.MySQLServer.Installation.View
	Microsoft.MySQLServer.ManagedServer.PerformanceView.FolderItem	Microsoft.MySQLServer.Performance.Folder	Microsoft.MySQLServer.ManagedServer.InnoDBBufferPoolPerformanceView

Folders (2)

	DisplayName	ID	ParentFolder	Accessibility
	MySQL	Microsoft.MySQLServer.Folder	Microsoft.SystemCenter.Monitoring.ViewFolder.Root	Public
	Performance Data	Microsoft.MySQLServer.Performance.Folder	Microsoft.MySQLServer.Folder	Public

Image References (2)

	DisplayName	ID	ImageID
	MySQL Server Database	Microsoft.MySQLServer.Database	GenericDatabase80
	MySQL Server Installation	Microsoft.MySQLServer.Installation	SQLDatabaseGroup80

Views (8)

	DisplayName	ID	Target	Type	Accessibility	Visible
	MySQL Server Alerts	Microsoft.MySQLServer.Alerts.View	Microsoft.MySQLServer.Installation	Microsoft.SystemCenter.AlertViewType	Public	True
	MySQL Server Databases	Microsoft.MySQLServer.Database.View	Microsoft.MySQLServer.Database	Microsoft.SystemCenter.StateViewType	Public	True
	MySQL Servers	Microsoft.MySQLServer.Installation.View	Microsoft.MySQLServer.Installation	Microsoft.SystemCenter.StateViewType	Public	True
	MySQL Server InnoDB Buffer Pool Performance	Microsoft.MySQLServer.ManagedServer.InnoDBBufferPoolPerformanceView	Microsoft.MySQLServer.Installation	Microsoft.SystemCenter.PerformanceViewType	Public	True
	MySQL Server Key Cache Performance	Microsoft.MySQLServer.ManagedServer.KeyCachePerformanceView	Microsoft.MySQLServer.Installation	Microsoft.SystemCenter.PerformanceViewType	Public	True
	MySQL Server Performance	Microsoft.MySQLServer.ManagedServer.PerformanceView	Microsoft.MySQLServer.Installation	Microsoft.SystemCenter.PerformanceViewType	Public	True
	MySQL Server Query Cache Performance	Microsoft.MySQLServer.ManagedServer.QueryCachePerformanceView	Microsoft.MySQLServer.Installation	Microsoft.SystemCenter.PerformanceViewType	Public	True
	MySQL Server Table Cache Performance	Microsoft.MySQLServer.ManagedServer.TableCachePerformanceView	Microsoft.MySQLServer.Installation	Microsoft.SystemCenter.PerformanceViewType	Public	True

Component Implementations (6)

	ID	Type	Platform	Target	Accessibility
	MySQLServerActiveAlerts.TypeImplementation	MySQLServerActiveAlerts.Type	Wpf, Silverlight		Public
	MySQLServerDatabases.TypeImplementation	MySQLServerDatabases.Type	Wpf, Silverlight		Public
	MySQLServers.TypeImplementation	MySQLServers.Type	Wpf, Silverlight		Public
	MySQLServerSummary.TypeImplementation	MySQLServerSummary.Type	Wpf, Silverlight		Public
	TopMySQLServerConnectionUsePct.TypeImplementation	TopMySQLServerConnectionUsePct.Type	Wpf, Silverlight		Public
	TopMySQLServerSize.TypeImplementation	TopMySQLServerSize.Type	Wpf, Silverlight		Public

Component References (6)

	ID	Type	Parent	Accessibility
	MySQLServerActiveAlerts.ComponentReference	MySQLServerActiveAlerts.Type	MySQLServerSummary.Type	Public
	MySQLServerDatabases.ComponentReference	MySQLServerDatabases.Type	MySQLServerSummary.Type	Public
	MySQLServers.ComponentReference	MySQLServers.Type	MySQLServerSummary.Type	Public
	MySQLServerSummary.ComponentReference	MySQLServerSummary.Type	Microsoft.MySQLServer.Folder	Public
	TopMySQLServerConnectionUsePct.ComponentReference	TopMySQLServerConnectionUsePct.Type	MySQLServerSummary.Type	Public
	TopMySQLServerSize.ComponentReference	TopMySQLServerSize.Type	MySQLServerSummary.Type	Public

Component Types (6)

	DisplayName	ID	Accessibility
	Active Alerts	MySQLServerActiveAlerts.Type	Public
	MySQL Databases	MySQLServerDatabases.Type	Public
	MySQL Servers	MySQLServers.Type	Public
	MySQL Server Summary	MySQLServerSummary.Type	Public
	Top 20 Total MySQL Server Connection Use Pct	TopMySQLServerConnectionUsePct.Type	Public
	Top 20 Total MySQL Server by Size	TopMySQLServerSize.Type	Public

Linked Reports (5)

	DisplayName	ID	Base	Target	Accessibility	Visible
	MySQL Server Connection Performance	Microsoft.MySQLServer.ConnectionPerformance.Report	Microsoft.SystemCenter.DataWarehouse.Report.Performance	Microsoft.MySQLServer.ManagedServer.Unix	Public	True
	MySQL Server InnoDB Buffer Pool Performance	Microsoft.MySQLServer.InnoDBBufferPoolPerformance.Report	Microsoft.SystemCenter.DataWarehouse.Report.Performance	Microsoft.MySQLServer.ManagedServer.Unix	Public	True
	MySQL Server Key Cache Performance	Microsoft.MySQLServer.KeyCachePerformance.Report	Microsoft.SystemCenter.DataWarehouse.Report.Performance	Microsoft.MySQLServer.ManagedServer.Unix	Public	True
	MySQL Server Query Cache Performance	Microsoft.MySQLServer.QueryCachePerformance.Report	Microsoft.SystemCenter.DataWarehouse.Report.Performance	Microsoft.MySQLServer.ManagedServer.Unix	Public	True
	MySQL Server Table Cache Performance	Microsoft.MySQLServer.TableCachePerformance.Report	Microsoft.SystemCenter.DataWarehouse.Report.Performance	Microsoft.MySQLServer.ManagedServer.Unix	Public	True