MySQL Bugs: #50800: CHANGE MASTER TO page needs max length for several options

Bug #50800	CHANGE MASTER TO page needs max length for several options
Submitted:	1 Feb 2010 19:27	Modified:	24 Feb 2010 19:32
Reporter:	Paul DuBois	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.0, 5.1, 5.5.99 +	OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
At the end of the CHANGE MASTER TO page (http://dev.mysql.com/doc/refman/5.5/en/change-master-to.html), there is a table that lists the maximum allowable length for a few of the string-valued options. However, there are many string-valued options, so this table is incomplete. Also, for 5.5 and up, there is an IGNORE_SERVER_IDS option that takes a list of server IDs; what is the maximum number of values that can be specified in this list?

How to repeat:
Add max-length values for remaining string-valued options.

Add max size of server ID list.

Thank you for the report.

Verified as described.

Paul, internal placeholder for the ignored servers list is
DYNAMIC_ARRAY ignore_server_ids;
There is nothing in the sources that sets a limit on the max size of the list,
except the DYNAMIC_ARRAY declaration
 typedef struct st_dynamic_array
  ...
  uint elements, max_element;

where `elements' is the counter of the array's items.

That must answer your question still platform-dependently.

cheers.

About the incomplete table.
The string-valued options consists of the complete part

    MASTER_HOST = 'host_name'
  | MASTER_USER = 'user_name'
  | MASTER_PASSWORD = 'password'
  | MASTER_LOG_FILE = 'master_log_name'

  [confirming the above group values are correct]
  

And the incomplete

  | RELAY_LOG_FILE = 'relay_log_name'
  | MASTER_SSL_CA = 'ca_file_name'
  | MASTER_SSL_CAPATH = 'ca_directory_name'
  | MASTER_SSL_CERT = 'cert_file_name'
  | MASTER_SSL_KEY = 'key_file_name'
  | MASTER_SSL_CIPHER = 'cipher_list'

All options have meaning of the file path, incl MASTER_SSL_CAPATH 
that is a path to a directory.
Since the path can be given in the abs and the relative format 
there is a conservative estimate on the file name len which is
255, that is the same as for MASTER_LOG_FILE.

Correction, the last line

  | MASTER_SSL_CIPHER = 'cipher_list'

is not for a path. MASTER_SSL_CIPHER list length is bound to be <= 511.

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.