Re: InnoDB and accesslog/ watchdog
Gerhard, I may be a little late, but want to answer this.
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. I'm not sure this alters the conversation, but wanted to go on record. - Ken Rickard agentrickard
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
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/
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 while ago, we removed the Engine=MyISAM from all core tables to allow creating the tables with whatever default the site admin decides. So, not sure why an explicit type is needed again.
participants (4)
-
Dries Buytaert -
Gerhard Killesreiter -
Ken Rickard -
Khalid B