Oracle 10gR2 enables asynchronous IO under RHEL 5
Record the steps for enabling asynchronous IO for Oracle 10gR2 under RHEL 5
Platform: RedHat Enterprise Linux 5 64bit, Oracle 10gR2 10.2.0.4 64bit
1. First install the following necessary rpm packages with the root user
# Rpm-Uvh libaio-0.3.106-3.2.x86_64.rpm
# Rpm-Uvh libaio-devel-0.3.106-3.2.x86_64.rpm
2. Supporting asynchronous I/O at the system level
Unlike setting asynchronous IO in RHEL 3 described in [Note 225751.1], you do not need to set
threads. Therefore, it is undesirable to use synchronous I/O in cases of high TCP concurrency, when you consider using non-blocking synchronous I/O or asynchronous I/O. Non-blocking synchronous I/O techniques include the use of Select (), poll (), Epoll, and so on. The technique of asynchronous I/O is to use AIO.From the I/O event dispatch mechanism, it is inappropriate to use Select () because it supports a limited number of concurrent connections (typically within 1024). If you consider perfo
, primarily assigning tasks to each background threadfor (i = 0;; i++) {fil_aio_wait(segment);Mutex_enter (ios_mutex);ios++;Mutex_exit (ios_mutex);}The main function of fil_aio_wait is Os_aio_simulated_handle, which simulates asynchronous IO settings based on the number of threads in the InnoDB.Segment = Os_aio_get_array_and_local_segment (array, global_segment);AIO and Sync AioWhen MySQL was born, there was no AI
prototype, reminding team members to keep their features and functions focused and concise, and when engineers suggest new features, He raised the wood and asked, "Where's the add?" "This piece of wood as a prototype always reminds the team to notice the actual experience." Finally, Palm Pilot was successful, and Apple's Newton failed on the contrary. In designing a Web product, the user Experience Department often produces prototypes to make people feel like a real-life product experience. Pro
------------
Transactions
------------
Trx id counter 0 59141
Purge done for TRX's N: O History List length 3
Total number of lock structs in row lock Hash Table 0
List of transactions for each session:
--- Transaction 0 0, not started, OS thread ID 3100
MySQL thread ID 3, query ID 32 localhost 127.0.0.1 Root
Show engine InnoDB status
--------
File I/O
--------
I/O Thread 0 state: Wait windows AIO (insert buffer thread)
I/O thread 1 State: Wait windo
Summary
When writing a high-load server program with a large number of connections, the classic multi-thread mode and select mode are no longer applicable.They should be discarded and epoll/kqueue/dev_poll should be used to capture I/O events. Finally, we briefly introduce AIO.
Origin
Network services are often inefficient or even completely paralyzed when handling tens of thousands of client connections.C10K problem. With the rapid development of the
today and finally understood the problem.
Platform: Redhat Enterprise Linux 5 64bit, Oracle 10gr2 10.2.0.4 64bit
1. First install the following necessary RPM packages with the root user
# Rpm-uvh libaio-0.3.106-3.2.i386.rpm# Rpm-uvh libaio-0.3.106-3.2.x86_64.rpm# Rpm-uvh libaio-devel-0.3.106-3.2.i386.rpm# Rpm-uvh libaio-devel-0.3.106-3.2.x86_64.rpm
2. Supporting asynchronous I/O at the system levelAnd[Note 225751.1]The asynchronous Io setting in RHEL 3 is different. You do not need to set
. Net asynchronous performance testing (including ASP. net mvc WebAPI Asynchronous Method), mvcwebapi
I haven't written a blog for a long time. This year, the product company launched a press conference just two days ago, so I thought about whether there is room for performance optimization for our products. net Asynchronization can optimize the performance, but how much can it increase? A friend is testing the asynchronous performance of various languages. (For more information about asynchrono
This article describes the four IO cases of Java BIO (synchronous blocking IO), pseudo-asynchronous Io,nio (non-blocking io), AIO (asynchronous IO), and compares different IO models.
Directory
1.BIO
2. Pseudo-Asynchronous IO
3.NIO
4.AIO
5. Four kinds of IO comparisons
6.bio\ Pseudo-Asynchronous Io\nio\aio source Download
1.BIO
The server that uses the Bio commun
tool HCOM formatHcr ibm hcd/HCM Product Configuration FileHDF advanced computer application local center (NCSA) geospatial Hierarchial Data Format FileHED HighEdit documentGame files saved in helmicrosoft Hellbender formatHEX Macintosh BinHex2.0 FileHgl hp Graphic Language drawing fileHH ing file, including some topic IDs and ing numbers of topics in the Help File System-allows running applications to send appropriate context help topics to usersHLP help file; Date CAD Windows Help FileDark For
construction of individualized quality culture must be people-oriented, establish quality concept and cultivate quality consciousness. Therefore, a quality expert said: "Product quality is not manufactured, quality is a habit." "The IBM School of Management also has a famous saying:" Quality is because 90% in attitude, knowledge only 10%. "Secondly, the construction of personalized brand culture also needs to build a personalized marketing culture. Marketing is to realize the brand value of the
As a common consumer commodity, digital camera its basic principle is to use CCD optical coupling device to convert the light signal into electrical signals, after a/D conversion, data compression and so on through the serial port or USB port in the PC-side application control of the picture (mostly JPEG format) to the PC's hard drive.
The current PC-side applications are provided by the camera manufacturer. Few people have noticed that some digital camera manufacturers provide developers with
In Nginx, what scenarios are suitable for enabling sendfile, what scenarios are suitable for enabling directio in Nginx, what scenarios are suitable for enabling sendfile, And what scenarios are suitable for enabling directio?
Reply content:
In Nginx, which scenarios are suitable for enabling sendfile and direo o?
Http://nginx.org/en/docs/http/ngx_http_core_module.html#aio
Location/video/{sendfile on; sendfile_max_chunk 256 k;
Netty, netty
This article introduces four types of IO: Java BIO (synchronous blocking IO), pseudo asynchronous IO, NIO (non-blocking IO), and AIO (asynchronous IO), and compares different IO models.
Directory
1. BIO
2. pseudo asynchronous IO
3. NIO
4. AIO
5. Comparison of four types of IO
6. BIO \ pseudo asynchronous IO \ NIO \ AIO source code download
1. BIO
A
. Net asynchronous performance testing (including ASP. net mvc WebAPI Asynchronous Method), mvcwebapi
I haven't written a blog for a long time. This year, the product company launched a press conference just two days ago, so I thought about whether there is room for performance optimization for our products. net Asynchronization can optimize the performance, but how much can it increase? A friend is testing the asynchronous performance of various languages. (For more information about asynchrono
where the network packet can be sent. */Unsigned accept: 1;/* indicates that a new connection can be established for this event when the flag is 1. Generally, in the listening dynamic array in ngx_cycle_t, the accept flag of each listening object ngx_listening_t is 1 in the corresponding read event. */Unsigned instance: 1;/* used to detect the stale events in kqueue, rtsig, and epoll * indicates whether the current event has expired, it is only used by the event-driven module, and the event con
When I was about to finish at noon today, I found a problem that was maddening.A lite AIO application should theoretically be more concurrent than a full version of the AIO application (because the full version of the transaction is more complex) and tested on the same machine.However, the test results show that the concurrency of the lite version is less than the full version of the
. */unsignedAccept1;The/ * flag bit, which is 1, indicates that a new connection can be established for this event. Usually in the listening dynamic array in ngx_cycle_t, each listener object ngx_listening_t, the accept flag bit in the corresponding read event will be 1. */unsignedInstance1;/ * Used to detect the stale events in Kqueue, Rtsig, and Epoll * This flag bit is used to differentiate whether the current event is out of date, it is only for the event driver module, and the event consump
returned infinitely. EverybodyThe commonly used select is conditional trigger. I used to pay attention to socket write events for a long time.CPU 100% error.
======================================
From: http://www.rosoo.net/a/201103/11088.html
In addition: c10k.pdf
Summary: When writing a high-load server program with a large number of connections, the classic multi-thread mode and select mode are no longer applicable. They should be discarded and epoll/kqueue/dev_poll should be used to capture
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.