没有合适的资源?快使用搜索试试~ 我知道了~
用于MySQL的SQL Diagnostic Manager是用于MySQL数据库管理的监视程序和顾问程序。它为您提供工具来管理更多的数据库服务器,调整当前的数据库基础结构,并帮助您在数据库应用程序发展成更严重的问题或代价高昂的停机之前查找和修复问题。 借助适用于MySQL的SQL Diagnostic Manager,您可以主动监视企业数据库环境并获得专家建议,以便即使MySQL的新手也可以加强安全性,优化性能并减少其MySQL系统的停机时间。
资源推荐
资源详情
资源评论





















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
剩余230页未读,继续阅读
资源评论

CIAS
- 粉丝: 636
- 资源: 278

上传资源 快速赚钱
我的内容管理 收起
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助

会员权益专享
安全验证
文档复制为VIP权益,开通VIP直接复制
