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: | |
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 |
[1 Feb 2010 19:27]
Paul DuBois
[1 Feb 2010 19:40]
Sveta Smirnova
Thank you for the report. Verified as described.
[17 Feb 2010 11:47]
Andrei Elkin
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.
[17 Feb 2010 17:58]
Andrei Elkin
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.
[17 Feb 2010 18:03]
Andrei Elkin
Correction, the last line | MASTER_SSL_CIPHER = 'cipher_list' is not for a path. MASTER_SSL_CIPHER list length is bound to be <= 511.
[24 Feb 2010 19:32]
Paul DuBois
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.