Tuesday, 11 July 2017

Exploring the OnCommand Unified Manager 7.2 MySQL Databases

Unlike with WFA and OCI, in the install of OCUM 7.2 you get to pick the MySQL root password. Using the MySQL root password we can explore the databases and tables that exist with a new install of OCUM 7.2.

cd C:\Program Files\MySQL\MySQL Server 5.7\bin
mysql -u root -p

 Image: OCUM 7.2 Databases
OCUM 7.2 Databases

mysql> show databases;
+---------------------+
| Database            |
+---------------------+
| information_schema  |
| acquisition         |
| management          |
| mysql               |
| netapp_model        |
| netapp_model_view   |
| netapp_performance  |
| ocum                |
| ocum_data_collector |
| ocum_report         |
| ocum_report_birt    |
| ocum_view           |
| opm                 |
| performance_schema  |
| sanscreen           |
| scalemonitor        |
| sys                 |
+---------------------+

Database: information_schema

mysql> use information_schema;
Database changed
mysql> show tables;
+---------------------------------------+
| Tables_in_information_schema          |
+---------------------------------------+
| CHARACTER_SETS                        |
| COLLATIONS                            |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS                               |
| COLUMN_PRIVILEGES                     |
| ENGINES                               |
| EVENTS                                |
| FILES                                 |
| GLOBAL_STATUS                         |
| GLOBAL_VARIABLES                      |
| KEY_COLUMN_USAGE                      |
| OPTIMIZER_TRACE                       |
| PARAMETERS                            |
| PARTITIONS                            |
| PLUGINS                               |
| PROCESSLIST                           |
| PROFILING                             |
| REFERENTIAL_CONSTRAINTS               |
| ROUTINES                              |
| SCHEMATA                              |
| SCHEMA_PRIVILEGES                     |
| SESSION_STATUS                        |
| SESSION_VARIABLES                     |
| STATISTICS                            |
| TABLES                                |
| TABLESPACES                           |
| TABLE_CONSTRAINTS                     |
| TABLE_PRIVILEGES                      |
| TRIGGERS                              |
| USER_PRIVILEGES                       |
| VIEWS                                 |
| INNODB_LOCKS                          |
| INNODB_TRX                            |
| INNODB_SYS_DATAFILES                  |
| INNODB_FT_CONFIG                      |
| INNODB_SYS_VIRTUAL                    |
| INNODB_CMP                            |
| INNODB_FT_BEING_DELETED               |
| INNODB_CMP_RESET                      |
| INNODB_CMP_PER_INDEX                  |
| INNODB_CMPMEM_RESET                   |
| INNODB_FT_DELETED                     |
| INNODB_BUFFER_PAGE_LRU                |
| INNODB_LOCK_WAITS                     |
| INNODB_TEMP_TABLE_INFO                |
| INNODB_SYS_INDEXES                    |
| INNODB_SYS_TABLES                     |
| INNODB_SYS_FIELDS                     |
| INNODB_CMP_PER_INDEX_RESET            |
| INNODB_BUFFER_PAGE                    |
| INNODB_FT_DEFAULT_STOPWORD            |
| INNODB_FT_INDEX_TABLE                 |
| INNODB_FT_INDEX_CACHE                 |
| INNODB_SYS_TABLESPACES                |
| INNODB_METRICS                        |
| INNODB_SYS_FOREIGN_COLS               |
| INNODB_CMPMEM                         |
| INNODB_BUFFER_POOL_STATS              |
| INNODB_SYS_COLUMNS                    |
| INNODB_SYS_FOREIGN                    |
| INNODB_SYS_TABLESTATS                 |
+---------------------------------------+

Database: acquisition

mysql> use acquisition;
Database changed
mysql> show tables;
+------------------------------+
| Tables_in_acquisition        |
+------------------------------+
| acquisition_storage_identify |
| acquisition_volume_identify  |
| au                           |
| au_attrs                     |
| au_audit                     |
| ds                           |
| ds_attrs                     |
| ds_audit                     |
| ds_audit_details             |
| ds_type                      |
| ds_type_attrs                |
| ds_type_vendormodel          |
| originator                   |
+------------------------------+

Database: management

mysql> use management;
Database changed
mysql> show tables;
+----------------------+
| Tables_in_management |
+----------------------+
| id                   |
| info                 |
| scale                |
| version              |
+----------------------+

Database: mysql

mysql> use mysql;
Database changed
mysql> show tables;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| db                        |
| engine_cost               |
| event                     |
| func                      |
| general_log               |
| gtid_executed             |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| innodb_index_stats        |
| innodb_table_stats        |
| ndb_binlog_index          |
| plugin                    |
| proc                      |
| procs_priv                |
| proxies_priv              |
| server_cost               |
| servers                   |
| slave_master_info         |
| slave_relay_log_info      |
| slave_worker_info         |
| slow_log                  |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+

Database: netapp_model

mysql> use netapp_model;
Database changed
mysql> show tables;
+--------------------------------------------------+
| Tables_in_netapp_model                           |
+--------------------------------------------------+
| aggregate                                        |
| aggregate_objectstore_config_mapping             |
| application_record                               |
| change_delete_detail                             |
| change_record                                    |
| changed_attribute                                |
| cifs_share                                       |
| cifs_share_acl                                   |
| cluster                                          |
| cluster_peer                                     |
| disk                                             |
| disk_aggregate_relationship                      |
| disk_path                                        |
| export_policy                                    |
| export_rule                                      |
| fcp_lif                                          |
| fcp_port                                         |
| flash_device                                     |
| ha_pair                                          |
| igroup                                           |
| igroup_initiator                                 |
| iscsi_portal_group                               |
| iscsi_portal_group_lif                           |
| iscsi_security_entry                             |
| iscsi_session                                    |
| iscsi_session_connection                         |
| job_schedule                                     |
| license                                          |
| license_v2_entitlement_risk                      |
| lif                                              |
| lun                                              |
| lun_import                                       |
| lun_map                                          |
| lun_map_reporting_node                           |
| metrocluster_operation                           |
| network_failover_group                           |
| network_failover_group_network_port_relationship |
| network_ip_space                                 |
| network_lif                                      |
| network_port                                     |
| network_port_broadcast_domain                    |
| network_port_relationship                        |
| network_route                                    |
| network_route_lif                                |
| network_subnet                                   |
| nis_domain                                       |
| node                                             |
| node_license_usage                               |
| objectstore_config                               |
| objectstore_space_detail                         |
| param                                            |
| plex                                             |
| portset                                          |
| portset_port                                     |
| portset_to_igroup                                |
| processor                                        |
| qos_policy_group                                 |
| qos_policy_group_vserver_relationship            |
| qos_service_center                               |
| qos_service_center_relationship                  |
| qos_volume_workload                              |
| qos_workload_detail                              |
| qos_workload_node_relationship                   |
| qtree                                            |
| qtree_quota                                      |
| quota_user                                       |
| raid_group                                       |
| resource_aggregate                               |
| routing_group                                    |
| routing_group_destination                        |
| service_processor                                |
| sis_policy                                       |
| snap_mirror                                      |
| snap_mirror_history                              |
| snap_mirror_policy                               |
| snap_mirror_policy_rule                          |
| snap_mirror_self_relationship                    |
| snaplock                                         |
| snapshot                                         |
| snapshot_policy                                  |
| snapshot_policy_schedule                         |
| snapshot_policy_vserver_relationship             |
| storage_adapter                                  |
| storage_pool                                     |
| storage_pool_aggregate_relationship              |
| storage_pool_available                           |
| storage_service                                  |
| storage_service_volume_relationship              |
| storage_shelf                                    |
| storage_shelf_cable                              |
| storage_switch                                   |
| system_health_alert                              |
| update_history                                   |
| upgrade_history                                  |
| user_quota                                       |
| version                                          |
| volume                                           |
| volume_flexcache                                 |
| volume_flexgroup_constituent_relationship        |
| volume_move_job                                  |
| volume_self_relationship                         |
| vserver                                          |
| vserver_name_mapping                             |
| vserver_peer                                     |
| vserver_to_aggregate                             |
+--------------------------------------------------+

Database: netapp_model_view

mysql> use netapp_model_view;
Database changed
mysql> show tables;
+-------------------------------------------------------+
| Tables_in_netapp_model_view                           |
+-------------------------------------------------------+
| aggregate                                             |
| aggregate_full                                        |
| aggregate_objectstore_config_mapping                  |
| aggregate_objectstore_config_mapping_full             |
| application_record                                    |
| application_record_full                               |
| change_delete_detail                                  |
| change_record                                         |
| changed_attribute                                     |
| cifs_share                                            |
| cifs_share_acl                                        |
| cifs_share_acl_full                                   |
| cifs_share_full                                       |
| cluster                                               |
| cluster_full                                          |
| cluster_peer                                          |
| cluster_peer_full                                     |
| disk                                                  |
| disk_aggregate_relationship                           |
| disk_aggregate_relationship_full                      |
| disk_full                                             |
| disk_path                                             |
| disk_path_full                                        |
| export_policy                                         |
| export_policy_full                                    |
| export_rule                                           |
| export_rule_full                                      |
| fcp_lif                                               |
| fcp_lif_derived                                       |
| fcp_lif_derived_full                                  |
| fcp_lif_full                                          |
| fcp_port                                              |
| fcp_port_full                                         |
| flash_device                                          |
| flash_device_full                                     |
| ha_pair                                               |
| ha_pair_full                                          |
| igroup                                                |
| igroup_full                                           |
| igroup_initiator                                      |
| igroup_initiator_full                                 |
| iscsi_portal_group                                    |
| iscsi_portal_group_full                               |
| iscsi_portal_group_lif                                |
| iscsi_portal_group_lif_full                           |
| iscsi_security_entry                                  |
| iscsi_security_entry_full                             |
| iscsi_session                                         |
| iscsi_session_connection                              |
| iscsi_session_connection_full                         |
| iscsi_session_full                                    |
| job_schedule                                          |
| job_schedule_full                                     |
| license                                               |
| license_full                                          |
| license_v2_entitlement_risk                           |
| license_v2_entitlement_risk_full                      |
| lif                                                   |
| lif_full                                              |
| lun                                                   |
| lun_full                                              |
| lun_import                                            |
| lun_import_full                                       |
| lun_map                                               |
| lun_map_full                                          |
| lun_map_reporting_node                                |
| lun_map_reporting_node_full                           |
| metrocluster_operation                                |
| metrocluster_operation_full                           |
| network_failover_group                                |
| network_failover_group_full                           |
| network_failover_group_network_port_relationship      |
| network_failover_group_network_port_relationship_full |
| network_ip_space                                      |
| network_ip_space_full                                 |
| network_lif                                           |
| network_lif_derived                                   |
| network_lif_derived_full                              |
| network_lif_full                                      |
| network_port                                          |
| network_port_broadcast_domain                         |
| network_port_broadcast_domain_full                    |
| network_port_full                                     |
| network_route                                         |
| network_route_full                                    |
| network_route_lif                                     |
| network_route_lif_full                                |
| network_subnet                                        |
| network_subnet_full                                   |
| nis_domain                                            |
| nis_domain_full                                       |
| node                                                  |
| node_full                                             |
| node_license_usage                                    |
| node_license_usage_full                               |
| objectstore_config                                    |
| objectstore_config_full                               |
| objectstore_space_detail                              |
| objectstore_space_detail_full                         |
| plex                                                  |
| plex_full                                             |
| portset                                               |
| portset_full                                          |
| portset_to_igroup                                     |
| portset_to_igroup_full                                |
| portset_to_port                                       |
| portset_to_port_full                                  |
| processor                                             |
| processor_full                                        |
| qos_policy_group                                      |
| qos_policy_group_full                                 |
| qos_service_center                                    |
| qos_service_center_full                               |
| qos_volume_workload                                   |
| qos_volume_workload_full                              |
| qos_workload_detail                                   |
| qos_workload_detail_full                              |
| qos_workload_node_relationship                        |
| qos_workload_node_relationship_full                   |
| qtree                                                 |
| qtree_full                                            |
| qtree_quota                                           |
| qtree_quota_full                                      |
| quota_user                                            |
| quota_user_full                                       |
| raid_group                                            |
| raid_group_full                                       |
| resource_aggregate                                    |
| resource_aggregate_full                               |
| routing_group                                         |
| routing_group_destination                             |
| routing_group_destination_full                        |
| routing_group_full                                    |
| service_processor                                     |
| service_processor_full                                |
| sis_policy                                            |
| sis_policy_full                                       |
| snap_mirror                                           |
| snap_mirror_full                                      |
| snap_mirror_history                                   |
| snap_mirror_history_full                              |
| snap_mirror_policy                                    |
| snap_mirror_policy_full                               |
| snap_mirror_policy_rule                               |
| snap_mirror_policy_rule_full                          |
| snaplock                                              |
| snaplock_full                                         |
| snapshot                                              |
| snapshot_full                                         |
| snapshot_policy                                       |
| snapshot_policy_full                                  |
| snapshot_policy_schedule                              |
| snapshot_policy_schedule_full                         |
| storage_adapter                                       |
| storage_adapter_full                                  |
| storage_pool                                          |
| storage_pool_aggregate_relationship                   |
| storage_pool_aggregate_relationship_full              |
| storage_pool_available                                |
| storage_pool_available_full                           |
| storage_pool_full                                     |
| storage_service                                       |
| storage_service_full                                  |
| storage_shelf                                         |
| storage_shelf_cable                                   |
| storage_shelf_cable_full                              |
| storage_shelf_full                                    |
| storage_switch                                        |
| storage_switch_full                                   |
| system_health_alert                                   |
| system_health_alert_full                              |
| user_quota                                            |
| user_quota_full                                       |
| volume                                                |
| volume_full                                           |
| volume_move_job                                       |
| volume_move_job_full                                  |
| vserver                                               |
| vserver_full                                          |
| vserver_name_mapping                                  |
| vserver_name_mapping_full                             |
| vserver_peer                                          |
| vserver_peer_full                                     |
| vserver_to_aggregate                                  |
| vserver_to_aggregate_full                             |
+-------------------------------------------------------+

Database: netapp_performance

mysql> use netapp_performance;
Database changed
mysql> show tables;
+------------------------------+
| Tables_in_netapp_performance |
+------------------------------+
| update_history               |
+------------------------------+

Database: ocum

mysql> use ocum;
Database changed
mysql> show tables;
+--------------------------------------------+
| Tables_in_ocum                             |
+--------------------------------------------+
| aggregate                                  |
| aggregatecalculationsview                  |
| aggregategrowthrateinfo                    |
| aggregatehistorymonth                      |
| aggregatehistoryweek                       |
| aggregatehistoryyear                       |
| aggregatelivelistdtoview                   |
| aggregateregressioninfo                    |
| aggregatestoragepoollivelistdtoview        |
| alert                                      |
| alert_emailaddressrecipients               |
| alert_emailadminrecipients                 |
| alert_eventseverities                      |
| alerteventtypevalues                       |
| alertresourceobjects                       |
| annotation                                 |
| annotationmanualresourcemapping            |
| annotationofcluster                        |
| annotationofvolume                         |
| annotationofvserver                        |
| annotationresourceobject                   |
| annotationresourceobjectlivelistdtoview    |
| annotationrule                             |
| annotationrulelivelistdtoview              |
| annotationtype                             |
| annotationtypevalueview                    |
| annotationvaluebreakdownlivelistdtoview    |
| authorizationunit                          |
| backupfileinfo                             |
| bridge                                     |
| bridgestackconnection                      |
| bridgestacklink                            |
| cifsshare                                  |
| cifssharelivelistdtoview                   |
| clienteventdetails                         |
| cluster                                    |
| clusterhistorymonth                        |
| clusterhistoryweek                         |
| clusterhistoryyear                         |
| clusterlivelistdtoview                     |
| clusternode                                |
| clusternodededicatesparecapacityview       |
| clusternodedowneventsview                  |
| clusternodehighavailabilitystateview       |
| clusternodehistorymonth                    |
| clusternodehistoryweek                     |
| clusternodehistoryyear                     |
| clusternoderawsparecapacityview            |
| clusternoderawsparesharedcachecapacityview |
| clusternoderawspareshareddatacapacityview  |
| conditiongroup                             |
| conditiontable                             |
| customeventtype                            |
| customeventtypevalue                       |
| databaseproperty                           |
| datapolicy                                 |
| datasource                                 |
| datasourcelivelistdtoview                  |
| deferredmccresource                        |
| deferredontapalert                         |
| deletedvolume                              |
| diskaggregaterelationship                  |
| diskaggregaterelationshipaggrcountview     |
| disklivelistdtoview                        |
| efficiencypolicy                           |
| event                                      |
| eventnote                                  |
| eventontapsystemhealthalertmapping         |
| eventtype                                  |
| eventtypecategoryclosureassociation        |
| eventtypecategorycontainer                 |
| eventtypesourcetypes                       |
| eventtypevalue                             |
| exportpolicy                               |
| exportrule                                 |
| exportrulelivelistdtoview                  |
| externalcache                              |
| externalcachehistorymonth                  |
| externalcachehistoryweek                   |
| externalcachehistoryyear                   |
| favorite                                   |
| fcptarget                                  |
| flashcard                                  |
| flexvolcalculationsview                    |
| groupaction                                |
| groupactionargument                        |
| groupactionlivelistdtoview                 |
| grouplivelistdtoview                       |
| groupmembership                            |
| groupmembershiprule                        |
| groupmembershiprulelivelistdtoview         |
| groups                                     |
| hibernate_sequences                        |
| igrouplivelistdtoview                      |
| infinitevolhistorymonth                    |
| infinitevolhistoryweek                     |
| infinitevolhistoryyear                     |
| initiator                                  |
| initiatorcountperigroupdtoview             |
| initiatordtoviewlist                       |
| initiatorgroup                             |
| internodeconnection                        |
| internodelink                              |
| interswitchconnection                      |
| interswitchlink                            |
| job                                        |
| jobreportview                              |
| ldapserver                                 |
| lifcountperigrouplistdtoview               |
| logicalinterface                           |
| logicalinterfacelivelistdtoview            |
| lun                                        |
| luncountperigrouplistdtoview               |
| lunlivelistdtoview                         |
| lunmapidperigroupdtoview                   |
| managedvolumecalculationsview              |
| managementstation                          |
| manualannotationbreakdownlivelistdto       |
| metroclusterrelationship                   |
| networkport                                |
| nfsexportlivelistdtoview                   |
| nodebridgeconnection                       |
| nodebridgelink                             |
| nodestackconnection                        |
| nodestacklink                              |
| nodeswitchconnection                       |
| nodeswitchlink                             |
| objectstore_config                         |
| ocummonitoringstatus                       |
| ontapalert                                 |
| ontapems                                   |
| ontapemsparameter                          |
| ontapfaultinfo                             |
| optionchainvalue                           |
| persistentproperty                         |
| plex                                       |
| portlivelistdtoview                        |
| portset                                    |
| portsetnamesperlogicalinterfacedtoview     |
| qrtz_blob_triggers                         |
| qrtz_calendars                             |
| qrtz_cron_triggers                         |
| qrtz_fired_triggers                        |
| qrtz_job_details                           |
| qrtz_locks                                 |
| qrtz_paused_trigger_grps                   |
| qrtz_scheduler_state                       |
| qrtz_simple_triggers                       |
| qrtz_simprop_triggers                      |
| qrtz_triggers                              |
| qtree                                      |
| qtreelivelistdtoview                       |
| readytaskworkitemqueueentry                |
| report                                     |
| reportschedule                             |
| reportschedulerelationship                 |
| resourcepool                               |
| resourcepoolaggregates                     |
| resourcepoollivelistdtoview                |
| role                                       |
| routinggrouproutesview                     |
| ruletemplate                               |
| script                                     |
| scriptlivelistdtoview                      |
| selectioncriterion                         |
| serviceworkflow                            |
| snapmirrorrelationship                     |
| snapmirrortransfer                         |
| snapshotexpirerecord                       |
| snapshotmetadata                           |
| snapshotpolicy                             |
| storagearray                               |
| storagearrayclusterassociation             |
| storagearraylunpath                        |
| storagearrayport                           |
| storagearrayportclusterassociation         |
| storageclass                               |
| storageservice                             |
| storageservice_contacts                    |
| storageserviceconnection                   |
| storageserviceconnectionmember             |
| storageservicenode                         |
| storageservicenodemember                   |
| storageservicenoderesourcepool             |
| storageservicerootmemberinfo               |
| storageservicesubscription                 |
| storageservicesubscription_metadatafields  |
| storageservicesubscriptionrootmember       |
| storageservicevserverdestination           |
| storageshelf                               |
| subscribedems                              |
| svmrelationshiplivelistdtoview             |
| switch                                     |
| switchbridgeconnection                     |
| switchbridgelink                           |
| switchinterswitchrelationship              |
| targetportalgroup                          |
| task                                       |
| taskmessage                                |
| taskobjectinteraction                      |
| taskpredecessor                            |
| taskreportview                             |
| taskretry                                  |
| taskstatuschange                           |
| taskstatuschangeview                       |
| thresholdobjectstocheck                    |
| trap                                       |
| trapvarbinding                             |
| userquota                                  |
| userquotalivelistdtoview                   |
| volume                                     |
| volumeaggregatemappingview                 |
| volumecalculationsview                     |
| volumeflexgroupaggregaterelationshipview   |
| volumegrowthrateinfo                       |
| volumehistorymonth                         |
| volumehistoryweek                          |
| volumehistoryyear                          |
| volumejunctionpathhistory                  |
| volumelivelistdtoview                      |
| volumelivelistmaxvolumemovejobview         |
| volumemovehistory                          |
| volumeoutgoingrelationshipview             |
| volumeregressioninfo                       |
| volumerelationshiplivelistdtoview          |
| volumesnapshot_metadatafields              |
| vserver                                    |
| vserverassociationlivelistdtoview          |
| vserverhistorymonth                        |
| vserverhistoryweek                         |
| vserverhistoryyear                         |
| vserverlivelistdtoview                     |
| wafldisk                                   |
+--------------------------------------------+

Database: ocum_data_collector

mysql> use ocum_data_collector;
Database changed
mysql> show tables;
Empty set (0.00 sec)

Database: ocum_report

mysql> use ocum_report;
Database changed
mysql> show tables;
+------------------------------------------+
| Tables_in_ocum_report                    |
+------------------------------------------+
| aggregate                                |
| aggregatecapacityhistorymonthview        |
| aggregatecapacityhistoryweekview         |
| aggregatecapacityhistoryyearview         |
| aggregateobjectstoremapping              |
| annotation                               |
| annotationofclusterview                  |
| annotationofvolumeview                   |
| annotationofvserverview                  |
| cifsshare                                |
| cifsshareacl                             |
| cluster                                  |
| clusterlicensedetailview                 |
| clusterlicenseview                       |
| clusternode                              |
| disk                                     |
| diskaggregatemapping                     |
| exportpolicy                             |
| exportrule                               |
| fcpport                                  |
| lif                                      |
| lun                                      |
| networkport                              |
| objectstore                              |
| objectstorespacedetails                  |
| protectunprotectvolumeview               |
| qtree                                    |
| qtreequota                               |
| storagepool                              |
| storagepoolaggregatemapping              |
| svm                                      |
| svmaggregatemapping                      |
| unprotectvolumeview                      |
| userquota                                |
| volume                                   |
| volumecapacityhistorymonthview           |
| volumecapacityhistoryweekview            |
| volumecapacityhistoryyearview            |
| volumeoutgoingrelationshipview           |
| volumeprotectionview                     |
| volumerelationshiphistoryaggweekhourview |
| volumerelationshiphistorychartcountview  |
| volumerelationshiphistorychartview       |
| volumerelationshiphistorydayview         |
| volumerelationshiphistorymonthview       |
| volumerelationshiphistoryview            |
| volumerelationshiphistoryweekview        |
| volumerelationshiphistoryyearview        |
| volumerelationshipinventoryview          |
| volumerelationships                      |
+------------------------------------------+

Database: ocum_report_birt

mysql> use ocum_report_birt;
Database changed
mysql> show tables;
+------------------------------------------+
| Tables_in_ocum_report_birt               |
+------------------------------------------+
| ackevents                                |
| acktoresolvedandobsoleteevents           |
| aggregatecapacityutilization             |
| aggregatecapacityutilizationhistory      |
| basicevents                              |
| clusterinventoryreport                   |
| clusterlicenseview                       |
| clusterunconfiguredcapacitymapping       |
| daywiseeventstatustrendchart             |
| diskcapacitymapping                      |
| eventseveritytrendchart                  |
| eventseveritytrendhelper                 |
| eventstatecharthelper                    |
| eventupdatedates                         |
| halevelmapping                           |
| hapairview                               |
| lunnodecapacitymapping                   |
| newevents                                |
| newtoresolvedandobsoleteevents           |
| nfsexport                                |
| nodelevelcapacitymapping                 |
| protectunprotectvolumeview               |
| qtreecapacityutilization                 |
| storagesummary                           |
| storagesystemhealthtable                 |
| svminventoryreport                       |
| unprotectvolumeview                      |
| volumecapacityutilization                |
| volumecapacityutilizationhistory         |
| volumenodecapacitymapping                |
| volumerelationshiphistoryaggweekhourview |
| volumerelationshiphistorychartcountview  |
| volumerelationshiphistorychartview       |
| volumerelationshiphistorydayview         |
| volumerelationshiphistorymonthview       |
| volumerelationshiphistoryview            |
| volumerelationshiphistoryweekview        |
| volumerelationshiphistoryyearview        |
| volumerelationshipinventoryview          |
+------------------------------------------+

Database: ocum_view

mysql> use ocum_view;
Database changed
mysql> show tables;
+------------------------------------+
| Tables_in_ocum_view                |
+------------------------------------+
| aggregate                          |
| annotation                         |
| annotationresourceobjectview       |
| annotationtype                     |
| event                              |
| eventnote                          |
| metadatavolume                     |
| resource_pool                      |
| resource_pool_aggregates           |
| volume                             |
| volumelivelistdtoview              |
| volumelivelistmaxvolumemovejobview |
| vserver_destination                |
+------------------------------------+

Database: opm

mysql> use opm;
Database changed
mysql> show tables;
+----------------------------------------------+
| Tables_in_opm                                |
+----------------------------------------------+
| acquisition_info                             |
| bp_event                                     |
| change_event                                 |
| change_event_attribute                       |
| change_event_workload                        |
| change_type_definition                       |
| config                                       |
| contention_analysis_role_definition          |
| continuous_event_occurrence                  |
| continuous_event_participant                 |
| continuous_event_participant_stats           |
| dyn_state_definition                         |
| element_type_definition                      |
| event_to_declare_bp                          |
| ext_data_config                              |
| ext_server_config                            |
| forecast                                     |
| notification_dynamic_event_option_definition |
| notification_level_definition                |
| notification_scope_definition                |
| notification_type_definition                 |
| notification_umevent_definition              |
| polling_interval_history                     |
| s_all_aggregates_periodic                    |
| s_all_clusters_periodic                      |
| s_all_lifs_periodic                          |
| s_all_luns_periodic                          |
| s_all_nodes_periodic                         |
| s_all_ports_periodic                         |
| s_all_svms_periodic                          |
| s_all_volumes_periodic                       |
| shadow_table_trail                           |
| stat_type_definition                         |
| target_type_definition                       |
| threshold                                    |
| threshold_notification                       |
| threshold_policy                             |
| threshold_policy_mapping                     |
| upgrade_history                              |
| version                                      |
+----------------------------------------------+

Database: performance_schema

mysql> use performance_schema;
Database changed
mysql> show tables;
+------------------------------------------------------+
| Tables_in_performance_schema                         |
+------------------------------------------------------+
| accounts                                             |
| cond_instances                                       |
| events_stages_current                                |
| events_stages_history                                |
| events_stages_history_long                           |
| events_stages_summary_by_account_by_event_name       |
| events_stages_summary_by_host_by_event_name          |
| events_stages_summary_by_thread_by_event_name        |
| events_stages_summary_by_user_by_event_name          |
| events_stages_summary_global_by_event_name           |
| events_statements_current                            |
| events_statements_history                            |
| events_statements_history_long                       |
| events_statements_summary_by_account_by_event_name   |
| events_statements_summary_by_digest                  |
| events_statements_summary_by_host_by_event_name      |
| events_statements_summary_by_program                 |
| events_statements_summary_by_thread_by_event_name    |
| events_statements_summary_by_user_by_event_name      |
| events_statements_summary_global_by_event_name       |
| events_transactions_current                          |
| events_transactions_history                          |
| events_transactions_history_long                     |
| events_transactions_summary_by_account_by_event_name |
| events_transactions_summary_by_host_by_event_name    |
| events_transactions_summary_by_thread_by_event_name  |
| events_transactions_summary_by_user_by_event_name    |
| events_transactions_summary_global_by_event_name     |
| events_waits_current                                 |
| events_waits_history                                 |
| events_waits_history_long                            |
| events_waits_summary_by_account_by_event_name        |
| events_waits_summary_by_host_by_event_name           |
| events_waits_summary_by_instance                     |
| events_waits_summary_by_thread_by_event_name         |
| events_waits_summary_by_user_by_event_name           |
| events_waits_summary_global_by_event_name            |
| file_instances                                       |
| file_summary_by_event_name                           |
| file_summary_by_instance                             |
| global_status                                        |
| global_variables                                     |
| host_cache                                           |
| hosts                                                |
| memory_summary_by_account_by_event_name              |
| memory_summary_by_host_by_event_name                 |
| memory_summary_by_thread_by_event_name               |
| memory_summary_by_user_by_event_name                 |
| memory_summary_global_by_event_name                  |
| metadata_locks                                       |
| mutex_instances                                      |
| objects_summary_global_by_type                       |
| performance_timers                                   |
| prepared_statements_instances                        |
| replication_applier_configuration                    |
| replication_applier_status                           |
| replication_applier_status_by_coordinator            |
| replication_applier_status_by_worker                 |
| replication_connection_configuration                 |
| replication_connection_status                        |
| replication_group_member_stats                       |
| replication_group_members                            |
| rwlock_instances                                     |
| session_account_connect_attrs                        |
| session_connect_attrs                                |
| session_status                                       |
| session_variables                                    |
| setup_actors                                         |
| setup_consumers                                      |
| setup_instruments                                    |
| setup_objects                                        |
| setup_timers                                         |
| socket_instances                                     |
| socket_summary_by_event_name                         |
| socket_summary_by_instance                           |
| status_by_account                                    |
| status_by_host                                       |
| status_by_thread                                     |
| status_by_user                                       |
| table_handles                                        |
| table_io_waits_summary_by_index_usage                |
| table_io_waits_summary_by_table                      |
| table_lock_waits_summary_by_table                    |
| threads                                              |
| user_variables_by_thread                             |
| users                                                |
| variables_by_thread                                  |
+------------------------------------------------------+

Database: sanscreen

mysql> use sanscreen;
Database changed
mysql> show tables;
+---------------------+
| Tables_in_sanscreen |
+---------------------+
| implicit_commit     |
| user                |
| user_role           |
+---------------------+

Database: scalemonitor

mysql> use scalemonitor;
Database changed
mysql> show tables;
+------------------------+
| Tables_in_scalemonitor |
+------------------------+
| attribute              |
| config                 |
| sample                 |
| upgrade_history        |
| value                  |
| version                |
+------------------------+

Database: sys

mysql> use sys;
Database changed
mysql> show tables;
+-----------------------------------------------+
| Tables_in_sys                                 |
+-----------------------------------------------+
| host_summary                                  |
| host_summary_by_file_io                       |
| host_summary_by_file_io_type                  |
| host_summary_by_stages                        |
| host_summary_by_statement_latency             |
| host_summary_by_statement_type                |
| innodb_buffer_stats_by_schema                 |
| innodb_buffer_stats_by_table                  |
| innodb_lock_waits                             |
| io_by_thread_by_latency                       |
| io_global_by_file_by_bytes                    |
| io_global_by_file_by_latency                  |
| io_global_by_wait_by_bytes                    |
| io_global_by_wait_by_latency                  |
| latest_file_io                                |
| memory_by_host_by_current_bytes               |
| memory_by_thread_by_current_bytes             |
| memory_by_user_by_current_bytes               |
| memory_global_by_current_bytes                |
| memory_global_total                           |
| metrics                                       |
| processlist                                   |
| ps_check_lost_instrumentation                 |
| schema_auto_increment_columns                 |
| schema_index_statistics                       |
| schema_object_overview                        |
| schema_redundant_indexes                      |
| schema_table_lock_waits                       |
| schema_table_statistics                       |
| schema_table_statistics_with_buffer           |
| schema_tables_with_full_table_scans           |
| schema_unused_indexes                         |
| session                                       |
| session_ssl_status                            |
| statement_analysis                            |
| statements_with_errors_or_warnings            |
| statements_with_full_table_scans              |
| statements_with_runtimes_in_95th_percentile   |
| statements_with_sorting                       |
| statements_with_temp_tables                   |
| sys_config                                    |
| user_summary                                  |
| user_summary_by_file_io                       |
| user_summary_by_file_io_type                  |
| user_summary_by_stages                        |
| user_summary_by_statement_latency             |
| user_summary_by_statement_type                |
| version                                       |
| wait_classes_global_by_avg_latency            |
| wait_classes_global_by_latency                |
| waits_by_host_by_latency                      |
| waits_by_user_by_latency                      |
| waits_global_by_latency                       |
| x$host_summary                                |
| x$host_summary_by_file_io                     |
| x$host_summary_by_file_io_type                |
| x$host_summary_by_stages                      |
| x$host_summary_by_statement_latency           |
| x$host_summary_by_statement_type              |
| x$innodb_buffer_stats_by_schema               |
| x$innodb_buffer_stats_by_table                |
| x$innodb_lock_waits                           |
| x$io_by_thread_by_latency                     |
| x$io_global_by_file_by_bytes                  |
| x$io_global_by_file_by_latency                |
| x$io_global_by_wait_by_bytes                  |
| x$io_global_by_wait_by_latency                |
| x$latest_file_io                              |
| x$memory_by_host_by_current_bytes             |
| x$memory_by_thread_by_current_bytes           |
| x$memory_by_user_by_current_bytes             |
| x$memory_global_by_current_bytes              |
| x$memory_global_total                         |
| x$processlist                                 |
| x$ps_digest_95th_percentile_by_avg_us         |
| x$ps_digest_avg_latency_distribution          |
| x$ps_schema_table_statistics_io               |
| x$schema_flattened_keys                       |
| x$schema_index_statistics                     |
| x$schema_table_lock_waits                     |
| x$schema_table_statistics                     |
| x$schema_table_statistics_with_buffer         |
| x$schema_tables_with_full_table_scans         |
| x$session                                     |
| x$statement_analysis                          |
| x$statements_with_errors_or_warnings          |
| x$statements_with_full_table_scans            |
| x$statements_with_runtimes_in_95th_percentile |
| x$statements_with_sorting                     |
| x$statements_with_temp_tables                 |
| x$user_summary                                |
| x$user_summary_by_file_io                     |
| x$user_summary_by_file_io_type                |
| x$user_summary_by_stages                      |
| x$user_summary_by_statement_latency           |
| x$user_summary_by_statement_type              |
| x$wait_classes_global_by_avg_latency          |
| x$wait_classes_global_by_latency              |
| x$waits_by_host_by_latency                    |
| x$waits_by_user_by_latency                    |
| x$waits_global_by_latency                     |
+-----------------------------------------------+

No comments:

Post a Comment