maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #04180
Re: Proposal to split @@optimizer_switch
Hi, Sergey!
On Jun 27, Sergey Petrunya wrote:
> > > Proposed solution
> > > -----------------
> > >
> > > Break optimizer_switch into multiple variables, with names having
> > > the dots in them. That is, current @@optimizer_switch flags will
> > > change into this set of variables:
> > >
> > > optimizer.index_merge=on
> > > optimizer.index_merge.union=on
> >
> > Assorted thoughts:
...
> > * another solution, create hierarchies implicitly, splitting on
> > underscores. Rename variables that don't fit into the correct
> > hierarchy, keep old names as obsolete aliases, remove them later.
>
> If there was a direct mapping from underscores to dots, there would have been
> no point in the dot notation.
> There is no point in changing @@time_zone to @@time.zone or
> @@table_definition_cache to table.definition.cache.
sure. I didn't like that solution either.
> > * named keycaches once again will be a problem, the syntax is so out of
> > line, it never fits anywhere
>
> I think that disallowing a few names for named key caches ('optimizer',
> 'aria','innodb') is not a big problem?
No. And I didn't mean that it is.
The above was in the "assorted thoughts" list, after all :)
But really, I'd prefer to introduce a new syntax for named keycaches.
Something more in line with other variables and more future proof.
Regards,
Sergei
References