Change XtraDB variables in 5.5
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Undecided
|
Unassigned | ||
5.5 |
Fix Released
|
High
|
Unassigned |
Bug Description
After discussion with Baron, we should change names of following variables in 5.5:
INNODB_
to
innodb_
INNODB_
to
innodb_
INNODB_
to
innodb_
INNODB_
to
innodb_
And next status variables:
> INNODB_
> INNODB_
> INNODB_
Should be
INNODB_
INNODB_
INNODB_
Changed in percona-server: | |
status: | New → Triaged |
importance: | Undecided → High |
assignee: | nobody → Yasufumi Kinoshita (yasufumi-kinoshita) |
milestone: | none → 5.5-21rc |
Yasufumi Kinoshita (yasufumi-kinoshita) wrote : | #1 |
Yasufumi Kinoshita (yasufumi-kinoshita) wrote : | #2 |
In addition, for example,
I regret I should not accept the name "adaptive_
It was wrong constitute name. And it was already renamed currently.
I should not accept careless suggestions.
Baron Schwartz (baron-xaprb) wrote : Re: [Bug 721611] Re: Change XtraDB variables in 5.5 | #3 |
My comments are inline. In general, I propose names that users will
understand, which express the behavior of the server. I think that
this is better than names that developers who know the InnoDB source
will understand, or names which express an operation on an internal
data structure.
>> INNODB_
>> to
>> innodb_
>
> fast? warmup?
> I don't like to cheat users. It is really not concrete name.
> The name should express the effect cleanly.
Users will not understand auto_lru_dump. The effect of the variable
is that the server becomes ready to answer queries more quickly after
starting. This is what users will understand and care about.
However, I think you are correct. There could be many different ways
to make the server warm up more quickly, and we should name them
specifically. I think that we might consider a name such as
"innodb_
"buffer_pool" is much better than "lru" for users. (We should also
not use "dump" because it has a slightly different and unprofessional
meaning in English, and the behavior is not only to save the LRU, it
is also to restore it from the saved information.)
>> INNODB_
>> to
>> innodb_
>
> "IMPORT TABLE" is supported basically. It is wrong name.
I agree. But I do not have a better suggestion. The current variable
name is very cryptic. It does not explain what the change in server
behavior is. Maybe we need a variable that explains "when importing a
tablespace, also do ________" ? What, exactly, does the variable
change? I think it renames the tablespace ID, right? I do not know
this feature's behavior very well.
>> INNODB_
>> to
>> innodb_
>
> I don't like to cheat users. It is really not concrete name.
> The name should express the effect cleanly.
The behavior of the server is that after a crash, replication gets its
position information from the storage engine, not the relay log file.
The word "overwrite" sounds like something bad in English. It means
that some data is being destroyed. I propose
"innodb_
it is better.
>> INNODB_
>> Rename to innodb_
>
> The user should understand passing corrupt table is abnormal for RDBMS...
> It may not the problem only about the table.
> ,as I described before.
>
> InnoDB should abort for all corruption detections.
>
> You should explain the abnormal name for me, again.
> You didn't explain any at the previous report.
> I don't accept one-side intrusion...
I do not propose to change the behavior. By default, InnoDB should
abort, as you say. But the word "pass" is very ambiguous in English,
and the meaning will not be clear to users. I propose
"innodb_
>> And next status variables:
>>> INNODB_
>>> INNODB_
>>> INNODB_
>>
>> Should be
>> INNODB_
>> INNODB_
>> INNODB_
>
> I intended that
> values about checkpoint
> "ag...
Baron Schwartz (baron-xaprb) wrote : | #4 |
> In addition, for example,
> I regret I should not accept the name "adaptive_
> It was wrong constitute name. And it was already renamed currently.
I am not sure what you mean. I do not remember suggesting a name for
this when you implemented the feature.
Changed in percona-server: | |
status: | Confirmed → Won't Fix |
importance: | High → Undecided |
assignee: | Yasufumi Kinoshita (yasufumi-kinoshita) → nobody |
milestone: | 5.5-20.1rc → none |
Yasufumi Kinoshita (yasufumi-kinoshita) wrote : | #5 |
Baron,
My naming policy is
describe by the name of "component" and "method" to eliminate suspicious and subjective.
Never by "effect", "purpose".
I know the such kind of complain is often from less-understanding about InnoDB.
I don't assume the less-understanding users.
I think all users who want to use InnoDB effectively should understand InnoDB.
As deeper understand, he should obtain better setting.
The good example of past about it is about "adaptive_
I named it as "adaptive_
Because it controls the amount of flushing blocks by background thread
to make small the impact and possibility that the checkpoint effect affects to performance.
But, Peter and Vadim forced to change the name for "adaptive_
I think it is name for the purpose. Bad name for describe the function.
Though it was attractive and catchy, it was wrong and made misunderstanding.
I think such wrong and misunderstanding
should obstruct the next step to improve InnoDB more.
I'd like to be sincere for all MySQL/InnoDB users.
If don't understanding, please study.
I believe "don't understanding" is much better than "misunderstand"
for MySQL/InnoDB ecosystem.
If the "don't understand" is from wrong expression of English language,
I will try to fix.
But from less understanding, I never accept it.
That's why I need the your reason.
The your reason should explain the what cause the "don't understand".
>>> INNODB_
>>> to
>>> innodb_
>>
>> fast? warmup?
>> I don't like to cheat users. It is really not concrete name.
>> The name should express the effect cleanly.
>
> Users will not understand auto_lru_dump. The effect of the variable
> is that the server becomes ready to answer queries more quickly after
> starting. This is what users will understand and care about.
> However, I think you are correct. There could be many different ways
> to make the server warm up more quickly, and we should name them
> specifically. I think that we might consider a name such as
> "innodb_
> "buffer_pool" is much better than "lru" for users. (We should also
> not use "dump" because it has a slightly different and unprofessional
> meaning in English, and the behavior is not only to save the LRU, it
> is also to restore it from the saved information.)
The relation between method and effect should be studied.
If you don't imagine the effect from the method name,
I don't recommend not to use it, because you should mistake about using.
The name should be sincere as I described above.
And users should know the option cause the new file to be used by it.
So the verb should be used to associate accessing another file.
The method name candidates are
"dump" (auto periodical)
"save" (auto periodical)
"preload_
"restore_
The component name candidates are
"lru"
"buffer_pool"
"list of cached_data_pages"
The exactly what is saved in the file is
list of the pairs of space_id and page_no.
So, "lru_list of buffer pool" is best component to be described.
Only "buffer pool" may cause misunderstanding to store also
the component of the pages li...
Baron Schwartz (baron-xaprb) wrote : | #6 |
>>>> INNODB_
I think we should consider the following candidate:
innodb_
This seems best to me because:
- Although the file contains the space_id and page_no pairs, the
buffer pool is what is restored.
- Although the feature both saves the pairs and restores the buffer
pool, the important part is restoring. (Saving the pairs is useless
without the restore.) And naming with both "save" and "restore" is
too long and awkward.
>>>> INNODB_
Maybe we can use innodb_
>>>> INNODB_
> can we named using opposite and negative words like
> "force", "ignore" or something?
> (like same image for force_recovery. And it is more expandable in the future. e.g. add leveling)
> and default is 0 and 0 means abort when meet corruption.
Maybe innodb_
Peter Zaitsev (pz-percona) wrote : | #7 |
Baron,
I think with import table it is practically new feature because
export/import was basically non workable
in normal Innodb because it is very hard to guaranty in production
conditions such as no insert buffer
entries or unpurged entries. This means for practical user you could not
export/import tables in
standard MySQL and you can in Percona Server
now for "pass corrupted table" I think permit corrupted table is confusing
as it looks as it makes
more prone to corruption. I would compare this to how file system (say
EXT3) allow to tune inconsistence
behavior. What we really tune here is the behavior on detected corruption.
The default behavior in
Innodb is "assert" What do we do with current behavior ? Do we make
table inaccessible until server restart ?
There could be other possibilities for example making table read only in the
future.
Maybe we can use innodb_
>
> >>>> INNODB_
> > can we named using opposite and negative words like
> > "force", "ignore" or something?
> > (like same image for force_recovery. And it is more expandable in the
> future. e.g. add leveling)
> > and default is 0 and 0 means abort when meet corruption.
>
> Maybe innodb_
>
> --
> You received this bug notification because you are a member of Percona
> developers, which is the registrant for Percona Server.
> https:/
>
> Title:
> Change XtraDB variables in 5.5
>
> Status in Percona Server with XtraDB:
> Won't Fix
> Status in Percona Server 5.5 series:
> Won't Fix
>
> Bug description:
> After discussion with Baron, we should change names of following
> variables in 5.5:
>
> INNODB_
> to
> innodb_
>
> INNODB_
> to
> innodb_
>
> INNODB_
> to
> innodb_
>
> INNODB_
> Rename to innodb_
>
> And next status variables:
> > INNODB_
> > INNODB_
> > INNODB_
>
> Should be
> INNODB_
> INNODB_
> INNODB_
>
--
Peter Zaitsev, CEO, Percona Inc.
Tel: +1 888 401 3401 ext 501 Skype: peter_zaitsev
24/7 Emergency Line +1 888 401 3401 ext 911
Looking for MySQL Support ?
http://
Baron Schwartz (baron-xaprb) wrote : | #8 |
Peter, can you read back through Yasufumi's comments and see what you
can suggest? He had some well-supported opinions about some of the
things I suggested -- maybe we can come up with something that
satisfies all of us. Variable naming is hard.
Yasufumi Kinoshita (yasufumi-kinoshita) wrote : | #9 |
Baron,
>>>>> INNODB_
>
> I think we should consider the following candidate:
> innodb_
> This seems best to me because:
> - Although the file contains the space_id and page_no pairs, the
> buffer pool is what is restored.
> - Although the feature both saves the pairs and restores the buffer
> pool, the important part is restoring. (Saving the pairs is useless
> without the restore.) And naming with both "save" and "restore" is
> too long and awkward.
Hmm... I may have to compromise....
>
>>>>> INNODB_
>
> Maybe we can use innodb_
Yes, it seems more clear than innodb_
But... in more concretely,
export is done by xtrabackup
XtraDB can import it by this option.
I have came to...
It may be better to describe based on the usage than describe behavior as it is.
How about like the direction like
"innodb_
>>>>> INNODB_
>> can we named using opposite and negative words like
>> "force", "ignore" or something?
>> (like same image for force_recovery. And it is more expandable in the future. e.g. add leveling)
>> and default is 0 and 0 means abort when meet corruption.
>
> Maybe innodb_
>
"permit" seems little strange for me.
What permitted is...
"continue to work"
not
"corrupt table"
The corrupt table is marked as "corrupt" and reply to mysqld "corrupted" always.
not permitted, I think.
Peter Zaitsev (pz-percona) wrote : | #10 |
Baron,
Yes I read through comments.
I think something like innodb_
For table I think it should be something like
innodb_
On Sun, Feb 27, 2011 at 1:58 PM, Xaprb <email address hidden> wrote:
> Peter, can you read back through Yasufumi's comments and see what you
> can suggest? He had some well-supported opinions about some of the
> things I suggested -- maybe we can come up with something that
> satisfies all of us. Variable naming is hard.
>
> --
> You received this bug notification because you are a member of Percona
> developers, which is the registrant for Percona Server.
> https:/
>
> Title:
> Change XtraDB variables in 5.5
>
> Status in Percona Server with XtraDB:
> Won't Fix
> Status in Percona Server 5.5 series:
> Won't Fix
>
> Bug description:
> After discussion with Baron, we should change names of following
> variables in 5.5:
>
> INNODB_
> to
> innodb_
>
> INNODB_
> to
> innodb_
>
> INNODB_
> to
> innodb_
>
> INNODB_
> Rename to innodb_
>
> And next status variables:
> > INNODB_
> > INNODB_
> > INNODB_
>
> Should be
> INNODB_
> INNODB_
> INNODB_
>
--
Peter Zaitsev, CEO, Percona Inc.
Tel: +1 888 401 3401 ext 501 Skype: peter_zaitsev
24/7 Emergency Line +1 888 401 3401 ext 911
Looking for MySQL Support ?
http://
description: | updated |
description: | updated |
description: | updated |
Vadim Tkachenko (vadim-tk) wrote : | #11 |
We need to finalize this bug. This is single show-stopper for next release.
I see current suggestions are:
INNODB_
to
innodb_
INNODB_
to
innodb_
INNODB_
to
innodb_
INNODB_
to
innodb_
Is it acceptable for everyone ?
Baron Schwartz (baron-xaprb) wrote : | #12 |
Here are my final suggestions. After this I can only say "see my many
previous suggestions and my reasons for them" :-)
Change INNODB_
Change INNODB_
(NOTE this is different from Peter's suggestion, which I think is confusing)
Change INNODB_
Change INNODB_
(NOTE: standard InnoDB's behavior is "assert" and this should be the default)
Peter Zaitsev (pz-percona) wrote : | #13 |
Baron, Vadim
BTW what exactly happens now when you use "pass_corrupt_
abort given query with error message ?
Does table become inaccessible until MySQL restart or does itbecome read
only ?
On Sun, Mar 6, 2011 at 11:59 AM, Xaprb <email address hidden> wrote:
> Here are my final suggestions. After this I can only say "see my many
> previous suggestions and my reasons for them" :-)
>
> Change INNODB_
> Change INNODB_
> (NOTE this is different from Peter's suggestion, which I think is
> confusing)
> Change INNODB_
> Change INNODB_
> (NOTE: standard InnoDB's behavior is "assert" and this should be the
> default)
>
> --
> You received this bug notification because you are a member of Percona
> developers, which is the registrant for Percona Server.
> https:/
>
> Title:
> Change XtraDB variables in 5.5
>
> Status in Percona Server with XtraDB:
> Won't Fix
> Status in Percona Server 5.5 series:
> Confirmed
>
> Bug description:
> After discussion with Baron, we should change names of following
> variables in 5.5:
>
> INNODB_
> to
> innodb_
>
> INNODB_
> to
> innodb_
>
> INNODB_
> to
> innodb_
>
> INNODB_
> to
> innodb_
>
> And next status variables:
> > INNODB_
> > INNODB_
> > INNODB_
>
> Should be
> INNODB_
> INNODB_
> INNODB_
>
--
Peter Zaitsev, CEO, Percona Inc.
Tel: +1 888 401 3401 ext 501 Skype: peter_zaitsev
24/7 Emergency Line +1 888 401 3401 ext 911
Looking for MySQL Support ?
http://
Vadim Tkachenko (vadim-tk) wrote : | #14 |
Peter
Idea is that table is inaccessible and query just returns error.
On Sun, Mar 6, 2011 at 4:54 PM, Peter Zaitsev <email address hidden> wrote:
> Baron, Vadim
>
> BTW what exactly happens now when you use "pass_corrupt_
> abort given query with error message ?
> Does table become inaccessible until MySQL restart or does itbecome read
> only ?
>
> On Sun, Mar 6, 2011 at 11:59 AM, Xaprb <email address hidden> wrote:
>
>> Here are my final suggestions. After this I can only say "see my many
>> previous suggestions and my reasons for them" :-)
>>
>> Change INNODB_
>> Change INNODB_
>> (NOTE this is different from Peter's suggestion, which I think is
>> confusing)
>> Change INNODB_
>> Change INNODB_
>> (NOTE: standard InnoDB's behavior is "assert" and this should be the
>> default)
>>
>> --
>> You received this bug notification because you are a member of Percona
>> developers, which is the registrant for Percona Server.
>> https:/
>>
>> Title:
>> Change XtraDB variables in 5.5
>>
>> Status in Percona Server with XtraDB:
>> Won't Fix
>> Status in Percona Server 5.5 series:
>> Confirmed
>>
>> Bug description:
>> After discussion with Baron, we should change names of following
>> variables in 5.5:
>>
>> INNODB_
>> to
>> innodb_
>>
>> INNODB_
>> to
>> innodb_
>>
>> INNODB_
>> to
>> innodb_
>>
>> INNODB_
>> to
>> innodb_
>>
>> And next status variables:
>> > INNODB_
>> > INNODB_
>> > INNODB_
>>
>> Should be
>> INNODB_
>> INNODB_
>> INNODB_
>>
>
>
> --
> Peter Zaitsev, CEO, Percona Inc.
> Tel: +1 888 401 3401 ext 501 Skype: peter_zaitsev
> 24/7 Emergency Line +1 888 401 3401 ext 911
>
> Looking for MySQL Support ?
> http://
>
> --
> You received this bug notification because you are a direct subscriber
> of the bug.
> https:/
>
> Title:
> Change XtraDB variables in 5.5
>
> Status in Percona Server with XtraDB:
> Won't Fix
> Status in Percona Server 5.5 series:
> Confirmed
>
> Bug description:
> After discussion with Baron, we should change names of following
> variables in 5.5:
>
> INNODB_
> to
> innodb_
>
> INNODB_
> to
> innodb_
>
> INNODB_
> to
> innodb_
>
> INNODB_
> to
> innodb_
>
> And next status variables:
> > INNODB_
> > INNODB_
> > INNODB_
>
> Should be
> INNODB_
> INNODB_
> INNODB_
>
...
Peter Zaitsev (pz-percona) wrote : | #15 |
Is error printed in error log in this case ?
I'm trying to figure out if "warn" is appropritate or do we need something
else ?
On Sun, Mar 6, 2011 at 5:04 PM, Vadim Tkachenko <email address hidden> wrote:
> Peter
>
> Idea is that table is inaccessible and query just returns error.
>
>
> On Sun, Mar 6, 2011 at 4:54 PM, Peter Zaitsev <email address hidden> wrote:
> > Baron, Vadim
> >
> > BTW what exactly happens now when you use "pass_corrupt_
> > abort given query with error message ?
> > Does table become inaccessible until MySQL restart or does itbecome read
> > only ?
> >
> > On Sun, Mar 6, 2011 at 11:59 AM, Xaprb <email address hidden> wrote:
> >
> >> Here are my final suggestions. After this I can only say "see my many
> >> previous suggestions and my reasons for them" :-)
> >>
> >> Change INNODB_
> >> Change INNODB_
> >> (NOTE this is different from Peter's suggestion, which I think is
> >> confusing)
> >> Change INNODB_
> innodb_
> >> Change INNODB_
> innodb_
> >> (NOTE: standard InnoDB's behavior is "assert" and this should be the
> >> default)
> >>
> >> --
> >> You received this bug notification because you are a member of Percona
> >> developers, which is the registrant for Percona Server.
> >> https:/
> >>
> >> Title:
> >> Change XtraDB variables in 5.5
> >>
> >> Status in Percona Server with XtraDB:
> >> Won't Fix
> >> Status in Percona Server 5.5 series:
> >> Confirmed
> >>
> >> Bug description:
> >> After discussion with Baron, we should change names of following
> >> variables in 5.5:
> >>
> >> INNODB_
> >> to
> >> innodb_
> >>
> >> INNODB_
> >> to
> >> innodb_
> >>
> >> INNODB_
> >> to
> >> innodb_
> >>
> >> INNODB_
> >> to
> >> innodb_
> >>
> >> And next status variables:
> >> > INNODB_
> >> > INNODB_
> >> > INNODB_
> >>
> >> Should be
> >> INNODB_
> >> INNODB_
> >> INNODB_
> >>
> >
> >
> > --
> > Peter Zaitsev, CEO, Percona Inc.
> > Tel: +1 888 401 3401 ext 501 Skype: peter_zaitsev
> > 24/7 Emergency Line +1 888 401 3401 ext 911
> >
> > Looking for MySQL Support ?
> > http://
> >
> > --
> > You received this bug notification because you are a direct subscriber
> > of the bug.
> > https:/
> >
> > Title:
> > Change XtraDB variables in 5.5
> >
> > Status in Percona Server with XtraDB:
> > Won't Fix
> > Status in Percona Server 5.5 series:
> > Confirmed
> >
> > Bug description:
> > After discussion with Baron, we should change names of following
> > variables in 5.5:
> >
> > INNODB_
> > to
> > innodb_
> >
> > INNODB_
> > to
> > innodb_
Vadim Tkachenko (vadim-tk) wrote : | #16 |
Yes, There should be corresponding error in error log.
On Sun, Mar 6, 2011 at 5:52 PM, Peter Zaitsev <email address hidden> wrote:
> Is error printed in error log in this case ?
>
> I'm trying to figure out if "warn" is appropritate or do we need something
> else ?
>
> On Sun, Mar 6, 2011 at 5:04 PM, Vadim Tkachenko <email address hidden> wrote:
>>
>> Peter
>>
>> Idea is that table is inaccessible and query just returns error.
>>
>>
>> On Sun, Mar 6, 2011 at 4:54 PM, Peter Zaitsev <email address hidden> wrote:
>> > Baron, Vadim
>> >
>> > BTW what exactly happens now when you use "pass_corrupt_
>> > abort given query with error message ?
>> > Does table become inaccessible until MySQL restart or does itbecome read
>> > only ?
>> >
>> > On Sun, Mar 6, 2011 at 11:59 AM, Xaprb <email address hidden> wrote:
>> >
>> >> Here are my final suggestions. After this I can only say "see my many
>> >> previous suggestions and my reasons for them" :-)
>> >>
>> >> Change INNODB_
>> >> Change INNODB_
>> >> (NOTE this is different from Peter's suggestion, which I think is
>> >> confusing)
>> >> Change INNODB_
>> >> innodb_
>> >> Change INNODB_
>> >> innodb_
>> >> (NOTE: standard InnoDB's behavior is "assert" and this should be the
>> >> default)
>> >>
>> >> --
>> >> You received this bug notification because you are a member of Percona
>> >> developers, which is the registrant for Percona Server.
>> >> https:/
>> >>
>> >> Title:
>> >> Change XtraDB variables in 5.5
>> >>
>> >> Status in Percona Server with XtraDB:
>> >> Won't Fix
>> >> Status in Percona Server 5.5 series:
>> >> Confirmed
>> >>
>> >> Bug description:
>> >> After discussion with Baron, we should change names of following
>> >> variables in 5.5:
>> >>
>> >> INNODB_
>> >> to
>> >> innodb_
>> >>
>> >> INNODB_
>> >> to
>> >> innodb_
>> >>
>> >> INNODB_
>> >> to
>> >> innodb_
>> >>
>> >> INNODB_
>> >> to
>> >> innodb_
>> >>
>> >> And next status variables:
>> >> > INNODB_
>> >> > INNODB_
>> >> > INNODB_
>> >>
>> >> Should be
>> >> INNODB_
>> >> INNODB_
>> >> INNODB_
>> >>
>> >
>> >
>> > --
>> > Peter Zaitsev, CEO, Percona Inc.
>> > Tel: +1 888 401 3401 ext 501 Skype: peter_zaitsev
>> > 24/7 Emergency Line +1 888 401 3401 ext 911
>> >
>> > Looking for MySQL Support ?
>> > http://
>> >
>> > --
>> > You received this bug notification because you are a direct subscriber
>> > of the bug.
>> > https:/
>> >
>> > Title:
>> > Change XtraDB variables in 5.5
>> >
>> > Status in Percona Server with XtraDB:
>> > Won't Fix
>> > Status in Percona Server 5.5 series:
>> > Confirmed
>> >
>> > Bug descri...
Peter Zaitsev (pz-percona) wrote : | #17 |
Then Warn is good :)
On Sun, Mar 6, 2011 at 5:53 PM, Vadim Tkachenko <email address hidden> wrote:
> Yes, There should be corresponding error in error log.
>
>
> On Sun, Mar 6, 2011 at 5:52 PM, Peter Zaitsev <email address hidden> wrote:
> > Is error printed in error log in this case ?
> >
> > I'm trying to figure out if "warn" is appropritate or do we need
> something
> > else ?
> >
> > On Sun, Mar 6, 2011 at 5:04 PM, Vadim Tkachenko <email address hidden>
> wrote:
> >>
> >> Peter
> >>
> >> Idea is that table is inaccessible and query just returns error.
> >>
> >>
> >> On Sun, Mar 6, 2011 at 4:54 PM, Peter Zaitsev <email address hidden> wrote:
> >> > Baron, Vadim
> >> >
> >> > BTW what exactly happens now when you use "pass_corrupt_
> we
> >> > abort given query with error message ?
> >> > Does table become inaccessible until MySQL restart or does itbecome
> read
> >> > only ?
> >> >
> >> > On Sun, Mar 6, 2011 at 11:59 AM, Xaprb <email address hidden> wrote:
> >> >
> >> >> Here are my final suggestions. After this I can only say "see my
> many
> >> >> previous suggestions and my reasons for them" :-)
> >> >>
> >> >> Change INNODB_
> >> >> Change INNODB_
> >> >> (NOTE this is different from Peter's suggestion, which I think is
> >> >> confusing)
> >> >> Change INNODB_
> >> >> innodb_
> >> >> Change INNODB_
> >> >> innodb_
> >> >> (NOTE: standard InnoDB's behavior is "assert" and this should be the
> >> >> default)
> >> >>
> >> >> --
> >> >> You received this bug notification because you are a member of
> Percona
> >> >> developers, which is the registrant for Percona Server.
> >> >> https:/
> >> >>
> >> >> Title:
> >> >> Change XtraDB variables in 5.5
> >> >>
> >> >> Status in Percona Server with XtraDB:
> >> >> Won't Fix
> >> >> Status in Percona Server 5.5 series:
> >> >> Confirmed
> >> >>
> >> >> Bug description:
> >> >> After discussion with Baron, we should change names of following
> >> >> variables in 5.5:
> >> >>
> >> >> INNODB_
> >> >> to
> >> >> innodb_
> >> >>
> >> >> INNODB_
> >> >> to
> >> >> innodb_
> >> >>
> >> >> INNODB_
> >> >> to
> >> >> innodb_
> >> >>
> >> >> INNODB_
> >> >> to
> >> >> innodb_
> >> >>
> >> >> And next status variables:
> >> >> > INNODB_
> >> >> > INNODB_
> >> >> > INNODB_
> >> >>
> >> >> Should be
> >> >> INNODB_
> >> >> INNODB_
> >> >> INNODB_
> >> >>
> >> >
> >> >
> >> > --
> >> > Peter Zaitsev, CEO, Percona Inc.
> >> > Tel: +1 888 401 3401 ext 501 Skype: peter_zaitsev
> >> > 24/7 Emergency Line +1 888 401 3401 ext 911
> >> >
> >> > Looking for MySQL Support ?
> >> > http://
> >> >
> >> > --
> >> > You received this bug notifica...
Yasufumi Kinoshita (yasufumi-kinoshita) wrote : | #18 |
Thank you, Baron.
They are also OK for me.
I will fix soon.
Xaprb wrote:
> Here are my final suggestions. After this I can only say "see my many
> previous suggestions and my reasons for them" :-)
>
> Change INNODB_
> Change INNODB_
> (NOTE this is different from Peter's suggestion, which I think is confusing)
> Change INNODB_
> Change INNODB_
> (NOTE: standard InnoDB's behavior is "assert" and this should be the default)
>
Fred Linhoss (fred-linhoss) wrote : | #19 |
Documentation changes:
Pages changed:
http://
http://
http://
http://
Indexes updated (added 4 system variables):
http://
http://
Peter Zaitsev (pz-percona) wrote : | #20 |
Fred,
Do we really want to have page named "innod_
was renamed ?
Should not we redirect the page to the one with new name and explain it was
the old name ?
On Wed, Mar 9, 2011 at 8:07 AM, Fred Linhoss <email address hidden>wrote:
> Documentation changes:
>
> Pages changed:
>
> http://
>
> http://
>
> http://
>
> http://
>
> Indexes updated (added 4 system variables):
>
> http://
>
> http://
>
> --
> You received this bug notification because you are a member of Percona
> developers, which is the registrant for Percona Server.
> https:/
>
> Title:
> Change XtraDB variables in 5.5
>
> Status in Percona Server with XtraDB:
> Won't Fix
> Status in Percona Server 5.5 series:
> Fix Committed
>
> Bug description:
> After discussion with Baron, we should change names of following
> variables in 5.5:
>
> INNODB_
> to
> innodb_
>
> INNODB_
> to
> innodb_
>
> INNODB_
> to
> innodb_
>
> INNODB_
> to
> innodb_
>
> And next status variables:
> > INNODB_
> > INNODB_
> > INNODB_
>
> Should be
> INNODB_
> INNODB_
> INNODB_
>
--
Peter Zaitsev, CEO, Percona Inc.
Tel: +1 888 401 3401 ext 501 Skype: peter_zaitsev
24/7 Emergency Line +1 888 401 3401 ext 911
Looking for MySQL Support ?
http://
Shahriyar Rzayev (rzayev-sehriyar) wrote : | #21 |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/
Basically, you should explain reasons.
I don't accept wrong constitute names and cheating user names.
> INNODB_ AUTO_LRU_ DUMP enable_ fast_warmup
> to
> innodb_
fast? warmup?
I don't like to cheat users. It is really not concrete name.
The name should express the effect cleanly.
> INNODB_ EXPAND_ IMPORT enable_ import_ tables
> to
> innodb_
"IMPORT TABLE" is supported basically. It is wrong name.
> INNODB_ OVERWRITE_ RELAY_LOG_ INFO provide_ replication_ position
> to
> innodb_
I don't like to cheat users. It is really not concrete name.
The name should express the effect cleanly.
> INNODB_ PASS_CORRUPT_ TABLE stop_on_ corrupt_ table=0| 1 ( default is 1)
> Rename to innodb_
The user should understand passing corrupt table is abnormal for RDBMS...
It may not the problem only about the table.
,as I described before.
InnoDB should abort for all corruption detections.
You should explain the abnormal name for me, again.
You didn't explain any at the previous report.
I don't accept one-side intrusion...
> And next status variables: CHECKPOINT_ AGE CHECKPOINT_ MAX_AGE CHECKPOINT_ TARGET_ AGE CHECKPOINT_ AGE CHECKPOINT_ AGE_MAX CHECKPOINT_ AGE_TARGET
>> INNODB_
>> INNODB_
>> INNODB_
>
> Should be
> INNODB_
> INNODB_
> INNODB_
I intended that
values about checkpoint
"age", "max age" and "target age".