Description:
--ndb-wait-connected and --ndb-wait-setup options do not appear to set any MySQL system variables.
Note that --ndb-wait-connected has been documented as setting a corresponding system variable since it was introduced.
How to repeat:
jon@grindval:~/bin/mysql-5.1-telco-7.0/bin> ./mysqld_safe --ndbcluster --ndb-connectstring=127.0.0.1 --ndb-wait-setup=100 --ndb-wait-connected=100 &
[1] 11079
jon@grindval:~/bin/mysql-5.1-telco-7.0/bin> 091029 11:49:58 mysqld_safe Logging to '/home/jon/bin/mysql-5.1-telco-7.0/var/grindval.err'.
091029 11:49:58 mysqld_safe Starting mysqld daemon with databases from /home/jon/bin/mysql-5.1-telco-7.0/var
jon@grindval:~/bin/mysql-5.1-telco-7.0/bin> ./mysql -uroot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.39-ndb-7.0.9 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show variables like 'ndb%';
+-------------------------------------+-----------+
| Variable_name | Value |
+-------------------------------------+-----------+
| ndb_autoincrement_prefetch_sz | 1 |
| ndb_batch_size | 32768 |
| ndb_cache_check_time | 0 |
| ndb_connectstring | 127.0.0.1 |
| ndb_extra_logging | 1 |
| ndb_force_send | ON |
| ndb_index_stat_cache_entries | 32 |
| ndb_index_stat_enable | OFF |
| ndb_index_stat_update_freq | 20 |
| ndb_log_binlog_index | ON |
| ndb_log_update_as_write | ON |
| ndb_log_updated_only | ON |
| ndb_optimization_delay | 10 |
| ndb_optimized_node_selection | 3 |
| ndb_report_thresh_binlog_epoch_slip | 3 |
| ndb_report_thresh_binlog_mem_usage | 10 |
| ndb_table_no_logging | OFF |
| ndb_table_temporary | OFF |
| ndb_use_copying_alter_table | OFF |
| ndb_use_exact_count | OFF |
| ndb_use_transactions | ON |
+-------------------------------------+-----------+
21 rows in set (0.00 sec)
mysql> show status like 'ndb%';
+--------------------------------+-----------+
| Variable_name | Value |
+--------------------------------+-----------+
| Ndb_cluster_node_id | 20 |
| Ndb_config_from_host | 127.0.0.1 |
| Ndb_config_from_port | 1186 |
| Ndb_number_of_data_nodes | 2 |
| Ndb_number_of_ready_data_nodes | 2 |
| Ndb_connect_count | 0 |
| Ndb_execute_count | 0 |
| Ndb_scan_count | 0 |
| Ndb_pruned_scan_count | 0 |
| Ndb_cluster_connection_pool | 1 |
| Ndb_conflict_fn_max | 0 |
| Ndb_conflict_fn_old | 0 |
+--------------------------------+-----------+
12 rows in set (0.00 sec)
mcm> exit
Bye
jon@grindval:~/bin/mysql-5.1-telco-7.0/bin> ./ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 @127.0.0.1 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0, Master)
id=2 @127.0.0.1 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=10 @127.0.0.1 (mysql-5.1.39 ndb-7.0.9)
[mysqld(API)] 2 node(s)
id=20 @127.0.0.1 (mysql-5.1.39 ndb-7.0.9)
id=21 (not connected, accepting connect from any host)
Suggested fix:
These options should set variables that are visible in the output of SHOW VARIABLES in the mysql client.
Due to the nature of these options, the MySQL system variables should IMO probably not be dynamic.
