Getting Priorities Straight: Improving Linux Support for Database I/O
Publikation: Bidrag til bog/antologi/rapport › Konferencebidrag i proceedings › Forskning › fagfællebedømt
The Linux 2.6 kernel supports asynchronous I/O as a result of propositions from the database industry. This is a positive evolution but is it a panacea? In the context of the Badger project, a collaboration between MySQL AB and University of Copenhagen, we evaluate how MySQL/InnoDB can best take advantage of Linux asynchronous I/O and how Linux can help MySQL/InnoDB best take advantage of the underlying I/O bandwidth. This is a crucial problem for
the increasing number of MySQL servers deployed for very large database applications. In this paper, we rst show that the conservative I/O submission policy used by InnoDB (as well as Oracle 9.2) leads to an under-utilization of the available I/O bandwidth. We then show that introducing prioritized asynchronous I/O in Linux will allow MySQL/InnoDB and the other Linux databases to fully utilize the available I/O bandwith using a more aggressive I/O submission policy.
the increasing number of MySQL servers deployed for very large database applications. In this paper, we rst show that the conservative I/O submission policy used by InnoDB (as well as Oracle 9.2) leads to an under-utilization of the available I/O bandwidth. We then show that introducing prioritized asynchronous I/O in Linux will allow MySQL/InnoDB and the other Linux databases to fully utilize the available I/O bandwith using a more aggressive I/O submission policy.
Originalsprog | Engelsk |
---|---|
Titel | Proceedings of the 31st International Conference on Very Large Data Bases |
Forlag | ACM |
Publikationsdato | 2005 |
Sider | 1116-1127 |
Status | Udgivet - 2005 |
Begivenhed | VLDB 2005 - Trondheim, Norge Varighed: 29 nov. 2010 → … Konferencens nummer: 31 |
Konference
Konference | VLDB 2005 |
---|---|
Nummer | 31 |
Land | Norge |
By | Trondheim |
Periode | 29/11/2010 → … |
- Det Natur- og Biovidenskabelige Fakultet
Forskningsområder
Links
- https://dl.acm.org/doi/10.5555/1083592.1083721
Forlagets udgivne version
ID: 3184948