[1]}"=="Yes"-A"${status[2]}"=="0" ] - Then +Echo"MySQL slave is ok" - Else + for((n=0; n)) A Do at if["${status[3]}"=="${error_numb[n]}"];then - ${skip} - Else -$cmd"stop Slave;start slave;" - fi - Done inEcho"MySQL Salve is not ok" -Echo"${ip} mysql is not ok"|mail-s"MySQL slave error at ' date +%f%t '"$QQ to fi +Sleep3 -Done The test results are as follows[Email protected] scripts]# sh check_mysql_slave.shMySQL Salve is not okMySQL
Tags: info include distributed apps a little view Collection graphical interface operation NBSP;NBSP;NBSP;OTANBSP;NBSP;NBSP; One of the primary responsibilities of the database administrator is to continuously monitor SQL Server performance. There are several reasons for monitoring, including performance, storage status, security, and standard compliance. Although many of these types of
Label:Text: Third--Part II--sixth Article monitoring SQL Server mirroringOriginal source: http://blog.csdn.net/dba_huangzj/article/details/26846203To optimize, first to monitor to see if there is a performance problem, if so, where. In order to start the real optimization, so this article with monitoring as the portal, in the previous article has provided some
Background
Now more and more enterprises, the company requirements for the database to achieve 7*24-hour database monitoring, the general use of the third party platform to achieve the message and mobile phone SMS monitoring reminders. A few days ago the company a new server, eager to deploy the program has not had time to build other related platforms, in order
1. Install Message Queuing for monitoring
2. Install SQL Server Reporting Services
3. Add the monitor server to the topology
4. Install the monitor server
5. Deploying a Monitoring Server Report
6. Configure
If you want to know what your server is doing, you need to know some basic commands, and once you've mastered these commands, you're a professional Linux system administrator.Some Linux distributions provide GUI programs to monitor the system, for example, SUSE Linux has a great and professional tool Yast,kde KDE system Guard is also excellent. Of course, to use these tools, you have to operate in front of the ser
If you want to know what your server is doing, you need to know some basic commands, and once you've mastered the commands, you're a professional Linux system administrator.
Some Linux distributions provide GUI programs for system monitoring, such as SUSE Linux has a great and professional tool yast,kde the KDE System Guard is also excellent. Of course, to use these tools, you have to operate in front of t
:27:17Collectl.COLLECTL reports the statistics of the system in a similar dstat format; like Dstat, it collects statistical information about different resources of the system, such as processors, memory, and networks. A simple example given here shows how to use COLLECTL to report network usage/bandwidth.$ collectl-sn-ot-i0.5 Waiting for 0.5 second sample ... # Installing Collectl# Ubuntu/debian User $ sudo apt-get install collectl #Fedora $ sudo yum install CollectlConclusionThese easy-to-use
One of the primary goals of managing certificates is to improve the security level of the enterprise, where authentication and access management should be valued. In this article, we'll start with a brief overview of the CA definition, and then focus on the application of Windows Server 2008 with professional certificate monitoring tools (Pkiview.msc and Certutil.exe). For an enterprise, it is very importan
The Munin monitoring tool detects all computers and records the computers that you see. Displays all information in a graphical web interface. The focus is on plug-and-play functionality. After the installation is complete, a large number of control plug-ins will be hit.With Munin you can easily monitor your computer, network, SAN, and applications, whatever you think of. Munin used a good? RRDTool (written by Tobi Oetiker) and a framework written in
One, monitoring server system load situation:1, use the uptime command to view the current load situation (1 minutes, 5 minutes, 15 minutes average load situation)# uptime15:43:59 up 186 days, 20:04, 1 user, load average:0.01, 0.02, 0.00Rule of thumb for system load: (detail reference: http://blog.csdn.net/skyline_loafer/article/details/26940539)(1) The main observation "15 minutes system load", it as the n
ID WA st2 0 0 57484 356864 861332 0 0 0 1 7 3 1 0 99 0 00 0 0 57468 356864 861360 0 0 0 0 336 145 6 1 94 0 00 0 0 57468 356864 861360 0 0 0 0 43 51 0 0 100 0 00 0 0 57468 356864 861360 0 0 0 16 51 62 0 0 100 0 0[16-wireshark]Wireshark's predecessor is called Ethereal, we can think Wireshark is the tcpdump command of the master brother, because Wireshark will be more professional, but also have more advanced protocol analysis and statistical capabilities.Wireshark also has GUI interfaces and she
buff cache si so bi bo in CS us sy ID WA St
2 0 0 57484 356864 861332 0 0 0 1 7 3 1 0 99 0 0
0 0 0 57468 356864 861360 0 0 0 0 336 145 6 1 94 0 0
0 0 0 57468 356864 861360 0 0 0 0 43 51 0 0 100 0 0
0 0 0 57468 356864 861360 0 0 0 16 51 62 0 0 100 0 0
[16-wireshark]Wireshark's predecessor is called Ethereal, we can think Wireshark is the tcpdump command of the master brother, because Wireshark will be more professional, but also have more advanced protocol analysis and stati
The above article mentioned win Performance Monitor is a necessary tool for monitoring database performance, Next I will give you some common monitoring indicators, in fact, is nothing more than disk, CPU, memory and other hardware operating indicators as well as the database itself, such as lock Ah, the number of user connections Ah, There is the need to pay attention to the parameters of their own busines
Tags: SQL Server mirroringThis article describes how a oldest unsent Transaction threshold alarm in SQL Server mirroring monitoring can heal itselfimage monitoring data and alarms are recorded and triggered by the database Mirroring Monitor job job, and when oldest unsent transaction exceeds threshold, the trigger code
Server monitoring by installing some commonly used monitoring software, sometimes you need to run some shell or Python scripts, and the shell can use the system's own PS/FREE/TOP/DF and other shell commands, Python can invoke modules such as subprocess to run shell commands, but it is cumbersome to do so. Here is a more useful third-party module: Psutil.Psutil is
monitoring point of the shortcut keys, as long as the corresponding letter input, you can display the corresponding resource consumption, input C, M, d after the display of the following (showing the CPU, memory, disk usage):Output fileAs described above only in server monitoring, what we really need is how to collect this data and handle the analysis of them. N
A few days ago wrote an article, jprofiler_ monitoring the remote Linux server tomcat process (practice), the use of jprofiler how to monitor the remote Linux tomcat process, these two days to think, in addition to monitoring the Tomcat process, Is it possible to monitor other Java processes, but to find a lap is to monitor Tomcat, so I intend to experiment with
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.