'. By default, Innotop hides inactive processes and its own processes. You can toggle and close these with ' I ' and ' a ' keys.R InnoDB Row Ops:The full name is InnoDB row Operations and semaphores (InnoDB line operation and semaphore).This mode shows InnoDB line operation, row operation Miscellaneous, signal, InnoDB wait informationS Variables Status:This mode calculates, for example, the statistics of queries per second. You can display the absolute value between, or increment values.' s '
This is my second tool used to monitor MySQL database performance: Spotlight on MySQL
Our server database is on Windows2003.
This tool is very fancy and has a very beautiful interface and comes with an alarm.
1. Create a connection
2. Monitoring Interface
3. View MySQL startup error logs
4. Parameter graphical interface
5. View Operating Sy
1. Installation Steps
The first step is to install wine.
Go directly to Ubuntu Software Center to search wine, click Install;
Step Two: Install common components.
By entering "Winetricks" in the terminal, you can choose to install windowsdlls and other common components that may be needed, such as: RICHED20,RICHED30,IE8,FLASH11,GDIPLUS,MSLS31,MSXML6, vcrun2005,vcrun2008, etc.;
Step three: Install Commitmonitor. (Installation package: commitmonitor-1.8.7.831.m
INNOTOP is a monitoring tool that displays MySQL and InnoDB in text mode. INNOTOP is written in PERL, which enables it to be used more flexibly on various operating platforms. it can monitor the running status of MYSQL and INNODB in detail, based on the results of DBA, you can: 1. innotop installation
Reference Official website: http://innotop.googlecode.com/svn/html/installing.html
# wget http://innotop.
timestamps This example samples are sampled 3 times per 250ms sample. The-t option is used to display the timestamp in the first column.jstat-gcoldcapacity-t218912503timestampogcmnogcmxogc ocygcfgcfgctgct150.11408.060544.011696.011696.0194 802.8743.799150.41408.060544.013820.013820.019481 2.9383.863150.71408.060544.013820.013820.0194812.938 The 3.863Timestamp column shows the elapsed time, in seconds, since the target JVM was started. In addition, the,-gcoldcapacity option output shows that th
MySQL Monitoring management tool--innotop1.innotop InstallationReference official website: http://innotop.googlecode.com/svn/html/installing.html# wget http://innotop.googlecode.com/files/innotop-1.9.0.tar.gz# TAR-ZXVF Innotop-1.9.0.tar.gz# CD innotop-1.9.0Installing the Innotop tool is very simple, it is written by Perl, and of course requires the Perl environme
boring than queuing).I/O systems also have many similarities with supermarket queues:r/s+w/s similar to the total number of people who have beenAverage Queue Length (AVGQU-SZ) is similar to the number of average queueing people in a unit timeAverage service time (SVCTM) is similar to the cashier's payment speedAverage wait time (await) is similar to the average wait time per personAverage I/O data (AVGRQ-SZ) is similar to the average number of things each person buysThe I/O operation rate (%uti
surround these arguments with a single quotation marks and then with a double quotation marks (or with Double quotation marks and then with a single quotation marks).
OptionsOptions are mutually exclusive.
-F
filename
Reads commands from the specified file. This option can is used only if you specify the process identifier or the main class as the first argument. Each command in the file must is written on a. Lines starting with a number sign ( # ) is ignor
queue length the better.Await the average wait time for each request, this time includes the queue time and service time, that is, in general, await is greater than SVCTM, their difference is smaller, then the shorter the queue time, conversely, the greater the difference, the longer the queue time indicates that the system has a problem.SVCTM The service time (ms) of each device IO operation, the closer to the await note the less waiting time.utilization of util equipment. All processing IO ti
Unix-like OS process monitoring and control tool Supervisor
Supervisor is a client server system that allows users to monitor and control the number of processes on Unix operating systems.
Official http://supervisord.org
Install1. easy_install supervisor2.Setuptools (latest) from http://pypi.python.org/pypi/setuptools.Meld3 (latest) from http://www.plope.com/software/meld3.Elementtree (latest) from http://e
Nload: the easy-to-use linux network bandwidth usage monitoring tool nload can display network bandwidth usage, reflecting inbound and outbound network traffic, and is easy to use. Install www.2cto.com: Common parameter of yum install nload:-t, in milliseconds. The default value is 500 milliseconds. '-M shows the bandwidth usage of multiple devices at the same time. -U traffic unit. H | H: automatic adjustm
Centos compilation and installation of the latest iftop port traffic monitoring tool
Iftop can monitor the real-time traffic on the server port. Therefore, you can install iftop on the server by compiling and installing it.
The installation procedure is as follows:
1. Download the source code package iftop-1.0pre4.tar.gz:
# Wgethttp: // www.ex-parrot.com /~ Pdw/iftop/download/iftop-1.0pre4.tar.gz
2. Go to
MySQL monitoring tool-orzdba
Source code: http://code.taobao.org/p/orzdba/src/trunk/[Root @ bkjia servers] # chmod + x orzdbaConfigure your MySQL verification information in line 1 of the Code: username, password, socket, host, port[Root @ bkjia servers] # grep-n 'my $ mysql' orzdba160: my $ MYSQL = qq {mysql-s -- skip-column-names-uroot-pyoon-h127.0.0.1-P $ port };Install tcprstat first[Root @ bkjia server
Document directory
Installation Method 2: (lazy method, simplest)
1. Description of iftop Interface
2. iftop Parameters
Common Parameters
Some operation commands after entering the iftop screen (case sensitive)
In Unix-like systems, you can use top to view system resources, processes, memory usage, and other information. To view the network status, you can use tools such as netstat and NMAP. To view real-time network traffic and monitor TCP/IP connections, you can use iftop.I. What is i
1. http://download.chinaunix.net/download.php?id=32248ResourceID=10197
Tar zxvf tcptrack-1.4.2.tar.gz
CD tcptrack-1.4.2
./configure;
#报错如下
Configure:error:Connot Find Pcap Library
#解决方法
Yum install-y libpcap-devel libpcap
Make make Install
2. Get help information using Tcptrack-hUsage:tcptrack [-DFHVP] [-R 3.Tcptrack runtime can only monitor the parameters of one network card at a time (if you have eth0eth1 on the host)
# tcptrack-i Eth0
6
Mtop bitsCN.com, a tool for real-time MySQL monitoring in Linux
Required modules:
Curses
DBI Distributed as Bundle: DBI:
DBD: mysql
Getopt: Long (Distributed with Perl 5)
Net: Domain Part of libnet:
# Perl-e use Curses
# Perl-e use DBI
# Perl-e use DBD: mysql
# Perl-e use Getopt: Long
# Perl-e use Net: Domain
If there is no output, the module is installed. if there is an error, the corresponding module
The uptime can show the top line of the upper screen![Email protected] ~]# uptime18:06:30 up, 6:40, 1 user, Load average:0.00, 0.00, 0.00Said above, is currently 18:06, the system has been turned on 52 days and 6:40, there are 1 users in the online, the average load is very low, so are 0 ah!What is the system load?The average system load is defined as the average process tree running in the queue for a specific time interval. If a process meets the following criteria, it will be in the run queue
context switching, resulting in less time for the CPU to do serious work, and the CPU not being fully utilized, is undesirable.5) Information about the CPU is: (CPU)US: CPU utilization in the user state during the specified time interval.SY: CPU utilization in the kernel mentality at the specified time interval.ID: The CPU idle time ratio during the specified time interval.WA: The CPU is idle for I/O during the specified time interval.Vmstat can be used to determine whether the work of a system
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.