io优化案例一则（IO optimization case one）.docVIP

io优化案例一则（IO optimization case one） IO optimization case one Personal classification: Altibase I write my whole process here, and I hope to provide you with a train of thought and reference. Environmental Science： OS:AIX 5307 DB:ALTIBASE 3 EMC DMX1000 The first problem Problem phenomenon: 210G memory is exhausted during the peak hours of the day. Memory database synchronization backlog, the backlog of log files to more than 2000, there have been SWAP OUT case. The host is slowing down, but not yet hang. When this problem occurs, first check the system memory usage, that memory is consumed, the noncomp (document type page cache) occupy relatively high, at the same time there are also waiting for the IO (the situation is not saved, unable to reproduce). Because running is relatively normal, things did not modify the storage layer, then try to modify the system parameters of max_perm% and min_perm%, after the modification, the noncomp is still occupied, because the two is only an approximate value, and not strictly limit noncomp memory, so in addition to parameter strict_maxperm = 1 noncomp, strictly limited memory footprint, modify the results in the synchronization process is abnormal, not normal replication. Time is pressing, and adopted the following method to solve: 1. Stop copying. 2, directly from the other logical partition on the 25 G memory over. 3, the night again to redo the full synchronization. Problem solving. ============================================ Second problems After the first settlement, the system remained stable for a few days. But half a month later, there was another problem. Have tried to add memory, can not continue to add, obviously palliative, and we do not have so much memory to continue to add. At that time, stop copying, release memory, and then re sync that night. But this can only be a temporary expedient, and can not be done once every time such full synchronization, determined to investigate the problem thoroughly. In the analysis