On Mon, Aug 18, 2003 at 01:34:59PM +0100, Andrew Braithwaite wrote:
> Hi All,
> 
> I have a database with many files in it and our research tells us that
> disabling the recording of atime (access time) for that DB may have
> significant performance improvement.
> 
> 2 questions:
> 
> 1. Has anyone done this and if so, what results did they have?

We've run many servers on which atime is disabled for MySQL's data.

> 2. Is the atime used in MySQL/MyISAM and will the disabling of atime cause
> problems?

It has never caused a problem for us.
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.13: up 17 days, processed 869,633,877 queries (591/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to