← Back to team overview

maria-developers team mailing list archive

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