[development] InnoDB and accesslog/ watchdog
larry at garfieldtech.com
Sun Aug 13 19:55:35 UTC 2006
What exactly would be the benefit here? My understanding is that InnoDB is
already better for write-heavy tables (while MyISAM is read-optimized), so
I'm not sure what the goal is. And what would this get us that UNION would
On Sunday 13 August 2006 12:17, Gerhard Killesreiter wrote:
> Hi there!
> I am considering to write a patch which would split up the accesslog and
> watchdog tables into a storage table and a smaller table where we'd
> insert the new events. To still show the end user the combined results,
> I would use a merge table in mysql (there are other methods for pgsql).
> The issue is that the merge engine only works for myisam tables so for
> mysql we'd need to enforce them. Is there anybody who prefers innodb for
> logging tables and would prefer to not change them to myisam?
Larry Garfield AIM: LOLG42
larry at garfieldtech.com ICQ: 6817012
"If nature has made any one thing less susceptible than all others of
exclusive property, it is the action of the thinking power called an idea,
which an individual may exclusively possess as long as he keeps it to
himself; but the moment it is divulged, it forces itself into the possession
of every one, and the receiver cannot dispossess himself of it." -- Thomas
More information about the development