Bug #68967 The server option 'server_id_bits' does not appear to be documented in 5.6

• Submitted: 15 Apr 2013 23:39
• Modified: 19 Apr 2013 17:19
• Reporter: Justin Swanhart
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• OS: Any
• Assigned to: Paul DuBois
• CPU Architecture: Any

[15 Apr 2013 23:39] Justin Swanhart

Description:
mysql> show global variables like '%bits%';
+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| server_id_bits | 32    |
+----------------+-------+
1 row in set (0.01 sec)

mysql> select @@version;
+------------+
| @@version  |
+------------+
| 5.6.10-log |
+------------+
1 row in set (0.00 sec)

How to repeat:
Try to find the 5.6 documentation on server_id_bits.

Suggested fix:
Document server_id_bits.

[16 Apr 2013 0:54] MySQL Verification Team

Thank you for the bug report. It's mentioned here:

http://dev.mysql.com/doc/refman/5.6/en/server-parameters.html

8.11.2. Tuning Server Parameters

server-id                                                  0
server-id-bits                                             32
sha256-password-private-key-path                           private_key.pem

However I wasn't unable to find more info about it.

[19 Apr 2013 17:19] Paul DuBois

It's a Cluster system variable, related to --server-id-bits. They're both listed on these pages:

http://dev.mysql.com/doc/refman/5.6/en/mysqld-option-tables.html
http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html

Direct link:
http://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-system-variables.html#sysvar_server_i...