[development] Re: InnoDB and accesslog/ watchdog

[Dries Buytaert]

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/