maria-discuss team mailing list archive

[Elena Stepanova <elenst@xxxxxxxxxxxxxxxx>]

Hi Ian, Pantelis,

What MySQL docs say is true, however confusing.
The value was switched ON in early versions of MySQL 5.5; caused some 
problems; was switched back to OFF in 5.5.7; stayed OFF in all further 
5.5 releases and early releases of 5.6; and was switched ON from 5.6.6.

For MariaDB it's a bit simpler for 5.5 and more complicated for 10.0.

As Ian said the first release was 5.5.20, so in MariaDB 5.5 it's just 
OFF by default.

In 10.0, it was OFF in 10.0.0-10.0.3; from 10.0.4, where InnoDB 5.6.10 
was merged, it was ON for the the InnoDB plugin (which was the default 
InnoDB then) but still OFF for XtraDB; and later when XtraDB was 
upgraded, it became ON for it too. All in all, in 10.0.10 which was the 
first GA release, it was already ON for both flavors, as it is now.

Regards,
Elena



On 08.05.2015 11:04, Ian Gilfillan wrote:
> Although the first MariaDB 5.5 release was 5.5.20... Anyway, fixed in
> the docs now, thanks for the report.
>
>
> On 08/05/2015 09:50, Ian Gilfillan wrote:
> > You're right that ON and OFF are switched around. I'll double check
> > the version that this changed - the 5.5 version of the MySQL docs at
> > http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_file_per_table
> > also say that this was changed in 5.5.7 (so it was probably changed in
> > both MySQL 5.5.7 and 5.6.6), but I'll check the MariaDB diffs to be sure.
> >
> > Sending to this list is fine, although there's also a docs-specific
> > list: maria-docs@xxxxxxxxxxxxxxxxxxx
> >
> > ian
> >
> > On 08/05/2015 01:50, Pantelis Theodosiou wrote:
> > > I was looking for the default setting of this variable and the
> > > MariaDB documentation
> > > <https://mariadb.com/kb/en/mariadb/xtradbinnodb-server-system-variables/#innodb_file_per_table>
> > > has:
> > >
> > > > *Default Value:* |OFF| (>= MariaDB/MySQL 5.5.7), |ON|
> > > (MariaDB/MySQL 5.5.0 to 5.5.6)
> > >
> > > while MySQL documentation
> > > <http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_file_per_table>
> > > has (I think correctly):
> > >
> > > *Permitted Values* (<= 5.6.5)*
> > > Type*|boolean|*Default *|OFF
> > >
> > > |*Permitted Values* (>= 5.6.6)
> > > *Type *|boolean|*  Default *|ON
> > >
> > > |
> > > |So, I see two issues:
> > > - first, the changing version is 5.6.6 (not 5.5.7), at least in
> > > MySQL, and
> > > - second, the values OFF / ON in the Maria documentation are reversed.
> > >
> > > |
> > > |Apologies if this is not the correct list to raise the issue.
> > >
> > >
> > > |
> > > |Pantelis Theodosiou
> > > |
> > > |
> > > |
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp