[development] Re: InnoDB and accesslog/ watchdog

[Gerhard Killesreiter]

Ken Rickard wrote:

> I may be a little late, but want to answer this.

Better late than never.

>> 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.

Can you ask him if he wouldn't prefer a split-table solution?

> I'm not sure this alters the conversation, but wanted to go on record.

Well, the patch I am working on would install split up log tables if 
your mysql server supports the Merge mysql engine.

The merge engine is probably more readily available than innodb, btw. It 
  does not need to be separately configured.

Cheers,
	Gerhard