The Optimization of Large Information Management Database Bottlenecks
Database object placement strategy is evenly distributed the data to disk, which is not simply put the data into the disk, but on balancing VO access, to avoid the 1/ 0 bottlenecks. Disperse the visit into different disk, so that the user data will across multiple devices as soon as possible. Multiple 1/ 0 operation can avoid the I/O competition, and to overcome the access bottleneck. The random access and continuous access data will be placed separately. Put the system database 1/0 and application database I/O on Separately disk. Put the system audit tables and temporary tables on the non-busy disk. Put the transaction log on a separate disk to reduce disk I/O spending. I is also beneficial to the recover from obstacles, and improves the systems security. Put the frequently visited active table on different disks;place the frequently used table, frequently joined operation tables into different disk, even place frequently visited into different disk. Separate the visit into different disk will avoid I/O contention
MIS Database Bottlenecks Optimization
Wang Zhong-zhuang Deng Lun-dan Wu Yun-ting He Zhi-wen
Nanchang University College of Science and Technology
国际会议
北京
英文
470-472
2010-09-18（万方平台首次上网日期，不代表论文的发表时间）