I am not a disk guy, but striping has provided significant performance gains for. Separating the busiest files from everything else can also help a lot; it keeps your busiest files from dragging down the rest of the system/account. If you're on *nix, you can do some very creative things like isolating busy files to a subset of disks and then mounting inside your main account(s). This way it looks to uv like the files are all in one location, but the O/S accesses them separately from everything else in the account. This doesn't fully resolve performance hits due to big complex queries on big complex files, but it can help isolate them so the rest of the world doesn't care.
hth, Brad. From: George Gallen <[email protected]> To: U2 Users List <[email protected]> Date: 04/28/2010 11:47 AM Subject: [U2] Universe and stripped drives Sent by: [email protected] We are in the process of upgrading our system. When we setup our current system, it was suggested we strip our data drives (5) into one, instead of having 5 separate drives, so it could pull more data at once. The new system will have 6 drives available for striping We were going to have 6 drives striped into one, which would be partitioned into our data areas the thought being it would be faster disk access if it's pulling from all 6 drives at once. BUT...all of the partitions are on that one striped drive. Would it be better to have (2) sets of 3 drives striped into one, and setup the two most used accounts on each of those drives, so now it's only pulling data from 3 drives, but there could be less competition between the two accounts, since they are pulling from separate drives? Anyone played with this at all? FYI, each drive is mirrored as well, so if there is a drive failure, data loss is protected, if there was a drive failure on both the main and mirror (same drive) then with the 6 drive strip, we stand to potentially lose more data, than if there were 2 sets of 3 striped. But...since we have full daily backups, and potentially, considering a second backup during the day, the amount of data loss would be minimal....so I'm putting that off the table for now in determining whether to go with a 3 or 6 stripe. George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator [email protected] ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users U.S. BANCORP made the following annotations --------------------------------------------------------------------- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. --------------------------------------------------------------------- _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
