管理和了解 MySQL：有什么新功能？.pdf

《管理和了解 MySQL：有什么新功能？.pdf》由會員分享，可在線閱讀，更多相關《管理和了解 MySQL：有什么新功能？.pdf（26頁珍藏版）》請在三個皮匠報告上搜索。

1、Managing and Monitoring MySQL:Whats New?Sriram Vrinda Product Management-MySQL Observability Agenda Introduction Overview of monitoring in MySQL HeatWave service in OCI(MHS)New capabilities for Observability and Management of MySQL systemsDemo Q&ACopyright 2024,Oracle and/or its affiliatesCopyright

2、2024,Oracle and/or its affiliatesIntroduction Observability and Management Advanced ServicesOracle Cloud Observability and Management PlatformObservability and Management Data SourcesInfrastructure ServicesLogsMetricsEventsTracesSQLCopyright 2024,Oracle and/or its affiliates4OCI services for a compr

3、ehensive database management solutionPublic cloud,hybrid cloud,and multicloud Copyright 2024,Oracle and/or its affiliates5Database ManagementUnified console for on-premises and cloud databases with lifecycle database management capabilities for monitoring,performance management,tuning,and administra

4、tion Stack MonitoringStack Monitoring provides discovery and monitoring of databases,hosts and other application tech stack components,enabling correlation of status and performance across the stackOps InsightsPredict and plan for future demand,eliminate systemic issues using advanced analytics on c

5、urated telemetry and long-term dataLogging AnalyticsProactive,repeatable,and automated problem detection and monitoring in a business context.Simplified IT Ops and DevOps using interactive ML/AI-driven advanced analyticsCopyright 2024,Oracle and/or its affiliatesNew Capabilities for MySQL Database M

6、anagement100%developed,managed,and supported by OracleNew Capabilities for MySQL Database ManagementCopyright 2024,Oracle and/or its affiliatesOCI Monitoring Find performance bottlenecks Collect metrics Define thresholdsDatabase Management Fix problem queries Rapidly troubleshoot performance issuesO

7、ps Insights Predictive Insights with AI Trend and forecastDatabase Management services for MySQLCopyright 2024,Oracle and/or its affiliates.All rights reserved.CategoriesCapabilitiesDatabase ManagementGeneral Availability:October.2023 for MDS Fleet and single DB dashboard Collects 40 key metrics wit

8、h monitoring UI showing 7 days of historical data for correlationUtilizes OCI Monitoring service data store&OCI Alarm capabilityPerformance Hub:Database performance diagnostics and troubleshootingBasic configuration information Configuration parameters organized by categories&searchable with links t

9、o MySQL config template for modificationOperations InsightsGeneral Availability:July 2024 for MDS Capacity Planning and ForecastingSQL Explorer plus WarehouseNote:Support for On-premises deployment would be GA in July 2024 MySQL Enterprise Monitor(MEM)End of Life(EOL)Announcement(Doc ID 3008050.1)My

10、SQL Enterprise MonitorCopyright 2024,Oracle and/or its affiliates9OCI monitoring serviceMonitoring MySQL databases in OCICopyright 2024,Oracle and/or its affiliates.All rights reserved.OCI Console supports native monitoring and management of MySQL DB System in OCI Metrics MySQL metrics to diagnose a

11、nd troubleshoot problems Create alarms on key metrics based on thresholds Events and NotificationOCI Events can be used get informed about state change of MySQL resources.Example:create/terminate,backup operations etc.Monitoring,events and notification service can also be integrated with third party

12、 services like Pager duty and Slack for operations managementOn-demand subscription based cloud serviceOracle Cloud Infrastructure Database Management ServiceCopyright 2024,Oracle and/or its affiliates.All rights reserved.Leading database performance diagnostics Combines back-end instrumentation and

13、 tools with visualization-driven interfaces Single pane of glass management view for databases deployed anywhereCloud native Fully managed by Oracle True cloud elasticity,low operations costKey use cases Monitor fleet of databases Real-time performance diagnostics Monitor databases deployed on multi

14、cloud or on-premisesUnified fleet view of databases across Oracle Cloud and on-premises On the Fleet Summary page,you can monitor multiple Databases MySQL,Autonomous,On-premisesNative OCI metrics for DevOps event alarms and monitoringDrill down from the Fleet Summary page to a specific MySQL databas

15、e of interestVisualization-driven load and performance analysisFleet monitoring and managementCopyright 2024,Oracle and/or its affiliates.All rights reserved.Drill down from the Fleet Summary page to a specific MySQL database of interest to monitor:Average statement latency CPU utilization Disk IOPS

16、 Memory Network throughput Metrics page for detailed charts of all the available metrics for better co-relation Configuration variables used by the running instances,view them by various filters,etc.Performance summaryCopyright 2024,Oracle and/or its affiliates.All rights reserved.Copyright 2024,Ora

17、cle and/or its affiliatesPerformance Hubfor SQL performance management Monitor and troubleshoot query performance Quickly identify expensive queries that impact the performance of their applications Visualize query activity to gain further insight into performance beyond query statistics Filter for

18、specific query problems like full table scans and bad indexes using advanced global search options Filter for queries offloaded to HeatWave Cluster Fix the root causes of poor performance directly in the SQL codePerformance Hub:Find and Fix Problem Queries Copyright 2024,Oracle and/or its affiliates

19、.All rights reserved.Real-time aggregation of query content and performance statistics without relying on MySQL logs or SHOW PROCESS LIST Aggregated and searchable roll-ups of all queries Canonical form of all queries Total number of query executions Total execution time of queries Total data size o

20、f queries Date and time when a query was first seenPerformance Hub:Find and Fix Problem Queries Copyright 2024,Oracle and/or its affiliates.All rights reserved.Analyzes data from Performance Schema to provide data about how statements generate their result sets drill down to specifics like:Table Loc

21、k time How many rows were examined versus returned How many temporary tables were created,and whether any were created on disk Whether range scans were done,and in what form they were done Whether sorting happened,how many rows were sorted,and what form the sort tookPerformance Hub:Find and Fix Prob

22、lem Queries Copyright 2024,Oracle and/or its affiliates.All rights reserved.Performance Hub:Find and Fix Problem Queries Copyright 2024,Oracle and/or its affiliates.All rights reserved.Problem scenarios:Queries with high execution times Queries a high number of rows Solution approach using Performan

23、ce Hub Identify queries with high execution times and small result sets Check if these queries are querying a large number of rows Determine if non-indexed columns are being used in the query Optimize the query by simplifying it or using indexed columns Monitor the performance of the query after opt

24、imization to ensure that the execution time has improved.MySQL Autopilot indexing(Coming soon)Recommends secondary indexes for OLTP workloadsCopyright 2024,Oracle and/or its affiliatesCREATE/DROPIndexesRowsidxQueriesDMLsRowsidxQueriesDMLsBase tablesBase tablesQueriesDMLsCREATE/DROPIndexesAutopilot I

25、ndexing(Coming soon)ML automation with MySQL HeatWave FeaturesML-based feature designed to help optimize database systems for better cost and performanceConsiders both query and DML performance Recommends CREATE and DROP of indexesGenerates DDLs for index creation/dropProvides performance prediction

26、Provides storage predictionContinuous learning and adaptingBenefitsDBAs no longer need to manually identify the secondary indexes for the database workload.Considers both the query performance and the cost of maintaining the indexesPredicts expected improvement without creating the indexes Provides

27、explanation for the recommendationsOriented by performance objectives:throughput,latency,storageCopyright 2024,Oracle and/or its affiliates100%developed,managed,and supported by OracleNew Capabilities for MySQL Database ManagementCopyright 2024,Oracle and/or its affiliatesOCI Monitoring Find perform

28、ance bottlenecks Collect metrics Define thresholdsDatabase Management Fix problem queries Rapidly troubleshoot performance issuesOps Insights Predictive Insights with AI Trend and forecastPredict demand from changing workloadsForecast demand for changing workloadsMax and average demand forecastsMach

29、ine learning seasonality modelsAutomatic prediction of near-term issuesQuickly isolate the largest,most utilized,and fastest growing databasesIdentify under-utilized and over-allocated footprint for right sizingInsights and recommendations to right size your infrastructure and optimize resource util

30、izationPredictive InsightsCopyright 2024,Oracle and/or its affiliates.All rights reserved.Coming soon!Insights into SQL performance Detect performance degradation in business-critical SQLCorrelate performanceAggregate and compare across databasesIdentify application scalability and inefficiency issu

31、esTrend and forecast metrics seasonality via custom analytics for solving specific issues Detects causes,measure effects,then correlates themCauses:workload changes,configuration changesEffects:regressed SQL,reach resource limits(CPU,I/O,memory)Predictive InsightsCopyright 2024,Oracle and/or its aff

32、iliates.All rights reserved.Coming soon!Maximizing reliability with automated proactive monitoringMySQL HeatWave service finds the problems before you doOracle Cloud Operations uses continuous monitoring for each database:8000+metrics and 1500+alarms Much broader than any on-premises customer Consol

33、idated monitoring of entire stack:infrastructure,load balancer,connection manager,databaseAutomatic service requests are generated for each deviation Immediate investigation and resolution by cloud ops Root cause analysis for every issue Zero customer actions requiredCopyright 2024,Oracle and/or its

34、 affiliatesCopyright 2023,Oracle and/or its affiliates Overview of Autonomous Database Serverless Copyright 2024,Oracle and/or its affiliatesDEMOObservability and Management Advanced ServicesOracle Cloud Observability and Management PlatformObservability and Management Data SourcesInfrastructure ServicesLogsMetricsEventsTracesSQLCopyright 2024,Oracle and/or its affiliates26