As described in "How to Improve the Performance of vmware5", by setting the virtual memory file to shut down VMWare, VMWare can truly run in physical memory. I installed the client Windows XP in VMware, by setting off the virtual memory of Windows XP, all programs can run in the physical memory, which greatly improves
When this problem encountered, I did not look at the alarm log, always thought that the database lock blocking affects performance. Know that the archive log is full when the view log is found. To cause this problem to occur:Errors in File/dbbk/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc0_28918.trc:ora-19809:limit exceeded for recoveryFilesora-19804:cannot Reclaim 34764800 bytes disk space from 4070572032 li
very important point: when unsure which type of join to use, let the MySQL optimizer automatically judge, we only need to write select * from t1,t2 where T1.field = T2.fieldThe 10.7 using where WHERE clause is used to restrict which row matches the next table or send to the customer. Unless you specifically request or check all rows from a table, the query may have some errors if the extra value is not a using where and the table join type is all or index. (This explanation is not very understa
Reference DocumentsVMware extended disk space under Ubuntu
Tips:
The application scope of this document is Vmware+ubuntu development environment
In embedded development, it is common to use the Ubuntu virtual machine installed in VMware for software development, in order to improve the disk
need to change the track, or the change time is very short; for random I/O, if this I/O is too large, the head will not stop changing, resulting in a great reduction in efficiency.
4. Sequential/concurrent I/O
In terms of concept, concurrent I/O refers to sending an I/O command to a disk without waiting for it to respond, and then sending an I/O command to another disk. For a striped RAID (Lun), I/O operat
certainly better than the IDE virtual disk performance,2, upgrading to a higher speed disk speed can greatly improve the performance of virtual machines.3. timed defragmentation and compression of existing virtual disksVMware Disabling the optical drive? USB useRecommended removal Check automatic connection USB w
of monitoring the entire disk.
Where,AVG. Disk SEC/readAndAVG. Disk SEC/WriteIt is two counters that mainly consider disk I/O performance. They do not need additional information for reference and can directly determine the average latency of I/O requests. AVG.
once, and no useful data is obtained.
(2) CSCript Diskmonitor.vbs 2Obtain disk performance data every 2 seconds and output until you press CTRL + C to terminate the program.
(3) CSCript diskmonitor.vbs 2 100Obtain disk performance data every 2 seconds and output, 100 times, and then exit.
The information that the s
In previous posts on vm.swappiness and using RAM disks we talked about how the memory on a Linux guest are used for the OS itself (the kernel, buffers, etc), applications, and also for file cache. File caching is an important performance improvement, and read caching are a clear win in most cases, balanced against APPL Ications using the RAM directly. Write caching is trickier. The Linux kernel stages disk
exceeding processing capacityPending I/O requests, the value increases when the request continues to exceed the disk processing power.Avgqu-sz > 2 can be considered an I/O performance issue.7) Wait time (await)-time to complete the requestThe time to wait for execution, the size of the await typically depends on the service time (SVCTM) and the length of the I/O queue and the emit mode of the I/O request.A
0.00 56.44 0.00 66.34 0.00 491.09 14.81 0.04 0.54 0.19 1.29According to the above formula: 436.00/57.00 = 7.65 kb per io,491.09/66.34 = 7.40 kb per IO. Compared with sequential Io, the KB per IO of the random Io is small enough to be negligible, and it is visible that the number of IOPS per second is important for random IO, rather than the throughput capacity (KB per io) of each IO.SWAPSwap devices are used when the system does not have enough physical memory to
Using the tmpfs File System to quickly optimize ganglia disk I/O performance by 20151203
Recently encountered a problem,
Problem: ganglia monitors host system slow response and normal command line operations are stuck, especially when opening and editing files.
Problem Analysis: Through the ganglia monitoring host monitoring, top, iotop, vmstat and other tools f
sufficient
To view your hard disk usage :View disk and partition information: Fdisk-lTo view file system Information: DF
DF [-m displays size in megabytes] [-K displays size in kilobytes] [-H in gb/mb/kb way] [-I with inode quantity display] [-A lists all file systems including special systems such as/proc] [-t display file system type] [-H displays in 1024=1000 mode]
DF reads the data i
Computer insert a U disk or insert removable disks, the computer right tips "This device can improve performance" hint information, this is how to do? Some friends must also encounter the disk transfer file slow problem, a 400M movie file transfer time should be nearly more than 20 minutes. In fact, this is the device
conv = fdatasync
(1) After the dd command is executed, a "sync" operation will be executed.
(2) The time required to read the M data to the memory and write the data to the disk.
(3) comparison with actual conditions
Actual running result:
4. dd bs = 128 k count = 10 k if =/dev/zero of = test oflag = dsync
(1) dd performs synchronous write operations every time it is executed.
(2) write the 128 k to the disk
Write in front: This article only for the IO causes MySQL performance problem localization, other such as CPU, mysql parameter configuration, program itself and other issues need to be further supplemented.Background: A SQL Build Table statement was run for 15 seconds: (STEP1:Open profiling
SET profiling=1;
Shut down
SET profiling=off;
Find the SQL statement ID that is running slow
) for each device I/O operation ). That is, delta (ruse + wuse)/delta (rio + wio)Svctm // average service time for each device I/O operation (MS ). That is, delta (use)/delta (rio + wio)% Util // The percentage of time in one second is used for I/O operations, that is, delta (use)/s/1000 (because use is measured in milliseconds)How can I use this data to analyze problems?1. If % util has a high probability of 100%, it indicates that too many I/O requests are generated and the I/O system is fully
1. ddif/dev/zerooftestbs64kcount16k is not accurate because the data is not actually written to the disk at the end of the command. ddif/dev/zerooftestbs64kcount16kconvfsync is accurate, and data has been written to disk 3.dd
1. dd if =/dev/zero of = test bs = 64 k count = 16 k
This is not accurate because the data is not actually written to the disk at the end
time (in milliseconds) for each device I/O operation ). That is, delta (use)/delta (rio + wio)
% Util: the percentage of time in one second is used for I/O operations, or the number of I/O queues in one second is not empty. That is, delta (use)/s/1000 (because the Unit of use is milliseconds)
If % util is close to 100%, it indicates that too many I/O requests are generated and the I/O system is fully loaded.
There may be bottlenecks. The idle is under a high I/O pressure of less than 70%, and t
1. dd if =/dev/zero of = test bs = 64 k count = 16 k
This is not accurate because the data is not actually written to the disk at the end of the command.
2. dd if =/dev/zero of = test bs = 64 k count = 16 k conv = fsync
This is fairly accurate. The data has been written to the disk.
3. dd if =/dev/zero of = test bs = 64 k count = 4 k oflag = dsync
This can be regarded as a simulation of database insert
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.