Tags: style color io os using strong file Data SPMost of the time, talk to friends around the two questions, what is the daily work of the DBA? What is the most important database aspect?I believe the answers to these two questions will not be exactly the same, I am also, so here only represents my personal views, and the following content will be around my ideas, I hope to have more or less help.What are the daily tasks of Q1:DBA?A:
Installa
Freescale Network patrol database monitoring software, deep database software monitoringAs the most important part of the information system, the database plays a key role in the operation of the business system. The system primarily uses analog accessTo monitor the performance parameters of the mainstream
Label:Recent life has a big change, so the blog has been shelved for a long time did not write, as if blogging has become a habit, put aside a period of time there is so little sense of crisis, the heart always feel uncomfortable. So from today on or continue to pick up the pen (keyboard), continue to maintain the blog, write the most real ideas in mind, write some of the people and things in contact with some of the new technology. Of course, blogging is not purely for the record, but also want
/local/zabbix/alertscripts/check_3306_port_num.shNote: the "3306connectNum" Here is Item key, which cannot be duplicated with the existing one, and needs to be used laterRestart Zabbix_agentd#systemctl Restart Zabbix-agentZabbix server-side test to get data#zabbix_get-S 192.168.80.30-k 3306connectNumThe output is as follows:48VNote: The above 192.168.80.30 refers to the client's ip,3306connectnum is the key we want to test, the return of 587 is 3306 database
: Change Unsafeuserparameters=1
add userparameter=3306connectnum,/usr/local/zabbix/alertscripts/check_3306 _port_num.sh Note: the "3306connectNum" Here is Item key, which cannot be duplicated with the existing one, and needs to be used laterRestart Zabbix_agentd#systemctl Restart Zabbix-agent Zabbix server-side test to get data #zabbix_get-S 192.168.80.30-k 3306connectNumThe output is as follows:48VNote: The above 192.168.80.30 refers to the client's ip,3306connectnum is the key we want to tes
SQL detail list below, click on the return of IE to go back to the current SQL ID.SQL Module: Shows how the SQL is connected to the database for execution, and if it is linked with sql*plus or PL/SQL, it is basically someone debugging the program. SQL that is typically executed with the foreground app link is empty.SQL Text: Simple SQL hint, detailed need to click on SQL ID.4.2 SQL ordered by CPU timeThe top SQL that executes the longest total CPU t
Label:Oracle static monitoring and dynamic monitoring A, what is registration? Registering is registering the database as a service to the listener. The client does not need to know the database name and the instance name, but only needs to know the service name provided by the dat
This article first summarizes the database monitoring system construction Those things, the next article describes the detailed deployment process1. Backgroundas the core IT business modules, the importance of the database is beyond doubt, the stable operation of the database is directly related to the availability, st
What Q:qmonitor is.
A:qmonitor is a professional database monitoring platform software for Oracle and MySQL. According to the user set up timely and effectively to the database of the abnormal alarm to facilitate users to see a variety of real-time state curve indicators, and monitoring, performance data statistical an
Tags: ZabbixZabbix monitoring MySQL master-slave database in the footsteps of the user name and password will appear the following error " warning:using A password on theCommandLine interface can insecure",The error is due to the MySQL 5.6 version of the password security policy, the previous version can be used in the command line with the password will be forced to error, so when using Zabbix
Tags: data acquisition server monitoring System database LepusLepus is a database enterprise-level monitoring system developed by python+php, which is an enterprise system which is reconstructed and re-developed after Mysqlmtop open source monitoring System (www.mtop.cc).
databases.
After the management database is deployed in the early stage of the system, during the continuous operation of the system, you must always pay attention to the potential impact and possible risks of the system itself and the environment on the operation, and promptly handle the risks.
We usually divide database O M management into two types: reactive and forward-looking.
Reactive
Atitit. software dashboard (4) -- db database subsystem-number of monitoring connections: deadlock table list: deadlock basic list (recent records, time, SQL, etc.) 3. monitor the server and obtain the CPU and I/O usage. monitors the database and obtains the remaining disk space, data space, and log space usage of the databas
Label:The above chapter "Zabbix implementation of MySQL database monitoring (ii)" Using MPM to monitor MySQL, but encountered installation problems always can not solve, here instead of Percona-monitoring-plugins to monitor the MySQL database zabbxi. For more information on Percona-
configuration file Key,zabbix to find the output value of the script monitoring through key.
Creates a new trigger that indicates that a specific action is triggered based on the monitoring item output value, a new trigger needs to be associated with a monitoring item, and an expression selects a monitoring item t
Atitit. Software dashboard (4) -- db database subsystem-monitoring, atitit -- db
Atitit. Software dashboard (4) -- db database subsystem-Monitoring
Connections :::
Deadlock table list: Basic deadlock list (recent records, time, SQL, etc)
3. Monitor servers and obtain CUP and I/O usage information4. Monitor the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.