Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: Tim Watts Newsgroups: comp.databases.mysql Subject: Re: Can MySql database store images? Followup-To: comp.databases.mysql Date: Mon, 25 Apr 2011 11:50:33 +0100 Organization: A noiseless patient Spider Lines: 28 Message-ID: References: <55md88-7pb.ln1@squidward.dionic.net> Mime-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7Bit Injection-Info: mx02.eternal-september.org; posting-host="6oIlEBqCjOm0MjsSUEk5CA"; logging-data="23157"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+8t88UP+XeB/RaHSHdI3285biS8J2L16A=" User-Agent: KNode/4.4.6 Cancel-Lock: sha1:r690B/AlnFJS+vvPqSTNi8N/Y5w= Xref: x330-a1.tempe.blueboxinc.net comp.databases.mysql:656 Jerry Stuckle wrote: > On 4/25/2011 3:36 AM, Tim Watts wrote: >> Norman Peelman wrote: >> >> >>> And will be cached by MySQL (depending on settings) anyway, so every >>> request won't go to the disk every time. >>> >> >> And to be fair, a decent FS on decent OS will do the same :) >> > > Except a file systems has to cache every file accessed, while a database > only caches the data accessed by the database - a much smaller amount of > data. With the tuning of the database buffers, etc. available, there is > a much greater likelihood the data will be available in the database's > cache than the file system's cache. > No, a *nix filesystem will cache *blocks* accessed which may or may not include entire files. Linux also maintains the dcache, a specific cache of pathname lookups which further increase speed. Like most RDBMSs, Linux's use of FS cache is tunable. -- Tim Watts