Linux disk failure causes the system to run slowly solution

The Linux disk has failed, causing the system to run slowly. If it is a personal okay, if it is a company, it will be very troublesome. How should we deal with this problem? The following small series will introduce you to the solution that the Linux disk failure causes the system to run slower.

OS: solaris 10

DBMS: Oracle 10.2.0.3.0

Canada is running an operating system Daily becomes extraordinarily slow, resulting in a backlog of data.

First out of awr report

log file sync 45,755 33,981 743 59.7 Commit

CPU time 14,009 24.6

db file parallel Write 63,119 11,374 180 20.0 System I/O

db file sequential read 736,650 3,692 5 6.5 User I/O

log file parallel write 9,148 3, 081 337 5.4 System I/O

Most of it is caused by IO.

Check the log log status first

select * from v$logfile;

There are 64 50m online log groups. Obviously unreasonable first

Add 5 2g log groups\\

alter databae add logfile group 66 ‘/filepath/redolog66.log’ size 2g;

.

alter database drop logfile group 1;

alter database drop logfile group 2;

. .

alter database drop logfile group 64;

alter database drop logfile group 65;

Observing the problem persists.

Fortunately, I found a previous awr report, which is far less load than before.

Observing system IO conditions

device r/sw/s kr/s kw/s wait actv svc_t %w %b

md0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

md1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

md3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

md5 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0< Br>

md10 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

md11 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

md13 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

md15 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

md20 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

md21 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

md23 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

md25 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

sd0 0.0 0.2 0.0 0.1 0.0 0.0 3.9 0 0

sd1 0.0 0.2 0.0 0.1 0.0 0.0 4.2 0 0

sd2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

sd3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

sd4 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

ssd5 13.0 106.0 126.4 847.7 0.0 1.8 15.4 0 100

ssd6 0.0 3.4 0.0 1.8 0.0 0.1 34.0 0 2

ssd7 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

ssd8 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

Ssd9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

nfs1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

The write per second is only about 840k, which is far from being a magnetic array. Performance

But cp has a large file performance and read performance. Inform the frontline colleagues to check the device status first

The cache feature of the magnetic array, I will introduce it in other logs.

The feedback is that the cache's battery has expired and the cache is disabled. Coordinate the battery replacement.

The above is a description of the solution to the slow operation of the Linux disk. If you encounter the same problem and the situation occurs, you need to replace the battery.