如何运用RDA巡检MYSQL数据库
发布时间：2022-01-16 09:48:49 所属栏目：MySql教程 来源：互联网
导读：本篇内容主要讲解如何使用RDA巡检MYSQL数据库，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习如何使用RDA巡检MYSQL数据库吧! 实验环境： Server version: 5.6.37 命令 RDA模块配置 ./rda.sh -S MYSQ 生成巡检结
|
本篇内容主要讲解“如何使用RDA巡检MYSQL数据库”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“如何使用RDA巡检MYSQL数据库”吧! 实验环境： Server version: 5.6.37 命令 RDA模块配置 ./rda.sh -S MYSQ 生成巡检结果 ./rda.sh -v MYSQ 实验过程 [mysql@jing1 rda]$ ./rda.sh -S MYSQ perl: warning: Setting locale failed. perl: warning: Please check that your locale settings: LANGUAGE = (unset), LC_ALL = (unset), LANG = "zh_CN.CB18030" are supported and installed on your system. perl: warning: Falling back to the standard locale ("C"). Enter the network domain name for this server > jing1 ------------------------------------------------------------------------------ RDA.BEGIN: Initializes the Data Collection ------------------------------------------------------------------------------ Enter the Oracle home to be used for data analysis > /usr/local/mysql ------------------------------------------------------------------------------ RDA.CONFIG: Collects Key Configuration Information ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ DB.MYSQ: Collects Oracle MySQL Server Information ------------------------------------------------------------------------------ Do you want RDA to collect Oracle MySQL Server information (Y/N)? Press Return to accept the default (Y) > Enter the full path of the Oracle MySQL Server configuration file Press Return to accept the default (/etc/my.cnf) > /data/mysqldata/3306/my.cnf Enter the user name for the Oracle MySQL Server connection > system ------------------------------------------------------------------------------ RDA.OCM: Set up the Configuration Manager Interface ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ RDA.STATUS: Produces the Remote Data Collection Reports ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ RDA.LOAD: Produces the External Collection Reports ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ RDA.FILTER: Controls Report Content Filtering ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ RDA.END: Finalizes the Data Collection ------------------------------------------------------------------------------ [mysql@jing1 rda]$ [mysql@jing1 rda]$ [mysql@jing1 rda]$ ./rda.sh -v MYSQ perl: warning: Setting locale failed. perl: warning: Please check that your locale settings: LANGUAGE = (unset), LC_ALL = (unset), LANG = "zh_CN.CB18030" are supported and installed on your system. perl: warning: Falling back to the standard locale ("C"). Collecting diagnostic data ... ------------------------------------------------------------------------------ RDA Data Collection Started 04-Dec-2017 10:26:01 ------------------------------------------------------------------------------ Processing RDA.BEGIN module ... Inside BEGIN module, testing the RDA engine code build Inside BEGIN module, testing the report directory Inside BEGIN module, testing the module targets Inside BEGIN module, launching parallel executions Processing RDA.CONFIG module ... Inside CONFIG module, listing Oracle homes Inside CONFIG module, getting Oracle home inventory (can take time) Processing DB.MYSQ module ... Inside MYSQ module, gathering database information (can take time) Enter password: Inside MYSQ module, collecting the configuration files Inside cat_report, looking for my.cnf in /data/mysqldata/3306 Inside MYSQ module, listing the files in /data/mysqldata/3306/data directory Inside MYSQ module, collecting the log files Processing RDA.LOAD module ... Inside LOAD module, running CRS diagnostic collection tool Inside LOAD module, gathering system comparison reports Inside LOAD module, gathering EPM validation reports Inside LOAD module, gathering HCVE reports Inside LOAD module, gathering JRockit tool reports Inside LOAD module, gathering jvm tool reports Inside LOAD module, gathering Trace Merge reports Inside LOAD module, gathering Network Advisor reports Inside LOAD module, gathering Oracle Configuration Manager information Inside LOAD module, gathering ORA600 reports Inside LOAD module, gathering ORADDC reports Inside LOAD module, gathering OSWatcher information Inside LOAD module, gathering database performance reports Inside LOAD module, gathering the most recent redo tool results Inside LOAD module, gathering the most recent TLsecure report Inside LOAD module, gathering Siebel crash reports Inside LOAD module, gathering siga/sosreport/sysreport reports Processing RDA.END module ... Inside END module, gathering system information Inside END module, getting CPU information (linux) Inside END module, getting memory information (linux) Inside END module, producing the file catalog Inside END module, producing target overview Inside END module, waiting for parallel execution completion Inside END module, producing setting overview ------------------------------------------------------------------------------ RDA Data Collection Ended 04-Dec-2017 10:29:57 ------------------------------------------------------------------------------ Generating the reports ... - collect/DB_MYSQ_datadir_overview.txt ... - collect/RDA_END_report.txt ... - collect/DB_MYSQ_db_info.txt ... - collect/RDA_END_system.txt ... - collect/RDA_END_target.txt ... - collect/RDA_END_files.txt ... - collect/DB_MYSQ_cfg_my_cnf.txt ... - collect/DB_MYSQ_log_files.txt ... - Report index ... Packaging collection results ... You can review the reports by transferring the /data/mysqldata/scripts/rda/output directory structure to a location where you have web-browser access. Then, point your browser at this file to display the reports: RDA__start.htm If this file was generated to assist in resolving a Service Request, send /data/mysqldata/scripts/rda/RDA_output_jing1.zip to Oracle Support by uploading the file via My Oracle Support. When sending with FTP, make sure you send it in BINARY format. （编辑：晋中站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
