Alibabacloud.com offers a wide variety of articles about solaris 10 performance monitoring, easily find your solaris 10 performance monitoring information here online.
, because SQL Server needs to always maintain 5-10m free memory for allocation, and when this value is below 5m, SQL Server may have a performance bottleneck due to a lack of memory.
4.Physical Disk:% Disk Time
This counter records how busy the disk is (whether the entire disk array or physical disk is busy). Theoretically this value should be less than 55%, and if it continues above 55%, that means there may be an IO bottleneck on this server.
If
The original author of this article is a senior System Architect with more than 10 years of experience. He specializes in Java EE, middleware, and JVM technologies. He also has profound insights on performance optimization and improvement. Next he will share with you 10 common problems that affect Java EE performance.
Reprint: https://www.cnblogs.com/kevingrace/p/7300191.htmlGenerally speaking, as a Linux SA, it is necessary to master a specialized system monitoring tool, so as to be able to keep abreast of the utilization of system resources. The next Linux performance real-time monitoring tool,-netdata, is the real-time performance
Directory
One, get the total number of processes under MySQL user
Second, host performance status
Third, CPU utilization
Four, disk IO volume
Five, swap volume [memory]
VI, Database performance status
Seven, QueryLog
Viii. extended-status instructions for mysqladmin view MySQL status values
Nine, open source monitoring sof
, here is the HTML This is the direct default return, which is directly using the default HTML 6.Enter value for Num_days: Here's the hint is let us output a few days of the report, if write 1 on the output 1 days, if 2 just two days . 7.Enter value for Begin_snap: The snapshot IDof the entry and exit, which refers to theprinted snap ID, followed by Snap started start of Time Enter a snapshot of the start, output an end of the snapshot ID (the start ID bit 3739, end ID bit 3740, that is, fro
Nmon Monitoring Linux PerformanceOne, download Nmon compressed package,: http://download.csdn.net/download/fhqsse220/6699865Second, installation method:1, nmon_linux14i.tar.gz decompression and put into Linux, such as the root directory test under the Nmon folder;2, enter the Nmon folder to assign all the files executable permissions, such as: chmod 777 *;third, real-time monitoring methods:1. Enter the Nmo
rated value, a meeting is exchanged; the command to view the rating:#cat/proc/meminfoThe exchange will reduce the number of physical pages used in the system in three ways:1. Reduce the buffer and the size of the page cache,2. Swap out the memory page of the System V type3. Swap out or discard the page. (Application occupies a memory page, that is, insufficient physical memory).In fact, a small amount of swap use does not affect the performance of th
tools such as Sqlio.5. Always place the log file on the RAID10/RAID1.6. Isolate the log files and data files from the physical disk.7. Carefully consider the data configuration of tempdb.8. Balance the number of data files with the capacity of the CPU.9. Do not neglect the foundation of SQL Server.10. Do not neglect the storage configurationMonitoring of SQL Server consumption of I/O resources is primarily focused on disk response time, queue length,
Tools for monitoring---topFirst line:
10:01:23 Current system time
126 days, 14:29 the system has been running for 126 day, 14 hours, 29 minutes (not restarted during this period)
2 users currently have 2 user login systems
Load average:1.15, 1.42, 1.44
Load how does this thing understand, like a road, there are n lanes, if n process into the driveway, then just one person, one mor
Month (1-31) month# | | |.-------month (1-12) OR jan,feb,mar,apr ... Years# | | | |.----DAY of Week (0-6) weeks (sunday=0 or 7) or Sun,mon,tue,wed,thu,fri,sat# | | | | | Commands run by the user# * * * * * * user-name command to be executedExample: Run the echo command at 9:10 in the evening;* * *centos/bin/echo "howdy!"[[email protected] ~]# Vim/etc/crontab the form of e-mails per minute* * * * * * Makangbo echo "Hello"Practice1, every 4 hours to ba
informationuname-a System basic InformationW or who view user loginSAR System Report commandCommon Parameters- q: CPU load- u: CPU Utilization- R: Memory- b: IO- n: Networksar-q 1 5 View CPU load status, statistics 1 times per 1s, total 5 timesIt can be seen that the load is lower, 5 CPUs have 3 Runqsz of 0, indicating that the system is not highsar-u 2 3 See CPU usage, 1 times per 2s, total statistics 3 timesThe idle ratio of the CPU reaches 90%+, which also indicates that the system is idles
List Example:
8. Insufficient active monitoring
Lack of monitoring will not cause actual performance problems, but it will affect your understanding of the performance and health status of the Java EE platform. In the end, this environment can reach a break point, which may expose some defects and problems (JVM Memory
# 10: Leverage your peers ' expertiseDon't take a risk alone. If you're upset about a problem and are doing something logical and isolated for you, that's good. This may be valid 19 times in 20 times. But the remaining 1 times, you may fall into the rabbit hole, it will be very time-consuming and laborious, it is entirely because the effort you are making now just seems to be meaningful.Build a MySQL-related resource network that goes beyond tools an
size of this process that really consumes memory. The SHR identifies the memory and library sizes that can be shared with other processes. 8, the Performance monitoring SAR command sar-u output displays CPU information. The-u option is the default option for SAR. The output shows the CPU usage in percent NBSP;CPUNBSP;CPU number %user time spent running processes in user mode %nice the time it takes to run
Change the nice value of the process to -20# Renice pid N Bsp Change the nice value of the process to 19 second, performance monitoringThe uptime command is used to see how long the server has been running and how many users are logged in to quickly learn about the load on the server.The following is a running instance of uptime:11:07:03 up 2 days, Min, 3 users, load average:0.53, 0.31, 0.25Current Time 11:07:03The system ha
operations. When working with a thread pool, you can put some slow-response actions into a task group individually, without affecting other operations.
10. Real-time monitoring to quickly solve problems and bottlenecks
The implementation of real-time monitoring, you can fully understand the operation of the system, find problems to solve problems, or even to ide
, it must be immune and provide powerful blocking measures to protect network users, all defense measures should be implemented based on hardware. However, all security measures are based on known attack methods and security vulnerabilities. If we cannot monitor the entire network, security will not be a complete feature ., Taking into account the high-speed forwarding of 10-ge switches and routes, the previous method of collecting traffic by CPU will
, because InnoDB runs faster and more stably than the previous MyISAM, and it is easier and quicker to manage performance and backup work. In the master configuration file, InnoDB should be set as the default database engine, and the system should check from time to times to see if the MyISAM table was accidentally created.6. Always have a good DB configuration and backupMany companies do not have a good backup mechanism and do not know how to do 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.