[Maria-discuss] innodb_file_per_table default setting in the online documentation
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
Thanks Pantelis 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_... 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@lists.launchpad.net 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 | | |
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_... 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@lists.launchpad.net
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 | | |
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_... 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@lists.launchpad.net
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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (3)
-
Elena Stepanova -
Ian Gilfillan -
Pantelis Theodosiou