- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: LVM IO sizes and Oracle writes
Operating System - HP-UX
1748123
Members
3430
Online
108758
Solutions
Forums
Categories
Company
Local Language
юдл
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
юдл
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Go to solution
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-14-2002 01:52 PM
тАО07-14-2002 01:52 PM
For file systems, I believe the max LVM IO size is 256K using file systems or 1MByte using asynchronous IO.
If I were to set Oracle redo log write sizes to match the max LVM IO size, rather than 1 big IO clump when it flushes the redo log buffer, would I necessarily get a faster write?Why? Surely doing just 1 IO call is faster than doing several evenly sized IO calls that match the IO size limit?
If I were to set Oracle redo log write sizes to match the max LVM IO size, rather than 1 big IO clump when it flushes the redo log buffer, would I necessarily get a faster write?Why? Surely doing just 1 IO call is faster than doing several evenly sized IO calls that match the IO size limit?
Solved! Go to Solution.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-16-2002 03:04 AM
тАО07-16-2002 03:04 AM
Re: LVM IO sizes and Oracle writes
In otherwords, will doing multiple IOs equal to the max LVM IO size be faster than doing 1 big IO from an application point of view?
ie Is there a real performance issue here or is this just academic?
ie Is there a real performance issue here or is this just academic?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-16-2002 06:48 AM
тАО07-16-2002 06:48 AM
Solution
IO that large will likely be chunked by the driver anyway.
HPUX sorts the IO requests by
location. Modern disks
don't have real HCS mapping
visible on the interface.
Choosing the max LVM IO size
will likely block all other
IO on the disk while it completes. This may be
slightly faster than smaller
requestes.
If your IO request is too large you may block other
IO on the same disk. This
could slow overall performance.
Unless you devote the disk to
redo logs, I would expect the
gains to be acedemic. Do you
expect to block waiting for
redo writes? Do you expect
to have the disk fully loaded
with IO requests.
Acedemically, you are deep into queuing theory.
HPUX sorts the IO requests by
location. Modern disks
don't have real HCS mapping
visible on the interface.
Choosing the max LVM IO size
will likely block all other
IO on the disk while it completes. This may be
slightly faster than smaller
requestes.
If your IO request is too large you may block other
IO on the same disk. This
could slow overall performance.
Unless you devote the disk to
redo logs, I would expect the
gains to be acedemic. Do you
expect to block waiting for
redo writes? Do you expect
to have the disk fully loaded
with IO requests.
Acedemically, you are deep into queuing theory.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-16-2002 07:04 AM
тАО07-16-2002 07:04 AM
Re: LVM IO sizes and Oracle writes
Thanks.
I guess I need a white paper on performance tuning queuing in the LVM.
I guess I need a white paper on performance tuning queuing in the LVM.
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP