Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to use RDA to inspect MYSQL database". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to use RDA to inspect MYSQL database.

Experimental environment:

Server version: 5.6.37

Command

RDA module configuration

. / rda.sh-S MYSQ

Generate inspection results

. / rda.sh-v MYSQ

Experimental process

[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 big 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

Based on your server configuration, some possible alternative approaches

Are:

-If your client computer with a browser has access to a web-shared

Directory, copy the / data/mysqldata/scripts/rda/output directory structure

To the web-shared directory and visit this URL:

Http://machine:port/web_shared_directory/RDA__start.htm

Or

-If your client computer with a browser has FTP access to the server

Computer with the / data/mysqldata/scripts/rda/output directory, visit this

URL:

Ftp://root@jing1.jing1//data/mysqldata/scripts/rda/output

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.

Note: Do not submit any health, payment card or other sensitive production

Data that requires protections greater than those specified in the Oracle

GCS Security Practices

(http://www.oracle.com/us/support/library/customer-support-security-practices-069170.pdf).

Information on how to remove data from your submission is available at

Https://support.oracle.com/rs?type=doc&id=1227943.1

RDA-00033: Warning-2 command (s) not executed in RDA.CONFIG, RDA.END module (s)

After the operation is completed, the following check results are generated

After downloading and decompressing, you can view it:

At this point, I believe you have a deeper understanding of "how to use RDA to inspect MYSQL database". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.