In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-16 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
one。 Main system monitoring tools
The main system monitoring tools are SMI, onstat, oncheck.
two。 System Monitoring Interface (SMI)
2.1. The function of the system monitoring interface: the system monitoring interface provides a read-only access to the online system information.
Provides a standard sql interface
Provides performance statistics snapshots and system status information.
Allows online system administrators to easily manage automatically.
2.2.sysmaster database
The sysmaster database is created automatically when the online system is initialized.
The database contains data dictionary information that points to the shared memory structure.
Some tables in the sysmaster database (for on-archive) are real tables.
2.3. In fact, using SMI is the process of querying the information of the provided table.
Sysdatabases: lists all databases, owners, and related information.
Systabnames: the table contains the names of all tables on the online system.
Syslogs: lists the information of the logical log.
Sysdbspaces: lists the definition information about dbspace.
Syschunks: lists information about all chunk of the online system.
Syslocks: lists information about active locks.
Sysvpprof: lists information about the active VP.
Syssessions: lists the information for each session.
Syssesprof: lists the details of a specific session.
Sysextents: lists statistics for extent in the online system.
Sysptprof: lists information about the tblspace that is in use at some point.
Sysprofile: lists the statistics of some events in the online system.
III. Onstat tool
The function of 3.1.onstat
Lists the information in the online shared memory when the command is executed.
Do not do any Icano operation.
It is not locked, so there is no impact on online performance.
3.2.onstat command options
Onstat-I interoperability option
Onstat-g Multi-thread option
Onstat-list all options
Common options for 3.3.onstat
Onstat-b buffer; onstat-d dbspace and chunks information; onstat-l log; onstat-m message log; onstat-p profile information
Onstat-g ses displays session information; onstat-g sql displays sql information; onstat-g seg displays memory segment information; onstat-g mem shows memory usage
III. Oncheck tool
The function of 3.1.oncheck
Check and repair the data page corruption of the index.
Check the data structure on the disk.
Report on various data structures.
Some oncheck option commands lock the tables being processed, which will prevent other users from modifying those tables.
Some common commands of 3.2.oncheck
Oncheck-c check
Oncheck-p display
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.