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
using Memcache in PHP1. Test codeThis is memcache official test memcache code2. Under Windows detection Memcache: http://download.csdn.net/detail/wujiangwei567/8571637Tool description Detailed Address: http://www.cnblogs.com/xffy1028/archive/2013/02/01/2861706.htmlThe use of memcache in PHP and the Memcache monitoring tool in Windows
. Number of Lookup requests 20 IP (commonly used to find the source of attack) Netstat-anlp|grep 80|grep Tcp|awk ' {print $} ' |awk-f: ' {print '} ' |sort|uniq-c|sort-nr|head-n203. Use tcpdump to sniff 80 ports with the highest number of IPTcpdump-i ETH0-TNN DST Port 80-c 1000 | Awk-f "." ' {print $1″. ' $2″. " $3″. " $4} ' | Sort | uniq-c | Sort-nr |head-104. Find more time_wait connectionsNetstat-n|grep Time_wait|awk ' {print $} ' |sort|uniq-c|sort-rn|head-n105. Check for more SYN connections
main cache mode: Buffer Cache and Page cache. The former is for the disk block read and write, the latter for the file inode read and write. These caches can effectively shorten the time for I/O system calls (such as read,write,getdents). Remember that the memory is for use, not to take a look. Unlike windows, no matter how much of your real physical memory, he will have to take the hard disk swap files to read. This is why Windows often prompts for a lack of virtual space. You think, how borin
displayed, and each item can be consulted. Need to observe the value of the ID (idle), generally speaking, he should be close to 100%, indicating that the system is rarely used resourcesLines Fourth and fifth: represents the current use of physical memory and virtual memory (MEM/SWAP).after line sixth: This is where the state is displayed when the command is entered in the top program. The picture below the top is the resource situation used by each process.By default, only the more important P
First, the official: http://dag.wieers.com/home-made/dstat/#downloadOr to the 51CTO download, install the time to note that the Linux system is 5 or 6, with different packages.Second, the installation is very simple, only need a RPM command to complete.Third, the use of methods #dstat--helpIv. Common Command # Dstat-cdlmnpsy--output xin.csvNote:-cdlmnpsy parameter--output output FileFile name of the output CSV format650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/87/B7/wKioL1ffxyjQNut
the core Httpry program was a set of parsing scripts for mining information out of generated log files. Most of these scripts is written as plugins for a core parsing script and include functionality for extracting search ter MS, searching for specified terms within client flows, and outputting the logs in XML among other things. It is relatively straightforward to write custom plugins for additional parsing tasks.Latest NewsThe latest release adds a number of useful features and tweaks. VLAN t
Sysstat monitors CPU usage, hard disk, and network throughput data. The collection and analysis of these data helps us determine whether the system is running normally, it is an effective assistant to improve system operation efficiency and secure operation of servers.
Sysstat writes the plan log in/etc/cron. d/sysstat. The log is recorded every 10 minutes, and the log process of the day is summarized and cut.
The SAR command displays the CPU running status by default.
SAR Command Options
-B
The simplest and most direct method is to add
-VVParameters to print the request and corresponding information of each client on the console, which is very suitable for development. Another direct method is to use Telnet. For example, if the server is a port 11211 of the local machine, you can use
Telnet local host 11211
And then use
StatsTo view the server status.
In addition, a better choice is to use some specialized monitoring tools. Some e
Monitor weblogic server, Very simple to use, weblogic monitoring, inspection, fault simple tool, monitorweblogic1. I developed a simple small program to monitor weblogic running conditions. You can download it and try it. You don't have to log on to the console to know the running status of the server, including jvm, thread, jdbc, status jms, etc. For a simpler option, select "warning" from the drop-down li
Iptraf: A Practical TCP/UDP Network Monitoring Tool
Iptraf is an ncurses-Based ip lan monitor that generates statistics including TCP information, UDP count, ICMP and OSPF information, Ethernet load information, node status information, IP checksum and error, and so on.
The ncurses-based user interface saves you from the tedious command line switch.
Features
IP traffic monitor is used to display IP traffi
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.