SQLDiagnosticManagerforMySQL8.9PDF.pdf-其它文档类资源-CSDN文库

Mysql

monyog

需积分: 11 123 浏览量 2020-06-16 12:25:18 上传评论收藏 3.41MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源推荐

资源详情

资源评论

SQL DM for MySQL 8.9

SQL Diagnostic Manager for MySQL 8.9 
2
Table of Contents
Access the SQL Diagnostic Manager for MySQL Release Notes ..............................11
New Features and Fixed Issues ...................................................................................................... 11
8.9 New Features............................................................................................................................................................. 11
8.9 Fixed Issues................................................................................................................................................................ 11
Known Issues................................................................................................................................... 11
8.9 Known Issues............................................................................................................................................................. 12
Get started.................................................................................................................13
Get Started with SQL Diagnostic Manager for MySQL................................................................... 13
Introduction .................................................................................................................................... 13
Features........................................................................................................................................................................... 13
Security and Authentication........................................................................................................... 15
Architecture..................................................................................................................................... 15
SQL DM for MySQL uses state-of-the-art web technology ............................................................................................ 15
SQL DM for MySQL is configurable using the de-facto web scripting language: JavaScript....................................... 15
SQL DM connects to MySQL directly: no JAVA, no PHP, no 'agents' install required .................................................. 16
SQL DM for MySQL has a built-in high-performance database..................................................................................... 16
SQL DM for MySQL is compatible with all modern browsers........................................................................................ 16
SQL DM for MySQL Requirements .................................................................................................. 16
SQL Diagnostic Manager for MySQL hardware sizing guidelines ................................................................................. 17
Installation ...................................................................................................................................... 18
Downloading SQL Diagnostic Manager for MySQL........................................................................................................ 18
Installing SQL Diagnostic Manager for MySQL............................................................................................................... 19
Linux ................................................................................................................................................................................ 19
Windows .......................................................................................................................................................................... 29
Monyog AMI ..................................................................................................................................................................... 34
Configuration .................................................................................................................................. 35
MySQL Configuration...................................................................................................................................................... 36
Running SQL DM for MySQL as unprivileged user ......................................................................................................... 36
Server Registration ......................................................................................................................... 37
Adding Servers ................................................................................................................................................................ 37
Register your servers.................................................................................................40

SQL Diagnostic Manager for MySQL 8.9 
3
Connecting to SQL DM for MySQL .................................................................................................. 40
Managing multiple servers ............................................................................................................. 40
Registering replicas......................................................................................................................... 40
Connecting to MySQL Server.......................................................................................................... 41
Registering Servers ......................................................................................................................................................... 41
SSH tunneling.................................................................................................................................................................. 42
Using SSH connections................................................................................................................................................... 42
Using SSL Connection..................................................................................................................................................... 43
Tags.................................................................................................................................................. 45
Notifications Settings ..................................................................................................................... 46
Different Notification Channels...................................................................................................................................... 46
MONITORS (CRITICAL & WARNING) ................................................................................................................................ 47
OTHER.............................................................................................................................................................................. 47
Advanced Settings .......................................................................................................................... 48
System Metrics ................................................................................................................................................................ 49
Data Collection................................................................................................................................................................ 51
Replication Settings........................................................................................................................................................ 52
Galera............................................................................................................................................................................... 54
MySQL Error Log Settings ............................................................................................................................................... 55
MySQL Query Log ............................................................................................................................................................ 57
Audit Log Settings ........................................................................................................................................................... 59
Sniffer Settings................................................................................................................................................................ 61
Deadlock Settings ........................................................................................................................................................... 65
Monitors Settings ............................................................................................................................................................ 66
Real-Time Settings.......................................................................................................................................................... 67
Connection Settings........................................................................................................................................................ 68
MySQL Privileges............................................................................................................................. 70
MySQL Privileges............................................................................................................................................................. 70
System Privileges ............................................................................................................................ 71
RDS OS and File based Log Monitoring Privileges......................................................................... 72
Navigate SQL DM for MySQL.....................................................................................74
Overview.......................................................................................................................................... 74
Servers ............................................................................................................................................. 75

SQL Diagnostic Manager for MySQL 8.9 
4
Server Block..................................................................................................................................................................... 75
Server options ................................................................................................................................................................. 76
Events .............................................................................................................................................................................. 76
Disk Info........................................................................................................................................................................... 77
Dashboard ....................................................................................................................................... 80
Real time Charts for Monitoring All MySQL Servers....................................................................................................... 80
Default Dashboards ........................................................................................................................................................ 80
Customizing Dashboard ................................................................................................................................................. 84
Query Details ................................................................................................................................................................... 88
Adding New Charts.......................................................................................................................................................... 88
Exporting Graphs ............................................................................................................................................................ 89
Monitors........................................................................................................................................... 89
Layout_View of Monitors ................................................................................................................................................ 90
Mail and Graph icon ........................................................................................................................................................ 91
Critical and Warning Alerts ............................................................................................................................................. 93
Difference between All time_Current, Delta.................................................................................................................. 94
Difference between Cumulative and Point in time counters........................................................................................ 95
Innodb Deadlock Monitoring.......................................................................................................................................... 95
Getting automatic alert notifications ............................................................................................................................ 96
MySQL Error Log.............................................................................................................................................................. 97
History_Trend and Graph Analysis................................................................................................................................. 98
Custom SQL Objects (CSOs) ......................................................................................................................................... 102
New CSOs and CSCs...................................................................................................................................................... 104
Duplicate Monitors........................................................................................................................................................ 106
Managing your changes................................................................................................................................................ 107
Monyog object model ................................................................................................................................................... 110
Customizing Monitors................................................................................................................................................... 116
Adding or Editing Monitors........................................................................................................................................... 116
How to RDS_Aurora OS monitoring in SQL DM for MySQL.......................................................................................... 119
Threads.......................................................................................................................................... 124
Layout_View of Threads ............................................................................................................................................... 125
Actions on currently running queries........................................................................................................................... 126
Filtering.......................................................................................................................................................................... 126
Customize Threads ....................................................................................................................................................... 127
Threads Settings ........................................................................................................................................................... 128

SQL Diagnostic Manager for MySQL 8.9 
5
Real-Time ...................................................................................................................................... 129
Real-Time collection mode........................................................................................................................................... 129
Using Real-Time ............................................................................................................................................................ 130
Query Analyzer .............................................................................................................................. 134
Different Types of Logs Supported............................................................................................................................... 135
Sniffer ............................................................................................................................................................................ 139
Audit Log........................................................................................................................................ 143
Server Configuration..................................................................................................................... 143
Compare Configuration ................................................................................................................................................ 144
Track Configuration Changes....................................................................................................................................... 145
Replication .................................................................................................................................... 147
SQL DM for MySQL Database Schema....................................................................150
What is SQL DM for MySQL Data? ................................................................................................. 150
Where can you find this data? ...................................................................................................................................... 150
How to view existing schema and data?...................................................................................................................... 151
Preferences and Connection Settings.......................................................................................... 151
Preferences and global settings................................................................................................................................... 151
MySQL variables and System data ............................................................................................... 151
mysql.data and system.data ........................................................................................................................................ 151
udo.data ........................................................................................................................................................................ 154
events.data.................................................................................................................................................................... 155
Query Analyzer and Processlist data............................................................................................ 156
sniffer.data .................................................................................................................................................................... 156
Processlist ..................................................................................................................................................................... 156
Information about the SQL DM for MySQL database schema itself ........................................................................... 157
SQL DM for MySQL Data Maintenance ......................................................................................... 157
Real-Time data .............................................................................................................................. 157
inndob_locks:................................................................................................................................................................ 158
innodb_transactions:.................................................................................................................................................... 158
metric_master:.............................................................................................................................................................. 158
profiler_timestamps: .................................................................................................................................................... 158
query_master: ............................................................................................................................................................... 159
query_snapshot: ........................................................................................................................................................... 159