[development] Re: InnoDB and accesslog/ watchdog

Dries Buytaert dries.buytaert at gmail.com
Mon Aug 14 14:46:28 UTC 2006

On 14 Aug 2006, at 16:27, Ken Rickard wrote:
> > Is there anybody who prefers innodb for
> > logging tables and would prefer to not change them to myisam?
> Yes.  At a large-scale site, InnoDB is much preferred.  Our MySQL  
> admin is working on a patchfile for database.4.1.mysql that  
> installs log tables as InnoDB by default for our installations.

A patch for this?

ALTER TABLE accesslog TYPE='InnoDB';

Dries Buytaert  ::  http://www.buytaert.net/

More information about the development mailing list