On Mon, 2007-08-06 at 10:40 +0200, Brice Figureau wrote: > Mysql accesses its database files in O_DIRECT mode. binlog is written using buffered IO. for InnoDB, binlog is synced first, then innodb log. on restart (in 5.0) these are synced back up so you don't get inconsistencies. and from a quick look at the innobase source, only data file is using O_DIRECT. > Since the database fits in RAM, the only kind of access Mysql is doing > is writing to the innodb log, the mysql binlog and finally to the innodb > database files. > There are certainly a whole lot of fsync'ing happening. yes. Keep in mind that the binlog grows in file size too... so this has to sync all the metadata as well (ick, i know). -- Stewart Smith, Senior Software Engineer MySQL AB, www.mysql.com Office: +14082136540 Ext: 6616 VoIP: [email protected] Mobile: +61 4 3 8844 332 Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html
Attachment:
signature.asc
Description: This is a digitally signed message part
- Follow-Ups:
- Re: [PATCH 00/23] per device dirty throttling -v8
- From: Andi Kleen <[email protected]>
- Re: [PATCH 00/23] per device dirty throttling -v8
- References:
- [PATCH 00/23] per device dirty throttling -v8
- From: Peter Zijlstra <[email protected]>
- Re: [PATCH 00/23] per device dirty throttling -v8
- From: Linus Torvalds <[email protected]>
- Re: [PATCH 00/23] per device dirty throttling -v8
- From: Ingo Molnar <[email protected]>
- Re: [PATCH 00/23] per device dirty throttling -v8
- From: Brice Figureau <[email protected]>
- Re: [PATCH 00/23] per device dirty throttling -v8
- From: Andi Kleen <[email protected]>
- Re: [PATCH 00/23] per device dirty throttling -v8
- From: Brice Figureau <[email protected]>
- [PATCH 00/23] per device dirty throttling -v8
- Prev by Date: ignoring unimplemented functions that are old and crusty on shiny new ports
- Next by Date: Re: [PATCH] [1/2many] - FInd the maintainer(s) for a patch - scripts/get_maintainer.pl
- Previous by thread: Re: [PATCH 00/23] per device dirty throttling -v8
- Next by thread: Re: [PATCH 00/23] per device dirty throttling -v8
- Index(es):
 |