[development] InnoDB and accesslog/ watchdog

Larry Garfield 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 
not?

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?
>
> Cheers,
> 	Gerhard

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


More information about the development mailing list