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