set_var.cc 98.5 KB
Newer Older
1
/* Copyright (C) 2000-2003 MySQL AB
unknown's avatar
unknown committed
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; either version 2 of the License, or
   (at your option) any later version.

   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.

   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */

/*
  Handling of MySQL SQL variables

  To add a new variable, one has to do the following:

  - Use one of the 'sys_var... classes from set_var.h or write a specific
    one for the variable type.
  - Define it in the 'variable definition list' in this file.
25 26
  - If the variable should be changeable or one should be able to access it
    with @@variable_name, it should be added to the 'list of all variables'
unknown's avatar
unknown committed
27 28 29
    list (sys_variables) in this file.
  - If the variable is thread specific, add it to 'system_variables' struct.
    If not, add it to mysqld.cc and an declaration in 'mysql_priv.h'
unknown's avatar
unknown committed
30 31
  - If the variable should be changed from the command line, add a definition
    of it in the my_option structure list in mysqld.dcc
unknown's avatar
unknown committed
32 33
  - Don't forget to initialize new fields in global_system_variables and
    max_system_variables!
unknown's avatar
unknown committed
34 35 36
  - If the variable should show up in 'show variables' add it to the
    init_vars[] struct in this file

37 38 39 40 41 42
  NOTES:
    - Be careful with var->save_result: sys_var::check() only updates
    ulonglong_value; so other members of the union are garbage then; to use
    them you must first assign a value to them (in specific ::check() for
    example).

unknown's avatar
unknown committed
43 44 45 46 47 48 49 50 51 52 53 54 55
  TODO:
    - Add full support for the variable character_set (for 4.1)

    - When updating myisam_delay_key_write, we should do a 'flush tables'
      of all MyISAM tables to ensure that they are reopen with the
      new attribute.
*/

#ifdef __GNUC__
#pragma implementation				// gcc: Class implementation
#endif

#include "mysql_priv.h"
56
#include <mysql.h>
unknown's avatar
unknown committed
57 58 59
#include "slave.h"
#include "sql_acl.h"
#include <my_getopt.h>
60
#include <thr_alarm.h>
unknown's avatar
unknown committed
61 62 63 64 65 66 67
#include <myisam.h>
#ifdef HAVE_BERKELEY_DB
#include "ha_berkeley.h"
#endif
#ifdef HAVE_INNOBASE_DB
#include "ha_innodb.h"
#endif
unknown's avatar
unknown committed
68 69 70
#ifdef HAVE_NDBCLUSTER_DB
#include "ha_ndbcluster.h"
#endif
unknown's avatar
unknown committed
71 72 73 74 75

static HASH system_variable_hash;
const char *bool_type_names[]= { "OFF", "ON", NullS };
TYPELIB bool_typelib=
{
76
  array_elements(bool_type_names)-1, "", bool_type_names, NULL
unknown's avatar
unknown committed
77 78
};

79 80 81
const char *delay_key_write_type_names[]= { "OFF", "ON", "ALL", NullS };
TYPELIB delay_key_write_typelib=
{
82 83
  array_elements(delay_key_write_type_names)-1, "",
  delay_key_write_type_names, NULL
84 85
};

86
static int  sys_check_charset(THD *thd, set_var *var);
unknown's avatar
unknown committed
87 88
static bool sys_update_charset(THD *thd, set_var *var);
static void sys_set_default_charset(THD *thd, enum_var_type type);
89
static int  sys_check_ftb_syntax(THD *thd,  set_var *var);
unknown's avatar
unknown committed
90 91
static bool sys_update_ftb_syntax(THD *thd, set_var * var);
static void sys_default_ftb_syntax(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
92 93 94 95
static bool sys_update_init_connect(THD*, set_var*);
static void sys_default_init_connect(THD*, enum_var_type type);
static bool sys_update_init_slave(THD*, set_var*);
static void sys_default_init_slave(THD*, enum_var_type type);
unknown's avatar
unknown committed
96 97
static bool set_option_bit(THD *thd, set_var *var);
static bool set_option_autocommit(THD *thd, set_var *var);
98
static int  check_log_update(THD *thd, set_var *var);
unknown's avatar
unknown committed
99
static bool set_log_update(THD *thd, set_var *var);
100
static int  check_pseudo_thread_id(THD *thd, set_var *var);
unknown's avatar
unknown committed
101 102 103 104
static void fix_low_priority_updates(THD *thd, enum_var_type type);
static void fix_tx_isolation(THD *thd, enum_var_type type);
static void fix_net_read_timeout(THD *thd, enum_var_type type);
static void fix_net_write_timeout(THD *thd, enum_var_type type);
105
static void fix_net_retry_count(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
106 107
static void fix_max_join_size(THD *thd, enum_var_type type);
static void fix_query_cache_size(THD *thd, enum_var_type type);
108
static void fix_query_cache_min_res_unit(THD *thd, enum_var_type type);
109 110
static void fix_myisam_max_extra_sort_file_size(THD *thd, enum_var_type type);
static void fix_myisam_max_sort_file_size(THD *thd, enum_var_type type);
111 112
static void fix_max_binlog_size(THD *thd, enum_var_type type);
static void fix_max_relay_log_size(THD *thd, enum_var_type type);
113
static void fix_max_connections(THD *thd, enum_var_type type);
114
static int check_max_delayed_threads(THD *thd, set_var *var);
115 116
static void fix_thd_mem_root(THD *thd, enum_var_type type);
static void fix_trans_mem_root(THD *thd, enum_var_type type);
117
static void fix_server_id(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
118
static KEY_CACHE *create_key_cache(const char *name, uint length);
119
void fix_sql_mode_var(THD *thd, enum_var_type type);
120 121
static byte *get_error_count(THD *thd);
static byte *get_warning_count(THD *thd);
unknown's avatar
unknown committed
122 123 124 125 126 127 128 129 130 131 132 133

/*
  Variable definition list

  These are variables that can be set from the command line, in
  alphabetic order
*/

sys_var_long_ptr	sys_binlog_cache_size("binlog_cache_size",
					      &binlog_cache_size);
sys_var_thd_ulong	sys_bulk_insert_buff_size("bulk_insert_buffer_size",
						  &SV::bulk_insert_buff_size);
134 135
sys_var_character_set_server	sys_character_set_server("character_set_server");
sys_var_str			sys_charset_system("character_set_system",
136 137
				    sys_check_charset,
				    sys_update_charset,
138 139
				    sys_set_default_charset,
                                    (char *)my_charset_utf8_general_ci.name);
140
sys_var_character_set_database	sys_character_set_database("character_set_database");
141
sys_var_character_set_client  sys_character_set_client("character_set_client");
unknown's avatar
unknown committed
142
sys_var_character_set_connection  sys_character_set_connection("character_set_connection");
143
sys_var_character_set_results sys_character_set_results("character_set_results");
unknown's avatar
unknown committed
144
sys_var_collation_connection sys_collation_connection("collation_connection");
145 146
sys_var_collation_database sys_collation_database("collation_database");
sys_var_collation_server sys_collation_server("collation_server");
unknown's avatar
unknown committed
147 148 149 150
sys_var_bool_ptr	sys_concurrent_insert("concurrent_insert",
					      &myisam_concurrent_insert);
sys_var_long_ptr	sys_connect_timeout("connect_timeout",
					    &connect_timeout);
151 152 153 154
sys_var_enum		sys_delay_key_write("delay_key_write",
					    &delay_key_write_options,
					    &delay_key_write_typelib,
					    fix_delay_key_write);
unknown's avatar
unknown committed
155 156 157 158 159 160
sys_var_long_ptr	sys_delayed_insert_limit("delayed_insert_limit",
						 &delayed_insert_limit);
sys_var_long_ptr	sys_delayed_insert_timeout("delayed_insert_timeout",
						   &delayed_insert_timeout);
sys_var_long_ptr	sys_delayed_queue_size("delayed_queue_size",
					       &delayed_queue_size);
unknown's avatar
unknown committed
161 162
sys_var_long_ptr	sys_expire_logs_days("expire_logs_days",
					     &expire_logs_days);
unknown's avatar
unknown committed
163 164
sys_var_bool_ptr	sys_flush("flush", &myisam_flush);
sys_var_long_ptr	sys_flush_time("flush_time", &flush_time);
unknown's avatar
unknown committed
165 166 167
sys_var_str             sys_ft_boolean_syntax("ft_boolean_syntax",
                                         sys_check_ftb_syntax,
                                         sys_update_ftb_syntax,
168 169
                                         sys_default_ftb_syntax,
                                         ft_boolean_syntax);
unknown's avatar
unknown committed
170 171
sys_var_str             sys_init_connect("init_connect", 0,
                                         sys_update_init_connect,
172
                                         sys_default_init_connect,0);
unknown's avatar
unknown committed
173 174
sys_var_str             sys_init_slave("init_slave", 0,
                                       sys_update_init_slave,
175
                                       sys_default_init_slave,0);
unknown's avatar
unknown committed
176 177 178 179
sys_var_thd_ulong	sys_interactive_timeout("interactive_timeout",
						&SV::net_interactive_timeout);
sys_var_thd_ulong	sys_join_buffer_size("join_buffer_size",
					     &SV::join_buff_size);
180
sys_var_key_buffer_size	sys_key_buffer_size("key_buffer_size");
181
sys_var_key_cache_long  sys_key_cache_block_size("key_cache_block_size",
unknown's avatar
unknown committed
182 183
						 offsetof(KEY_CACHE,
							  param_block_size));
184
sys_var_key_cache_long	sys_key_cache_division_limit("key_cache_division_limit",
unknown's avatar
unknown committed
185 186
						     offsetof(KEY_CACHE,
							      param_division_limit));
187
sys_var_key_cache_long  sys_key_cache_age_threshold("key_cache_age_threshold",
unknown's avatar
unknown committed
188 189
						     offsetof(KEY_CACHE,
							      param_age_threshold));
unknown's avatar
unknown committed
190 191
sys_var_bool_ptr	sys_local_infile("local_infile",
					 &opt_local_infile);
192
sys_var_thd_ulong	sys_log_warnings("log_warnings", &SV::log_warnings);
unknown's avatar
unknown committed
193 194 195 196 197 198 199 200 201 202 203 204 205 206 207
sys_var_thd_ulong	sys_long_query_time("long_query_time",
					     &SV::long_query_time);
sys_var_thd_bool	sys_low_priority_updates("low_priority_updates",
						 &SV::low_priority_updates,
						 fix_low_priority_updates);
#ifndef TO_BE_DELETED	/* Alias for the low_priority_updates */
sys_var_thd_bool	sys_sql_low_priority_updates("sql_low_priority_updates",
						     &SV::low_priority_updates,
						     fix_low_priority_updates);
#endif
sys_var_thd_ulong	sys_max_allowed_packet("max_allowed_packet",
					       &SV::max_allowed_packet);
sys_var_long_ptr	sys_max_binlog_cache_size("max_binlog_cache_size",
						  &max_binlog_cache_size);
sys_var_long_ptr	sys_max_binlog_size("max_binlog_size",
208 209
					    &max_binlog_size,
                                            fix_max_binlog_size);
unknown's avatar
unknown committed
210
sys_var_long_ptr	sys_max_connections("max_connections",
211 212
					    &max_connections,
                                            fix_max_connections);
unknown's avatar
unknown committed
213 214
sys_var_long_ptr	sys_max_connect_errors("max_connect_errors",
					       &max_connect_errors);
215
sys_var_thd_ulong       sys_max_insert_delayed_threads("max_insert_delayed_threads",
216 217 218
						       &SV::max_insert_delayed_threads,
                                                       check_max_delayed_threads,
                                                       fix_max_connections);
219 220
sys_var_thd_ulong	sys_max_delayed_threads("max_delayed_threads",
						&SV::max_insert_delayed_threads,
221 222
                                                check_max_delayed_threads,
                                                fix_max_connections);
223 224
sys_var_thd_ulong	sys_max_error_count("max_error_count",
					    &SV::max_error_count);
unknown's avatar
unknown committed
225 226
sys_var_thd_ulong	sys_max_heap_table_size("max_heap_table_size",
						&SV::max_heap_table_size);
227 228 229
sys_var_thd_ulong       sys_pseudo_thread_id("pseudo_thread_id",
					     &SV::pseudo_thread_id,
                                             check_pseudo_thread_id, 0);
230
sys_var_thd_ha_rows	sys_max_join_size("max_join_size",
unknown's avatar
unknown committed
231 232
					  &SV::max_join_size,
					  fix_max_join_size);
233 234
sys_var_thd_ulong	sys_max_seeks_for_key("max_seeks_for_key",
					      &SV::max_seeks_for_key);
unknown's avatar
unknown committed
235
sys_var_thd_ulong   sys_max_length_for_sort_data("max_length_for_sort_data",
236
                                                 &SV::max_length_for_sort_data);
unknown's avatar
unknown committed
237
#ifndef TO_BE_DELETED	/* Alias for max_join_size */
238
sys_var_thd_ha_rows	sys_sql_max_join_size("sql_max_join_size",
unknown's avatar
unknown committed
239 240 241
					      &SV::max_join_size,
					      fix_max_join_size);
#endif
242 243 244
sys_var_long_ptr	sys_max_relay_log_size("max_relay_log_size",
                                               &max_relay_log_size,
                                               fix_max_relay_log_size);
unknown's avatar
unknown committed
245 246 247 248 249 250 251 252
sys_var_thd_ulong	sys_max_sort_length("max_sort_length",
					    &SV::max_sort_length);
sys_var_long_ptr	sys_max_user_connections("max_user_connections",
						 &max_user_connections);
sys_var_thd_ulong	sys_max_tmp_tables("max_tmp_tables",
					   &SV::max_tmp_tables);
sys_var_long_ptr	sys_max_write_lock_count("max_write_lock_count",
						 &max_write_lock_count);
unknown's avatar
unknown committed
253 254
sys_var_long_ptr	sys_myisam_data_pointer_size("myisam_data_pointer_size",
                                                    &myisam_data_pointer_size);
255 256
sys_var_thd_ulonglong	sys_myisam_max_extra_sort_file_size("myisam_max_extra_sort_file_size", &SV::myisam_max_extra_sort_file_size, fix_myisam_max_extra_sort_file_size, 1);
sys_var_thd_ulonglong	sys_myisam_max_sort_file_size("myisam_max_sort_file_size", &SV::myisam_max_sort_file_size, fix_myisam_max_sort_file_size, 1);
257
sys_var_thd_ulong       sys_myisam_repair_threads("myisam_repair_threads", &SV::myisam_repair_threads);
unknown's avatar
unknown committed
258 259 260 261 262
sys_var_thd_ulong	sys_myisam_sort_buffer_size("myisam_sort_buffer_size", &SV::myisam_sort_buff_size);
sys_var_thd_ulong	sys_net_buffer_length("net_buffer_length",
					      &SV::net_buffer_length);
sys_var_thd_ulong	sys_net_read_timeout("net_read_timeout",
					     &SV::net_read_timeout,
263
					     0, fix_net_read_timeout);
unknown's avatar
unknown committed
264 265
sys_var_thd_ulong	sys_net_write_timeout("net_write_timeout",
					      &SV::net_write_timeout,
266
					      0, fix_net_write_timeout);
267 268
sys_var_thd_ulong	sys_net_retry_count("net_retry_count",
					    &SV::net_retry_count,
269
					    0, fix_net_retry_count);
270
sys_var_thd_bool	sys_new_mode("new", &SV::new_mode);
271
sys_var_thd_bool	sys_old_passwords("old_passwords", &SV::old_passwords);
unknown's avatar
unknown committed
272 273
sys_var_thd_ulong       sys_preload_buff_size("preload_buffer_size",
                                              &SV::preload_buff_size);
unknown's avatar
unknown committed
274 275
sys_var_thd_ulong	sys_read_buff_size("read_buffer_size",
					   &SV::read_buff_size);
276
sys_var_bool_ptr	sys_readonly("read_only", &opt_readonly);
unknown's avatar
unknown committed
277 278
sys_var_thd_ulong	sys_read_rnd_buff_size("read_rnd_buffer_size",
					       &SV::read_rnd_buff_size);
279 280 281 282
#ifdef HAVE_REPLICATION
sys_var_bool_ptr	sys_relay_log_purge("relay_log_purge",
                                            &relay_log_purge);
#endif
unknown's avatar
unknown committed
283 284 285 286 287
sys_var_long_ptr	sys_rpl_recovery_rank("rpl_recovery_rank",
					      &rpl_recovery_rank);
sys_var_long_ptr	sys_query_cache_size("query_cache_size",
					     &query_cache_size,
					     fix_query_cache_size);
288 289 290 291

sys_var_thd_ulong	sys_range_alloc_block_size("range_alloc_block_size",
						   &SV::range_alloc_block_size);
sys_var_thd_ulong	sys_query_alloc_block_size("query_alloc_block_size",
292
						   &SV::query_alloc_block_size,
293
						   0, fix_thd_mem_root);
294
sys_var_thd_ulong	sys_query_prealloc_size("query_prealloc_size",
295
						&SV::query_prealloc_size,
296
						0, fix_thd_mem_root);
297
sys_var_thd_ulong	sys_trans_alloc_block_size("transaction_alloc_block_size",
298
						   &SV::trans_alloc_block_size,
299
						   0, fix_trans_mem_root);
300
sys_var_thd_ulong	sys_trans_prealloc_size("transaction_prealloc_size",
301
						&SV::trans_prealloc_size,
302
						0, fix_trans_mem_root);
303

unknown's avatar
unknown committed
304 305 306
#ifdef HAVE_QUERY_CACHE
sys_var_long_ptr	sys_query_cache_limit("query_cache_limit",
					      &query_cache.query_cache_limit);
307 308 309
sys_var_long_ptr        sys_query_cache_min_res_unit("query_cache_min_res_unit",
						     &query_cache_min_res_unit,
						     fix_query_cache_min_res_unit);
unknown's avatar
unknown committed
310 311 312
sys_var_thd_enum	sys_query_cache_type("query_cache_type",
					     &SV::query_cache_type,
					     &query_cache_type_typelib);
313 314 315
sys_var_thd_bool
sys_query_cache_wlock_invalidate("query_cache_wlock_invalidate",
				 &SV::query_cache_wlock_invalidate);
unknown's avatar
unknown committed
316
#endif /* HAVE_QUERY_CACHE */
317
sys_var_bool_ptr	sys_secure_auth("secure_auth", &opt_secure_auth);
318
sys_var_long_ptr	sys_server_id("server_id", &server_id, fix_server_id);
319 320
sys_var_bool_ptr	sys_slave_compressed_protocol("slave_compressed_protocol",
						      &opt_slave_compressed_protocol);
unknown's avatar
SCRUM  
unknown committed
321
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
322 323
sys_var_long_ptr	sys_slave_net_timeout("slave_net_timeout",
					      &slave_net_timeout);
324
#endif
unknown's avatar
unknown committed
325 326 327 328
sys_var_long_ptr	sys_slow_launch_time("slow_launch_time",
					     &slow_launch_time);
sys_var_thd_ulong	sys_sort_buffer("sort_buffer_size",
					&SV::sortbuff_size);
329 330
sys_var_thd_sql_mode    sys_sql_mode("sql_mode",
                                     &SV::sql_mode);
331 332
sys_var_thd_table_type  sys_table_type("table_type",
				       &SV::table_type);
unknown's avatar
unknown committed
333 334
sys_var_thd_storage_engine sys_storage_engine("storage_engine",
				       &SV::table_type);
335 336 337 338
#ifdef HAVE_REPLICATION
sys_var_sync_binlog_period sys_sync_binlog_period("sync_binlog", &sync_binlog_period);
#endif
sys_var_bool_ptr	sys_sync_frm("sync_frm", &opt_sync_frm);
unknown's avatar
unknown committed
339 340 341 342 343 344 345 346 347 348 349 350
sys_var_long_ptr	sys_table_cache_size("table_cache",
					     &table_cache_size);
sys_var_long_ptr	sys_thread_cache_size("thread_cache_size",
					      &thread_cache_size);
sys_var_thd_enum	sys_tx_isolation("tx_isolation",
					 &SV::tx_isolation,
					 &tx_isolation_typelib,
					 fix_tx_isolation);
sys_var_thd_ulong	sys_tmp_table_size("tmp_table_size",
					   &SV::tmp_table_size);
sys_var_thd_ulong	sys_net_wait_timeout("wait_timeout",
					     &SV::net_wait_timeout);
351

352 353 354
#ifdef HAVE_INNOBASE_DB
sys_var_long_ptr        sys_innodb_max_dirty_pages_pct("innodb_max_dirty_pages_pct",
                                                        &srv_max_buf_pool_modified_pct);
355 356
sys_var_long_ptr	sys_innodb_max_purge_lag("innodb_max_purge_lag",
							&srv_max_purge_lag);
357 358
sys_var_thd_bool	sys_innodb_table_locks("innodb_table_locks",
                                               &SV::innodb_table_locks);
359 360
sys_var_long_ptr	sys_innodb_autoextend_increment("innodb_autoextend_increment",
							&srv_auto_extend_increment);
unknown's avatar
unknown committed
361
#endif
362 363 364 365 366 367 368 369 370 371 372 373
#ifdef HAVE_NDBCLUSTER_DB
// ndb thread specific variable settings
sys_var_thd_ulong 
sys_ndb_autoincrement_prefetch_sz("ndb_autoincrement_prefetch_sz",
				  &SV::ndb_autoincrement_prefetch_sz);
sys_var_thd_bool
sys_ndb_force_send("ndb_force_send",
		   &SV::ndb_force_send);
sys_var_thd_bool
sys_ndb_use_exact_count("ndb_use_exact_count",
			&SV::ndb_use_exact_count);
sys_var_thd_bool
374 375 376
sys_ndb_use_local_query_cache("ndb_use_local_query_cache",
			      &SV::ndb_use_local_query_cache);
sys_var_thd_bool
377 378 379 380 381
sys_ndb_use_transactions("ndb_use_transactions",
			 &SV::ndb_use_transactions);
// ndb server global variable settings
// none
#endif
382 383 384 385 386

/* Time/date/datetime formats */

sys_var_thd_date_time_format sys_time_format("time_format",
					     &SV::time_format,
387
					     MYSQL_TIMESTAMP_TIME);
388 389
sys_var_thd_date_time_format sys_date_format("date_format",
					     &SV::date_format,
390
					     MYSQL_TIMESTAMP_DATE);
391 392
sys_var_thd_date_time_format sys_datetime_format("datetime_format",
						 &SV::datetime_format,
393
						 MYSQL_TIMESTAMP_DATETIME);
394 395

/* Variables that are bits in THD */
unknown's avatar
unknown committed
396

397
static sys_var_thd_bit	sys_autocommit("autocommit", 0,
unknown's avatar
unknown committed
398 399 400
				       set_option_autocommit,
				       OPTION_NOT_AUTOCOMMIT,
				       1);
401
static sys_var_thd_bit	sys_big_tables("big_tables", 0,
unknown's avatar
unknown committed
402 403 404
				       set_option_bit,
				       OPTION_BIG_TABLES);
#ifndef TO_BE_DELETED	/* Alias for big_tables */
405
static sys_var_thd_bit	sys_sql_big_tables("sql_big_tables", 0,
unknown's avatar
unknown committed
406 407 408
					   set_option_bit,
					   OPTION_BIG_TABLES);
#endif
409
static sys_var_thd_bit	sys_big_selects("sql_big_selects", 0,
unknown's avatar
unknown committed
410
					set_option_bit,
411
					OPTION_BIG_SELECTS);
412
static sys_var_thd_bit	sys_log_off("sql_log_off", 0,
unknown's avatar
unknown committed
413 414 415
				    set_option_bit,
				    OPTION_LOG_OFF);
static sys_var_thd_bit	sys_log_update("sql_log_update",
416
                                       check_log_update,
unknown's avatar
unknown committed
417 418 419
				       set_log_update,
				       OPTION_UPDATE_LOG);
static sys_var_thd_bit	sys_log_binlog("sql_log_bin",
420 421 422 423
                                       check_log_update,
                                       set_log_update,
                                       OPTION_BIN_LOG);
static sys_var_thd_bit	sys_sql_warnings("sql_warnings", 0,
unknown's avatar
unknown committed
424 425
					 set_option_bit,
					 OPTION_WARNINGS);
426
static sys_var_thd_bit	sys_auto_is_null("sql_auto_is_null", 0,
unknown's avatar
unknown committed
427 428
					 set_option_bit,
					 OPTION_AUTO_IS_NULL);
429
static sys_var_thd_bit	sys_safe_updates("sql_safe_updates", 0,
unknown's avatar
unknown committed
430 431
					 set_option_bit,
					 OPTION_SAFE_UPDATES);
432
static sys_var_thd_bit	sys_buffer_results("sql_buffer_result", 0,
unknown's avatar
unknown committed
433 434
					   set_option_bit,
					   OPTION_BUFFER_RESULT);
435
static sys_var_thd_bit	sys_quote_show_create("sql_quote_show_create", 0,
unknown's avatar
unknown committed
436 437
					      set_option_bit,
					      OPTION_QUOTE_SHOW_CREATE);
438
static sys_var_thd_bit	sys_foreign_key_checks("foreign_key_checks", 0,
439 440 441
					       set_option_bit,
					       OPTION_NO_FOREIGN_KEY_CHECKS,
					       1);
442
static sys_var_thd_bit	sys_unique_checks("unique_checks", 0,
443 444 445 446
					  set_option_bit,
					  OPTION_RELAXED_UNIQUE_CHECKS,
					  1);

unknown's avatar
unknown committed
447 448
/* Local state variables */

449
static sys_var_thd_ha_rows	sys_select_limit("sql_select_limit",
unknown's avatar
unknown committed
450 451 452 453 454
						 &SV::select_limit);
static sys_var_timestamp	sys_timestamp("timestamp");
static sys_var_last_insert_id	sys_last_insert_id("last_insert_id");
static sys_var_last_insert_id	sys_identity("identity");
static sys_var_insert_id	sys_insert_id("insert_id");
455 456 457 458 459 460 461 462 463
static sys_var_readonly		sys_error_count("error_count",
						OPT_SESSION,
						SHOW_LONG,
						get_error_count);
static sys_var_readonly		sys_warning_count("warning_count",
						  OPT_SESSION,
						  SHOW_LONG,
						  get_warning_count);

unknown's avatar
unknown committed
464
/* alias for last_insert_id() to be compatible with Sybase */
unknown's avatar
SCRUM  
unknown committed
465
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
466
static sys_var_slave_skip_counter sys_slave_skip_counter("sql_slave_skip_counter");
467
#endif
468 469
static sys_var_rand_seed1	sys_rand_seed1("rand_seed1");
static sys_var_rand_seed2	sys_rand_seed2("rand_seed2");
unknown's avatar
unknown committed
470

471 472
static sys_var_thd_ulong        sys_default_week_format("default_week_format",
					                &SV::default_week_format);
unknown's avatar
unknown committed
473

unknown's avatar
unknown committed
474 475 476
sys_var_thd_ulong               sys_group_concat_max_len("group_concat_max_len",
                                                         &SV::group_concat_max_len);

477
sys_var_thd_time_zone            sys_time_zone("time_zone");
478 479 480 481

/* Read only variables */

sys_var_const_str		sys_os("version_compile_os", SYSTEM_TYPE);
482
/* Global read-only variable describing server license */
483
sys_var_const_str		sys_license("license", STRINGIFY_ARG(LICENSE));
484

485

unknown's avatar
unknown committed
486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502
/*
  List of all variables for initialisation and storage in hash
  This is sorted in alphabetical order to make it easy to add new variables

  If the variable is not in this list, it can't be changed with
  SET variable_name=
*/

sys_var *sys_variables[]=
{
  &sys_auto_is_null,
  &sys_autocommit,
  &sys_big_tables,
  &sys_big_selects,
  &sys_binlog_cache_size,
  &sys_buffer_results,
  &sys_bulk_insert_buff_size,
503 504
  &sys_character_set_server,
  &sys_character_set_database,
505
  &sys_character_set_client,
unknown's avatar
unknown committed
506
  &sys_character_set_connection,
507
  &sys_character_set_results,
unknown's avatar
unknown committed
508
  &sys_collation_connection,
509 510
  &sys_collation_database,
  &sys_collation_server,
unknown's avatar
unknown committed
511 512
  &sys_concurrent_insert,
  &sys_connect_timeout,
513 514
  &sys_date_format,
  &sys_datetime_format,
515
  &sys_default_week_format,
unknown's avatar
unknown committed
516 517 518 519
  &sys_delay_key_write,
  &sys_delayed_insert_limit,
  &sys_delayed_insert_timeout,
  &sys_delayed_queue_size,
520
  &sys_error_count,
unknown's avatar
unknown committed
521
  &sys_expire_logs_days,
unknown's avatar
unknown committed
522 523
  &sys_flush,
  &sys_flush_time,
unknown's avatar
unknown committed
524
  &sys_ft_boolean_syntax,
525
  &sys_foreign_key_checks,
unknown's avatar
unknown committed
526
  &sys_group_concat_max_len,
unknown's avatar
unknown committed
527
  &sys_identity,
unknown's avatar
unknown committed
528 529
  &sys_init_connect,
  &sys_init_slave,
unknown's avatar
unknown committed
530 531 532 533
  &sys_insert_id,
  &sys_interactive_timeout,
  &sys_join_buffer_size,
  &sys_key_buffer_size,
unknown's avatar
unknown committed
534
  &sys_key_cache_block_size,
535 536
  &sys_key_cache_division_limit,
  &sys_key_cache_age_threshold,
unknown's avatar
unknown committed
537
  &sys_last_insert_id,
538
  &sys_license,
unknown's avatar
unknown committed
539 540 541 542 543 544 545 546 547 548 549 550 551
  &sys_local_infile,
  &sys_log_binlog,
  &sys_log_off,
  &sys_log_update,
  &sys_log_warnings,
  &sys_long_query_time,
  &sys_low_priority_updates,
  &sys_max_allowed_packet,
  &sys_max_binlog_cache_size,
  &sys_max_binlog_size,
  &sys_max_connect_errors,
  &sys_max_connections,
  &sys_max_delayed_threads,
552
  &sys_max_error_count,
553
  &sys_max_insert_delayed_threads,
unknown's avatar
unknown committed
554 555
  &sys_max_heap_table_size,
  &sys_max_join_size,
unknown's avatar
unknown committed
556
  &sys_max_length_for_sort_data,
557
  &sys_max_relay_log_size,
558
  &sys_max_seeks_for_key,
unknown's avatar
unknown committed
559 560 561 562
  &sys_max_sort_length,
  &sys_max_tmp_tables,
  &sys_max_user_connections,
  &sys_max_write_lock_count,
unknown's avatar
unknown committed
563
  &sys_myisam_data_pointer_size,
unknown's avatar
unknown committed
564 565
  &sys_myisam_max_extra_sort_file_size,
  &sys_myisam_max_sort_file_size,
566
  &sys_myisam_repair_threads,
unknown's avatar
unknown committed
567 568 569
  &sys_myisam_sort_buffer_size,
  &sys_net_buffer_length,
  &sys_net_read_timeout,
570
  &sys_net_retry_count,
unknown's avatar
unknown committed
571 572
  &sys_net_wait_timeout,
  &sys_net_write_timeout,
573
  &sys_new_mode,
574
  &sys_old_passwords,
unknown's avatar
unknown committed
575
  &sys_preload_buff_size,
unknown's avatar
unknown committed
576
  &sys_pseudo_thread_id,
577
  &sys_query_alloc_block_size,
unknown's avatar
unknown committed
578
  &sys_query_cache_size,
579
  &sys_query_prealloc_size,
unknown's avatar
unknown committed
580 581
#ifdef HAVE_QUERY_CACHE
  &sys_query_cache_limit,
582
  &sys_query_cache_min_res_unit,
unknown's avatar
unknown committed
583
  &sys_query_cache_type,
584
  &sys_query_cache_wlock_invalidate,
585
#endif /* HAVE_QUERY_CACHE */
unknown's avatar
unknown committed
586
  &sys_quote_show_create,
587 588
  &sys_rand_seed1,
  &sys_rand_seed2,
589
  &sys_range_alloc_block_size,
590
  &sys_readonly,
unknown's avatar
unknown committed
591 592
  &sys_read_buff_size,
  &sys_read_rnd_buff_size,
593 594 595
#ifdef HAVE_REPLICATION
  &sys_relay_log_purge,
#endif
unknown's avatar
unknown committed
596 597
  &sys_rpl_recovery_rank,
  &sys_safe_updates,
598
  &sys_secure_auth,
unknown's avatar
unknown committed
599 600
  &sys_select_limit,
  &sys_server_id,
unknown's avatar
SCRUM  
unknown committed
601
#ifdef HAVE_REPLICATION
602
  &sys_slave_compressed_protocol,
unknown's avatar
unknown committed
603 604
  &sys_slave_net_timeout,
  &sys_slave_skip_counter,
605
#endif
unknown's avatar
unknown committed
606 607 608 609 610
  &sys_slow_launch_time,
  &sys_sort_buffer,
  &sys_sql_big_tables,
  &sys_sql_low_priority_updates,
  &sys_sql_max_join_size,
611
  &sys_sql_mode,
unknown's avatar
unknown committed
612
  &sys_sql_warnings,
unknown's avatar
unknown committed
613
  &sys_storage_engine,
614 615 616 617
#ifdef HAVE_REPLICATION
  &sys_sync_binlog_period,
#endif
  &sys_sync_frm,
unknown's avatar
unknown committed
618 619 620
  &sys_table_cache_size,
  &sys_table_type,
  &sys_thread_cache_size,
621
  &sys_time_format,
unknown's avatar
unknown committed
622
  &sys_timestamp,
623
  &sys_time_zone,
unknown's avatar
unknown committed
624
  &sys_tmp_table_size,
625 626
  &sys_trans_alloc_block_size,
  &sys_trans_prealloc_size,
unknown's avatar
unknown committed
627
  &sys_tx_isolation,
628
  &sys_os,
629 630
#ifdef HAVE_INNOBASE_DB
  &sys_innodb_max_dirty_pages_pct,
631
  &sys_innodb_max_purge_lag,
632
  &sys_innodb_table_locks,
633
  &sys_innodb_max_purge_lag,
634
  &sys_innodb_autoextend_increment,
635 636 637 638 639
#endif  
#ifdef HAVE_NDBCLUSTER_DB
  &sys_ndb_autoincrement_prefetch_sz,
  &sys_ndb_force_send,
  &sys_ndb_use_exact_count,
640
  &sys_ndb_use_local_query_cache,
641 642
  &sys_ndb_use_transactions,
#endif
643 644
  &sys_unique_checks,
  &sys_warning_count
unknown's avatar
unknown committed
645 646 647 648 649 650 651 652 653 654 655 656 657
};


/*
  Variables shown by SHOW variables in alphabetical order
*/

struct show_var_st init_vars[]= {
  {"back_log",                (char*) &back_log,                    SHOW_LONG},
  {"basedir",                 mysql_home,                           SHOW_CHAR},
#ifdef HAVE_BERKELEY_DB
  {"bdb_cache_size",          (char*) &berkeley_cache_size,         SHOW_LONG},
  {"bdb_home",                (char*) &berkeley_home,               SHOW_CHAR_PTR},
658
  {"bdb_log_buffer_size",     (char*) &berkeley_log_buffer_size,    SHOW_LONG},
unknown's avatar
unknown committed
659
  {"bdb_logdir",              (char*) &berkeley_logdir,             SHOW_CHAR_PTR},
660
  {"bdb_max_lock",            (char*) &berkeley_max_lock,	    SHOW_LONG},
unknown's avatar
unknown committed
661 662 663 664 665
  {"bdb_shared_data",	      (char*) &berkeley_shared_data,	    SHOW_BOOL},
  {"bdb_tmpdir",              (char*) &berkeley_tmpdir,             SHOW_CHAR_PTR},
#endif
  {sys_binlog_cache_size.name,(char*) &sys_binlog_cache_size,	    SHOW_SYS},
  {sys_bulk_insert_buff_size.name,(char*) &sys_bulk_insert_buff_size,SHOW_SYS},
666
  {sys_character_set_client.name,(char*) &sys_character_set_client, SHOW_SYS},
unknown's avatar
unknown committed
667
  {sys_character_set_connection.name,(char*) &sys_character_set_connection,SHOW_SYS},
668
  {sys_character_set_database.name, (char*) &sys_character_set_database,SHOW_SYS},
669
  {sys_character_set_results.name,(char*) &sys_character_set_results, SHOW_SYS},
670 671
  {sys_character_set_server.name, (char*) &sys_character_set_server,SHOW_SYS},
  {sys_charset_system.name,   (char*) &sys_charset_system,          SHOW_SYS},
672
  {"character_sets_dir",      mysql_charsets_dir,                   SHOW_CHAR},
unknown's avatar
unknown committed
673
  {sys_collation_connection.name,(char*) &sys_collation_connection, SHOW_SYS},
674 675
  {sys_collation_database.name,(char*) &sys_collation_database,     SHOW_SYS},
  {sys_collation_server.name,(char*) &sys_collation_server,         SHOW_SYS},
unknown's avatar
unknown committed
676 677 678
  {sys_concurrent_insert.name,(char*) &sys_concurrent_insert,       SHOW_SYS},
  {sys_connect_timeout.name,  (char*) &sys_connect_timeout,         SHOW_SYS},
  {"datadir",                 mysql_real_data_home,                 SHOW_CHAR},
679 680 681
  {sys_date_format.name,      (char*) &sys_date_format,		    SHOW_SYS},
  {sys_datetime_format.name,  (char*) &sys_datetime_format,	    SHOW_SYS},
  {sys_default_week_format.name, (char*) &sys_default_week_format,  SHOW_SYS},
unknown's avatar
unknown committed
682 683 684 685
  {sys_delay_key_write.name,  (char*) &sys_delay_key_write,         SHOW_SYS},
  {sys_delayed_insert_limit.name, (char*) &sys_delayed_insert_limit,SHOW_SYS},
  {sys_delayed_insert_timeout.name, (char*) &sys_delayed_insert_timeout, SHOW_SYS},
  {sys_delayed_queue_size.name,(char*) &sys_delayed_queue_size,     SHOW_SYS},
unknown's avatar
unknown committed
686
  {sys_expire_logs_days.name, (char*) &sys_expire_logs_days,        SHOW_SYS},
unknown's avatar
unknown committed
687 688
  {sys_flush.name,             (char*) &sys_flush,                  SHOW_SYS},
  {sys_flush_time.name,        (char*) &sys_flush_time,             SHOW_SYS},
unknown's avatar
unknown committed
689
  {sys_ft_boolean_syntax.name,(char*) &ft_boolean_syntax,	    SHOW_CHAR},
unknown's avatar
unknown committed
690
  {"ft_max_word_len",         (char*) &ft_max_word_len,             SHOW_LONG},
691
  {"ft_min_word_len",         (char*) &ft_min_word_len,             SHOW_LONG},
692
  {"ft_query_expansion_limit",(char*) &ft_query_expansion_limit,    SHOW_LONG},
693
  {"ft_stopword_file",        (char*) &ft_stopword_file,            SHOW_CHAR_PTR},
unknown's avatar
unknown committed
694
  {sys_group_concat_max_len.name, (char*) &sys_group_concat_max_len,  SHOW_SYS},
695
  {"have_archive",	      (char*) &have_archive_db,	            SHOW_HAVE},
unknown's avatar
unknown committed
696
  {"have_bdb",		      (char*) &have_berkeley_db,	    SHOW_HAVE},
unknown's avatar
unknown committed
697
  {"have_compress",	      (char*) &have_compress,		    SHOW_HAVE},
698
  {"have_crypt",	      (char*) &have_crypt,		    SHOW_HAVE},
699
  {"have_csv",	              (char*) &have_csv_db,	            SHOW_HAVE},
700
  {"have_example_engine",      (char*) &have_example_db,	            SHOW_HAVE},
unknown's avatar
unknown committed
701
  {"have_geometry",           (char*) &have_geometry,               SHOW_HAVE},
unknown's avatar
unknown committed
702
  {"have_innodb",	      (char*) &have_innodb,		    SHOW_HAVE},
703
  {"have_isam",		      (char*) &have_isam,		    SHOW_HAVE},
unknown's avatar
unknown committed
704
  {"have_ndbcluster",         (char*) &have_ndbcluster,             SHOW_HAVE},
unknown's avatar
unknown committed
705 706
  {"have_openssl",	      (char*) &have_openssl,		    SHOW_HAVE},
  {"have_query_cache",        (char*) &have_query_cache,            SHOW_HAVE},
707
  {"have_raid",		      (char*) &have_raid,		    SHOW_HAVE},
708
  {"have_rtree_keys",         (char*) &have_rtree_keys,             SHOW_HAVE},
709
  {"have_symlink",            (char*) &have_symlink,                SHOW_HAVE},
unknown's avatar
unknown committed
710
  {"init_connect",            (char*) &sys_init_connect,            SHOW_SYS},
711
  {"init_file",               (char*) &opt_init_file,               SHOW_CHAR_PTR},
unknown's avatar
unknown committed
712
  {"init_slave",              (char*) &sys_init_slave,              SHOW_SYS},
unknown's avatar
unknown committed
713 714
#ifdef HAVE_INNOBASE_DB
  {"innodb_additional_mem_pool_size", (char*) &innobase_additional_mem_pool_size, SHOW_LONG },
715
  {sys_innodb_autoextend_increment.name, (char*) &sys_innodb_autoextend_increment, SHOW_SYS},
unknown's avatar
unknown committed
716
  {"innodb_buffer_pool_awe_mem_mb", (char*) &innobase_buffer_pool_awe_mem_mb, SHOW_LONG },
717
  {"innodb_buffer_pool_size", (char*) &innobase_buffer_pool_size, SHOW_LONG },
unknown's avatar
unknown committed
718 719 720
  {"innodb_data_file_path", (char*) &innobase_data_file_path,	    SHOW_CHAR_PTR},
  {"innodb_data_home_dir",  (char*) &innobase_data_home_dir,	    SHOW_CHAR_PTR},
  {"innodb_fast_shutdown", (char*) &innobase_fast_shutdown, SHOW_MY_BOOL},
721
  {"innodb_file_io_threads", (char*) &innobase_file_io_threads, SHOW_LONG },
unknown's avatar
unknown committed
722
  {"innodb_file_per_table", (char*) &innobase_file_per_table, SHOW_MY_BOOL},
723
  {"innodb_locks_unsafe_for_binlog", (char*) &innobase_locks_unsafe_for_binlog, SHOW_MY_BOOL},
724
  {"innodb_flush_log_at_trx_commit", (char*) &innobase_flush_log_at_trx_commit, SHOW_INT},
unknown's avatar
unknown committed
725
  {"innodb_flush_method",    (char*) &innobase_unix_file_flush_method, SHOW_CHAR_PTR},
726
  {"innodb_force_recovery", (char*) &innobase_force_recovery, SHOW_LONG },
unknown's avatar
unknown committed
727 728 729 730 731 732 733
  {"innodb_lock_wait_timeout", (char*) &innobase_lock_wait_timeout, SHOW_LONG },
  {"innodb_log_arch_dir",   (char*) &innobase_log_arch_dir, 	    SHOW_CHAR_PTR},
  {"innodb_log_archive",    (char*) &innobase_log_archive, 	    SHOW_MY_BOOL},
  {"innodb_log_buffer_size", (char*) &innobase_log_buffer_size, SHOW_LONG },
  {"innodb_log_file_size", (char*) &innobase_log_file_size, SHOW_LONG},
  {"innodb_log_files_in_group", (char*) &innobase_log_files_in_group,	SHOW_LONG},
  {"innodb_log_group_home_dir", (char*) &innobase_log_group_home_dir, SHOW_CHAR_PTR},
734
  {sys_innodb_max_dirty_pages_pct.name, (char*) &sys_innodb_max_dirty_pages_pct, SHOW_SYS},
735
  {sys_innodb_max_purge_lag.name, (char*) &sys_innodb_max_purge_lag, SHOW_SYS},
736
  {sys_innodb_table_locks.name, (char*) &sys_innodb_table_locks, SHOW_SYS},
737
  {sys_innodb_max_purge_lag.name, (char*) &sys_innodb_max_purge_lag, SHOW_SYS},
738 739 740
  {"innodb_mirrored_log_groups", (char*) &innobase_mirrored_log_groups, SHOW_LONG},
  {"innodb_open_files", (char*) &innobase_open_files, SHOW_LONG },
  {"innodb_thread_concurrency", (char*) &innobase_thread_concurrency, SHOW_LONG },
unknown's avatar
unknown committed
741 742 743 744
#endif
  {sys_interactive_timeout.name,(char*) &sys_interactive_timeout,   SHOW_SYS},
  {sys_join_buffer_size.name,   (char*) &sys_join_buffer_size,	    SHOW_SYS},
  {sys_key_buffer_size.name,	(char*) &sys_key_buffer_size,	    SHOW_SYS},
745
  {sys_key_cache_age_threshold.name,   (char*) &sys_key_cache_age_threshold,
746
                                                                    SHOW_SYS},
unknown's avatar
unknown committed
747
  {sys_key_cache_block_size.name,   (char*) &sys_key_cache_block_size,
748
                                                                    SHOW_SYS},
749
  {sys_key_cache_division_limit.name,   (char*) &sys_key_cache_division_limit,
750
                                                                    SHOW_SYS},
unknown's avatar
unknown committed
751
  {"language",                language,                             SHOW_CHAR},
752 753
  {"large_files_support",     (char*) &opt_large_files,             SHOW_BOOL},
  {sys_license.name,	      (char*) &sys_license,                 SHOW_SYS},
unknown's avatar
unknown committed
754 755 756 757 758 759
  {sys_local_infile.name,     (char*) &sys_local_infile,	    SHOW_SYS},
#ifdef HAVE_MLOCKALL
  {"locked_in_memory",	      (char*) &locked_in_memory,	    SHOW_BOOL},
#endif
  {"log",                     (char*) &opt_log,                     SHOW_BOOL},
  {"log_bin",                 (char*) &opt_bin_log,                 SHOW_BOOL},
760
  {"log_error",               (char*) log_error_file,               SHOW_CHAR},
unknown's avatar
SCRUM  
unknown committed
761
#ifdef HAVE_REPLICATION
762
  {"log_slave_updates",       (char*) &opt_log_slave_updates,       SHOW_MY_BOOL},
763
#endif
unknown's avatar
unknown committed
764
  {"log_slow_queries",        (char*) &opt_slow_log,                SHOW_BOOL},
765
  {"log_update",              (char*) &opt_update_log,              SHOW_BOOL},
unknown's avatar
unknown committed
766 767 768
  {sys_log_warnings.name,     (char*) &sys_log_warnings,	    SHOW_SYS},
  {sys_long_query_time.name,  (char*) &sys_long_query_time, 	    SHOW_SYS},
  {sys_low_priority_updates.name, (char*) &sys_low_priority_updates, SHOW_SYS},
769
  {"lower_case_file_system",  (char*) &lower_case_file_system,      SHOW_MY_BOOL},
unknown's avatar
unknown committed
770
  {"lower_case_table_names",  (char*) &lower_case_table_names,      SHOW_INT},
unknown's avatar
unknown committed
771 772 773 774
  {sys_max_allowed_packet.name,(char*) &sys_max_allowed_packet,	    SHOW_SYS},
  {sys_max_binlog_cache_size.name,(char*) &sys_max_binlog_cache_size, SHOW_SYS},
  {sys_max_binlog_size.name,    (char*) &sys_max_binlog_size,	    SHOW_SYS},
  {sys_max_connect_errors.name, (char*) &sys_max_connect_errors,    SHOW_SYS},
775
  {sys_max_connections.name,    (char*) &sys_max_connections,	    SHOW_SYS},
unknown's avatar
unknown committed
776
  {sys_max_delayed_threads.name,(char*) &sys_max_delayed_threads,   SHOW_SYS},
777
  {sys_max_error_count.name,	(char*) &sys_max_error_count,	    SHOW_SYS},
unknown's avatar
unknown committed
778
  {sys_max_heap_table_size.name,(char*) &sys_max_heap_table_size,   SHOW_SYS},
779 780
  {sys_max_insert_delayed_threads.name,
   (char*) &sys_max_insert_delayed_threads,   SHOW_SYS},
unknown's avatar
unknown committed
781
  {sys_max_join_size.name,	(char*) &sys_max_join_size,	    SHOW_SYS},
unknown's avatar
unknown committed
782
  {sys_max_length_for_sort_data.name, (char*) &sys_max_length_for_sort_data,
unknown's avatar
unknown committed
783
   SHOW_SYS},
784 785
  {sys_max_relay_log_size.name, (char*) &sys_max_relay_log_size,    SHOW_SYS},
  {sys_max_seeks_for_key.name,  (char*) &sys_max_seeks_for_key,	    SHOW_SYS},
unknown's avatar
unknown committed
786
  {sys_max_sort_length.name,	(char*) &sys_max_sort_length,	    SHOW_SYS},
787
  {sys_max_tmp_tables.name,	(char*) &sys_max_tmp_tables,	    SHOW_SYS},
788
  {sys_max_user_connections.name,(char*) &sys_max_user_connections, SHOW_SYS},
unknown's avatar
unknown committed
789
  {sys_max_write_lock_count.name, (char*) &sys_max_write_lock_count,SHOW_SYS},
unknown's avatar
unknown committed
790
  {sys_myisam_data_pointer_size.name, (char*) &sys_myisam_data_pointer_size, SHOW_SYS},
unknown's avatar
unknown committed
791 792 793
  {sys_myisam_max_extra_sort_file_size.name,
   (char*) &sys_myisam_max_extra_sort_file_size,
   SHOW_SYS},
794 795
  {sys_myisam_max_sort_file_size.name, (char*) &sys_myisam_max_sort_file_size,
   SHOW_SYS},
796
  {"myisam_recover_options",  (char*) &myisam_recover_options_str,  SHOW_CHAR_PTR},
797
  {sys_myisam_repair_threads.name, (char*) &sys_myisam_repair_threads,
unknown's avatar
unknown committed
798 799 800
   SHOW_SYS},
  {sys_myisam_sort_buffer_size.name, (char*) &sys_myisam_sort_buffer_size, SHOW_SYS},
#ifdef __NT__
801
  {"named_pipe",	      (char*) &opt_enable_named_pipe,       SHOW_MY_BOOL},
802 803 804 805 806 807
#endif
#ifdef HAVE_NDBCLUSTER_DB
  {sys_ndb_autoincrement_prefetch_sz.name,
   (char*) &sys_ndb_autoincrement_prefetch_sz,                      SHOW_SYS},
  {sys_ndb_force_send.name,   (char*) &sys_ndb_force_send,          SHOW_SYS},
  {sys_ndb_use_exact_count.name,(char*) &sys_ndb_use_exact_count,   SHOW_SYS},
808 809
  {sys_ndb_use_local_query_cache.name,
   (char*) &sys_ndb_use_local_query_cache,                          SHOW_SYS},
810
  {sys_ndb_use_transactions.name,(char*) &sys_ndb_use_transactions, SHOW_SYS},
unknown's avatar
unknown committed
811 812 813
#endif
  {sys_net_buffer_length.name,(char*) &sys_net_buffer_length,       SHOW_SYS},
  {sys_net_read_timeout.name, (char*) &sys_net_read_timeout,        SHOW_SYS},
814
  {sys_net_retry_count.name,  (char*) &sys_net_retry_count,	    SHOW_SYS},
unknown's avatar
unknown committed
815
  {sys_net_write_timeout.name,(char*) &sys_net_write_timeout,       SHOW_SYS},
816
  {sys_new_mode.name,         (char*) &sys_new_mode,                SHOW_SYS},
817
  {sys_old_passwords.name,    (char*) &sys_old_passwords,           SHOW_SYS},
unknown's avatar
unknown committed
818 819
  {"open_files_limit",	      (char*) &open_files_limit,	    SHOW_LONG},
  {"pid_file",                (char*) pidfile_name,                 SHOW_CHAR},
820
  {"port",                    (char*) &mysqld_port,                  SHOW_INT},
unknown's avatar
unknown committed
821
  {sys_preload_buff_size.name, (char*) &sys_preload_buff_size,      SHOW_SYS},
822
  {"protocol_version",        (char*) &protocol_version,            SHOW_INT},
823 824
  {sys_query_alloc_block_size.name, (char*) &sys_query_alloc_block_size,
   SHOW_SYS},
unknown's avatar
unknown committed
825
#ifdef HAVE_QUERY_CACHE
unknown's avatar
unknown committed
826
  {sys_query_cache_limit.name,(char*) &sys_query_cache_limit,	    SHOW_SYS},
827 828
  {sys_query_cache_min_res_unit.name, (char*) &sys_query_cache_min_res_unit,
   SHOW_SYS},
unknown's avatar
unknown committed
829 830
  {sys_query_cache_size.name, (char*) &sys_query_cache_size,	    SHOW_SYS},
  {sys_query_cache_type.name, (char*) &sys_query_cache_type,        SHOW_SYS},
unknown's avatar
unknown committed
831 832
  {sys_query_cache_wlock_invalidate.name,
   (char *) &sys_query_cache_wlock_invalidate, SHOW_SYS},
unknown's avatar
unknown committed
833
#endif /* HAVE_QUERY_CACHE */
834
  {sys_query_prealloc_size.name, (char*) &sys_query_prealloc_size,  SHOW_SYS},
835 836
  {sys_range_alloc_block_size.name, (char*) &sys_range_alloc_block_size,
   SHOW_SYS},
unknown's avatar
unknown committed
837 838 839
  {sys_read_buff_size.name,   (char*) &sys_read_buff_size,	    SHOW_SYS},
  {sys_readonly.name,         (char*) &sys_readonly,                SHOW_SYS},
  {sys_read_rnd_buff_size.name,(char*) &sys_read_rnd_buff_size,	    SHOW_SYS},
unknown's avatar
unknown committed
840 841 842
#ifdef HAVE_REPLICATION
  {sys_relay_log_purge.name,  (char*) &sys_relay_log_purge,         SHOW_SYS},
#endif
unknown's avatar
unknown committed
843
  {sys_rpl_recovery_rank.name,(char*) &sys_rpl_recovery_rank,       SHOW_SYS},
844
  {"secure_auth",             (char*) &sys_secure_auth,             SHOW_SYS},
845 846 847 848
#ifdef HAVE_SMEM
  {"shared_memory",           (char*) &opt_enable_shared_memory,    SHOW_MY_BOOL},
  {"shared_memory_base_name", (char*) &shared_memory_base_name,     SHOW_CHAR_PTR},
#endif
unknown's avatar
unknown committed
849
  {sys_server_id.name,	      (char*) &sys_server_id,		    SHOW_SYS},
850
  {"skip_external_locking",   (char*) &my_disable_locking,          SHOW_MY_BOOL},
unknown's avatar
unknown committed
851 852
  {"skip_networking",         (char*) &opt_disable_networking,      SHOW_BOOL},
  {"skip_show_database",      (char*) &opt_skip_show_db,            SHOW_BOOL},
853 854 855
#ifdef HAVE_REPLICATION
  {sys_slave_net_timeout.name,(char*) &sys_slave_net_timeout,	    SHOW_SYS},
#endif
unknown's avatar
unknown committed
856
  {sys_slow_launch_time.name, (char*) &sys_slow_launch_time,        SHOW_SYS},
857
#ifdef HAVE_SYS_UN_H
858
  {"socket",                  (char*) &mysqld_unix_port,             SHOW_CHAR_PTR},
859
#endif
unknown's avatar
unknown committed
860
  {sys_sort_buffer.name,      (char*) &sys_sort_buffer, 	    SHOW_SYS},
861
  {sys_sql_mode.name,         (char*) &sys_sql_mode,                SHOW_SYS},
unknown's avatar
unknown committed
862
  {sys_storage_engine.name,   (char*) &sys_storage_engine,          SHOW_SYS},
863 864 865 866
#ifdef HAVE_REPLICATION
  {sys_sync_binlog_period.name,(char*) &sys_sync_binlog_period,     SHOW_SYS},
#endif
  {sys_sync_frm.name,         (char*) &sys_sync_frm,               SHOW_SYS},
867 868 869
#ifdef HAVE_TZNAME
  {"system_time_zone",        system_time_zone,                     SHOW_CHAR},
#endif
unknown's avatar
unknown committed
870 871 872 873 874 875 876
  {"table_cache",             (char*) &table_cache_size,            SHOW_LONG},
  {sys_table_type.name,	      (char*) &sys_table_type,	            SHOW_SYS},
  {sys_thread_cache_size.name,(char*) &sys_thread_cache_size,       SHOW_SYS},
#ifdef HAVE_THR_SETCONCURRENCY
  {"thread_concurrency",      (char*) &concurrency,                 SHOW_LONG},
#endif
  {"thread_stack",            (char*) &thread_stack,                SHOW_LONG},
877
  {sys_time_format.name,      (char*) &sys_time_format,		    SHOW_SYS},
878
  {"time_zone",               (char*) &sys_time_zone,               SHOW_SYS},
unknown's avatar
unknown committed
879
  {sys_tmp_table_size.name,   (char*) &sys_tmp_table_size,	    SHOW_SYS},
unknown's avatar
unknown committed
880
  {"tmpdir",                  (char*) &opt_mysql_tmpdir,            SHOW_CHAR_PTR},
881 882 883
  {sys_trans_alloc_block_size.name, (char*) &sys_trans_alloc_block_size,
   SHOW_SYS},
  {sys_trans_prealloc_size.name, (char*) &sys_trans_prealloc_size,  SHOW_SYS},
884
  {sys_tx_isolation.name,     (char*) &sys_tx_isolation,	    SHOW_SYS},
unknown's avatar
unknown committed
885
  {"version",                 server_version,                       SHOW_CHAR},
886 887 888
#ifdef HAVE_BERKELEY_DB
  {"version_bdb",             (char*) DB_VERSION_STRING,            SHOW_CHAR},
#endif
889
  {"version_comment",         (char*) MYSQL_COMPILATION_COMMENT,    SHOW_CHAR},
890
  {"version_compile_machine", (char*) MACHINE_TYPE,		    SHOW_CHAR},
891
  {sys_os.name,		      (char*) &sys_os,			    SHOW_SYS},
unknown's avatar
unknown committed
892 893 894 895
  {sys_net_wait_timeout.name, (char*) &sys_net_wait_timeout,	    SHOW_SYS},
  {NullS, NullS, SHOW_LONG}
};

896

897 898 899 900 901 902
bool sys_var::check(THD *thd, set_var *var)
{
  var->save_result.ulonglong_value= var->value->val_int();
  return 0;
}

unknown's avatar
unknown committed
903 904 905 906 907 908 909 910 911 912 913 914
bool sys_var_str::check(THD *thd, set_var *var)
{
  int res;
  if (!check_func)
    return 0;

  if ((res=(*check_func)(thd, var)) < 0)
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name,
             var->value->str_value.ptr());
  return res;
}

unknown's avatar
unknown committed
915 916 917 918
/*
  Functions to check and update variables
*/

unknown's avatar
unknown committed
919

920 921 922 923 924 925 926 927 928 929
/*
  Update variables 'init_connect, init_slave'.

  In case of 'DEFAULT' value
  (for example: 'set GLOBAL init_connect=DEFAULT')
  'var' parameter is NULL pointer.
*/

bool update_sys_var_str(sys_var_str *var_str, rw_lock_t *var_mutex,
			set_var *var)
unknown's avatar
unknown committed
930
{
unknown's avatar
unknown committed
931 932
  char *res= 0, *old_value=(char *)(var ? var->value->str_value.ptr() : 0);
  uint new_length= (var ? var->value->str_value.length() : 0);
unknown's avatar
unknown committed
933 934
  if (!old_value)
    old_value= (char*) "";
935
  if (!(res= my_strdup_with_length((byte*)old_value, new_length, MYF(0))))
unknown's avatar
unknown committed
936
    return 1;
unknown's avatar
unknown committed
937 938 939 940
  /*
    Replace the old value in such a way that the any thread using
    the value will work.
  */
941 942 943 944 945
  rw_wrlock(var_mutex);
  old_value= var_str->value;
  var_str->value= res;
  var_str->value_length= new_length;
  rw_unlock(var_mutex);
unknown's avatar
unknown committed
946 947 948 949 950
  my_free(old_value, MYF(MY_ALLOW_ZERO_PTR));
  return 0;
}


951 952 953 954 955 956
static bool sys_update_init_connect(THD *thd, set_var *var)
{
  return update_sys_var_str(&sys_init_connect, &LOCK_sys_init_connect, var);
}


unknown's avatar
unknown committed
957 958
static void sys_default_init_connect(THD* thd, enum_var_type type)
{
959
  update_sys_var_str(&sys_init_connect, &LOCK_sys_init_connect, 0);
unknown's avatar
unknown committed
960 961 962 963 964
}


static bool sys_update_init_slave(THD *thd, set_var *var)
{
965
  return update_sys_var_str(&sys_init_slave, &LOCK_sys_init_slave, var);
unknown's avatar
unknown committed
966 967 968 969 970
}


static void sys_default_init_slave(THD* thd, enum_var_type type)
{
971
  update_sys_var_str(&sys_init_slave, &LOCK_sys_init_slave, 0);
unknown's avatar
unknown committed
972 973
}

unknown's avatar
unknown committed
974 975 976
static int sys_check_ftb_syntax(THD *thd,  set_var *var)
{
  if (thd->master_access & SUPER_ACL)
977
    return ft_boolean_check_syntax_string((byte*) var->value->str_value.c_ptr()) ?
unknown's avatar
unknown committed
978
      -1 : 0;
unknown's avatar
unknown committed
979 980 981 982 983 984 985 986 987
  else
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
}

static bool sys_update_ftb_syntax(THD *thd, set_var * var)
{
unknown's avatar
unknown committed
988 989
  strmake(ft_boolean_syntax, var->value->str_value.c_ptr(),
	  sizeof(ft_boolean_syntax)-1);
unknown's avatar
unknown committed
990 991 992 993 994
  return 0;
}

static void sys_default_ftb_syntax(THD *thd, enum_var_type type)
{
995
  strmake(ft_boolean_syntax, def_ft_boolean_syntax,
unknown's avatar
unknown committed
996
	  sizeof(ft_boolean_syntax)-1);
unknown's avatar
unknown committed
997
}
unknown's avatar
unknown committed
998

unknown's avatar
unknown committed
999 1000 1001 1002 1003
/*
  The following 3 functions need to be changed in 4.1 when we allow
  one to change character sets
*/

unknown's avatar
unknown committed
1004
static int sys_check_charset(THD *thd, set_var *var)
unknown's avatar
unknown committed
1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033
{
  return 0;
}


static bool sys_update_charset(THD *thd, set_var *var)
{
  return 0;
}


static void sys_set_default_charset(THD *thd, enum_var_type type)
{
}


/*
  If one sets the LOW_PRIORIY UPDATES flag, we also must change the
  used lock type
*/

static void fix_low_priority_updates(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
    thd->update_lock_default= (thd->variables.low_priority_updates ?
			       TL_WRITE_LOW_PRIORITY : TL_WRITE);
}


1034 1035 1036 1037
static void
fix_myisam_max_extra_sort_file_size(THD *thd, enum_var_type type)
{
  myisam_max_extra_temp_length=
1038
    (my_off_t) global_system_variables.myisam_max_extra_sort_file_size;
1039 1040 1041 1042 1043 1044 1045 1046 1047 1048
}


static void
fix_myisam_max_sort_file_size(THD *thd, enum_var_type type)
{
  myisam_max_temp_length=
    (my_off_t) global_system_variables.myisam_max_sort_file_size;
}

unknown's avatar
unknown committed
1049 1050 1051 1052 1053 1054 1055 1056
/*
  Set the OPTION_BIG_SELECTS flag if max_join_size == HA_POS_ERROR
*/

static void fix_max_join_size(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
  {
1057
    if (thd->variables.max_join_size == HA_POS_ERROR)
unknown's avatar
unknown committed
1058 1059 1060 1061 1062
      thd->options|= OPTION_BIG_SELECTS;
    else
      thd->options&= ~OPTION_BIG_SELECTS;
  }
}
1063

unknown's avatar
unknown committed
1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081

/*
  If one doesn't use the SESSION modifier, the isolation level
  is only active for the next command
*/

static void fix_tx_isolation(THD *thd, enum_var_type type)
{
  if (type == OPT_SESSION)
    thd->session_tx_isolation= ((enum_tx_isolation)
				thd->variables.tx_isolation);
}


/*
  If we are changing the thread variable, we have to copy it to NET too
*/

unknown's avatar
SCRUM  
unknown committed
1082
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095
static void fix_net_read_timeout(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
    thd->net.read_timeout=thd->variables.net_read_timeout;
}


static void fix_net_write_timeout(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
    thd->net.write_timeout=thd->variables.net_write_timeout;
}

1096 1097 1098 1099 1100
static void fix_net_retry_count(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
    thd->net.retry_count=thd->variables.net_retry_count;
}
unknown's avatar
SCRUM  
unknown committed
1101 1102 1103
#else /* HAVE_REPLICATION */
static void fix_net_read_timeout(THD *thd __attribute__(unused),
				 enum_var_type type __attribute__(unused))
1104
{}
unknown's avatar
SCRUM  
unknown committed
1105 1106
static void fix_net_write_timeout(THD *thd __attribute__(unused),
				  enum_var_type type __attribute__(unused))
1107
{}
unknown's avatar
SCRUM  
unknown committed
1108 1109
static void fix_net_retry_count(THD *thd __attribute__(unused),
				enum_var_type type __attribute__(unused))
1110
{}
unknown's avatar
SCRUM  
unknown committed
1111
#endif /* HAVE_REPLICATION */
1112

unknown's avatar
unknown committed
1113 1114 1115 1116

static void fix_query_cache_size(THD *thd, enum_var_type type)
{
#ifdef HAVE_QUERY_CACHE
1117
  ulong requested= query_cache_size;
unknown's avatar
unknown committed
1118
  query_cache.resize(query_cache_size);
1119 1120 1121 1122
  if (requested != query_cache_size)
    push_warning_printf(current_thd, MYSQL_ERROR::WARN_LEVEL_WARN,
			ER_WARN_QC_RESIZE, ER(ER_WARN_QC_RESIZE),
			requested, query_cache_size);
unknown's avatar
unknown committed
1123 1124 1125 1126
#endif
}


1127 1128 1129 1130 1131 1132 1133 1134 1135
#ifdef HAVE_QUERY_CACHE
static void fix_query_cache_min_res_unit(THD *thd, enum_var_type type)
{
  query_cache_min_res_unit= 
    query_cache.set_min_res_unit(query_cache_min_res_unit);
}
#endif


1136
extern void fix_delay_key_write(THD *thd, enum_var_type type)
1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151
{
  switch ((enum_delay_key_write) delay_key_write_options) {
  case DELAY_KEY_WRITE_NONE:
    myisam_delay_key_write=0;
    break;
  case DELAY_KEY_WRITE_ON:
    myisam_delay_key_write=1;
    break;
  case DELAY_KEY_WRITE_ALL:
    myisam_delay_key_write=1;
    ha_open_options|= HA_OPEN_DELAY_KEY_WRITE;
    break;
  }
}

1152
static void fix_max_binlog_size(THD *thd, enum_var_type type)
1153 1154 1155 1156 1157
{
  DBUG_ENTER("fix_max_binlog_size");
  DBUG_PRINT("info",("max_binlog_size=%lu max_relay_log_size=%lu",
                     max_binlog_size, max_relay_log_size));
  mysql_bin_log.set_max_size(max_binlog_size);
1158
#ifdef HAVE_REPLICATION
1159 1160
  if (!max_relay_log_size)
    active_mi->rli.relay_log.set_max_size(max_binlog_size);
unknown's avatar
unknown committed
1161
#endif
1162 1163 1164
  DBUG_VOID_RETURN;
}

1165
static void fix_max_relay_log_size(THD *thd, enum_var_type type)
1166 1167 1168 1169
{
  DBUG_ENTER("fix_max_relay_log_size");
  DBUG_PRINT("info",("max_binlog_size=%lu max_relay_log_size=%lu",
                     max_binlog_size, max_relay_log_size));
1170
#ifdef HAVE_REPLICATION
1171 1172
  active_mi->rli.relay_log.set_max_size(max_relay_log_size ?
                                        max_relay_log_size: max_binlog_size);
1173
#endif
1174 1175
  DBUG_VOID_RETURN;
}
1176

1177

1178 1179
static int check_max_delayed_threads(THD *thd, set_var *var)
{
unknown's avatar
unknown committed
1180
  longlong val= var->value->val_int();
1181
  if (var->type != OPT_GLOBAL && val != 0 &&
unknown's avatar
unknown committed
1182
      val != (longlong) global_system_variables.max_insert_delayed_threads)
1183 1184 1185 1186 1187 1188 1189 1190
  {
    char buf[64];
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), var->var->name, llstr(val, buf));
    return 1;
  }
  return 0;
}

unknown's avatar
unknown committed
1191

1192
static void fix_max_connections(THD *thd, enum_var_type type)
1193
{
1194
#ifndef EMBEDDED_LIBRARY
1195 1196
  resize_thr_alarm(max_connections + 
		   global_system_variables.max_insert_delayed_threads + 10);
1197
#endif
1198 1199
}

1200

1201 1202 1203
static void fix_thd_mem_root(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
unknown's avatar
unknown committed
1204
    reset_root_defaults(thd->mem_root,
1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217
                        thd->variables.query_alloc_block_size,
                        thd->variables.query_prealloc_size);
}


static void fix_trans_mem_root(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
    reset_root_defaults(&thd->transaction.mem_root,
                        thd->variables.trans_alloc_block_size,
                        thd->variables.trans_prealloc_size);
}

1218

1219 1220 1221 1222
static void fix_server_id(THD *thd, enum_var_type type)
{
  server_id_supplied = 1;
}
1223

1224

unknown's avatar
unknown committed
1225 1226
bool sys_var_long_ptr::update(THD *thd, set_var *var)
{
1227
  ulonglong tmp= var->save_result.ulonglong_value;
1228
  pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
1229 1230 1231 1232
  if (option_limits)
    *value= (ulong) getopt_ull_limit_value(tmp, option_limits);
  else
    *value= (ulong) tmp;
1233
  pthread_mutex_unlock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
1234 1235 1236 1237 1238 1239 1240 1241 1242 1243
  return 0;
}


void sys_var_long_ptr::set_default(THD *thd, enum_var_type type)
{
  *value= (ulong) option_limits->def_value;
}


1244 1245
bool sys_var_ulonglong_ptr::update(THD *thd, set_var *var)
{
1246
  ulonglong tmp= var->save_result.ulonglong_value;
1247
  pthread_mutex_lock(&LOCK_global_system_variables);
1248 1249 1250 1251
  if (option_limits)
    *value= (ulonglong) getopt_ull_limit_value(tmp, option_limits);
  else
    *value= (ulonglong) tmp;
1252
  pthread_mutex_unlock(&LOCK_global_system_variables);
1253 1254 1255 1256 1257 1258
  return 0;
}


void sys_var_ulonglong_ptr::set_default(THD *thd, enum_var_type type)
{
1259
  pthread_mutex_lock(&LOCK_global_system_variables);
1260
  *value= (ulonglong) option_limits->def_value;
1261
  pthread_mutex_unlock(&LOCK_global_system_variables);
1262 1263 1264
}


unknown's avatar
unknown committed
1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277
bool sys_var_bool_ptr::update(THD *thd, set_var *var)
{
  *value= (my_bool) var->save_result.ulong_value;
  return 0;
}


void sys_var_bool_ptr::set_default(THD *thd, enum_var_type type)
{
  *value= (my_bool) option_limits->def_value;
}


1278 1279 1280 1281 1282 1283 1284
bool sys_var_enum::update(THD *thd, set_var *var)
{
  *value= (uint) var->save_result.ulong_value;
  return 0;
}


1285
byte *sys_var_enum::value_ptr(THD *thd, enum_var_type type, LEX_STRING *base)
1286 1287 1288 1289
{
  return (byte*) enum_names->type_names[*value];
}

1290 1291 1292 1293 1294
bool sys_var_thd_ulong::check(THD *thd, set_var *var)
{
  return (sys_var_thd::check(thd, var) ||
          (check_func && (*check_func)(thd, var)));
}
1295

unknown's avatar
unknown committed
1296 1297
bool sys_var_thd_ulong::update(THD *thd, set_var *var)
{
1298
  ulonglong tmp= var->save_result.ulonglong_value;
unknown's avatar
unknown committed
1299 1300 1301 1302 1303 1304 1305 1306

  /* Don't use bigger value than given with --maximum-variable-name=.. */
  if ((ulong) tmp > max_system_variables.*offset)
    tmp= max_system_variables.*offset;

  if (option_limits)
    tmp= (ulong) getopt_ull_limit_value(tmp, option_limits);
  if (var->type == OPT_GLOBAL)
1307
    global_system_variables.*offset= (ulong) tmp;
unknown's avatar
unknown committed
1308 1309 1310 1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325
  else
    thd->variables.*offset= (ulong) tmp;
  return 0;
}


void sys_var_thd_ulong::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
  {
    /* We will not come here if option_limits is not set */
    global_system_variables.*offset= (ulong) option_limits->def_value;
  }
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1326 1327
byte *sys_var_thd_ulong::value_ptr(THD *thd, enum_var_type type,
				   LEX_STRING *base)
unknown's avatar
unknown committed
1328 1329 1330 1331 1332 1333 1334
{
  if (type == OPT_GLOBAL)
    return (byte*) &(global_system_variables.*offset);
  return (byte*) &(thd->variables.*offset);
}


1335 1336
bool sys_var_thd_ha_rows::update(THD *thd, set_var *var)
{
1337
  ulonglong tmp= var->save_result.ulonglong_value;
1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371

  /* Don't use bigger value than given with --maximum-variable-name=.. */
  if ((ha_rows) tmp > max_system_variables.*offset)
    tmp= max_system_variables.*offset;

  if (option_limits)
    tmp= (ha_rows) getopt_ull_limit_value(tmp, option_limits);
  if (var->type == OPT_GLOBAL)
  {
    /* Lock is needed to make things safe on 32 bit systems */
    pthread_mutex_lock(&LOCK_global_system_variables);    
    global_system_variables.*offset= (ha_rows) tmp;
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
  else
    thd->variables.*offset= (ha_rows) tmp;
  return 0;
}


void sys_var_thd_ha_rows::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
  {
    /* We will not come here if option_limits is not set */
    pthread_mutex_lock(&LOCK_global_system_variables);
    global_system_variables.*offset= (ha_rows) option_limits->def_value;
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1372 1373
byte *sys_var_thd_ha_rows::value_ptr(THD *thd, enum_var_type type,
				     LEX_STRING *base)
1374 1375 1376 1377 1378 1379
{
  if (type == OPT_GLOBAL)
    return (byte*) &(global_system_variables.*offset);
  return (byte*) &(thd->variables.*offset);
}

unknown's avatar
unknown committed
1380 1381
bool sys_var_thd_ulonglong::update(THD *thd,  set_var *var)
{
1382
  ulonglong tmp= var->save_result.ulonglong_value;
1383

1384
  if (tmp > max_system_variables.*offset)
1385 1386 1387
    tmp= max_system_variables.*offset;

  if (option_limits)
1388
    tmp= getopt_ull_limit_value(tmp, option_limits);
unknown's avatar
unknown committed
1389
  if (var->type == OPT_GLOBAL)
1390 1391 1392
  {
    /* Lock is needed to make things safe on 32 bit systems */
    pthread_mutex_lock(&LOCK_global_system_variables);
1393
    global_system_variables.*offset= (ulonglong) tmp;
1394 1395
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
unknown's avatar
unknown committed
1396
  else
1397
    thd->variables.*offset= (ulonglong) tmp;
unknown's avatar
unknown committed
1398 1399 1400 1401 1402 1403 1404
  return 0;
}


void sys_var_thd_ulonglong::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
1405 1406
  {
    pthread_mutex_lock(&LOCK_global_system_variables);
1407
    global_system_variables.*offset= (ulonglong) option_limits->def_value;
1408 1409
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
unknown's avatar
unknown committed
1410 1411 1412 1413 1414
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1415 1416
byte *sys_var_thd_ulonglong::value_ptr(THD *thd, enum_var_type type,
				       LEX_STRING *base)
unknown's avatar
unknown committed
1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442
{
  if (type == OPT_GLOBAL)
    return (byte*) &(global_system_variables.*offset);
  return (byte*) &(thd->variables.*offset);
}


bool sys_var_thd_bool::update(THD *thd,  set_var *var)
{
  if (var->type == OPT_GLOBAL)
    global_system_variables.*offset= (my_bool) var->save_result.ulong_value;
  else
    thd->variables.*offset= (my_bool) var->save_result.ulong_value;
  return 0;
}


void sys_var_thd_bool::set_default(THD *thd,  enum_var_type type)
{
  if (type == OPT_GLOBAL)
    global_system_variables.*offset= (my_bool) option_limits->def_value;
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1443 1444
byte *sys_var_thd_bool::value_ptr(THD *thd, enum_var_type type,
				  LEX_STRING *base)
unknown's avatar
unknown committed
1445 1446 1447 1448 1449 1450 1451 1452 1453
{
  if (type == OPT_GLOBAL)
    return (byte*) &(global_system_variables.*offset);
  return (byte*) &(thd->variables.*offset);
}


bool sys_var::check_enum(THD *thd, set_var *var, TYPELIB *enum_names)
{
1454 1455
  char buff[80];
  const char *value;
1456
  String str(buff, sizeof(buff), system_charset_info), *res;
unknown's avatar
unknown committed
1457 1458 1459 1460 1461

  if (var->value->result_type() == STRING_RESULT)
  {
    if (!(res=var->value->val_str(&str)) ||
	((long) (var->save_result.ulong_value=
1462 1463
		 (ulong) find_type(enum_names, res->ptr(),
				   res->length(),1)-1)) < 0)
unknown's avatar
unknown committed
1464
    {
1465
      value= res ? res->c_ptr() : "NULL";
unknown's avatar
unknown committed
1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486
      goto err;
    }
  }
  else
  {
    ulonglong tmp=var->value->val_int();
    if (tmp >= enum_names->count)
    {
      llstr(tmp,buff);
      value=buff;				// Wrong value is here
      goto err;
    }
    var->save_result.ulong_value= (ulong) tmp;	// Save for update
  }
  return 0;

err:
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, value);
  return 1;
}

1487 1488 1489

bool sys_var::check_set(THD *thd, set_var *var, TYPELIB *enum_names)
{
1490
  bool not_used;
unknown's avatar
unknown committed
1491
  char buff[80], *error= 0;
1492 1493 1494 1495 1496 1497 1498
  uint error_len= 0;
  String str(buff, sizeof(buff), system_charset_info), *res;

  if (var->value->result_type() == STRING_RESULT)
  {
    if (!(res= var->value->val_str(&str)))
      goto err;
unknown's avatar
unknown committed
1499 1500
    var->save_result.ulong_value= ((ulong)
				   find_set(enum_names, res->c_ptr(),
1501 1502 1503
					    res->length(),
                                            NULL,
                                            &error, &error_len,
unknown's avatar
unknown committed
1504
					    &not_used));
1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526 1527 1528
    if (error_len)
    {
      strmake(buff, error, min(sizeof(buff), error_len));
      goto err;
    }
  }
  else
  {
    ulonglong tmp= var->value->val_int();
    if (tmp >= enum_names->count)
    {
      llstr(tmp, buff);
      goto err;
    }
    var->save_result.ulong_value= (ulong) tmp;  // Save for update
  }
  return 0;

err:
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, buff);
  return 1;
}


unknown's avatar
unknown committed
1529 1530 1531 1532 1533 1534 1535
/*
  Return an Item for a variable.  Used with @@[global.]variable_name

  If type is not given, return local value if exists, else global

  We have to use netprintf() instead of my_error() here as this is
  called on the parsing stage.
1536 1537 1538 1539

  TODO:
    With prepared statements/stored procedures this has to be fixed
    to create an item that gets the current value at fix_fields() stage.
unknown's avatar
unknown committed
1540 1541
*/

1542
Item *sys_var::item(THD *thd, enum_var_type var_type, LEX_STRING *base)
unknown's avatar
unknown committed
1543 1544 1545 1546 1547
{
  if (check_type(var_type))
  {
    if (var_type != OPT_DEFAULT)
    {
unknown's avatar
unknown committed
1548
      net_printf(thd, ER_INCORRECT_GLOBAL_LOCAL_VAR,
1549
		 name, var_type == OPT_GLOBAL ? "SESSION" : "GLOBAL");
unknown's avatar
unknown committed
1550 1551 1552 1553 1554 1555 1556
      return 0;
    }
    /* As there was no local variable, return the global value */
    var_type= OPT_GLOBAL;
  }
  switch (type()) {
  case SHOW_LONG:
1557 1558 1559 1560 1561 1562 1563
  {
    ulong value;
    pthread_mutex_lock(&LOCK_global_system_variables);
    value= *(ulong*) value_ptr(thd, var_type, base);
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return new Item_uint((int32) value);
  }
unknown's avatar
unknown committed
1564
  case SHOW_LONGLONG:
1565 1566 1567
  {
    longlong value;
    pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
1568
    value= *(longlong*) value_ptr(thd, var_type, base);
1569 1570 1571
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return new Item_int(value);
  }
1572
  case SHOW_HA_ROWS:
1573 1574 1575
  {
    ha_rows value;
    pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
1576
    value= *(ha_rows*) value_ptr(thd, var_type, base);
1577 1578 1579
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return new Item_int((longlong) value);
  }
unknown's avatar
unknown committed
1580
  case SHOW_MY_BOOL:
1581
    return new Item_int((int32) *(my_bool*) value_ptr(thd, var_type, base),1);
unknown's avatar
unknown committed
1582 1583
  case SHOW_CHAR:
  {
1584 1585
    Item_string *tmp;
    pthread_mutex_lock(&LOCK_global_system_variables);
1586
    char *str= (char*) value_ptr(thd, var_type, base);
1587 1588 1589
    tmp= new Item_string(str, strlen(str), system_charset_info);
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return tmp;
unknown's avatar
unknown committed
1590 1591
  }
  default:
1592
    net_printf(thd, ER_VAR_CANT_BE_READ, name);
unknown's avatar
unknown committed
1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616
  }
  return 0;
}


bool sys_var_thd_enum::update(THD *thd, set_var *var)
{
  if (var->type == OPT_GLOBAL)
    global_system_variables.*offset= var->save_result.ulong_value;
  else
    thd->variables.*offset= var->save_result.ulong_value;
  return 0;
}


void sys_var_thd_enum::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
    global_system_variables.*offset= (ulong) option_limits->def_value;
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1617 1618
byte *sys_var_thd_enum::value_ptr(THD *thd, enum_var_type type,
				  LEX_STRING *base)
unknown's avatar
unknown committed
1619 1620 1621 1622 1623 1624 1625
{
  ulong tmp= ((type == OPT_GLOBAL) ?
	      global_system_variables.*offset :
	      thd->variables.*offset);
  return (byte*) enum_names->type_names[tmp];
}

1626 1627 1628 1629 1630
bool sys_var_thd_bit::check(THD *thd, set_var *var)
{
  return (check_enum(thd, var, &bool_typelib) ||
          (check_func && (*check_func)(thd, var)));
}
unknown's avatar
unknown committed
1631 1632 1633

bool sys_var_thd_bit::update(THD *thd, set_var *var)
{
1634
  int res= (*update_func)(thd, var);
unknown's avatar
unknown committed
1635 1636 1637 1638
  return res;
}


1639 1640
byte *sys_var_thd_bit::value_ptr(THD *thd, enum_var_type type,
				 LEX_STRING *base)
unknown's avatar
unknown committed
1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651
{
  /*
    If reverse is 0 (default) return 1 if bit is set.
    If reverse is 1, return 0 if bit is set
  */
  thd->sys_var_tmp.my_bool_value= ((thd->options & bit_flag) ?
				   !reverse : reverse);
  return (byte*) &thd->sys_var_tmp.my_bool_value;
}


1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716 1717 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746 1747 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757
/* Update a date_time format variable based on given value */

void sys_var_thd_date_time_format::update2(THD *thd, enum_var_type type,
					   DATE_TIME_FORMAT *new_value)
{
  DATE_TIME_FORMAT *old;
  DBUG_ENTER("sys_var_date_time_format::update2");
  DBUG_DUMP("positions",(char*) new_value->positions,
	    sizeof(new_value->positions));

  if (type == OPT_GLOBAL)
  {
    pthread_mutex_lock(&LOCK_global_system_variables);
    old= (global_system_variables.*offset);
    (global_system_variables.*offset)= new_value;
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
  else
  {
    old= (thd->variables.*offset);
    (thd->variables.*offset)= new_value;
  }
  my_free((char*) old, MYF(MY_ALLOW_ZERO_PTR));
  DBUG_VOID_RETURN;
}


bool sys_var_thd_date_time_format::update(THD *thd, set_var *var)
{
  DATE_TIME_FORMAT *new_value;
  /* We must make a copy of the last value to get it into normal memory */
  new_value= date_time_format_copy((THD*) 0,
				   var->save_result.date_time_format);
  if (!new_value)
    return 1;					// Out of memory
  update2(thd, var->type, new_value);		// Can't fail
  return 0;
}


bool sys_var_thd_date_time_format::check(THD *thd, set_var *var)
{
  char buff[80];
  String str(buff,sizeof(buff), system_charset_info), *res;
  DATE_TIME_FORMAT *format;

  if (!(res=var->value->val_str(&str)))
    res= &my_empty_string;

  if (!(format= date_time_format_make(date_time_type,
				      res->ptr(), res->length())))
  {
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, res->c_ptr());
    return 1;
  }
  
  /*
    We must copy result to thread space to not get a memory leak if
    update is aborted
  */
  var->save_result.date_time_format= date_time_format_copy(thd, format);
  my_free((char*) format, MYF(0));
  return var->save_result.date_time_format == 0;
}


void sys_var_thd_date_time_format::set_default(THD *thd, enum_var_type type)
{
  DATE_TIME_FORMAT *res= 0;

  if (type == OPT_GLOBAL)
  {
    const char *format;
    if ((format= opt_date_time_formats[date_time_type]))
      res= date_time_format_make(date_time_type, format, strlen(format));
  }
  else
  {
    /* Make copy with malloc */
    res= date_time_format_copy((THD *) 0, global_system_variables.*offset);
  }

  if (res)					// Should always be true
    update2(thd, type, res);
}


byte *sys_var_thd_date_time_format::value_ptr(THD *thd, enum_var_type type,
					      LEX_STRING *base)
{
  if (type == OPT_GLOBAL)
  {
    char *res;
    /*
      We do a copy here just to be sure things will work even if someone
      is modifying the original string while the copy is accessed
      (Can't happen now in SQL SHOW, but this is a good safety for the future)
    */
    res= thd->strmake((global_system_variables.*offset)->format.str,
		      (global_system_variables.*offset)->format.length);
    return (byte*) res;
  }
  return (byte*) (thd->variables.*offset)->format.str;
}


1758 1759
typedef struct old_names_map_st
{
unknown's avatar
unknown committed
1760 1761 1762
  const char *old_name;
  const char *new_name;
} my_old_conv;
unknown's avatar
unknown committed
1763

unknown's avatar
unknown committed
1764 1765
static my_old_conv old_conv[]= 
{
1766 1767 1768 1769 1770 1771 1772 1773 1774 1775 1776
  {	"cp1251_koi8"		,	"cp1251"	},
  {	"cp1250_latin2"		,	"cp1250"	},
  {	"kam_latin2"		,	"keybcs2"	},
  {	"mac_latin2"		,	"MacRoman"	},
  {	"macce_latin2"		,	"MacCE"		},
  {	"pc2_latin2"		,	"pclatin2"	},
  {	"vga_latin2"		,	"pclatin1"	},
  {	"koi8_cp1251"		,	"koi8r"		},
  {	"win1251ukr_koi8_ukr"	,	"win1251ukr"	},
  {	"koi8_ukr_win1251ukr"	,	"koi8u"		},
  {	NULL			,	NULL		}
unknown's avatar
unknown committed
1777
};
unknown's avatar
unknown committed
1778

unknown's avatar
unknown committed
1779
CHARSET_INFO *get_old_charset_by_name(const char *name)
unknown's avatar
unknown committed
1780
{
unknown's avatar
unknown committed
1781
  my_old_conv *conv;
unknown's avatar
unknown committed
1782
 
unknown's avatar
unknown committed
1783
  for (conv= old_conv; conv->old_name; conv++)
1784
  {
unknown's avatar
unknown committed
1785 1786
    if (!my_strcasecmp(&my_charset_latin1, name, conv->old_name))
      return get_charset_by_csname(conv->new_name, MY_CS_PRIMARY, MYF(0));
1787
  }
unknown's avatar
unknown committed
1788
  return NULL;
unknown's avatar
unknown committed
1789 1790
}

unknown's avatar
unknown committed
1791

1792
bool sys_var_collation::check(THD *thd, set_var *var)
unknown's avatar
unknown committed
1793 1794 1795
{
  CHARSET_INFO *tmp;

1796
  if (var->value->result_type() == STRING_RESULT)
1797
  {
1798 1799 1800 1801 1802 1803 1804 1805 1806 1807 1808 1809
    char buff[80];
    String str(buff,sizeof(buff), system_charset_info), *res;
    if (!(res=var->value->val_str(&str)))
    {
      my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, "NULL");
      return 1;
    }
    if (!(tmp=get_charset_by_name(res->c_ptr(),MYF(0))))
    {
      my_error(ER_UNKNOWN_COLLATION, MYF(0), res->c_ptr());
      return 1;
    }
1810
  }
1811
  else // INT_RESULT
1812
  {
1813
    if (!(tmp=get_charset((int) var->value->val_int(),MYF(0))))
1814 1815
    {
      char buf[20];
1816
      int10_to_str((int) var->value->val_int(), buf, -10);
1817 1818 1819
      my_error(ER_UNKNOWN_COLLATION, MYF(0), buf);
      return 1;
    }
1820 1821 1822 1823 1824
  }
  var->save_result.charset= tmp;	// Save for update
  return 0;
}

1825

1826 1827 1828 1829
bool sys_var_character_set::check(THD *thd, set_var *var)
{
  CHARSET_INFO *tmp;

1830 1831 1832 1833 1834
  if (var->value->result_type() == STRING_RESULT)
  {
    char buff[80];
    String str(buff,sizeof(buff), system_charset_info), *res;
    if (!(res=var->value->val_str(&str)))
1835
    {
1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846
      if (!nullable)
      {
        my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, "NULL");
        return 1;
      }
      tmp= NULL;
    }
    else if (!(tmp=get_charset_by_csname(res->c_ptr(),MY_CS_PRIMARY,MYF(0))) &&
             !(tmp=get_old_charset_by_name(res->c_ptr())))
    {
      my_error(ER_UNKNOWN_CHARACTER_SET, MYF(0), res->c_ptr());
1847 1848 1849
      return 1;
    }
  }
1850
  else // INT_RESULT
unknown's avatar
unknown committed
1851
  {
1852
    if (!(tmp=get_charset((int) var->value->val_int(),MYF(0))))
1853 1854
    {
      char buf[20];
1855
      int10_to_str((int) var->value->val_int(), buf, -10);
1856 1857 1858
      my_error(ER_UNKNOWN_CHARACTER_SET, MYF(0), buf);
      return 1;
    }
unknown's avatar
unknown committed
1859 1860 1861 1862 1863
  }
  var->save_result.charset= tmp;	// Save for update
  return 0;
}

1864

1865
bool sys_var_character_set::update(THD *thd, set_var *var)
unknown's avatar
unknown committed
1866
{
1867
  ci_ptr(thd,var->type)[0]= var->save_result.charset;
unknown's avatar
unknown committed
1868
  thd->update_charset();
unknown's avatar
unknown committed
1869 1870 1871
  return 0;
}

1872 1873 1874

byte *sys_var_character_set::value_ptr(THD *thd, enum_var_type type,
				       LEX_STRING *base)
unknown's avatar
unknown committed
1875
{
1876
  CHARSET_INFO *cs= ci_ptr(thd,type)[0];
1877
  return cs ? (byte*) cs->csname : (byte*) "NULL";
unknown's avatar
unknown committed
1878 1879
}

1880

1881 1882
CHARSET_INFO ** sys_var_character_set_connection::ci_ptr(THD *thd,
							 enum_var_type type)
unknown's avatar
unknown committed
1883 1884 1885 1886 1887 1888 1889
{
  if (type == OPT_GLOBAL)
    return &global_system_variables.collation_connection;
  else
    return &thd->variables.collation_connection;
}

1890 1891 1892

void sys_var_character_set_connection::set_default(THD *thd,
						   enum_var_type type)
unknown's avatar
unknown committed
1893 1894 1895 1896
{
 if (type == OPT_GLOBAL)
   global_system_variables.collation_connection= default_charset_info;
 else
unknown's avatar
unknown committed
1897
 {
unknown's avatar
unknown committed
1898
   thd->variables.collation_connection= global_system_variables.collation_connection;
unknown's avatar
unknown committed
1899 1900
   thd->update_charset();
 }
unknown's avatar
unknown committed
1901 1902
}

1903

1904 1905
CHARSET_INFO ** sys_var_character_set_client::ci_ptr(THD *thd,
						     enum_var_type type)
1906 1907 1908 1909 1910 1911 1912
{
  if (type == OPT_GLOBAL)
    return &global_system_variables.character_set_client;
  else
    return &thd->variables.character_set_client;
}

1913

1914
void sys_var_character_set_client::set_default(THD *thd, enum_var_type type)
1915 1916
{
 if (type == OPT_GLOBAL)
1917
   global_system_variables.character_set_client= default_charset_info;
1918
 else
unknown's avatar
unknown committed
1919 1920 1921 1922 1923
 {
   thd->variables.character_set_client= (global_system_variables.
					 character_set_client);
   thd->update_charset();
 }
1924
}
unknown's avatar
unknown committed
1925

1926

unknown's avatar
unknown committed
1927 1928
CHARSET_INFO **
sys_var_character_set_results::ci_ptr(THD *thd, enum_var_type type)
1929
{
1930 1931
  if (type == OPT_GLOBAL)
    return &global_system_variables.character_set_results;
1932
  else
1933
    return &thd->variables.character_set_results;
1934 1935
}

1936

1937
void sys_var_character_set_results::set_default(THD *thd, enum_var_type type)
1938
{
1939
 if (type == OPT_GLOBAL)
1940
   global_system_variables.character_set_results= default_charset_info;
1941
 else
unknown's avatar
unknown committed
1942 1943 1944 1945 1946
 {
   thd->variables.character_set_results= (global_system_variables.
					  character_set_results);
   thd->update_charset();
 }
1947 1948
}

1949

unknown's avatar
unknown committed
1950 1951
CHARSET_INFO **
sys_var_character_set_server::ci_ptr(THD *thd, enum_var_type type)
1952 1953
{
  if (type == OPT_GLOBAL)
1954
    return &global_system_variables.collation_server;
1955
  else
1956
    return &thd->variables.collation_server;
1957 1958
}

1959

1960
void sys_var_character_set_server::set_default(THD *thd, enum_var_type type)
1961 1962
{
 if (type == OPT_GLOBAL)
1963
   global_system_variables.collation_server= default_charset_info;
1964
 else
unknown's avatar
unknown committed
1965
 {
1966
   thd->variables.collation_server= global_system_variables.collation_server;
unknown's avatar
unknown committed
1967 1968
   thd->update_charset();
 }
1969 1970
}

1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984
#if defined(HAVE_REPLICATION) && (MYSQL_VERSION_ID < 50000)
bool sys_var_character_set_server::check(THD *thd, set_var *var)
{
  if ((var->type == OPT_GLOBAL) &&
      (mysql_bin_log.is_open() ||
       active_mi->slave_running || active_mi->rli.slave_running))
  {
    my_printf_error(0, "Binary logging and replication forbid changing \
the global server character set or collation", MYF(0));
    return 1;
  }
  return sys_var_character_set::check(thd,var);
}
#endif
1985 1986 1987

CHARSET_INFO ** sys_var_character_set_database::ci_ptr(THD *thd,
						       enum_var_type type)
1988 1989
{
  if (type == OPT_GLOBAL)
1990
    return &global_system_variables.collation_database;
1991
  else
1992
    return &thd->variables.collation_database;
1993 1994
}

1995

1996 1997 1998
void sys_var_character_set_database::set_default(THD *thd, enum_var_type type)
{
 if (type == OPT_GLOBAL)
1999
    global_system_variables.collation_database= default_charset_info;
2000
  else
unknown's avatar
unknown committed
2001
  {
2002
    thd->variables.collation_database= thd->db_charset;
unknown's avatar
unknown committed
2003 2004
    thd->update_charset();
  }
2005 2006
}

2007

2008
bool sys_var_collation_connection::update(THD *thd, set_var *var)
2009 2010
{
  if (var->type == OPT_GLOBAL)
2011
    global_system_variables.collation_connection= var->save_result.charset;
2012
  else
unknown's avatar
unknown committed
2013
  {
2014
    thd->variables.collation_connection= var->save_result.charset;
unknown's avatar
unknown committed
2015 2016
    thd->update_charset();
  }
2017 2018 2019
  return 0;
}

2020 2021 2022

byte *sys_var_collation_connection::value_ptr(THD *thd, enum_var_type type,
					      LEX_STRING *base)
2023 2024
{
  CHARSET_INFO *cs= ((type == OPT_GLOBAL) ?
2025 2026 2027
		  global_system_variables.collation_connection :
		  thd->variables.collation_connection);
  return cs ? (byte*) cs->name : (byte*) "NULL";
2028 2029
}

2030

2031
void sys_var_collation_connection::set_default(THD *thd, enum_var_type type)
2032 2033
{
 if (type == OPT_GLOBAL)
2034
   global_system_variables.collation_connection= default_charset_info;
2035
 else
unknown's avatar
unknown committed
2036 2037 2038 2039 2040
 {
   thd->variables.collation_connection= (global_system_variables.
					 collation_connection);
   thd->update_charset();
 }
2041 2042
}

2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077
bool sys_var_collation_database::update(THD *thd, set_var *var)
{
  if (var->type == OPT_GLOBAL)
    global_system_variables.collation_database= var->save_result.charset;
  else
  {
    thd->variables.collation_database= var->save_result.charset;
    thd->update_charset();
  }
  return 0;
}


byte *sys_var_collation_database::value_ptr(THD *thd, enum_var_type type,
					      LEX_STRING *base)
{
  CHARSET_INFO *cs= ((type == OPT_GLOBAL) ?
		  global_system_variables.collation_database :
		  thd->variables.collation_database);
  return cs ? (byte*) cs->name : (byte*) "NULL";
}


void sys_var_collation_database::set_default(THD *thd, enum_var_type type)
{
 if (type == OPT_GLOBAL)
   global_system_variables.collation_database= default_charset_info;
 else
 {
   thd->variables.collation_database= (global_system_variables.
					 collation_database);
   thd->update_charset();
 }
}

2078 2079 2080 2081 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091
#if defined(HAVE_REPLICATION) && (MYSQL_VERSION_ID < 50000)
bool sys_var_collation_server::check(THD *thd, set_var *var)
{
  if ((var->type == OPT_GLOBAL) &&
      (mysql_bin_log.is_open() ||
       active_mi->slave_running || active_mi->rli.slave_running))
  {
    my_printf_error(0, "Binary logging and replication forbid changing \
the global server character set or collation", MYF(0));
    return 1;
  }
  return sys_var_collation::check(thd,var);
}
#endif
2092 2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 2121 2122 2123 2124 2125 2126 2127

bool sys_var_collation_server::update(THD *thd, set_var *var)
{
  if (var->type == OPT_GLOBAL)
    global_system_variables.collation_server= var->save_result.charset;
  else
  {
    thd->variables.collation_server= var->save_result.charset;
    thd->update_charset();
  }
  return 0;
}


byte *sys_var_collation_server::value_ptr(THD *thd, enum_var_type type,
					      LEX_STRING *base)
{
  CHARSET_INFO *cs= ((type == OPT_GLOBAL) ?
		  global_system_variables.collation_server :
		  thd->variables.collation_server);
  return cs ? (byte*) cs->name : (byte*) "NULL";
}


void sys_var_collation_server::set_default(THD *thd, enum_var_type type)
{
 if (type == OPT_GLOBAL)
   global_system_variables.collation_server= default_charset_info;
 else
 {
   thd->variables.collation_server= (global_system_variables.
					 collation_server);
   thd->update_charset();
 }
}

2128

2129
LEX_STRING default_key_cache_base= {(char *) "default", 7 };
unknown's avatar
unknown committed
2130

unknown's avatar
unknown committed
2131
static KEY_CACHE zero_key_cache;
unknown's avatar
unknown committed
2132

unknown's avatar
unknown committed
2133
KEY_CACHE *get_key_cache(LEX_STRING *cache_name)
unknown's avatar
unknown committed
2134
{
2135 2136
  safe_mutex_assert_owner(&LOCK_global_system_variables);
  if (!cache_name || ! cache_name->length)
unknown's avatar
unknown committed
2137
    cache_name= &default_key_cache_base;
unknown's avatar
unknown committed
2138
  return ((KEY_CACHE*) find_named(&key_caches,
2139
                                      cache_name->str, cache_name->length, 0));
unknown's avatar
unknown committed
2140 2141
}

2142

unknown's avatar
unknown committed
2143 2144
byte *sys_var_key_cache_param::value_ptr(THD *thd, enum_var_type type,
					 LEX_STRING *base)
2145
{
unknown's avatar
unknown committed
2146
  KEY_CACHE *key_cache= get_key_cache(base);
unknown's avatar
unknown committed
2147 2148 2149 2150
  if (!key_cache)
    key_cache= &zero_key_cache;
  return (byte*) key_cache + offset ;
}
unknown's avatar
unknown committed
2151

2152

2153 2154
bool sys_var_key_buffer_size::update(THD *thd, set_var *var)
{
2155
  ulonglong tmp= var->save_result.ulonglong_value;
unknown's avatar
unknown committed
2156
  LEX_STRING *base_name= &var->base;
unknown's avatar
unknown committed
2157
  KEY_CACHE *key_cache;
2158 2159 2160
  bool error= 0;

  /* If no basename, assume it's for the key cache named 'default' */
unknown's avatar
unknown committed
2161
  if (!base_name->length)
2162
    base_name= &default_key_cache_base;
2163 2164 2165

  pthread_mutex_lock(&LOCK_global_system_variables);
  key_cache= get_key_cache(base_name);
unknown's avatar
unknown committed
2166
                            
2167 2168
  if (!key_cache)
  {
2169
    /* Key cache didn't exists */
2170
    if (!tmp)					// Tried to delete cache
2171 2172 2173 2174 2175 2176
      goto end;					// Ok, nothing to do
    if (!(key_cache= create_key_cache(base_name->str, base_name->length)))
    {
      error= 1;
      goto end;
    }
2177
  }
2178 2179 2180 2181 2182 2183 2184 2185 2186

  /*
    Abort if some other thread is changing the key cache
    TODO: This should be changed so that we wait until the previous
    assignment is done and then do the new assign
  */
  if (key_cache->in_init)
    goto end;

unknown's avatar
unknown committed
2187
  if (!tmp)					// Zero size means delete
2188
  {
2189 2190 2191
    if (key_cache == sql_key_cache)
      goto end;					// Ignore default key cache

unknown's avatar
unknown committed
2192
    if (key_cache->key_cache_inited)		// If initied
2193 2194
    {
      /*
2195 2196
	Move tables using this key cache to the default key cache
	and clear the old key cache.
2197
      */
2198
      NAMED_LIST *list; 
unknown's avatar
unknown committed
2199
      key_cache= (KEY_CACHE *) find_named(&key_caches, base_name->str,
2200
					      base_name->length, &list);
2201 2202 2203 2204 2205
      key_cache->in_init= 1;
      pthread_mutex_unlock(&LOCK_global_system_variables);
      error= reassign_keycache_tables(thd, key_cache, sql_key_cache);
      pthread_mutex_lock(&LOCK_global_system_variables);
      key_cache->in_init= 0;
2206
    }
2207 2208 2209 2210 2211
    /*
      We don't delete the key cache as some running threads my still be
      in the key cache code with a pointer to the deleted (empty) key cache
    */
    goto end;
2212 2213
  }

unknown's avatar
unknown committed
2214 2215
  key_cache->param_buff_size=
    (ulonglong) getopt_ull_limit_value(tmp, option_limits);
2216

2217 2218 2219 2220
  /* If key cache didn't existed initialize it, else resize it */
  key_cache->in_init= 1;
  pthread_mutex_unlock(&LOCK_global_system_variables);

unknown's avatar
unknown committed
2221
  if (!key_cache->key_cache_inited)
2222
    error= (bool) (ha_init_key_cache("", key_cache));
unknown's avatar
unknown committed
2223
  else
2224
    error= (bool)(ha_resize_key_cache(key_cache));
2225

2226 2227
  pthread_mutex_lock(&LOCK_global_system_variables);
  key_cache->in_init= 0;  
2228

2229 2230 2231
end:
  pthread_mutex_unlock(&LOCK_global_system_variables);
  return error;
2232 2233
}

2234 2235

bool sys_var_key_cache_long::update(THD *thd, set_var *var)
2236
{
unknown's avatar
unknown committed
2237
  ulong tmp= (ulong) var->value->val_int();
2238
  LEX_STRING *base_name= &var->base;
2239 2240
  bool error= 0;

2241
  if (!base_name->length)
unknown's avatar
unknown committed
2242
    base_name= &default_key_cache_base;
2243 2244

  pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
2245
  KEY_CACHE *key_cache= get_key_cache(base_name);
unknown's avatar
unknown committed
2246

unknown's avatar
unknown committed
2247 2248
  if (!key_cache && !(key_cache= create_key_cache(base_name->str,
				                  base_name->length)))
2249 2250 2251 2252
  {
    error= 1;
    goto end;
  }
unknown's avatar
unknown committed
2253

2254 2255 2256 2257 2258 2259 2260 2261 2262
  /*
    Abort if some other thread is changing the key cache
    TODO: This should be changed so that we wait until the previous
    assignment is done and then do the new assign
  */
  if (key_cache->in_init)
    goto end;

  *((ulong*) (((char*) key_cache) + offset))=
2263
    (ulong) getopt_ull_limit_value(tmp, option_limits);
unknown's avatar
unknown committed
2264

2265 2266 2267 2268 2269
  /*
    Don't create a new key cache if it didn't exist
    (key_caches are created only when the user sets block_size)
  */
  key_cache->in_init= 1;
2270

2271
  pthread_mutex_unlock(&LOCK_global_system_variables);
2272

2273 2274 2275 2276 2277 2278 2279 2280
  error= (bool) (ha_resize_key_cache(key_cache));

  pthread_mutex_lock(&LOCK_global_system_variables);
  key_cache->in_init= 0;  

end:
  pthread_mutex_unlock(&LOCK_global_system_variables);
  return error;
2281 2282
}

2283

2284 2285 2286 2287
/*****************************************************************************
  Functions to handle SET NAMES and SET CHARACTER SET
*****************************************************************************/

unknown's avatar
unknown committed
2288
int set_var_collation_client::check(THD *thd)
2289 2290 2291 2292
{
  return 0;
}

unknown's avatar
unknown committed
2293
int set_var_collation_client::update(THD *thd)
2294
{
2295 2296
  thd->variables.character_set_client= character_set_client;
  thd->variables.character_set_results= character_set_results;
unknown's avatar
unknown committed
2297
  thd->variables.collation_connection= collation_connection;
unknown's avatar
unknown committed
2298
  thd->update_charset();
2299 2300 2301 2302 2303 2304 2305
  thd->protocol_simple.init(thd);
  thd->protocol_prep.init(thd);
  return 0;
}

/****************************************************************************/

unknown's avatar
unknown committed
2306 2307
bool sys_var_timestamp::update(THD *thd,  set_var *var)
{
2308
  thd->set_time((time_t) var->save_result.ulonglong_value);
unknown's avatar
unknown committed
2309 2310 2311 2312 2313 2314 2315 2316 2317 2318
  return 0;
}


void sys_var_timestamp::set_default(THD *thd, enum_var_type type)
{
  thd->user_time=0;
}


2319 2320
byte *sys_var_timestamp::value_ptr(THD *thd, enum_var_type type,
				   LEX_STRING *base)
unknown's avatar
unknown committed
2321 2322 2323 2324 2325 2326 2327 2328
{
  thd->sys_var_tmp.long_value= (long) thd->start_time;
  return (byte*) &thd->sys_var_tmp.long_value;
}


bool sys_var_last_insert_id::update(THD *thd, set_var *var)
{
2329
  thd->insert_id(var->save_result.ulonglong_value);
unknown's avatar
unknown committed
2330 2331 2332 2333
  return 0;
}


2334 2335
byte *sys_var_last_insert_id::value_ptr(THD *thd, enum_var_type type,
					LEX_STRING *base)
unknown's avatar
unknown committed
2336 2337 2338 2339 2340 2341 2342 2343
{
  thd->sys_var_tmp.long_value= (long) thd->insert_id();
  return (byte*) &thd->last_insert_id;
}


bool sys_var_insert_id::update(THD *thd, set_var *var)
{
2344
  thd->next_insert_id= var->save_result.ulonglong_value;
unknown's avatar
unknown committed
2345 2346 2347 2348
  return 0;
}


2349 2350
byte *sys_var_insert_id::value_ptr(THD *thd, enum_var_type type,
				   LEX_STRING *base)
unknown's avatar
unknown committed
2351 2352 2353 2354 2355
{
  return (byte*) &thd->current_insert_id;
}


unknown's avatar
SCRUM  
unknown committed
2356
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
2357 2358
bool sys_var_slave_skip_counter::check(THD *thd, set_var *var)
{
2359
  int result= 0;
unknown's avatar
unknown committed
2360
  pthread_mutex_lock(&LOCK_active_mi);
unknown's avatar
unknown committed
2361 2362 2363 2364 2365 2366 2367
  pthread_mutex_lock(&active_mi->rli.run_lock);
  if (active_mi->rli.slave_running)
  {
    my_error(ER_SLAVE_MUST_STOP, MYF(0));
    result=1;
  }
  pthread_mutex_unlock(&active_mi->rli.run_lock);
unknown's avatar
unknown committed
2368
  pthread_mutex_unlock(&LOCK_active_mi);
2369
  var->save_result.ulong_value= (ulong) var->value->val_int();
unknown's avatar
unknown committed
2370 2371 2372 2373 2374 2375
  return result;
}


bool sys_var_slave_skip_counter::update(THD *thd, set_var *var)
{
unknown's avatar
unknown committed
2376
  pthread_mutex_lock(&LOCK_active_mi);
unknown's avatar
unknown committed
2377 2378 2379 2380 2381 2382 2383 2384 2385
  pthread_mutex_lock(&active_mi->rli.run_lock);
  /*
    The following test should normally never be true as we test this
    in the check function;  To be safe against multiple
    SQL_SLAVE_SKIP_COUNTER request, we do the check anyway
  */
  if (!active_mi->rli.slave_running)
  {
    pthread_mutex_lock(&active_mi->rli.data_lock);
2386
    active_mi->rli.slave_skip_counter= var->save_result.ulong_value;
unknown's avatar
unknown committed
2387 2388 2389
    pthread_mutex_unlock(&active_mi->rli.data_lock);
  }
  pthread_mutex_unlock(&active_mi->rli.run_lock);
unknown's avatar
unknown committed
2390
  pthread_mutex_unlock(&LOCK_active_mi);
unknown's avatar
unknown committed
2391
  return 0;
2392 2393 2394 2395 2396 2397
}


bool sys_var_sync_binlog_period::update(THD *thd, set_var *var)
{
  pthread_mutex_t *lock_log= mysql_bin_log.get_log_lock();
2398
  sync_binlog_period= (ulong) var->save_result.ulonglong_value;
2399 2400 2401 2402 2403 2404 2405 2406 2407
  /*
    Must reset the counter otherwise it may already be beyond the new period
    and so the new period will not be taken into account. Need mutex otherwise
    might be cancelled by a simultanate ++ in MYSQL_LOG::write().
  */
  pthread_mutex_lock(lock_log);
  sync_binlog_counter= 0;
  pthread_mutex_unlock(lock_log);
  return 0;
unknown's avatar
unknown committed
2408
}
unknown's avatar
SCRUM  
unknown committed
2409
#endif /* HAVE_REPLICATION */
unknown's avatar
unknown committed
2410

2411 2412
bool sys_var_rand_seed1::update(THD *thd, set_var *var)
{
2413
  thd->rand.seed1= (ulong) var->save_result.ulonglong_value;
2414 2415 2416 2417 2418
  return 0;
}

bool sys_var_rand_seed2::update(THD *thd, set_var *var)
{
2419
  thd->rand.seed2= (ulong) var->save_result.ulonglong_value;
2420 2421 2422 2423
  return 0;
}


2424 2425 2426 2427 2428 2429 2430 2431 2432 2433 2434 2435 2436 2437 2438 2439
bool sys_var_thd_time_zone::check(THD *thd, set_var *var)
{
  char buff[MAX_TIME_ZONE_NAME_LENGTH]; 
  String str(buff, sizeof(buff), &my_charset_latin1);
  String *res= var->value->val_str(&str);

#if defined(HAVE_REPLICATION) && (MYSQL_VERSION_ID < 50000)
  if ((var->type == OPT_GLOBAL) &&
      (mysql_bin_log.is_open() ||
       active_mi->slave_running || active_mi->rli.slave_running))
  {
    my_printf_error(0, "Binary logging and replication forbid changing "
                       "of the global server time zone", MYF(0));
    return 1;
  }
#endif
2440 2441 2442

  if (!(var->save_result.time_zone=
          my_tz_find(res, thd->lex->time_zone_tables_used)))
2443 2444 2445 2446 2447 2448 2449 2450 2451 2452 2453 2454 2455 2456 2457 2458 2459 2460 2461 2462 2463 2464 2465 2466 2467 2468 2469 2470 2471 2472 2473 2474 2475 2476 2477 2478 2479 2480 2481 2482 2483 2484 2485 2486
  {
    my_error(ER_UNKNOWN_TIME_ZONE, MYF(0), res ? res->c_ptr() : "NULL");
    return 1;
  }
  return 0;
}


bool sys_var_thd_time_zone::update(THD *thd, set_var *var)
{
  /* We are using Time_zone object found during check() phase */ 
  *get_tz_ptr(thd,var->type)= var->save_result.time_zone;
  return 0;
}


byte *sys_var_thd_time_zone::value_ptr(THD *thd, enum_var_type type,
				       LEX_STRING *base)
{
  /* 
    We can use ptr() instead of c_ptr() here because String contaning
    time zone name is guaranteed to be zero ended.
  */
  return (byte *)((*get_tz_ptr(thd,type))->get_name()->ptr());
}


Time_zone** sys_var_thd_time_zone::get_tz_ptr(THD *thd, 
                                              enum_var_type type)
{
  if (type == OPT_GLOBAL)
    return &global_system_variables.time_zone;
  else
    return &thd->variables.time_zone;
}


void sys_var_thd_time_zone::set_default(THD *thd, enum_var_type type)
{
 if (type == OPT_GLOBAL)
 {
   if (default_tz_name)
   {
     String str(default_tz_name, &my_charset_latin1);
2487 2488
     global_system_variables.time_zone=
       my_tz_find(&str, thd->lex->time_zone_tables_used);
2489 2490 2491 2492 2493 2494 2495 2496
   }
   else
     global_system_variables.time_zone= my_tz_SYSTEM;
 }
 else
   thd->variables.time_zone= global_system_variables.time_zone;
}

unknown's avatar
unknown committed
2497 2498 2499 2500 2501 2502
/*
  Functions to update thd->options bits
*/

static bool set_option_bit(THD *thd, set_var *var)
{
2503 2504 2505
  sys_var_thd_bit *sys_var= ((sys_var_thd_bit*) var->var);
  if ((var->save_result.ulong_value != 0) == sys_var->reverse)
    thd->options&= ~sys_var->bit_flag;
unknown's avatar
unknown committed
2506
  else
2507
    thd->options|= sys_var->bit_flag;
unknown's avatar
unknown committed
2508 2509 2510 2511 2512 2513 2514 2515 2516 2517 2518 2519 2520 2521 2522 2523 2524 2525 2526 2527 2528 2529 2530 2531 2532 2533 2534 2535 2536 2537 2538 2539 2540 2541
  return 0;
}


static bool set_option_autocommit(THD *thd, set_var *var)
{
  /* The test is negative as the flag we use is NOT autocommit */

  ulong org_options=thd->options;

  if (var->save_result.ulong_value != 0)
    thd->options&= ~((sys_var_thd_bit*) var->var)->bit_flag;
  else
    thd->options|= ((sys_var_thd_bit*) var->var)->bit_flag;

  if ((org_options ^ thd->options) & OPTION_NOT_AUTOCOMMIT)
  {
    if ((org_options & OPTION_NOT_AUTOCOMMIT))
    {
      /* We changed to auto_commit mode */
      thd->options&= ~(ulong) (OPTION_BEGIN | OPTION_STATUS_NO_TRANS_UPDATE);
      thd->server_status|= SERVER_STATUS_AUTOCOMMIT;
      if (ha_commit(thd))
	return 1;
    }
    else
    {
      thd->options&= ~(ulong) (OPTION_STATUS_NO_TRANS_UPDATE);
      thd->server_status&= ~SERVER_STATUS_AUTOCOMMIT;
    }
  }
  return 0;
}

2542
static int check_log_update(THD *thd, set_var *var)
unknown's avatar
unknown committed
2543
{
2544 2545 2546 2547 2548 2549 2550
#ifndef NO_EMBEDDED_ACCESS_CHECKS
  if (!(thd->master_access & SUPER_ACL))
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
#endif
2551 2552 2553 2554 2555
  return 0;
}

static bool set_log_update(THD *thd, set_var *var)
{
unknown's avatar
unknown committed
2556 2557 2558 2559 2560 2561 2562
  if (opt_sql_bin_update)
    ((sys_var_thd_bit*) var->var)->bit_flag|= (OPTION_BIN_LOG |
					       OPTION_UPDATE_LOG);
  set_option_bit(thd, var);
  return 0;
}

2563 2564 2565 2566 2567 2568 2569 2570 2571 2572 2573 2574 2575 2576 2577 2578
static int check_pseudo_thread_id(THD *thd, set_var *var)
{
  var->save_result.ulonglong_value= var->value->val_int();
#ifndef NO_EMBEDDED_ACCESS_CHECKS
  if (thd->master_access & SUPER_ACL)
    return 0;
  else
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
#else
  return 0;
#endif
}

2579 2580 2581 2582 2583 2584 2585 2586 2587 2588 2589 2590 2591 2592 2593
static byte *get_warning_count(THD *thd)
{
  thd->sys_var_tmp.long_value=
    (thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_NOTE] +
     thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_WARN]);
  return (byte*) &thd->sys_var_tmp.long_value;
}

static byte *get_error_count(THD *thd)
{
  thd->sys_var_tmp.long_value= 
    thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_ERROR];
  return (byte*) &thd->sys_var_tmp.long_value;
}

unknown's avatar
unknown committed
2594 2595 2596 2597 2598 2599 2600 2601 2602 2603 2604 2605 2606 2607 2608 2609 2610 2611 2612 2613 2614 2615 2616 2617 2618 2619 2620 2621 2622 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638 2639 2640 2641 2642 2643 2644 2645 2646 2647 2648 2649 2650 2651 2652

/****************************************************************************
  Main handling of variables:
  - Initialisation
  - Searching during parsing
  - Update loop
****************************************************************************/

/*
  Find variable name in option my_getopt structure used for command line args

  SYNOPSIS
    find_option()
    opt		option structure array to search in
    name	variable name

  RETURN VALUES
    0		Error
    ptr		pointer to option structure
*/

static struct my_option *find_option(struct my_option *opt, const char *name) 
{
  uint length=strlen(name);
  for (; opt->name; opt++)
  {
    if (!getopt_compare_strings(opt->name, name, length) &&
	!opt->name[length])
    {
      /*
	Only accept the option if one can set values through it.
	If not, there is no default value or limits in the option.
      */
      return (opt->value) ? opt : 0;
    }
  }
  return 0;
}


/*
  Return variable name and length for hashing of variables
*/

static byte *get_sys_var_length(const sys_var *var, uint *length,
				my_bool first)
{
  *length= var->name_length;
  return (byte*) var->name;
}


/*
  Initialises sys variables and put them in system_variable_hash
*/


void set_var_init()
{
2653 2654
  hash_init(&system_variable_hash, system_charset_info,
	    array_elements(sys_variables),0,0,
unknown's avatar
unknown committed
2655
	    (hash_get_key) get_sys_var_length,0,0);
unknown's avatar
unknown committed
2656 2657 2658 2659 2660 2661 2662
  sys_var **var, **end;
  for (var= sys_variables, end= sys_variables+array_elements(sys_variables) ;
       var < end;
       var++)
  {
    (*var)->name_length= strlen((*var)->name);
    (*var)->option_limits= find_option(my_long_options, (*var)->name);
unknown's avatar
SCRUM  
unknown committed
2663
    my_hash_insert(&system_variable_hash, (byte*) *var);
unknown's avatar
unknown committed
2664 2665 2666 2667 2668 2669 2670 2671 2672 2673 2674 2675 2676 2677 2678 2679 2680 2681 2682 2683 2684 2685 2686 2687 2688 2689 2690 2691 2692 2693 2694 2695 2696 2697
  }
  /*
    Special cases
    Needed because MySQL can't find the limits for a variable it it has
    a different name than the command line option.
    As these variables are deprecated, this code will disappear soon...
  */
  sys_sql_max_join_size.option_limits= sys_max_join_size.option_limits;
}


void set_var_free()
{
  hash_free(&system_variable_hash);
}


/*
  Find a user set-table variable

  SYNOPSIS
    find_sys_var()
    str		Name of system variable to find
    length	Length of variable.  zero means that we should use strlen()
		on the variable

  NOTE
    We have to use net_printf() as this is called during the parsing stage

  RETURN VALUES
    pointer	pointer to variable definitions
    0		Unknown variable (error message is given)
*/

2698
sys_var *find_sys_var(const char *str, uint length)
unknown's avatar
unknown committed
2699
{
unknown's avatar
unknown committed
2700 2701
  sys_var *var= (sys_var*) hash_search(&system_variable_hash,
				       (byte*) str,
unknown's avatar
unknown committed
2702 2703 2704
				       length ? length :
				       strlen(str));
  if (!var)
2705
    net_printf(current_thd, ER_UNKNOWN_SYSTEM_VARIABLE, (char*) str);
unknown's avatar
unknown committed
2706 2707 2708 2709 2710 2711 2712 2713 2714 2715 2716 2717 2718 2719 2720 2721 2722 2723 2724 2725 2726 2727
  return var;
}


/*
  Execute update of all variables

  SYNOPSIS

  sql_set
    THD		Thread id
    set_var	List of variables to update

  DESCRIPTION
    First run a check of all variables that all updates will go ok.
    If yes, then execute all updates, returning an error if any one failed.

    This should ensure that in all normal cases none all or variables are
    updated

    RETURN VALUE
    0	ok
2728 2729
    1	ERROR, message sent (normally no variables was updated)
    -1  ERROR, message not sent
unknown's avatar
unknown committed
2730 2731
*/

2732
int sql_set_variables(THD *thd, List<set_var_base> *var_list)
unknown's avatar
unknown committed
2733
{
2734
  int error= 0;
unknown's avatar
unknown committed
2735
  List_iterator_fast<set_var_base> it(*var_list);
unknown's avatar
unknown committed
2736
  DBUG_ENTER("sql_set_variables");
unknown's avatar
unknown committed
2737 2738 2739 2740

  set_var_base *var;
  while ((var=it++))
  {
2741
    if ((error=var->check(thd)))
unknown's avatar
unknown committed
2742
      DBUG_RETURN(error);
unknown's avatar
unknown committed
2743
  }
2744 2745
  if (thd->net.report_error)
    DBUG_RETURN(1);
unknown's avatar
unknown committed
2746 2747
  it.rewind();
  while ((var=it++))
2748
    error|= var->update(thd);			// Returns 0, -1 or 1
unknown's avatar
unknown committed
2749
  DBUG_RETURN(error);
unknown's avatar
unknown committed
2750 2751 2752
}


2753 2754 2755 2756 2757 2758 2759 2760 2761 2762 2763 2764 2765 2766 2767 2768 2769 2770 2771 2772 2773 2774 2775 2776 2777 2778 2779 2780 2781 2782
/*
  Say if all variables set by a SET support the ONE_SHOT keyword (currently,
  only character set and collation do; later timezones will).

  SYNOPSIS

  not_all_support_one_shot
    set_var	List of variables to update

  NOTES
    It has a "not_" because it makes faster tests (no need to "!")

    RETURN VALUE
    0	all variables of the list support ONE_SHOT
    1	at least one does not support ONE_SHOT
*/

bool not_all_support_one_shot(List<set_var_base> *var_list)
{
  List_iterator_fast<set_var_base> it(*var_list);
  set_var_base *var;
  while ((var= it++))
  {
    if (var->no_support_one_shot())
      return 1;
  }
  return 0;
}


unknown's avatar
unknown committed
2783 2784 2785 2786
/*****************************************************************************
  Functions to handle SET mysql_internal_variable=const_expr
*****************************************************************************/

2787
int set_var::check(THD *thd)
unknown's avatar
unknown committed
2788 2789 2790 2791 2792 2793
{
  if (var->check_type(type))
  {
    my_error(type == OPT_GLOBAL ? ER_LOCAL_VARIABLE : ER_GLOBAL_VARIABLE,
	     MYF(0),
	     var->name);
2794
    return -1;
unknown's avatar
unknown committed
2795 2796 2797 2798 2799 2800 2801 2802 2803
  }
  if ((type == OPT_GLOBAL && check_global_access(thd, SUPER_ACL)))
    return 1;
  /* value is a NULL pointer if we are using SET ... = DEFAULT */
  if (!value)
  {
    if (var->check_default(type))
    {
      my_error(ER_NO_DEFAULT, MYF(0), var->name);
2804
      return -1;
unknown's avatar
unknown committed
2805 2806 2807 2808
    }
    return 0;
  }

unknown's avatar
unknown committed
2809
  if (value->fix_fields(thd, 0, &value) || value->check_cols(1))
2810
    return -1;
unknown's avatar
unknown committed
2811 2812 2813
  if (var->check_update_type(value->result_type()))
  {
    my_error(ER_WRONG_TYPE_FOR_VAR, MYF(0), var->name);
2814
    return -1;
2815
  }
2816
  return var->check(thd, this) ? -1 : 0;
unknown's avatar
unknown committed
2817 2818 2819
}


unknown's avatar
unknown committed
2820 2821 2822 2823 2824 2825 2826 2827 2828 2829 2830 2831
/*
  Check variable, but without assigning value (used by PS)

  SYNOPSIS
    set_var::light_check()
    thd		thread handler

  RETURN VALUE
    0	ok
    1	ERROR, message sent (normally no variables was updated)
    -1  ERROR, message not sent
*/
2832 2833 2834 2835 2836 2837 2838 2839 2840
int set_var::light_check(THD *thd)
{
  if (var->check_type(type))
  {
    my_error(type == OPT_GLOBAL ? ER_LOCAL_VARIABLE : ER_GLOBAL_VARIABLE,
	     MYF(0),
	     var->name);
    return -1;
  }
unknown's avatar
unknown committed
2841
  if (type == OPT_GLOBAL && check_global_access(thd, SUPER_ACL))
2842 2843 2844 2845 2846 2847 2848 2849
    return 1;

  if (value && (value->fix_fields(thd, 0, &value) || value->check_cols(1)))
    return -1;
  return 0;
}


2850
int set_var::update(THD *thd)
unknown's avatar
unknown committed
2851 2852 2853 2854
{
  if (!value)
    var->set_default(thd, type);
  else if (var->update(thd, this))
2855
    return -1;				// should never happen
unknown's avatar
unknown committed
2856 2857 2858 2859 2860 2861 2862 2863 2864 2865
  if (var->after_update)
    (*var->after_update)(thd, type);
  return 0;
}


/*****************************************************************************
  Functions to handle SET @user_variable=const_expr
*****************************************************************************/

2866
int set_var_user::check(THD *thd)
unknown's avatar
unknown committed
2867
{
unknown's avatar
unknown committed
2868 2869
  /*
    Item_func_set_user_var can't substitute something else on its place =>
2870
    0 can be passed as last argument (reference on item)
unknown's avatar
unknown committed
2871 2872
  */
  return (user_var_item->fix_fields(thd, 0, (Item**) 0) ||
2873
	  user_var_item->check()) ? -1 : 0;
unknown's avatar
unknown committed
2874 2875 2876
}


unknown's avatar
unknown committed
2877 2878 2879 2880 2881 2882 2883 2884 2885 2886 2887 2888
/*
  Check variable, but without assigning value (used by PS)

  SYNOPSIS
    set_var_user::light_check()
    thd		thread handler

  RETURN VALUE
    0	ok
    1	ERROR, message sent (normally no variables was updated)
    -1  ERROR, message not sent
*/
2889 2890 2891 2892 2893 2894 2895 2896 2897 2898
int set_var_user::light_check(THD *thd)
{
  /*
    Item_func_set_user_var can't substitute something else on its place =>
    0 can be passed as last argument (reference on item)
  */
  return (user_var_item->fix_fields(thd, 0, (Item**) 0));
}


2899
int set_var_user::update(THD *thd)
unknown's avatar
unknown committed
2900 2901 2902 2903
{
  if (user_var_item->update())
  {
    /* Give an error if it's not given already */
2904 2905
    my_error(ER_SET_CONSTANTS_ONLY, MYF(0));
    return -1;
unknown's avatar
unknown committed
2906 2907 2908 2909 2910 2911 2912 2913 2914
  }
  return 0;
}


/*****************************************************************************
  Functions to handle SET PASSWORD
*****************************************************************************/

2915
int set_var_password::check(THD *thd)
unknown's avatar
unknown committed
2916
{
unknown's avatar
unknown committed
2917
#ifndef NO_EMBEDDED_ACCESS_CHECKS
unknown's avatar
unknown committed
2918 2919
  if (!user->host.str)
    user->host.str= (char*) thd->host_or_ip;
2920
  /* Returns 1 as the function sends error to client */
2921 2922 2923
  return check_change_password(thd, user->host.str, user->user.str, password) ?
         1 : 0;
#else
unknown's avatar
unknown committed
2924 2925
  return 0;
#endif
unknown's avatar
unknown committed
2926 2927
}

2928
int set_var_password::update(THD *thd)
unknown's avatar
unknown committed
2929
{
unknown's avatar
unknown committed
2930
#ifndef NO_EMBEDDED_ACCESS_CHECKS
2931
  /* Returns 1 as the function sends error to client */
2932 2933
  return change_password(thd, user->host.str, user->user.str, password) ?
	  1 : 0;
unknown's avatar
unknown committed
2934 2935 2936
#else
  return 0;
#endif
unknown's avatar
unknown committed
2937 2938
}

2939 2940 2941 2942
/****************************************************************************
 Functions to handle table_type
****************************************************************************/

unknown's avatar
unknown committed
2943 2944
/* Based upon sys_var::check_enum() */

unknown's avatar
unknown committed
2945
bool sys_var_thd_storage_engine::check(THD *thd, set_var *var)
2946 2947 2948 2949 2950 2951 2952 2953 2954 2955 2956 2957 2958 2959 2960 2961
{
  char buff[80];
  const char *value;
  String str(buff, sizeof(buff), &my_charset_latin1), *res;

  if (var->value->result_type() == STRING_RESULT)
  {
    if (!(res=var->value->val_str(&str)) ||
	!(var->save_result.ulong_value=
	 (ulong) ha_resolve_by_name(res->ptr(), res->length())))
    {
      value= res ? res->c_ptr() : "NULL";
      goto err;
    }
    return 0;
  }
unknown's avatar
unknown committed
2962
  value= "unknown";
2963 2964

err:
unknown's avatar
unknown committed
2965
  my_error(ER_UNKNOWN_STORAGE_ENGINE, MYF(0), value);
2966 2967 2968
  return 1;    
}

unknown's avatar
unknown committed
2969

unknown's avatar
unknown committed
2970 2971
byte *sys_var_thd_storage_engine::value_ptr(THD *thd, enum_var_type type,
					    LEX_STRING *base)
2972 2973 2974 2975
{
  ulong val;
  val= ((type == OPT_GLOBAL) ? global_system_variables.*offset :
        thd->variables.*offset);
unknown's avatar
unknown committed
2976
  const char *table_type= ha_get_storage_engine((enum db_type)val);
unknown's avatar
unknown committed
2977
  return (byte *) table_type;
2978 2979
}

unknown's avatar
unknown committed
2980

unknown's avatar
unknown committed
2981
void sys_var_thd_storage_engine::set_default(THD *thd, enum_var_type type)
2982 2983 2984 2985 2986 2987 2988
{
  if (type == OPT_GLOBAL)
    global_system_variables.*offset= (ulong) DB_TYPE_MYISAM;
  else
    thd->variables.*offset= (ulong) (global_system_variables.*offset);
}

unknown's avatar
unknown committed
2989

unknown's avatar
unknown committed
2990
bool sys_var_thd_storage_engine::update(THD *thd, set_var *var)
2991 2992 2993 2994 2995 2996 2997 2998
{
  if (var->type == OPT_GLOBAL)
    global_system_variables.*offset= var->save_result.ulong_value;
  else
    thd->variables.*offset= var->save_result.ulong_value;
  return 0;
}

unknown's avatar
unknown committed
2999 3000 3001 3002
void sys_var_thd_table_type::warn_deprecated(THD *thd)
{
  push_warning_printf(thd, MYSQL_ERROR::WARN_LEVEL_WARN,
		      ER_WARN_DEPRECATED_SYNTAX,
3003 3004
		      ER(ER_WARN_DEPRECATED_SYNTAX), "table_type",
                      "storage_engine"); 
unknown's avatar
unknown committed
3005 3006 3007 3008 3009 3010 3011 3012 3013 3014 3015 3016 3017 3018
}

void sys_var_thd_table_type::set_default(THD *thd, enum_var_type type)
{
  warn_deprecated(thd);
  sys_var_thd_storage_engine::set_default(thd, type);
}

bool sys_var_thd_table_type::update(THD *thd, set_var *var)
{
  warn_deprecated(thd);
  return sys_var_thd_storage_engine::update(thd, var);
}

unknown's avatar
unknown committed
3019

3020 3021 3022
/****************************************************************************
 Functions to handle sql_mode
****************************************************************************/
3023

3024 3025
byte *sys_var_thd_sql_mode::value_ptr(THD *thd, enum_var_type type,
				      LEX_STRING *base)
3026 3027 3028 3029 3030 3031 3032 3033 3034 3035 3036 3037 3038 3039 3040 3041 3042 3043 3044 3045 3046 3047 3048 3049 3050 3051 3052 3053 3054 3055 3056 3057 3058 3059 3060 3061 3062 3063 3064 3065
{
  ulong val;
  char buff[256];
  String tmp(buff, sizeof(buff), &my_charset_latin1);

  tmp.length(0);
  val= ((type == OPT_GLOBAL) ? global_system_variables.*offset :
        thd->variables.*offset);
  for (uint i= 0; val; val>>= 1, i++)
  {
    if (val & 1)
    {
      tmp.append(enum_names->type_names[i]);
      tmp.append(',');
    }
  }
  if (tmp.length())
    tmp.length(tmp.length() - 1);
  return (byte*) thd->strmake(tmp.ptr(), tmp.length());
}


void sys_var_thd_sql_mode::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
    global_system_variables.*offset= 0;
  else
    thd->variables.*offset= global_system_variables.*offset;
}

void fix_sql_mode_var(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
    global_system_variables.sql_mode=
      fix_sql_mode(global_system_variables.sql_mode);
  else
    thd->variables.sql_mode= fix_sql_mode(thd->variables.sql_mode);
}

/* Map database specific bits to function bits */
3066

3067 3068 3069 3070 3071 3072 3073 3074 3075 3076 3077 3078 3079 3080 3081 3082 3083 3084 3085 3086 3087 3088 3089 3090 3091 3092 3093 3094 3095 3096 3097
ulong fix_sql_mode(ulong sql_mode)
{
  /*
    Note that we dont set 
    MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS | MODE_NO_FIELD_OPTIONS
    to allow one to get full use of MySQL in this mode.
  */

  if (sql_mode & MODE_ANSI)
    sql_mode|= (MODE_REAL_AS_FLOAT | MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE | MODE_ONLY_FULL_GROUP_BY);
  if (sql_mode & MODE_ORACLE)
    sql_mode|= (MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE |
		MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS |
		MODE_NO_FIELD_OPTIONS);
  if (sql_mode & MODE_MSSQL)
    sql_mode|= (MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE |
		MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS |
		MODE_NO_FIELD_OPTIONS);
  if (sql_mode & MODE_POSTGRESQL)
    sql_mode|= (MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE |
		MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS |
		MODE_NO_FIELD_OPTIONS);
  if (sql_mode & MODE_DB2)
    sql_mode|= (MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE |
		MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS |
		MODE_NO_FIELD_OPTIONS);
3098
  if (sql_mode & MODE_MAXDB)
3099 3100 3101 3102 3103 3104 3105 3106 3107 3108
    sql_mode|= (MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE |
		MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS |
		MODE_NO_FIELD_OPTIONS);
  if (sql_mode & MODE_MYSQL40)
    sql_mode|= MODE_NO_FIELD_OPTIONS;
  if (sql_mode & MODE_MYSQL323)
    sql_mode|= MODE_NO_FIELD_OPTIONS;
  return sql_mode;
}
3109 3110


3111 3112 3113 3114
/****************************************************************************
  Named list handling
****************************************************************************/

unknown's avatar
unknown committed
3115 3116
gptr find_named(I_List<NAMED_LIST> *list, const char *name, uint length,
		NAMED_LIST **found)
3117 3118 3119 3120 3121 3122
{
  I_List_iterator<NAMED_LIST> it(*list);
  NAMED_LIST *element;
  while ((element= it++))
  {
    if (element->cmp(name, length))
unknown's avatar
unknown committed
3123
    {
3124 3125
      if (found)
        *found= element;
3126
      return element->data;
unknown's avatar
unknown committed
3127
    }
3128 3129 3130 3131 3132
  }
  return 0;
}


3133 3134
void delete_elements(I_List<NAMED_LIST> *list,
		     void (*free_element)(const char *name, gptr))
3135 3136
{
  NAMED_LIST *element;
unknown's avatar
unknown committed
3137
  DBUG_ENTER("delete_elements");
3138 3139
  while ((element= list->get()))
  {
3140
    (*free_element)(element->name, element->data);
3141 3142
    delete element;
  }
unknown's avatar
unknown committed
3143
  DBUG_VOID_RETURN;
3144 3145 3146 3147 3148
}


/* Key cache functions */

unknown's avatar
unknown committed
3149
static KEY_CACHE *create_key_cache(const char *name, uint length)
3150
{
unknown's avatar
unknown committed
3151
  KEY_CACHE *key_cache;
3152 3153 3154
  DBUG_ENTER("create_key_cache");
  DBUG_PRINT("enter",("name: %.*s", length, name));
  
unknown's avatar
unknown committed
3155
  if ((key_cache= (KEY_CACHE*) my_malloc(sizeof(KEY_CACHE),
3156
					     MYF(MY_ZEROFILL | MY_WME))))
unknown's avatar
unknown committed
3157 3158
  {
    if (!new NAMED_LIST(&key_caches, name, length, (gptr) key_cache))
3159 3160
    {
      my_free((char*) key_cache, MYF(0));
unknown's avatar
unknown committed
3161
      key_cache= 0;
3162 3163 3164 3165 3166 3167 3168 3169 3170
    }
    else
    {
      /*
	Set default values for a key cache
	The values in dflt_key_cache_var is set by my_getopt() at startup

	We don't set 'buff_size' as this is used to enable the key cache
      */
unknown's avatar
unknown committed
3171 3172 3173
      key_cache->param_block_size=     dflt_key_cache_var.param_block_size;
      key_cache->param_division_limit= dflt_key_cache_var.param_division_limit;
      key_cache->param_age_threshold=  dflt_key_cache_var.param_age_threshold;
3174
    }
unknown's avatar
unknown committed
3175
  }
3176
  DBUG_RETURN(key_cache);
3177 3178 3179
}


unknown's avatar
unknown committed
3180
KEY_CACHE *get_or_create_key_cache(const char *name, uint length)
3181
{
unknown's avatar
unknown committed
3182
  LEX_STRING key_cache_name;
unknown's avatar
unknown committed
3183
  KEY_CACHE *key_cache;
3184

unknown's avatar
unknown committed
3185 3186
  key_cache_name.str= (char *) name;
  key_cache_name.length= length;
3187 3188
  pthread_mutex_lock(&LOCK_global_system_variables);
  if (!(key_cache= get_key_cache(&key_cache_name)))
3189
    key_cache= create_key_cache(name, length);
3190
  pthread_mutex_unlock(&LOCK_global_system_variables);
3191 3192 3193 3194
  return key_cache;
}


unknown's avatar
unknown committed
3195
void free_key_cache(const char *name, KEY_CACHE *key_cache)
3196
{
3197 3198
  ha_end_key_cache(key_cache);
  my_free((char*) key_cache, MYF(0));
unknown's avatar
unknown committed
3199 3200 3201
}


unknown's avatar
unknown committed
3202
bool process_key_caches(int (* func) (const char *name, KEY_CACHE *))
3203
{
unknown's avatar
unknown committed
3204 3205
  I_List_iterator<NAMED_LIST> it(key_caches);
  NAMED_LIST *element;
3206

unknown's avatar
unknown committed
3207 3208
  while ((element= it++))
  {
unknown's avatar
unknown committed
3209
    KEY_CACHE *key_cache= (KEY_CACHE *) element->data;
3210
    func(element->name, key_cache);
unknown's avatar
unknown committed
3211 3212
  }
  return 0;
3213 3214
}

3215

unknown's avatar
unknown committed
3216 3217 3218 3219 3220 3221
/****************************************************************************
  Used templates
****************************************************************************/

#ifdef __GNUC__
template class List<set_var_base>;
unknown's avatar
unknown committed
3222
template class List_iterator_fast<set_var_base>;
3223
template class I_List_iterator<NAMED_LIST>;
unknown's avatar
unknown committed
3224
#endif