mysqld.cc 172 KB
Newer Older
unknown's avatar
unknown committed
1
/* Copyright (C) 2000-2003 MySQL AB
2

unknown's avatar
unknown committed
3 4 5 6
   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.
7

unknown's avatar
unknown committed
8 9 10 11
   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.
12

unknown's avatar
unknown committed
13 14 15 16 17 18
   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 */

#include "mysql_priv.h"
#include <m_ctype.h>
19
#include <my_dir.h>
unknown's avatar
unknown committed
20
#include "sql_acl.h"
21
#include "slave.h"
22
#include "sql_repl.h"
23
#include "repl_failsafe.h"
unknown's avatar
unknown committed
24
#include "stacktrace.h"
unknown's avatar
unknown committed
25 26 27
#ifdef HAVE_BERKELEY_DB
#include "ha_berkeley.h"
#endif
28
#ifdef HAVE_INNOBASE_DB
29
#include "ha_innodb.h"
30
#endif
unknown's avatar
unknown committed
31 32 33 34
#include "ha_myisam.h"
#include <nisam.h>
#include <thr_alarm.h>
#include <ft_global.h>
35
#include <assert.h>
unknown's avatar
unknown committed
36

37 38 39 40
#ifndef DBUG_OFF
#define ONE_THREAD
#endif

41 42 43 44
#define SHUTDOWN_THD
#define MAIN_THD
#define SIGNAL_THD

unknown's avatar
unknown committed
45
#ifdef HAVE_purify
46 47 48 49 50
#define IF_PURIFY(A,B) (A)
#else
#define IF_PURIFY(A,B) (B)
#endif

51
/* stack traces are only supported on linux intel */
52 53 54 55 56 57
#if defined(__linux__)  && defined(__i386__) && defined(USE_PSTACK)
#define	HAVE_STACK_TRACE_ON_SEGV
#include "../pstack/pstack.h"
char pstack_file_name[80];
#endif /* __linux__ */

unknown's avatar
unknown committed
58 59 60 61
#if defined(HAVE_DEC_3_2_THREADS) || defined(SIGNALS_DONT_BREAK_READ)
#define HAVE_CLOSE_SERVER_SOCK 1
#endif  

unknown's avatar
unknown committed
62 63 64 65
extern "C" {					// Because of SCO 3.2V4.2
#include <errno.h>
#include <sys/stat.h>
#ifndef __GNU_LIBRARY__
66
#define __GNU_LIBRARY__				// Skip warnings in getopt.h
unknown's avatar
unknown committed
67
#endif
68
#include <my_getopt.h>
unknown's avatar
unknown committed
69 70 71 72 73 74 75 76 77 78
#ifdef HAVE_SYSENT_H
#include <sysent.h>
#endif
#ifdef HAVE_PWD_H
#include <pwd.h>				// For getpwent
#endif
#ifdef HAVE_GRP_H
#include <grp.h>
#endif

unknown's avatar
unknown committed
79 80 81
#if defined(OS2)
#  include <sys/un.h>
#elif !defined( __WIN__)
unknown's avatar
unknown committed
82
#  ifndef __NETWARE__
unknown's avatar
unknown committed
83
#include <sys/resource.h>
unknown's avatar
unknown committed
84
#  endif /* __NETWARE__ */
unknown's avatar
unknown committed
85 86 87 88 89 90 91 92 93 94 95
#ifdef HAVE_SYS_UN_H
#  include <sys/un.h>
#endif
#include <netdb.h>
#ifdef HAVE_SELECT_H
#  include <select.h>
#endif
#ifdef HAVE_SYS_SELECT_H
#include <sys/select.h>
#endif
#include <sys/utsname.h>
unknown's avatar
unknown committed
96
#endif /* __WIN__ */
unknown's avatar
unknown committed
97 98 99 100 101 102 103 104 105

#ifdef HAVE_LIBWRAP
#include <tcpd.h>
#include <syslog.h>
#ifdef NEED_SYS_SYSLOG_H
#include <sys/syslog.h>
#endif /* NEED_SYS_SYSLOG_H */
int allow_severity = LOG_INFO;
int deny_severity = LOG_WARNING;
106

107
#ifdef __STDC__
108 109 110
#define my_fromhost(A)	   fromhost(A)
#define my_hosts_access(A) hosts_access(A)
#define my_eval_client(A)  eval_client(A)
111 112 113 114
#else
#define my_fromhost(A)	   fromhost()
#define my_hosts_access(A) hosts_access()
#define my_eval_client(A)  eval_client()
115
#endif
unknown's avatar
unknown committed
116 117
#endif /* HAVE_LIBWRAP */

118 119 120 121
#ifdef HAVE_SYS_MMAN_H
#include <sys/mman.h>
#endif

unknown's avatar
unknown committed
122 123 124 125 126 127 128 129 130
#ifdef __NETWARE__
#include <nks/vm.h>
#include <library.h>
#include <monitor.h>

event_handle_t eh;
Report_t ref;
#endif /* __NETWARE__ */

unknown's avatar
unknown committed
131
#ifdef _AIX41
unknown's avatar
unknown committed
132
int initgroups(const char *,unsigned int);
unknown's avatar
unknown committed
133 134
#endif

unknown's avatar
unknown committed
135 136 137 138 139 140 141 142 143 144 145 146 147
#if defined(__FreeBSD__) && defined(HAVE_IEEEFP_H)
#include <ieeefp.h>
#ifdef HAVE_FP_EXCEPT				// Fix type conflict
typedef fp_except fp_except_t;
#endif

  /* We can't handle floating point expections with threads, so disable
     this on freebsd
  */

inline void reset_floating_point_exceptions()
{
  /* Don't fall for overflow, underflow,divide-by-zero or loss of precision */
unknown's avatar
unknown committed
148 149 150
#if defined(__i386__)
  fpsetmask(~(FP_X_INV | FP_X_DNML | FP_X_OFL | FP_X_UFL | FP_X_DZ |
	      FP_X_IMP));
unknown's avatar
unknown committed
151
#else
unknown's avatar
unknown committed
152 153 154
 fpsetmask(~(FP_X_INV |             FP_X_OFL | FP_X_UFL | FP_X_DZ |
	     FP_X_IMP));
#endif
unknown's avatar
unknown committed
155 156 157 158 159
}
#else
#define reset_floating_point_exceptions()
#endif /* __FreeBSD__ && HAVE_IEEEFP_H */

unknown's avatar
unknown committed
160 161
} /* cplusplus */

unknown's avatar
unknown committed
162 163 164 165 166 167 168 169 170 171 172 173

#if defined(HAVE_LINUXTHREADS)
#define THR_KILL_SIGNAL SIGINT
#else
#define THR_KILL_SIGNAL SIGUSR2		// Can't use this with LinuxThreads
#endif

#ifdef HAVE_GLIBC2_STYLE_GETHOSTBYNAME_R
#include <sys/types.h>
#else
#include <my_pthread.h>			// For thr_setconcurency()
#endif
174
#if defined(HAVE_GETRLIMIT) && defined(RLIMIT_NOFILE) && !defined(HAVE_mit_thread)
unknown's avatar
unknown committed
175 176 177 178 179 180 181 182 183 184 185
#define SET_RLIMIT_NOFILE
#endif

#ifdef SOLARIS
extern "C" int gethostname(char *name, int namelen);
#endif

#define MYSQL_KILL_SIGNAL SIGTERM

#ifndef DBUG_OFF
static const char* default_dbug_option=IF_WIN("d:t:i:O,\\mysqld.trace",
186
					      "d:t:i:o,/tmp/mysqld.trace");
unknown's avatar
unknown committed
187 188 189 190 191 192 193 194 195 196 197
#endif

#ifdef __NT__
static char szPipeName [ 257 ];
static SECURITY_ATTRIBUTES saPipeSecurity;
static SECURITY_DESCRIPTOR sdPipeDescriptor;
static HANDLE hPipe = INVALID_HANDLE_VALUE;
static pthread_cond_t COND_handler_count;
static uint handler_count;
#endif
#ifdef __WIN__
198
static bool start_mode=0, use_opt_args;
199 200
static int opt_argc;
static char **opt_argv;
unknown's avatar
unknown committed
201 202
#endif

unknown's avatar
unknown committed
203 204 205 206
/* Set prefix for windows binary */
#ifdef __WIN__
#undef MYSQL_SERVER_SUFFIX
#ifdef __NT__
207
#if defined(HAVE_BERKELEY_DB)
unknown's avatar
unknown committed
208 209 210 211
#define MYSQL_SERVER_SUFFIX "-max-nt"
#else
#define MYSQL_SERVER_SUFFIX "-nt"
#endif /* ...DB */
212
#elif defined(HAVE_BERKELEY_DB)
unknown's avatar
unknown committed
213 214 215 216
#define MYSQL_SERVER_SUFFIX "-max"
#else
#define MYSQL_SERVER_SUFFIX ""
#endif /* __NT__ */
217
#endif /* __WIN__ */
unknown's avatar
unknown committed
218

219 220 221 222 223 224
#ifdef HAVE_BERKELEY_DB
SHOW_COMP_OPTION have_berkeley_db=SHOW_OPTION_YES;
#else
SHOW_COMP_OPTION have_berkeley_db=SHOW_OPTION_NO;
#endif
#ifdef HAVE_INNOBASE_DB
unknown's avatar
unknown committed
225
SHOW_COMP_OPTION have_innodb=SHOW_OPTION_YES;
226
#else
unknown's avatar
unknown committed
227
SHOW_COMP_OPTION have_innodb=SHOW_OPTION_NO;
228
#endif
229
#ifdef HAVE_ISAM
230 231 232 233
SHOW_COMP_OPTION have_isam=SHOW_OPTION_YES;
#else
SHOW_COMP_OPTION have_isam=SHOW_OPTION_NO;
#endif
234 235 236 237 238 239
#ifdef USE_RAID
SHOW_COMP_OPTION have_raid=SHOW_OPTION_YES;
#else
SHOW_COMP_OPTION have_raid=SHOW_OPTION_NO;
#endif
#ifdef HAVE_OPENSSL
unknown's avatar
unknown committed
240
SHOW_COMP_OPTION have_openssl=SHOW_OPTION_YES;
241
#else
unknown's avatar
unknown committed
242
SHOW_COMP_OPTION have_openssl=SHOW_OPTION_NO;
243
#endif
244 245 246
#ifdef HAVE_BROKEN_REALPATH
SHOW_COMP_OPTION have_symlink=SHOW_OPTION_NO;
#else
247
SHOW_COMP_OPTION have_symlink=SHOW_OPTION_YES;
248
#endif
unknown's avatar
unknown committed
249 250 251 252 253
#ifdef HAVE_QUERY_CACHE
SHOW_COMP_OPTION have_query_cache=SHOW_OPTION_YES;
#else
SHOW_COMP_OPTION have_query_cache=SHOW_OPTION_NO;
#endif
unknown's avatar
unknown committed
254 255 256 257 258
#ifdef HAVE_CRYPT
SHOW_COMP_OPTION have_crypt=SHOW_OPTION_YES;
#else
SHOW_COMP_OPTION have_crypt=SHOW_OPTION_NO;
#endif
259

unknown's avatar
unknown committed
260
bool opt_large_files= sizeof(my_off_t) > 4;
261 262 263 264 265 266
#if SIZEOF_OFF_T > 4 && defined(BIG_TABLES)
#define GET_HA_ROWS GET_ULL
#else
#define GET_HA_ROWS GET_ULONG
#endif

unknown's avatar
unknown committed
267 268 269
#ifdef HAVE_LIBWRAP
char *libwrapName= NULL;
#endif
unknown's avatar
unknown committed
270 271 272 273

/*
  Variables to store startup options
*/
unknown's avatar
unknown committed
274

275
my_bool opt_skip_slave_start = 0; // If set, slave is not autostarted
276 277 278 279
/*
  If set, some standard measures to enforce slave data integrity will not
  be performed
*/
280
my_bool opt_reckless_slave = 0; 
unknown's avatar
unknown committed
281

282
ulong back_log, connect_timeout, concurrency;
unknown's avatar
unknown committed
283
char mysql_home[FN_REFLEN], pidfile_name[FN_REFLEN], time_zone[30];
unknown's avatar
unknown committed
284
char log_error_file[FN_REFLEN];
unknown's avatar
unknown committed
285
bool opt_log, opt_update_log, opt_bin_log, opt_slow_log;
286
bool opt_error_log= IF_WIN(1,0);
unknown's avatar
unknown committed
287
bool opt_disable_networking=0, opt_skip_show_db=0;
288
my_bool opt_enable_named_pipe= 0, opt_debugging= 0;
289
my_bool opt_local_infile, opt_external_locking, opt_slave_compressed_protocol;
290
uint delay_key_write_options= (uint) DELAY_KEY_WRITE_ON;
unknown's avatar
unknown committed
291

292
static my_bool opt_do_pstack = 0;
unknown's avatar
unknown committed
293
static ulong opt_specialflag=SPECIAL_ENGLISH;
294

unknown's avatar
unknown committed
295 296
static ulong opt_myisam_block_size;
static my_socket unix_sock= INVALID_SOCKET,ip_sock= INVALID_SOCKET;
unknown's avatar
unknown committed
297
static my_string opt_logname=0,opt_update_logname=0,
298
       opt_binlog_index_name = 0,opt_slow_logname=0;
unknown's avatar
unknown committed
299

300 301
static char* mysql_home_ptr= mysql_home;
static char* pidfile_name_ptr= pidfile_name;
unknown's avatar
unknown committed
302
char* log_error_file_ptr= log_error_file;
unknown's avatar
unknown committed
303
static pthread_t select_thread;
304 305
static my_bool opt_noacl=0, opt_bootstrap=0, opt_myisam_log=0;
my_bool opt_safe_user_create = 0, opt_no_mix_types = 0;
306
my_bool lower_case_table_names, opt_old_rpl_compat;
307
my_bool opt_show_slave_auth_info, opt_sql_bin_update = 0;
308
my_bool opt_log_slave_updates= 0, opt_console= 0;
309
my_bool opt_readonly = 0;
310

311
volatile bool  mqh_used = 0;
312
FILE *bootstrap_file=0;
313
int segfaulted = 0; // ensure we do not enter SIGSEGV handler twice
unknown's avatar
unknown committed
314

315 316 317 318
/*
  If sql_bin_update is true, SQL_LOG_UPDATE and SQL_LOG_BIN are kept in sync,
  and are treated as aliases for each other
*/
unknown's avatar
unknown committed
319 320

static bool kill_in_progress=FALSE;
321
struct rand_struct sql_rand; // used by sql_class.cc:THD::THD()
unknown's avatar
unknown committed
322
static int cleanup_done;
unknown's avatar
unknown committed
323
static char **defaults_argv;
324
char glob_hostname[FN_REFLEN];
unknown's avatar
unknown committed
325

326
#include "sslopt-vars.h"
unknown's avatar
unknown committed
327
#ifdef HAVE_OPENSSL
unknown's avatar
unknown committed
328
char *des_key_file = 0;
329
struct st_VioSSLAcceptorFd *ssl_acceptor_fd= 0;
unknown's avatar
unknown committed
330 331
#endif /* HAVE_OPENSSL */

unknown's avatar
unknown committed
332
I_List <i_string_pair> replicate_rewrite_db;
unknown's avatar
unknown committed
333 334 335 336
I_List<i_string> replicate_do_db, replicate_ignore_db;
// allow the user to tell us which db to replicate and which to ignore
I_List<i_string> binlog_do_db, binlog_ignore_db;

337
/* if we guessed server_id , we need to know about it */
unknown's avatar
unknown committed
338
ulong server_id= 0;			// Must be long becasue of set_var.cc
339 340
bool server_id_supplied = 0;

unknown's avatar
unknown committed
341
uint mysql_port;
342
uint test_flags = 0, select_errors=0, dropping_tables=0,ha_open_options=0;
unknown's avatar
unknown committed
343
uint volatile thread_count=0, thread_running=0, kill_cached_threads=0,
344
	      wake_thread=0;
unknown's avatar
unknown committed
345
ulong thd_startup_options=(OPTION_UPDATE_LOG | OPTION_AUTO_IS_NULL |
346
			   OPTION_BIN_LOG | OPTION_QUOTE_SHOW_CREATE );
unknown's avatar
unknown committed
347
uint protocol_version=PROTOCOL_VERSION;
348 349
struct system_variables global_system_variables;
struct system_variables max_system_variables;
350 351
ulonglong keybuff_size;
ulong table_cache_size,
352 353
      thread_stack,
      thread_stack_min,what_to_log= ~ (1L << (uint) COM_TIME),
354
      query_buff_size,
355
      slow_launch_time = 2L,
unknown's avatar
unknown committed
356
      slave_open_temp_tables=0,
357
      open_files_limit=0, max_binlog_size;
358
ulong com_stat[(uint) SQLCOM_END], com_other;
unknown's avatar
unknown committed
359
ulong slave_net_timeout;
360
ulong thread_cache_size=0, binlog_cache_size=0, max_binlog_cache_size=0;
361
ulong query_cache_size=0;
unknown's avatar
unknown committed
362
#ifdef HAVE_QUERY_CACHE
unknown's avatar
unknown committed
363
ulong query_cache_limit=0;
unknown's avatar
unknown committed
364 365 366
Query_cache query_cache;
#endif

unknown's avatar
unknown committed
367 368
volatile ulong cached_thread_count=0;

369
// replication parameters, if master_host is not NULL, we are a slave
unknown's avatar
unknown committed
370
my_string master_user = (char*) "test", master_password = 0, master_host=0,
371 372
  master_info_file = (char*) "master.info",
  relay_log_info_file = (char*) "relay-log.info",
unknown's avatar
unknown committed
373
  master_ssl_key=0, master_ssl_cert=0, master_ssl_capath=0, master_ssl_cipher=0;
374
my_string report_user = 0, report_password = 0, report_host=0;
375
 
376
const char *localhost=LOCAL_HOST;
377
const char *delayed_user="DELAYED";
unknown's avatar
unknown committed
378
uint master_port = MYSQL_PORT, master_connect_retry = 60;
379
uint report_port = MYSQL_PORT;
380
my_bool master_ssl = 0;
unknown's avatar
unknown committed
381

382
ulong master_retry_count=0;
383
ulong bytes_sent= 0L, bytes_received= 0L, net_big_packet_count= 0L;
unknown's avatar
unknown committed
384

unknown's avatar
unknown committed
385
bool opt_endinfo,using_udf_functions, locked_in_memory;
386
bool opt_using_transactions, using_update_log;
unknown's avatar
unknown committed
387 388
bool volatile abort_loop, select_thread_in_use, signal_thread_in_use;
bool volatile ready_to_exit, shutdown_in_progress, grant_option;
unknown's avatar
unknown committed
389
ulong refresh_version=1L,flush_version=1L;	/* Increments on each reload */
390
ulong query_id=1L,long_query_count,aborted_threads, killed_threads,
unknown's avatar
unknown committed
391 392
      aborted_connects,delayed_insert_timeout,delayed_insert_limit,
      delayed_queue_size,delayed_insert_threads,delayed_insert_writes,
393
      delayed_rows_in_use,delayed_insert_errors,flush_time, thread_created;
394
ulong filesort_rows, filesort_range_count, filesort_scan_count;
395
ulong filesort_merge_passes;
396 397
ulong select_range_check_count, select_range_count, select_scan_count;
ulong select_full_range_join_count,select_full_join_count;
398 399
ulong specialflag=0,opened_tables=0,created_tmp_tables=0,
      created_tmp_disk_tables=0;
unknown's avatar
unknown committed
400
ulong max_connections,max_insert_delayed_threads,max_used_connections,
unknown's avatar
unknown committed
401
      max_connect_errors, max_user_connections = 0;
unknown's avatar
unknown committed
402 403
ulong thread_id=1L,current_pid;
ulong slow_launch_threads = 0;
404
  
unknown's avatar
unknown committed
405
char mysql_real_data_home[FN_REFLEN],
unknown's avatar
unknown committed
406
     language[LIBLEN],reg_ext[FN_EXTLEN],
unknown's avatar
unknown committed
407
     mysql_charsets_dir[FN_REFLEN], *charsets_list,
408
     max_sort_char,*mysqld_user,*mysqld_chroot, *opt_init_file;
409
char *language_ptr= language;
unknown's avatar
unknown committed
410
char mysql_data_home_buff[2], *mysql_data_home=mysql_real_data_home;
unknown's avatar
unknown committed
411
#ifndef EMBEDDED_LIBRARY
412
bool mysql_embedded=0;
unknown's avatar
unknown committed
413
#else
414
bool mysql_embedded=1;
unknown's avatar
unknown committed
415 416
#endif

417
static char *opt_bin_logname = 0;
418
char *opt_relay_logname = 0, *opt_relaylog_index_name=0;
unknown's avatar
unknown committed
419
char server_version[SERVER_VERSION_LENGTH]=MYSQL_SERVER_VERSION;
unknown's avatar
unknown committed
420 421
const char *first_keyword="first";
const char **errmesg;			/* Error messages */
422
const char *myisam_recover_options_str="OFF";
423
const char *sql_mode_str="OFF";
unknown's avatar
unknown committed
424
ulong rpl_recovery_rank=0;
425

unknown's avatar
unknown committed
426
my_string mysql_unix_port=NULL, opt_mysql_tmpdir=NULL, mysql_tmpdir=NULL;
unknown's avatar
unknown committed
427
ulong my_bind_addr;			/* the address we bind to */
428
char *my_bind_addr_str;
unknown's avatar
unknown committed
429 430 431 432 433
DATE_FORMAT dayord;
double log_10[32];			/* 10 potences */
I_List<THD> threads,thread_cache;
time_t start_time;

434 435 436
ulong opt_sql_mode = 0L;
const char *sql_mode_names[] =
{ "REAL_AS_FLOAT", "PIPES_AS_CONCAT", "ANSI_QUOTES", "IGNORE_SPACE",
437
  "SERIALIZE","ONLY_FULL_GROUP_BY", "NO_UNSIGNED_SUBTRACTION",NullS };
438
TYPELIB sql_mode_typelib= {array_elements(sql_mode_names)-1,"",
439
			   sql_mode_names};
unknown's avatar
unknown committed
440

441
MY_BITMAP temp_pool;
442
my_bool use_temp_pool=0;
443

unknown's avatar
unknown committed
444 445 446 447 448 449 450
pthread_key(MEM_ROOT*,THR_MALLOC);
pthread_key(THD*, THR_THD);
pthread_key(NET*, THR_NET);
pthread_mutex_t LOCK_mysql_create_db, LOCK_Acl, LOCK_open, LOCK_thread_count,
		LOCK_mapped_file, LOCK_status, LOCK_grant,
		LOCK_error_log,
		LOCK_delayed_insert, LOCK_delayed_status, LOCK_delayed_create,
451
		LOCK_crypt, LOCK_bytes_sent, LOCK_bytes_received,
452
	        LOCK_global_system_variables,
453
		LOCK_user_conn, LOCK_slave_list, LOCK_active_mi;
unknown's avatar
unknown committed
454

unknown's avatar
unknown committed
455 456
pthread_cond_t COND_refresh,COND_thread_count, COND_slave_stopped,
	       COND_slave_start;
unknown's avatar
unknown committed
457 458 459 460 461 462 463
pthread_cond_t COND_thread_cache,COND_flush_thread_cache;
pthread_t signal_thread;
pthread_attr_t connection_attrib;

#ifdef __WIN__
#undef	 getpid
#include <process.h>
unknown's avatar
unknown committed
464
#if !defined(EMBEDDED_LIBRARY)
unknown's avatar
unknown committed
465
HANDLE hEventShutdown;
466
static char shutdown_event_name[40];
unknown's avatar
unknown committed
467 468 469
#include "nt_servc.h"
static	 NTService  Service;	      // Service object for WinNT
#endif
unknown's avatar
unknown committed
470
#endif
unknown's avatar
unknown committed
471

unknown's avatar
unknown committed
472 473 474 475
#ifdef OS2
pthread_cond_t eventShutdown;
#endif

476
static void start_signal_handler(void);
477
extern "C" pthread_handler_decl(signal_hand, arg);
unknown's avatar
unknown committed
478 479 480 481
static void set_options(void);
static void get_options(int argc,char **argv);
static char *get_relative_path(const char *path);
static void fix_paths(void);
482 483
extern "C" pthread_handler_decl(handle_connections_sockets,arg);
extern "C" pthread_handler_decl(kill_server_thread,arg);
unknown's avatar
unknown committed
484
static int bootstrap(FILE *file);
485
static void close_server_sock();
unknown's avatar
unknown committed
486 487
static bool read_init_file(char *file_name);
#ifdef __NT__
488
extern "C" pthread_handler_decl(handle_connections_namedpipes,arg);
unknown's avatar
unknown committed
489
#endif
490
extern "C" pthread_handler_decl(handle_slave,arg);
unknown's avatar
unknown committed
491 492 493
#ifdef SET_RLIMIT_NOFILE
static uint set_maximum_open_files(uint max_file_limit);
#endif
494
static ulong find_bit_type(const char *x, TYPELIB *bit_lib);
unknown's avatar
unknown committed
495
static void clean_up(bool print_message);
unknown's avatar
unknown committed
496
static void clean_up_mutexes(void);
unknown's avatar
unknown committed
497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514

/****************************************************************************
** Code to end mysqld
****************************************************************************/

static void close_connections(void)
{
#ifdef EXTRA_DEBUG
  int count=0;
#endif
  NET net;
  DBUG_ENTER("close_connections");

  /* Clear thread cache */
  kill_cached_threads++;
  flush_thread_cache();

  /* kill flush thread */
515 516
  (void) pthread_mutex_lock(&LOCK_manager);
  if (manager_thread_in_use)
unknown's avatar
unknown committed
517
  {
518 519
    DBUG_PRINT("quit",("killing manager thread: %lx",manager_thread));
   (void) pthread_cond_signal(&COND_manager);
unknown's avatar
unknown committed
520
  }
521
  (void) pthread_mutex_unlock(&LOCK_manager);
unknown's avatar
unknown committed
522 523

  /* kill connection thread */
unknown's avatar
unknown committed
524
#if !defined(__WIN__) && !defined(__EMX__) && !defined(OS2) && !defined(__NETWARE__)
unknown's avatar
unknown committed
525 526 527 528 529 530 531 532 533 534 535 536
  DBUG_PRINT("quit",("waiting for select thread: %lx",select_thread));
  (void) pthread_mutex_lock(&LOCK_thread_count);

  while (select_thread_in_use)
  {
    struct timespec abstime;
    int error;
    LINT_INIT(error);
#ifndef DONT_USE_THR_ALARM
    if (pthread_kill(select_thread,THR_CLIENT_ALARM))
      break;					// allready dead
#endif
537
    set_timespec(abstime, 2);
unknown's avatar
unknown committed
538 539 540 541 542 543 544 545 546 547 548
    for (uint tmp=0 ; tmp < 10 ; tmp++)
    {
      error=pthread_cond_timedwait(&COND_thread_count,&LOCK_thread_count,
				   &abstime);
      if (error != EINTR)
	break;
    }
#ifdef EXTRA_DEBUG
    if (error != 0 && !count++)
      sql_print_error("Got error %d from pthread_cond_timedwait",error);
#endif
unknown's avatar
unknown committed
549
    close_server_sock();
unknown's avatar
unknown committed
550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566
  }
  (void) pthread_mutex_unlock(&LOCK_thread_count);
#endif /* __WIN__ */


  /* Abort listening to new connections */
  DBUG_PRINT("quit",("Closing sockets"));
  if ( !opt_disable_networking )
  {
    if (ip_sock != INVALID_SOCKET)
    {
      (void) shutdown(ip_sock,2);
      (void) closesocket(ip_sock);
      ip_sock= INVALID_SOCKET;
    }
  }
#ifdef __NT__
unknown's avatar
unknown committed
567
  if (hPipe != INVALID_HANDLE_VALUE && opt_enable_named_pipe)
unknown's avatar
unknown committed
568
  {
unknown's avatar
merge  
unknown committed
569
    HANDLE temp;
unknown's avatar
unknown committed
570
    DBUG_PRINT( "quit", ("Closing named pipes") );
571
     
unknown's avatar
merge  
unknown committed
572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587
    /* Create connection to the handle named pipe handler to break the loop */
    if ((temp = CreateFile(szPipeName,
			   GENERIC_READ | GENERIC_WRITE,
			   0,
			   NULL,
			   OPEN_EXISTING,
			   0,
			   NULL )) != INVALID_HANDLE_VALUE)
    {
      WaitNamedPipe(szPipeName, 1000);
      DWORD dwMode = PIPE_READMODE_BYTE | PIPE_WAIT;
      SetNamedPipeHandleState(temp, &dwMode, NULL, NULL);
      CancelIo(temp);
      DisconnectNamedPipe(temp);
      CloseHandle(temp);
    }
unknown's avatar
unknown committed
588 589 590 591 592 593 594 595 596 597 598
  }
#endif
#ifdef HAVE_SYS_UN_H
  if (unix_sock != INVALID_SOCKET)
  {
    (void) shutdown(unix_sock,2);
    (void) closesocket(unix_sock);
    (void) unlink(mysql_unix_port);
    unix_sock= INVALID_SOCKET;
  }
#endif
599
  end_thr_alarm(0);			 // Abort old alarms.
600
  end_slave();
unknown's avatar
unknown committed
601 602 603 604 605 606 607 608 609 610 611 612 613 614 615

  /* First signal all threads that it's time to die */

  THD *tmp;
  (void) pthread_mutex_lock(&LOCK_thread_count); // For unlink from list

  I_List_iterator<THD> it(threads);
  while ((tmp=it++))
  {
    DBUG_PRINT("quit",("Informing thread %ld that it's time to die",
		       tmp->thread_id));
    tmp->killed=1;
    if (tmp->mysys_var)
    {
      tmp->mysys_var->abort=1;
unknown's avatar
unknown committed
616 617
      pthread_mutex_lock(&tmp->mysys_var->mutex);
      if (tmp->mysys_var->current_cond)
unknown's avatar
unknown committed
618 619 620 621 622
      {
	pthread_mutex_lock(tmp->mysys_var->current_mutex);
	pthread_cond_broadcast(tmp->mysys_var->current_cond);
	pthread_mutex_unlock(tmp->mysys_var->current_mutex);
      }
unknown's avatar
unknown committed
623
      pthread_mutex_unlock(&tmp->mysys_var->mutex);
unknown's avatar
unknown committed
624 625 626 627 628 629 630 631 632
    }
  }
  (void) pthread_mutex_unlock(&LOCK_thread_count); // For unlink from list

  if (thread_count)
    sleep(1);					// Give threads time to die

  /* Force remaining threads to die by closing the connection to the client */

unknown's avatar
unknown committed
633
  (void) my_net_init(&net, (st_vio*) 0);
unknown's avatar
unknown committed
634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669
  for (;;)
  {
    DBUG_PRINT("quit",("Locking LOCK_thread_count"));
    (void) pthread_mutex_lock(&LOCK_thread_count); // For unlink from list
    if (!(tmp=threads.get()))
    {
      DBUG_PRINT("quit",("Unlocking LOCK_thread_count"));
      (void) pthread_mutex_unlock(&LOCK_thread_count);
      break;
    }
#ifndef __bsdi__				// Bug in BSDI kernel
    if ((net.vio=tmp->net.vio) != 0)
    {
      sql_print_error(ER(ER_FORCING_CLOSE),my_progname,
		      tmp->thread_id,tmp->user ? tmp->user : "");
      close_connection(&net,0,0);
    }
#endif
    DBUG_PRINT("quit",("Unlocking LOCK_thread_count"));
    (void) pthread_mutex_unlock(&LOCK_thread_count);
  }
  net_end(&net);
  /* All threads has now been aborted */
  DBUG_PRINT("quit",("Waiting for threads to die (count=%u)",thread_count));
  (void) pthread_mutex_lock(&LOCK_thread_count);
  while (thread_count)
  {
    (void) pthread_cond_wait(&COND_thread_count,&LOCK_thread_count);
    DBUG_PRINT("quit",("One thread died (count=%u)",thread_count));
  }
  (void) pthread_mutex_unlock(&LOCK_thread_count);

  DBUG_PRINT("quit",("close_connections thread"));
  DBUG_VOID_RETURN;
}

unknown's avatar
unknown committed
670

671
static void close_server_sock()
unknown's avatar
unknown committed
672
{
673
#ifdef HAVE_CLOSE_SERVER_SOCK
unknown's avatar
unknown committed
674
  DBUG_ENTER("close_server_sock");
675 676 677
  my_socket tmp_sock;
  tmp_sock=ip_sock;
  if (tmp_sock != INVALID_SOCKET)
unknown's avatar
unknown committed
678 679
  {
    ip_sock=INVALID_SOCKET;
680
    DBUG_PRINT("info",("calling shutdown on TCP/IP socket"));
681
    VOID(shutdown(tmp_sock,2));
unknown's avatar
unknown committed
682
#if defined(__NETWARE__)
683
    /*
unknown's avatar
unknown committed
684 685
      The following code is disabled for normal systems as it causes MySQL
      to hang on AIX 4.3 during shutdown
686 687
    */
    DBUG_PRINT("info",("calling closesocket on TCP/IP socket"));    
688
    VOID(closesocket(tmp_sock));
689
#endif
unknown's avatar
unknown committed
690
  }
691 692
  tmp_sock=unix_sock;
  if (tmp_sock != INVALID_SOCKET)
unknown's avatar
unknown committed
693
  {
694
    unix_sock=INVALID_SOCKET;
695
    DBUG_PRINT("info",("calling shutdown on unix socket"));
696
    VOID(shutdown(tmp_sock,2));
unknown's avatar
unknown committed
697
#if defined(__NETWARE__)
unknown's avatar
unknown committed
698
    /*
unknown's avatar
unknown committed
699
      The following code is disabled for normal systems as it causes MySQL
unknown's avatar
unknown committed
700 701 702
      AIX 4.3 during shutdown (not tested, but likely)
    */
    DBUG_PRINT("info",("calling closesocket on unix/IP socket"));
703
    VOID(closesocket(tmp_sock));
unknown's avatar
unknown committed
704
#endif
unknown's avatar
unknown committed
705 706 707 708
    VOID(unlink(mysql_unix_port));
  }
  DBUG_VOID_RETURN;
#endif
709
}
unknown's avatar
unknown committed
710

711

unknown's avatar
unknown committed
712 713 714 715
void kill_mysql(void)
{
  DBUG_ENTER("kill_mysql");

unknown's avatar
unknown committed
716
#ifdef SIGNALS_DONT_BREAK_READ
717 718
  abort_loop=1;					// Break connection loops
  close_server_sock();				// Force accept to wake up
unknown's avatar
unknown committed
719
#endif  
unknown's avatar
unknown committed
720

unknown's avatar
unknown committed
721
#if defined(__WIN__)
unknown's avatar
unknown committed
722
#if !defined(EMBEDDED_LIBRARY)
unknown's avatar
unknown committed
723 724 725 726 727
  {
    if (!SetEvent(hEventShutdown))
    {
      DBUG_PRINT("error",("Got error: %ld from SetEvent",GetLastError()));
    }
728 729 730 731 732 733
    /*
      or:
      HANDLE hEvent=OpenEvent(0, FALSE, "MySqlShutdown");
      SetEvent(hEventShutdown);
      CloseHandle(hEvent);
    */
unknown's avatar
unknown committed
734
  }
unknown's avatar
unknown committed
735
#endif
unknown's avatar
unknown committed
736 737
#elif defined(OS2)
  pthread_cond_signal( &eventShutdown);		// post semaphore
unknown's avatar
unknown committed
738
#elif defined(HAVE_PTHREAD_KILL)
739
  if (pthread_kill(signal_thread, MYSQL_KILL_SIGNAL))
unknown's avatar
unknown committed
740 741 742 743
  {
    DBUG_PRINT("error",("Got error %d from pthread_kill",errno)); /* purecov: inspected */
  }
#elif !defined(SIGNALS_DONT_BREAK_READ)
744
  kill(current_pid, MYSQL_KILL_SIGNAL);
unknown's avatar
unknown committed
745
#endif
unknown's avatar
unknown committed
746 747 748
  DBUG_PRINT("quit",("After pthread_kill"));
  shutdown_in_progress=1;			// Safety if kill didn't work
#ifdef SIGNALS_DONT_BREAK_READ
749
  if (!kill_in_progress)
unknown's avatar
unknown committed
750 751
  {
    pthread_t tmp;
unknown's avatar
unknown committed
752
    abort_loop=1;
unknown's avatar
unknown committed
753 754 755 756
    if (pthread_create(&tmp,&connection_attrib, kill_server_thread,
			   (void*) 0))
      sql_print_error("Error: Can't create thread to kill server");
  }
unknown's avatar
unknown committed
757
#endif    
unknown's avatar
unknown committed
758
  DBUG_VOID_RETURN;
unknown's avatar
unknown committed
759 760 761 762 763
}


	/* Force server down. kill all connections and threads and exit */

unknown's avatar
unknown committed
764
#if defined(OS2) || defined(__NETWARE__)
unknown's avatar
unknown committed
765
extern "C" void kill_server(int sig_ptr)
766
#define RETURN_FROM_KILL_SERVER DBUG_VOID_RETURN
unknown's avatar
unknown committed
767
#elif !defined(__WIN__)
unknown's avatar
unknown committed
768
static void *kill_server(void *sig_ptr)
unknown's avatar
unknown committed
769
#define RETURN_FROM_KILL_SERVER DBUG_RETURN(0)
unknown's avatar
unknown committed
770 771
#else
static void __cdecl kill_server(int sig_ptr)
unknown's avatar
unknown committed
772
#define RETURN_FROM_KILL_SERVER DBUG_VOID_RETURN
unknown's avatar
unknown committed
773 774 775 776 777
#endif
{
  int sig=(int) (long) sig_ptr;			// This is passed a int
  DBUG_ENTER("kill_server");

778
  // if there is a signal during the kill in progress, ignore the other
unknown's avatar
unknown committed
779 780 781 782 783 784 785 786 787 788
  if (kill_in_progress)				// Safety
    RETURN_FROM_KILL_SERVER;
  kill_in_progress=TRUE;
  abort_loop=1;					// This should be set
  signal(sig,SIG_IGN);
  if (sig == MYSQL_KILL_SIGNAL || sig == 0)
    sql_print_error(ER(ER_NORMAL_SHUTDOWN),my_progname);
  else
    sql_print_error(ER(ER_GOT_SIGNAL),my_progname,sig); /* purecov: inspected */

unknown's avatar
unknown committed
789
#if defined(__NETWARE__) || (defined(USE_ONE_SIGNAL_HAND) && !defined(__WIN__) && !defined(OS2))
unknown's avatar
unknown committed
790 791 792 793 794 795
  my_thread_init();				// If this is a new thread
#endif
  close_connections();
  if (sig != MYSQL_KILL_SIGNAL && sig != 0)
    unireg_abort(1);				/* purecov: inspected */
  else
796
    unireg_end();
unknown's avatar
unknown committed
797 798 799 800

#ifdef __NETWARE__
  pthread_join(select_thread, NULL);		// wait for main thread
#endif /* __NETWARE__ */
801 802
  
  pthread_exit(0);				/* purecov: deadcode */
unknown's avatar
unknown committed
803

unknown's avatar
unknown committed
804 805 806 807
  RETURN_FROM_KILL_SERVER;
}


unknown's avatar
unknown committed
808
#if defined(USE_ONE_SIGNAL_HAND) || (defined(__NETWARE__) && defined(SIGNALS_DONT_BREAK_READ))
809
extern "C" pthread_handler_decl(kill_server_thread,arg __attribute__((unused)))
unknown's avatar
unknown committed
810
{
811
  SHUTDOWN_THD;
unknown's avatar
unknown committed
812 813 814 815 816 817 818
  my_thread_init();				// Initialize new thread
  kill_server(0);
  my_thread_end();				// Normally never reached
  return 0;
}
#endif

unknown's avatar
unknown committed
819 820 821 822 823
#if defined(__amiga__)
#undef sigset
#define sigset signal
#endif

824
extern "C" sig_handler print_signal_warning(int sig)
unknown's avatar
unknown committed
825
{
826 827 828 829 830 831
  if (!DBUG_IN_USE)
  {
    if (global_system_variables.log_warnings)
      sql_print_error("Warning: Got signal %d from thread %d",
		      sig,my_thread_id());
  }
unknown's avatar
unknown committed
832 833 834
#ifdef DONT_REMEMBER_SIGNAL
  sigset(sig,print_signal_warning);		/* int. thread system calls */
#endif
unknown's avatar
unknown committed
835
#if !defined(__WIN__) && !defined(OS2) && !defined(__NETWARE__)
unknown's avatar
unknown committed
836 837 838 839 840
  if (sig == SIGALRM)
    alarm(2);					/* reschedule alarm */
#endif
}

841 842 843 844 845 846 847 848 849 850 851 852 853
/*
  cleanup all memory and end program nicely

  SYNOPSIS
    unireg_end()

  NOTES
    This function never returns.

    If SIGNALS_DONT_BREAK_READ is defined, this function is called
    by the main thread. To get MySQL to shut down nicely in this case
    (Mac OS X) we have to call exit() instead if pthread_exit().
*/
unknown's avatar
unknown committed
854

855
void unireg_end(void)
unknown's avatar
unknown committed
856
{
unknown's avatar
unknown committed
857
  clean_up(1);
unknown's avatar
unknown committed
858
  my_thread_end();
859
#if defined(SIGNALS_DONT_BREAK_READ) && !defined(__NETWARE__)
860 861
  exit(0);
#else
unknown's avatar
unknown committed
862
  pthread_exit(0);				// Exit is in main thread
863
#endif
unknown's avatar
unknown committed
864 865 866
}


867
extern "C" void unireg_abort(int exit_code)
unknown's avatar
unknown committed
868
{
869
  DBUG_ENTER("unireg_abort");
unknown's avatar
unknown committed
870 871
  if (exit_code)
    sql_print_error("Aborting\n");
unknown's avatar
unknown committed
872
  clean_up(1); /* purecov: inspected */
873
  DBUG_PRINT("quit",("done with cleanup in unireg_abort"));
unknown's avatar
unknown committed
874
  my_thread_end();
unknown's avatar
unknown committed
875 876
  clean_up_mutexes();
  my_end(opt_endinfo ? MY_CHECK_ERROR | MY_GIVE_INFO : 0);
unknown's avatar
unknown committed
877 878 879 880
  exit(exit_code); /* purecov: inspected */
}


881
void clean_up(bool print_message)
unknown's avatar
unknown committed
882 883 884 885
{
  DBUG_PRINT("exit",("clean_up"));
  if (cleanup_done++)
    return; /* purecov: inspected */
unknown's avatar
unknown committed
886 887 888 889 890 891

  mysql_log.cleanup();
  mysql_slow_log.cleanup();
  mysql_update_log.cleanup();
  mysql_bin_log.cleanup();

unknown's avatar
unknown committed
892 893
  if (use_slave_mask)
    bitmap_free(&slave_error_mask);
unknown's avatar
unknown committed
894 895
  acl_free(1);
  grant_free();
unknown's avatar
unknown committed
896
  query_cache_destroy();
unknown's avatar
unknown committed
897 898 899 900
  table_cache_free();
  hostname_cache_free();
  item_user_lock_free();
  lex_free();				/* Free some memory */
unknown's avatar
unknown committed
901
  set_var_free();
unknown's avatar
unknown committed
902 903 904 905
#ifdef HAVE_DLOPEN
  if (!opt_noacl)
    udf_free();
#endif
906
  (void) ha_panic(HA_PANIC_CLOSE);	/* close all tables and logs */
unknown's avatar
unknown committed
907
  end_key_cache();
908
  end_thr_alarm(1);			/* Free allocated memory */
unknown's avatar
unknown committed
909 910 911
#ifdef USE_RAID
  end_raid();
#endif
unknown's avatar
unknown committed
912 913
  if (defaults_argv)
    free_defaults(defaults_argv);
914
  my_free(charsets_list, MYF(MY_ALLOW_ZERO_PTR));
unknown's avatar
unknown committed
915
  my_free(mysql_tmpdir,MYF(MY_ALLOW_ZERO_PTR));
916
  my_free(slave_load_tmpdir,MYF(MY_ALLOW_ZERO_PTR));
917
  x_free(opt_bin_logname);
918
  x_free(opt_relay_logname);
unknown's avatar
unknown committed
919
  bitmap_free(&temp_pool);
unknown's avatar
unknown committed
920
  free_max_user_conn();
921
  end_slave_list();
922 923 924 925 926 927
  free_list(&replicate_do_db);
  free_list(&replicate_ignore_db);
  free_list(&binlog_do_db);
  free_list(&binlog_ignore_db);
  free_list(&replicate_rewrite_db);

unknown's avatar
unknown committed
928
#ifdef HAVE_OPENSSL
unknown's avatar
unknown committed
929 930
  if (ssl_acceptor_fd)
    my_free((gptr) ssl_acceptor_fd, MYF(MY_ALLOW_ZERO_PTR));
unknown's avatar
unknown committed
931 932
  free_des_key_file();
#endif /* HAVE_OPENSSL */
unknown's avatar
unknown committed
933 934 935
#ifdef USE_REGEX
  regex_end();
#endif
unknown's avatar
unknown committed
936

unknown's avatar
unknown committed
937 938
  if (print_message && errmesg)
    sql_print_error(ER(ER_SHUTDOWN_COMPLETE),my_progname);
unknown's avatar
unknown committed
939
#if !defined(__WIN__) && !defined(EMBEDDED_LIBRARY)
940 941
  if (!opt_bootstrap)
    (void) my_delete(pidfile_name,MYF(0));	// This may not always exist
unknown's avatar
unknown committed
942
#endif
943
  x_free((gptr) my_errmsg[ERRMAPP]);	/* Free messages */
944
  DBUG_PRINT("quit", ("Error messages freed"));
unknown's avatar
unknown committed
945 946
  /* Tell main we are ready */
  (void) pthread_mutex_lock(&LOCK_thread_count);
947
  DBUG_PRINT("quit", ("got thread count lock"));
unknown's avatar
unknown committed
948
  ready_to_exit=1;
unknown's avatar
unknown committed
949
  /* do the broadcast inside the lock to ensure that my_end() is not called */
unknown's avatar
unknown committed
950 951
  (void) pthread_cond_broadcast(&COND_thread_count);
  (void) pthread_mutex_unlock(&LOCK_thread_count);
unknown's avatar
unknown committed
952 953 954 955
  /*
    The following lines may never be executed as the main thread may have
    killed us
  */
956
  DBUG_PRINT("quit", ("done with cleanup"));
unknown's avatar
unknown committed
957 958 959
} /* clean_up */


unknown's avatar
unknown committed
960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987
static void clean_up_mutexes()
{
  (void) pthread_mutex_destroy(&LOCK_mysql_create_db);
  (void) pthread_mutex_destroy(&LOCK_Acl);
  (void) pthread_mutex_destroy(&LOCK_grant);
  (void) pthread_mutex_destroy(&LOCK_open);
  (void) pthread_mutex_destroy(&LOCK_thread_count);
  (void) pthread_mutex_destroy(&LOCK_mapped_file);
  (void) pthread_mutex_destroy(&LOCK_status);
  (void) pthread_mutex_destroy(&LOCK_error_log);
  (void) pthread_mutex_destroy(&LOCK_delayed_insert);
  (void) pthread_mutex_destroy(&LOCK_delayed_status);
  (void) pthread_mutex_destroy(&LOCK_delayed_create);
  (void) pthread_mutex_destroy(&LOCK_manager);
  (void) pthread_mutex_destroy(&LOCK_crypt);
  (void) pthread_mutex_destroy(&LOCK_bytes_sent);
  (void) pthread_mutex_destroy(&LOCK_bytes_received);
  (void) pthread_mutex_destroy(&LOCK_user_conn);
  (void) pthread_mutex_destroy(&LOCK_rpl_status);
  (void) pthread_mutex_destroy(&LOCK_active_mi);
  (void) pthread_mutex_destroy(&LOCK_global_system_variables);
  (void) pthread_cond_destroy(&COND_thread_count);
  (void) pthread_cond_destroy(&COND_refresh);
  (void) pthread_cond_destroy(&COND_thread_cache);
  (void) pthread_cond_destroy(&COND_flush_thread_cache);
  (void) pthread_cond_destroy(&COND_manager);
  (void) pthread_cond_destroy(&COND_rpl_status);
}
unknown's avatar
unknown committed
988 989 990 991 992 993 994 995

/****************************************************************************
** Init IP and UNIX socket
****************************************************************************/

static void set_ports()
{
  char	*env;
996
  if (!mysql_port && !opt_disable_networking)
unknown's avatar
unknown committed
997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020
  {					// Get port if not from commandline
    struct  servent *serv_ptr;
    mysql_port = MYSQL_PORT;
    if ((serv_ptr = getservbyname("mysql", "tcp")))
      mysql_port = ntohs((u_short) serv_ptr->s_port); /* purecov: inspected */
    if ((env = getenv("MYSQL_TCP_PORT")))
      mysql_port = (uint) atoi(env);		/* purecov: inspected */
  }
  if (!mysql_unix_port)
  {
#ifdef __WIN__
    mysql_unix_port = (char*) MYSQL_NAMEDPIPE;
#else
    mysql_unix_port = (char*) MYSQL_UNIX_ADDR;
#endif
    if ((env = getenv("MYSQL_UNIX_PORT")))
      mysql_unix_port = env;			/* purecov: inspected */
  }
}

/* Change to run as another user if started with --user */

static void set_user(const char *user)
{
unknown's avatar
unknown committed
1021
#if !defined(__WIN__) && !defined(OS2) && !defined(__NETWARE__)
1022 1023
  struct passwd *ent;
  uid_t user_id= geteuid();
unknown's avatar
unknown committed
1024 1025

  // don't bother if we aren't superuser
1026
  if (user_id)
unknown's avatar
unknown committed
1027 1028
  {
    if (user)
1029 1030 1031 1032 1033 1034 1035 1036
    {
      /* Don't give a warning, if real user is same as given with --user */
      struct passwd *user_info= getpwnam(user);

      if (!user_info || user_id != user_info->pw_uid)
	fprintf(stderr,
		"Warning: One can only use the --user switch if running as root\n");
    }
unknown's avatar
unknown committed
1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050
    return;
  }
  else if (!user)
  {
    if (!opt_bootstrap)
    {
      fprintf(stderr,"Fatal error: Please read \"Security\" section of the manual to find out how to run mysqld as root!\n");
      unireg_abort(1);
    }
    return;
  }
  if (!strcmp(user,"root"))
    return;				// Avoid problem with dynamic libraries

unknown's avatar
unknown committed
1051
  uid_t uid;
unknown's avatar
unknown committed
1052 1053
  if (!(ent = getpwnam(user)))
  {
unknown's avatar
unknown committed
1054 1055 1056 1057 1058 1059 1060 1061 1062
    // allow a numeric uid to be used
    const char *pos;
    for (pos=user; isdigit(*pos); pos++) ;
    if (*pos)					// Not numeric id
    {
      fprintf(stderr,"Fatal error: Can't change to run as user '%s' ;  Please check that the user exists!\n",user);
      unireg_abort(1);
    }
    uid=atoi(user);				// Use numberic uid
unknown's avatar
unknown committed
1063
  }
unknown's avatar
unknown committed
1064 1065
  else
  {
unknown's avatar
unknown committed
1066
#ifdef HAVE_INITGROUPS
unknown's avatar
unknown committed
1067
    initgroups((char*) user,ent->pw_gid);
unknown's avatar
unknown committed
1068
#endif
unknown's avatar
unknown committed
1069 1070 1071 1072 1073 1074
    if (setgid(ent->pw_gid) == -1)
    {
      sql_perror("setgid");
      unireg_abort(1);
    }
    uid=ent->pw_uid;
unknown's avatar
unknown committed
1075
  }
unknown's avatar
unknown committed
1076 1077

  if (setuid(uid) == -1)
unknown's avatar
unknown committed
1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088
  {
    sql_perror("setuid");
    unireg_abort(1);
  }
#endif
}

/* Change root user if started with  --chroot */

static void set_root(const char *path)
{
unknown's avatar
unknown committed
1089
#if !defined(__WIN__) && !defined(__EMX__) && !defined(OS2) && !defined(__NETWARE__)
unknown's avatar
unknown committed
1090 1091 1092 1093 1094
  if (chroot(path) == -1)
  {
    sql_perror("chroot");
    unireg_abort(1);
  }
1095
  my_setwd("/", MYF(0));
unknown's avatar
unknown committed
1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136
#endif
}

static void server_init(void)
{
  struct sockaddr_in	IPaddr;
#ifdef HAVE_SYS_UN_H
  struct sockaddr_un	UNIXaddr;
#endif
  int	arg=1;
  DBUG_ENTER("server_init");

#ifdef	__WIN__
  if ( !opt_disable_networking )
  {
    WSADATA WsaData;
    if (SOCKET_ERROR == WSAStartup (0x0101, &WsaData))
    {
      my_message(0,"WSAStartup Failed\n",MYF(0));
      unireg_abort(1);
    }
  }
#endif /* __WIN__ */

  set_ports();

  if (mysql_port != 0 && !opt_disable_networking && !opt_bootstrap)
  {
    DBUG_PRINT("general",("IP Socket is %d",mysql_port));
    ip_sock = socket(AF_INET, SOCK_STREAM, 0);
    if (ip_sock == INVALID_SOCKET)
    {
      DBUG_PRINT("error",("Got error: %d from socket()",socket_errno));
      sql_perror(ER(ER_IPSOCK_ERROR));		/* purecov: tested */
      unireg_abort(1);				/* purecov: tested */
    }
    bzero((char*) &IPaddr, sizeof(IPaddr));
    IPaddr.sin_family = AF_INET;
    IPaddr.sin_addr.s_addr = my_bind_addr;
    IPaddr.sin_port = (unsigned short) htons((unsigned short) mysql_port);
    (void) setsockopt(ip_sock,SOL_SOCKET,SO_REUSEADDR,(char*)&arg,sizeof(arg));
1137 1138
    if (bind(ip_sock, my_reinterpret_cast(struct sockaddr *) (&IPaddr),
	     sizeof(IPaddr)) < 0)
unknown's avatar
unknown committed
1139 1140
    {
      DBUG_PRINT("error",("Got error: %d from bind",socket_errno));
1141
      sql_perror("Can't start server: Bind on TCP/IP port");
unknown's avatar
unknown committed
1142 1143 1144
      sql_print_error("Do you already have another mysqld server running on port: %d ?",mysql_port);
      unireg_abort(1);
    }
1145
    if (listen(ip_sock,(int) back_log) < 0)
unknown's avatar
unknown committed
1146
    {
1147
      sql_perror("Can't start server: listen() on TCP/IP port");
unknown's avatar
unknown committed
1148
      sql_print_error("Error:  listen() on TCP/IP failed with error %d",
unknown's avatar
unknown committed
1149
		      socket_errno);
unknown's avatar
unknown committed
1150 1151
      unireg_abort(1);
    }
unknown's avatar
unknown committed
1152
  }
unknown's avatar
unknown committed
1153
  set_user(mysqld_user);		// Works also with mysqld_user==NULL
unknown's avatar
unknown committed
1154 1155 1156

#ifdef __NT__
  /* create named pipe */
unknown's avatar
unknown committed
1157 1158
  if (Service.IsNT() && mysql_unix_port[0] && !opt_bootstrap &&
      opt_enable_named_pipe)
unknown's avatar
unknown committed
1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182
  {
    sprintf( szPipeName, "\\\\.\\pipe\\%s", mysql_unix_port );
    ZeroMemory( &saPipeSecurity, sizeof(saPipeSecurity) );
    ZeroMemory( &sdPipeDescriptor, sizeof(sdPipeDescriptor) );
    if ( !InitializeSecurityDescriptor(&sdPipeDescriptor,
				       SECURITY_DESCRIPTOR_REVISION) )
    {
      sql_perror("Can't start server : Initialize security descriptor");
      unireg_abort(1);
    }
    if (!SetSecurityDescriptorDacl(&sdPipeDescriptor, TRUE, NULL, FALSE))
    {
      sql_perror("Can't start server : Set security descriptor");
      unireg_abort(1);
    }
    saPipeSecurity.nLength = sizeof( SECURITY_ATTRIBUTES );
    saPipeSecurity.lpSecurityDescriptor = &sdPipeDescriptor;
    saPipeSecurity.bInheritHandle = FALSE;
    if ((hPipe = CreateNamedPipe(szPipeName,
				 PIPE_ACCESS_DUPLEX,
				 PIPE_TYPE_BYTE |
				 PIPE_READMODE_BYTE |
				 PIPE_WAIT,
				 PIPE_UNLIMITED_INSTANCES,
1183 1184
				 (int) global_system_variables.net_buffer_length,
				 (int) global_system_variables.net_buffer_length,
unknown's avatar
unknown committed
1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201
				 NMPWAIT_USE_DEFAULT_WAIT,
				 &saPipeSecurity )) == INVALID_HANDLE_VALUE)
      {
	LPVOID lpMsgBuf;
	int error=GetLastError();
	FormatMessage(FORMAT_MESSAGE_ALLOCATE_BUFFER |
		      FORMAT_MESSAGE_FROM_SYSTEM,
		      NULL, error, MAKELANGID(LANG_NEUTRAL, SUBLANG_DEFAULT),
		      (LPTSTR) &lpMsgBuf, 0, NULL );
	MessageBox( NULL, (LPTSTR) lpMsgBuf, "Error from CreateNamedPipe",
		    MB_OK|MB_ICONINFORMATION );
	LocalFree( lpMsgBuf );
	unireg_abort(1);
      }
  }
#endif

1202
#if defined(HAVE_SYS_UN_H)
unknown's avatar
unknown committed
1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232
  /*
  ** Create the UNIX socket
  */
  if (mysql_unix_port[0] && !opt_bootstrap)
  {
    DBUG_PRINT("general",("UNIX Socket is %s",mysql_unix_port));

    if ((unix_sock = socket(AF_UNIX, SOCK_STREAM, 0)) < 0)
    {
      sql_perror("Can't start server : UNIX Socket "); /* purecov: inspected */
      unireg_abort(1);				/* purecov: inspected */
    }
    bzero((char*) &UNIXaddr, sizeof(UNIXaddr));
    UNIXaddr.sun_family = AF_UNIX;
    strmov(UNIXaddr.sun_path, mysql_unix_port);
    (void) unlink(mysql_unix_port);
    (void) setsockopt(unix_sock,SOL_SOCKET,SO_REUSEADDR,(char*)&arg,
		      sizeof(arg));
    umask(0);
    if (bind(unix_sock, my_reinterpret_cast(struct sockaddr *) (&UNIXaddr),
	     sizeof(UNIXaddr)) < 0)
    {
      sql_perror("Can't start server : Bind on unix socket"); /* purecov: tested */
      sql_print_error("Do you already have another mysqld server running on socket: %s ?",mysql_unix_port);
      unireg_abort(1);					/* purecov: tested */
    }
    umask(((~my_umask) & 0666));
#if defined(S_IFSOCK) && defined(SECURE_SOCKETS)
    (void) chmod(mysql_unix_port,S_IFSOCK);	/* Fix solaris 2.6 bug */
#endif
1233 1234
    if (listen(unix_sock,(int) back_log) < 0)
      sql_print_error("Warning:  listen() on Unix socket failed with error %d",
unknown's avatar
unknown committed
1235
		      socket_errno);
unknown's avatar
unknown committed
1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246
  }
#endif
  DBUG_PRINT("info",("server started"));
  DBUG_VOID_RETURN;
}


void yyerror(const char *s)
{
  NET *net=my_pthread_getspecific_ptr(NET*,THR_NET);
  char *yytext=(char*) current_lex->tok_start;
1247
  if (!strcmp(s,"parse error") || !strcmp(s,"syntax error"))
unknown's avatar
unknown committed
1248 1249 1250 1251 1252 1253 1254 1255
    s=ER(ER_SYNTAX_ERROR);
  net_printf(net,ER_PARSE_ERROR, s, yytext ? (char*) yytext : "",
	     current_lex->yylineno);
}


void close_connection(NET *net,uint errcode,bool lock)
{
unknown's avatar
unknown committed
1256
  st_vio* vio;
unknown's avatar
unknown committed
1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276
  DBUG_ENTER("close_connection");
  DBUG_PRINT("enter",("fd: %s  error: '%s'",
                    net->vio? vio_description(net->vio):"(not connected)",
                    errcode ? ER(errcode) : ""));
  if (lock)
    (void) pthread_mutex_lock(&LOCK_thread_count);
  if ((vio=net->vio) != 0)
  {
    if (errcode)
      send_error(net,errcode,ER(errcode));	/* purecov: inspected */
    vio_close(vio);			/* vio is freed in delete thd */
  }
  if (lock)
    (void) pthread_mutex_unlock(&LOCK_thread_count);
  DBUG_VOID_RETURN;
}

	/* Called when a thread is aborted */
	/* ARGSUSED */

1277
extern "C" sig_handler end_thread_signal(int sig __attribute__((unused)))
unknown's avatar
unknown committed
1278 1279 1280
{
  THD *thd=current_thd;
  DBUG_ENTER("end_thread_signal");
1281
  if (thd && ! thd->bootstrap)
1282 1283
  {
    statistic_increment(killed_threads, &LOCK_status);
unknown's avatar
unknown committed
1284
    end_thread(thd,0);
1285
  }
unknown's avatar
unknown committed
1286 1287 1288 1289 1290 1291 1292
  DBUG_VOID_RETURN;				/* purecov: deadcode */
}


void end_thread(THD *thd, bool put_in_cache)
{
  DBUG_ENTER("end_thread");
unknown's avatar
unknown committed
1293
  thd->cleanup();
unknown's avatar
unknown committed
1294 1295 1296
  (void) pthread_mutex_lock(&LOCK_thread_count);
  thread_count--;
  delete thd;
1297

1298 1299
  if (put_in_cache && cached_thread_count < thread_cache_size &&
      ! abort_loop && !kill_cached_threads)
unknown's avatar
unknown committed
1300 1301 1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312
  {
    /* Don't kill the thread, just put it in cache for reuse */
    DBUG_PRINT("info", ("Adding thread to cache"))
    cached_thread_count++;
    while (!abort_loop && ! wake_thread && ! kill_cached_threads)
      (void) pthread_cond_wait(&COND_thread_cache, &LOCK_thread_count);
    cached_thread_count--;
    if (kill_cached_threads)
      pthread_cond_signal(&COND_flush_thread_cache);
    if (wake_thread)
    {
      wake_thread--;
      thd=thread_cache.get();
1313
      thd->real_id=pthread_self();
unknown's avatar
unknown committed
1314
      (void) thd->store_globals();
1315
      threads.append(thd);
unknown's avatar
unknown committed
1316 1317 1318 1319 1320 1321 1322 1323 1324
      pthread_mutex_unlock(&LOCK_thread_count);
      DBUG_VOID_RETURN;
    }
  }

  DBUG_PRINT("info", ("sending a broadcast"))

  /* Tell main we are ready */
  (void) pthread_mutex_unlock(&LOCK_thread_count);
1325
  /* It's safe to broadcast outside a lock (COND... is not deleted here) */
unknown's avatar
unknown committed
1326
  (void) pthread_cond_broadcast(&COND_thread_count);
unknown's avatar
unknown committed
1327
  DBUG_PRINT("info", ("unlocked thread_count mutex"))
1328
#ifdef ONE_THREAD
unknown's avatar
unknown committed
1329 1330 1331 1332 1333 1334 1335 1336 1337 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
  if (!(test_flags & TEST_NO_THREADS))	// For debugging under Linux
#endif
  {
    my_thread_end();
    pthread_exit(0);
  }
  DBUG_VOID_RETURN;
}


/* Start a cached thread. LOCK_thread_count is locked on entry */

static void start_cached_thread(THD *thd)
{
  thread_cache.append(thd);
  wake_thread++;
  thread_count++;
  pthread_cond_signal(&COND_thread_cache);
}


void flush_thread_cache()
{
  (void) pthread_mutex_lock(&LOCK_thread_count);
  kill_cached_threads++;
  while (cached_thread_count)
  {
    pthread_cond_broadcast(&COND_thread_cache);
    pthread_cond_wait(&COND_flush_thread_cache,&LOCK_thread_count);
  }
  kill_cached_threads--;
  (void) pthread_mutex_unlock(&LOCK_thread_count);
}


1364 1365 1366 1367 1368
/*
  Aborts a thread nicely. Commes here on SIGPIPE
  TODO: One should have to fix that thr_alarm know about this
  thread too.
*/
unknown's avatar
unknown committed
1369 1370

#ifdef THREAD_SPECIFIC_SIGPIPE
1371
extern "C" sig_handler abort_thread(int sig __attribute__((unused)))
unknown's avatar
unknown committed
1372 1373 1374 1375 1376 1377 1378 1379 1380 1381
{
  THD *thd=current_thd;
  DBUG_ENTER("abort_thread");
  if (thd)
    thd->killed=1;
  DBUG_VOID_RETURN;
}
#endif

/******************************************************************************
1382 1383 1384
  Setup a signal thread with handles all signals.
  Because Linux doesn't support schemas use a mutex to check that
  the signal thread is ready before continuing
unknown's avatar
unknown committed
1385 1386
******************************************************************************/

unknown's avatar
unknown committed
1387
#if defined(__WIN__) || defined(OS2)
unknown's avatar
unknown committed
1388 1389 1390 1391 1392
static void init_signals(void)
{
  int signals[] = {SIGINT,SIGILL,SIGFPE,SIGSEGV,SIGTERM,SIGABRT } ;
  for (uint i=0 ; i < sizeof(signals)/sizeof(int) ; i++)
    signal( signals[i], kill_server) ;
unknown's avatar
unknown committed
1393
#if defined(__WIN__)
unknown's avatar
unknown committed
1394
  signal(SIGBREAK,SIG_IGN);	//ignore SIGBREAK for NT
unknown's avatar
unknown committed
1395 1396 1397
#else
  signal(SIGBREAK, kill_server);
#endif
unknown's avatar
unknown committed
1398 1399
}

1400
static void start_signal_handler(void)
unknown's avatar
unknown committed
1401 1402 1403 1404
{}

static void check_data_home(const char *path)
{}
1405

unknown's avatar
unknown committed
1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 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 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467
#elif defined(__NETWARE__)

// down server event callback
void mysql_down_server_cb(void *, void *)
{
  kill_server(0);
}

// destroy callback resources
void mysql_cb_destroy(void *)
{
  UnRegisterEventNotification(eh);  // cleanup down event notification
  NX_UNWRAP_INTERFACE(ref);
}

// initialize callbacks
void mysql_cb_init()
{
  // register for down server event
  void *handle = getnlmhandle();
  rtag_t rt = AllocateResourceTag(handle, "MySQL Down Server Callback",
                                  EventSignature);
  NX_WRAP_INTERFACE((void *)mysql_down_server_cb, 2, (void **)&ref);
  eh = RegisterForEventNotification(rt, EVENT_DOWN_SERVER,
                                    EVENT_PRIORITY_APPLICATION,
                                    NULL, ref, NULL);
  NXVmRegisterExitHandler(mysql_cb_destroy, NULL);  // clean-up
}

static void init_signals(void)
{
  int signals[] = {SIGINT,SIGILL,SIGFPE,SIGSEGV,SIGTERM,SIGABRT};

  for (uint i=0 ; i < sizeof(signals)/sizeof(int) ; i++)
    signal(signals[i], kill_server);
  mysql_cb_init();  // initialize callbacks
}

static void start_signal_handler(void)
{
  // Save vm id of this process
  if (!opt_bootstrap)
  {
    File pidFile;
    if ((pidFile = my_create(pidfile_name,0664, O_WRONLY, MYF(MY_WME))) >= 0)
    {
      char buff[21];
      sprintf(buff,"%lu",(ulong) getpid());
      (void) my_write(pidFile, buff,strlen(buff),MYF(MY_WME));
      (void) my_close(pidFile,MYF(0));
    }
  }
  // no signal handler
}


/*  Warn if the data is on a Traditional volume */

static void check_data_home(const char *path)
{
}

unknown's avatar
unknown committed
1468 1469 1470
#elif defined(__EMX__)
static void sig_reload(int signo)
{
1471 1472
 // Flush everything
  reload_acl_and_cache((THD*) 0,REFRESH_LOG, (TABLE_LIST*) 0);
unknown's avatar
unknown committed
1473 1474 1475 1476 1477
  signal(signo, SIG_ACK);
}

static void sig_kill(int signo)
{
1478
  if (!kill_in_progress)
unknown's avatar
unknown committed
1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495
  {
    abort_loop=1;				// mark abort for threads
    kill_server((void*) signo);
  }
  signal(signo, SIG_ACK);
}

static void init_signals(void)
{
  signal(SIGQUIT, sig_kill);
  signal(SIGKILL, sig_kill);
  signal(SIGTERM, sig_kill);
  signal(SIGINT,  sig_kill);
  signal(SIGHUP,  sig_reload);	// Flush everything
  signal(SIGALRM, SIG_IGN);
  signal(SIGBREAK,SIG_IGN);
  signal_thread = pthread_self();
1496
  SIGNAL_THD;
unknown's avatar
unknown committed
1497
}
1498 1499

static void start_signal_handler(void)
unknown's avatar
unknown committed
1500
{}
1501

unknown's avatar
unknown committed
1502
static void check_data_home(const char *path)
unknown's avatar
unknown committed
1503
{}
unknown's avatar
unknown committed
1504

unknown's avatar
unknown committed
1505
#else /* if ! __WIN__ && ! __EMX__ */
unknown's avatar
unknown committed
1506

unknown's avatar
unknown committed
1507 1508
#ifdef HAVE_LINUXTHREADS
#define UNSAFE_DEFAULT_LINUX_THREADS 200
1509
#endif
1510

1511
extern "C" sig_handler handle_segfault(int sig)
1512
{
unknown's avatar
unknown committed
1513
  THD *thd=current_thd;
1514 1515 1516 1517 1518 1519
  /*
    Strictly speaking, one needs a mutex here
    but since we have got SIGSEGV already, things are a mess
    so not having the mutex is not as bad as possibly using a buggy
    mutex - so we keep things simple
  */
1520
  if (segfaulted)
unknown's avatar
unknown committed
1521 1522 1523 1524
  {
    fprintf(stderr, "Fatal signal %d while backtracing\n", sig);
    exit(1);
  }
unknown's avatar
unknown committed
1525
  
1526
  segfaulted = 1;
1527
  fprintf(stderr,"\
1528
mysqld got signal %d;\n\
unknown's avatar
unknown committed
1529
This could be because you hit a bug. It is also possible that this binary\n\
unknown's avatar
unknown committed
1530
or one of the libraries it was linked against is corrupt, improperly built,\n\
unknown's avatar
unknown committed
1531 1532 1533 1534 1535
or misconfigured. This error can also be caused by malfunctioning hardware.\n",
	  sig);
  fprintf(stderr, "\
We will try our best to scrape up some info that will hopefully help diagnose\n\
the problem, but since we have already crashed, something is definitely wrong\n\
unknown's avatar
unknown committed
1536
and this may fail.\n\n");
1537
  fprintf(stderr, "key_buffer_size=%lu\n", (ulong) keybuff_size);
unknown's avatar
unknown committed
1538
  fprintf(stderr, "read_buffer_size=%ld\n", global_system_variables.read_buff_size);
unknown's avatar
unknown committed
1539 1540 1541 1542
  fprintf(stderr, "max_used_connections=%ld\n", max_used_connections);
  fprintf(stderr, "max_connections=%ld\n", max_connections);
  fprintf(stderr, "threads_connected=%d\n", thread_count);
  fprintf(stderr, "It is possible that mysqld could use up to \n\
unknown's avatar
unknown committed
1543
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = %ld K\n\
1544 1545
bytes of memory\n", ((ulong) keybuff_size +
		     (global_system_variables.read_buff_size +
unknown's avatar
unknown committed
1546
		      global_system_variables.sortbuff_size) *
1547
		     max_connections)/ 1024);
unknown's avatar
unknown committed
1548
  fprintf(stderr, "Hope that's ok; if not, decrease some variables in the equation.\n\n");
unknown's avatar
unknown committed
1549
  
1550
#if defined(HAVE_LINUXTHREADS)
unknown's avatar
unknown committed
1551 1552 1553 1554
  if (sizeof(char*) == 4 && thread_count > UNSAFE_DEFAULT_LINUX_THREADS)
  {
    fprintf(stderr, "\
You seem to be running 32-bit Linux and have %d concurrent connections.\n\
unknown's avatar
unknown committed
1555 1556
If you have not changed STACK_SIZE in LinuxThreads and built the binary \n\
yourself, LinuxThreads is quite likely to steal a part of the global heap for\n\
unknown's avatar
unknown committed
1557 1558 1559 1560
the thread stack. Please read http://www.mysql.com/doc/L/i/Linux.html\n\n",
	    thread_count);
  }
#endif /* HAVE_LINUXTHREADS */
unknown's avatar
unknown committed
1561

unknown's avatar
unknown committed
1562
#ifdef HAVE_STACKTRACE
1563
  if (!(test_flags & TEST_NO_STACKTRACE))
unknown's avatar
unknown committed
1564
  {
1565
    fprintf(stderr,"thd=%p\n",thd);
unknown's avatar
unknown committed
1566 1567
    print_stacktrace(thd ? (gptr) thd->thread_stack : (gptr) 0,
		     thread_stack);
unknown's avatar
unknown committed
1568
  }
unknown's avatar
unknown committed
1569 1570 1571 1572 1573 1574 1575 1576
  if (thd)
  {
    fprintf(stderr, "Trying to get some variables.\n\
Some pointers may be invalid and cause the dump to abort...\n");
    safe_print_str("thd->query", thd->query, 1024);
    fprintf(stderr, "thd->thread_id=%ld\n", thd->thread_id);
  }
  fprintf(stderr, "\
unknown's avatar
unknown committed
1577
The manual page at http://www.mysql.com/doc/en/Crashing.html contains\n\
unknown's avatar
unknown committed
1578
information that should help you find out what is causing the crash.\n");
1579
  fflush(stderr);
unknown's avatar
unknown committed
1580 1581
#endif /* HAVE_STACKTRACE */

1582
 if (test_flags & TEST_CORE_ON_SIGNAL)
unknown's avatar
unknown committed
1583 1584 1585
 {
   fprintf(stderr, "Writing a core file\n");
   fflush(stderr);
1586
   write_core(sig);
unknown's avatar
unknown committed
1587
 }
1588
 exit(1);
1589 1590
}

unknown's avatar
unknown committed
1591 1592 1593 1594 1595 1596
#ifndef SA_RESETHAND
#define SA_RESETHAND 0
#endif
#ifndef SA_NODEFER
#define SA_NODEFER 0
#endif
1597

unknown's avatar
unknown committed
1598 1599 1600
static void init_signals(void)
{
  sigset_t set;
1601
  struct sigaction sa;
unknown's avatar
unknown committed
1602 1603
  DBUG_ENTER("init_signals");

1604 1605
  if (test_flags & TEST_SIGINT)
    sigset(THR_KILL_SIGNAL,end_thread_signal);
unknown's avatar
unknown committed
1606
  sigset(THR_SERVER_ALARM,print_signal_warning); // Should never be called!
unknown's avatar
unknown committed
1607

unknown's avatar
unknown committed
1608
  if (!(test_flags & TEST_NO_STACKTRACE) || (test_flags & TEST_CORE_ON_SIGNAL))
unknown's avatar
unknown committed
1609
  {
unknown's avatar
unknown committed
1610 1611 1612 1613
    sa.sa_flags = SA_RESETHAND | SA_NODEFER;
    sigemptyset(&sa.sa_mask);
    sigprocmask(SIG_SETMASK,&sa.sa_mask,NULL);

unknown's avatar
unknown committed
1614
    init_stacktrace();
unknown's avatar
unknown committed
1615 1616 1617
#if defined(__amiga__)
    sa.sa_handler=(void(*)())handle_segfault;
#else
unknown's avatar
unknown committed
1618
    sa.sa_handler=handle_segfault;
unknown's avatar
unknown committed
1619
#endif
unknown's avatar
unknown committed
1620
    sigaction(SIGSEGV, &sa, NULL);
1621
    sigaction(SIGABRT, &sa, NULL);
unknown's avatar
unknown committed
1622
#ifdef SIGBUS
unknown's avatar
unknown committed
1623
    sigaction(SIGBUS, &sa, NULL);
unknown's avatar
unknown committed
1624
#endif
unknown's avatar
unknown committed
1625
    sigaction(SIGILL, &sa, NULL);
1626
    sigaction(SIGFPE, &sa, NULL);
unknown's avatar
unknown committed
1627
  }
1628 1629 1630 1631 1632 1633 1634

#ifdef HAVE_GETRLIMIT
  if (test_flags & TEST_CORE_ON_SIGNAL)
  {
    /* Change limits so that we will get a core file */
    struct rlimit rl;
    rl.rlim_cur = rl.rlim_max = RLIM_INFINITY;
unknown's avatar
unknown committed
1635
    if (setrlimit(RLIMIT_CORE, &rl) && global_system_variables.log_warnings)
1636 1637 1638
      sql_print_error("Warning: setrlimit could not change the size of core files to 'infinity';  We may not be able to generate a core file on signals");
  }
#endif
unknown's avatar
unknown committed
1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650
  (void) sigemptyset(&set);
#ifdef THREAD_SPECIFIC_SIGPIPE
  sigset(SIGPIPE,abort_thread);
  sigaddset(&set,SIGPIPE);
#else
  (void) signal(SIGPIPE,SIG_IGN);		// Can't know which thread
  sigaddset(&set,SIGPIPE);
#endif
  sigaddset(&set,SIGINT);
  sigaddset(&set,SIGQUIT);
  sigaddset(&set,SIGTERM);
  sigaddset(&set,SIGHUP);
1651 1652

  /* Fix signals if blocked by parents (can happen on Mac OS X) */
unknown's avatar
unknown committed
1653
  sigemptyset(&sa.sa_mask);
1654 1655 1656 1657 1658 1659
  sa.sa_flags = 0;
  sa.sa_handler = print_signal_warning;
  sigaction(SIGTERM, &sa, (struct sigaction*) 0);
  sa.sa_flags = 0;
  sa.sa_handler = print_signal_warning;
  sigaction(SIGHUP, &sa, (struct sigaction*) 0);
unknown's avatar
unknown committed
1660 1661 1662 1663
#ifdef SIGTSTP
  sigaddset(&set,SIGTSTP);
#endif
  sigaddset(&set,THR_SERVER_ALARM);
1664 1665
  if (test_flags & TEST_SIGINT)
    sigdelset(&set,THR_KILL_SIGNAL);		// May be SIGINT
unknown's avatar
unknown committed
1666
  sigdelset(&set,THR_CLIENT_ALARM);		// For alarms
1667 1668
  sigprocmask(SIG_SETMASK,&set,NULL);
  pthread_sigmask(SIG_SETMASK,&set,NULL);
1669 1670 1671 1672 1673 1674 1675 1676 1677
  DBUG_VOID_RETURN;
}


static void start_signal_handler(void)
{
  int error;
  pthread_attr_t thr_attr;
  DBUG_ENTER("start_signal_handler");
unknown's avatar
unknown committed
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

  (void) pthread_attr_init(&thr_attr);
#if !defined(HAVE_DEC_3_2_THREADS)
  pthread_attr_setscope(&thr_attr,PTHREAD_SCOPE_SYSTEM);
  (void) pthread_attr_setdetachstate(&thr_attr,PTHREAD_CREATE_DETACHED);
  if (!(opt_specialflag & SPECIAL_NO_PRIOR))
    my_pthread_attr_setprio(&thr_attr,INTERRUPT_PRIOR);
  pthread_attr_setstacksize(&thr_attr,32768);
#endif

  (void) pthread_mutex_lock(&LOCK_thread_count);
  if ((error=pthread_create(&signal_thread,&thr_attr,signal_hand,0)))
  {
    sql_print_error("Can't create interrupt-thread (error %d, errno: %d)",
		    error,errno);
    exit(1);
  }
  (void) pthread_cond_wait(&COND_thread_count,&LOCK_thread_count);
  pthread_mutex_unlock(&LOCK_thread_count);

  (void) pthread_attr_destroy(&thr_attr);
  DBUG_VOID_RETURN;
}


1703
/* This threads handles all signals and alarms */
unknown's avatar
unknown committed
1704 1705

/* ARGSUSED */
1706
extern "C" void *signal_hand(void *arg __attribute__((unused)))
unknown's avatar
unknown committed
1707 1708 1709 1710 1711
{
  sigset_t set;
  int sig;
  my_thread_init();				// Init new thread
  DBUG_ENTER("signal_hand");
unknown's avatar
unknown committed
1712 1713
  signal_thread_in_use= 1;

unknown's avatar
unknown committed
1714 1715
  /*
    Setup alarm handler
1716 1717
    This should actually be '+ max_number_of_slaves' instead of +10,
    but the +10 should be quite safe.
unknown's avatar
unknown committed
1718
  */
1719
  init_thr_alarm(max_connections+max_insert_delayed_threads+10);
unknown's avatar
unknown committed
1720
#if SIGINT != THR_KILL_SIGNAL
1721 1722 1723 1724 1725 1726
  if (test_flags & TEST_SIGINT)
  {
    (void) sigemptyset(&set);			// Setup up SIGINT for debug
    (void) sigaddset(&set,SIGINT);		// For debugging
    (void) pthread_sigmask(SIG_UNBLOCK,&set,NULL);
  }
unknown's avatar
unknown committed
1727 1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739
#endif
  (void) sigemptyset(&set);			// Setup up SIGINT for debug
#ifdef USE_ONE_SIGNAL_HAND
  (void) sigaddset(&set,THR_SERVER_ALARM);	// For alarms
#endif
  (void) sigaddset(&set,SIGQUIT);
  (void) sigaddset(&set,SIGTERM);
#if THR_CLIENT_ALARM != SIGHUP
  (void) sigaddset(&set,SIGHUP);
#endif
  (void) sigaddset(&set,SIGTSTP);

  /* Save pid to this process (or thread on Linux) */
1740
  if (!opt_bootstrap)
unknown's avatar
unknown committed
1741
  {
1742 1743
    File pidFile;
    if ((pidFile = my_create(pidfile_name,0664, O_WRONLY, MYF(MY_WME))) >= 0)
unknown's avatar
unknown committed
1744
    {
1745 1746
      char buff[21];
      sprintf(buff,"%lu",(ulong) getpid());
1747
      (void) my_write(pidFile, buff,strlen(buff),MYF(MY_WME));
1748
      (void) my_close(pidFile,MYF(0));
unknown's avatar
unknown committed
1749 1750
    }
  }
1751 1752 1753 1754 1755 1756 1757
#ifdef HAVE_STACK_TRACE_ON_SEGV
  if (opt_do_pstack)
  {
    sprintf(pstack_file_name,"mysqld-%lu-%%d-%%d.backtrace", (ulong)getpid());
    pstack_install_segv_action(pstack_file_name);
  }
#endif /* HAVE_STACK_TRACE_ON_SEGV */
unknown's avatar
unknown committed
1758

1759 1760 1761 1762 1763 1764 1765
  /*
    signal to start_signal_handler that we are ready
    This works by waiting for start_signal_handler to free mutex,
    after which we signal it that we are ready.
    At this pointer there is no other threads running, so there
    should not be any other pthread_cond_signal() calls.
  */
unknown's avatar
unknown committed
1766 1767
  (void) pthread_mutex_lock(&LOCK_thread_count);
  (void) pthread_mutex_unlock(&LOCK_thread_count);
1768
  (void) pthread_cond_broadcast(&COND_thread_count);
unknown's avatar
unknown committed
1769

1770
  (void) pthread_sigmask(SIG_BLOCK,&set,NULL);
unknown's avatar
unknown committed
1771 1772 1773 1774 1775
  for (;;)
  {
    int error;					// Used when debugging
    if (shutdown_in_progress && !abort_loop)
    {
1776
      sig= SIGTERM;
unknown's avatar
unknown committed
1777 1778 1779 1780 1781
      error=0;
    }
    else
      while ((error=my_sigwait(&set,&sig)) == EINTR) ;
    if (cleanup_done)
1782 1783
    {
      my_thread_end();
unknown's avatar
unknown committed
1784
      signal_thread_in_use= 0;
unknown's avatar
unknown committed
1785
      pthread_exit(0);				// Safety
1786
    }
unknown's avatar
unknown committed
1787 1788 1789 1790 1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805
    switch (sig) {
    case SIGTERM:
    case SIGQUIT:
    case SIGKILL:
#ifdef EXTRA_DEBUG
      sql_print_error("Got signal %d to shutdown mysqld",sig);
#endif
      DBUG_PRINT("info",("Got signal: %d  abort_loop: %d",sig,abort_loop));
      if (!abort_loop)
      {
	abort_loop=1;				// mark abort for threads
#ifdef USE_ONE_SIGNAL_HAND
	pthread_t tmp;
	if (!(opt_specialflag & SPECIAL_NO_PRIOR))
	  my_pthread_attr_setprio(&connection_attrib,INTERRUPT_PRIOR);
	if (pthread_create(&tmp,&connection_attrib, kill_server_thread,
			   (void*) sig))
	  sql_print_error("Error: Can't create thread to kill server");
#else
unknown's avatar
unknown committed
1806
	kill_server((void*) sig);	// MIT THREAD has a alarm thread
unknown's avatar
unknown committed
1807 1808 1809 1810
#endif
      }
      break;
    case SIGHUP:
unknown's avatar
unknown committed
1811 1812 1813 1814 1815 1816 1817 1818 1819
      if (!abort_loop)
      {
	reload_acl_and_cache((THD*) 0,
			     (REFRESH_LOG | REFRESH_TABLES | REFRESH_FAST |
			      REFRESH_STATUS | REFRESH_GRANT |
			      REFRESH_THREADS | REFRESH_HOSTS),
			     (TABLE_LIST*) 0); // Flush logs
	mysql_print_status((THD*) 0);		// Send debug some info
      }
unknown's avatar
unknown committed
1820 1821 1822 1823 1824 1825 1826 1827
      break;
#ifdef USE_ONE_SIGNAL_HAND
    case THR_SERVER_ALARM:
      process_alarm(sig);			// Trigger alarms.
      break;
#endif
    default:
#ifdef EXTRA_DEBUG
1828
      sql_print_error("Warning: Got signal: %d  error: %d",sig,error); /* purecov: tested */
unknown's avatar
unknown committed
1829 1830 1831 1832 1833 1834 1835
#endif
      break;					/* purecov: tested */
    }
  }
  return(0);					/* purecov: deadcode */
}

unknown's avatar
unknown committed
1836
static void check_data_home(const char *path)
unknown's avatar
unknown committed
1837
{}
unknown's avatar
unknown committed
1838

unknown's avatar
unknown committed
1839 1840 1841 1842
#endif	/* __WIN__*/


/*
1843 1844
  All global error messages are sent here where the first one is stored for
  the client
unknown's avatar
unknown committed
1845 1846 1847 1848
*/


/* ARGSUSED */
1849 1850
extern "C" int my_message_sql(uint error, const char *str,
			      myf MyFlags __attribute__((unused)))
unknown's avatar
unknown committed
1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867
{
  NET *net;
  DBUG_ENTER("my_message_sql");
  DBUG_PRINT("error",("Message: '%s'",str));
  if ((net=my_pthread_getspecific_ptr(NET*,THR_NET)))
  {
    if (!net->last_error[0])			// Return only first message
    {
      strmake(net->last_error,str,sizeof(net->last_error)-1);
      net->last_errno=error ? error : ER_UNKNOWN_ERROR;
    }
  }
  else
    sql_print_error("%s: %s",my_progname,str); /* purecov: inspected */
  DBUG_RETURN(0);
}

unknown's avatar
unknown committed
1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878

/*
  Forget last error message (if we got one)
*/

void clear_error_message(THD *thd)
{
  thd->net.last_error[0]= 0;
}


unknown's avatar
unknown committed
1879 1880 1881 1882 1883 1884 1885
#ifdef __WIN__

struct utsname
{
  char nodename[FN_REFLEN];
};

unknown's avatar
unknown committed
1886

unknown's avatar
unknown committed
1887 1888 1889 1890 1891 1892
int uname(struct utsname *a)
{
  return -1;
}


1893
extern "C" pthread_handler_decl(handle_shutdown,arg)
unknown's avatar
unknown committed
1894 1895
{
  MSG msg;
1896
  SHUTDOWN_THD;
unknown's avatar
unknown committed
1897 1898 1899 1900
  my_thread_init();

  /* this call should create the message queue for this thread */
  PeekMessage(&msg, NULL, 1, 65534,PM_NOREMOVE);
unknown's avatar
unknown committed
1901
#if !defined(EMBEDDED_LIBRARY)
unknown's avatar
unknown committed
1902
  if (WaitForSingleObject(hEventShutdown,INFINITE)==WAIT_OBJECT_0)
unknown's avatar
unknown committed
1903
#endif
unknown's avatar
unknown committed
1904 1905 1906 1907
     kill_server(MYSQL_KILL_SIGNAL);
  return 0;
}

unknown's avatar
unknown committed
1908
int STDCALL handle_kill(ulong ctrl_type)
unknown's avatar
unknown committed
1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919
{
  if (ctrl_type == CTRL_CLOSE_EVENT ||
      ctrl_type == CTRL_SHUTDOWN_EVENT)
  {
    kill_server(MYSQL_KILL_SIGNAL);
    return TRUE;
  }
  return FALSE;
}
#endif

unknown's avatar
unknown committed
1920
#ifdef OS2
1921
extern "C" pthread_handler_decl(handle_shutdown,arg)
unknown's avatar
unknown committed
1922
{
1923
  SHUTDOWN_THD;
unknown's avatar
unknown committed
1924 1925 1926 1927 1928 1929 1930 1931
  my_thread_init();

  // wait semaphore
  pthread_cond_wait( &eventShutdown, NULL);

  // close semaphore and kill server
  pthread_cond_destroy( &eventShutdown);

1932 1933 1934 1935
  /*
    Exit main loop on main thread, so kill will be done from
    main thread (this is thread 2)
  */
unknown's avatar
unknown committed
1936 1937 1938
  abort_loop = 1;

  // unblock select()
1939 1940
  so_cancel(ip_sock);
  so_cancel(unix_sock);
unknown's avatar
unknown committed
1941 1942 1943 1944 1945

  return 0;
}
#endif

1946

1947
const char *load_default_groups[]= { "mysqld","server",MYSQL_BASE_VERSION,0 };
unknown's avatar
unknown committed
1948

1949 1950 1951 1952 1953
bool open_log(MYSQL_LOG *log, const char *hostname,
	      const char *opt_name, const char *extension,
	      const char *index_file_name,
	      enum_log_type type, bool read_append,
	      bool no_auto_events)
unknown's avatar
unknown committed
1954 1955 1956 1957
{
  char tmp[FN_REFLEN];
  if (!opt_name || !opt_name[0])
  {
1958 1959 1960
    /*
      TODO: The following should be using fn_format();  We just need to
      first change fn_format() to cut the file name if it's too long.
unknown's avatar
unknown committed
1961 1962
    */
    strmake(tmp,hostname,FN_REFLEN-5);
1963
    strmov(fn_ext(tmp),extension);
unknown's avatar
unknown committed
1964 1965
    opt_name=tmp;
  }
1966
  // get rid of extension if the log is binary to avoid problems
1967 1968
  if (type == LOG_BIN)
  {
unknown's avatar
unknown committed
1969
    char *p = fn_ext(opt_name);
1970
    if (p)
unknown's avatar
unknown committed
1971 1972 1973 1974 1975
    {
      uint length=(uint) (p-opt_name);
      strmake(tmp,opt_name,min(length,FN_REFLEN));
      opt_name=tmp;
    }
1976
  }
1977 1978 1979
  return log->open(opt_name, type, 0, index_file_name,
		   (read_append) ? SEQ_READ_APPEND : WRITE_CACHE,
		   no_auto_events);
unknown's avatar
unknown committed
1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993
}



#ifdef __WIN__
int win_main(int argc, char **argv)
#else
int main(int argc, char **argv)
#endif
{
  DEBUGGER_OFF;

  my_umask=0660;		// Default umask for new files
  my_umask_dir=0700;		// Default umask for new directories
1994
  MAIN_THD;
1995 1996 1997 1998
  /*
    Initialize signal_th and shutdown_th to main_th for default value
    as we need to initialize them to something safe. They are used
    when compiled with safemalloc.
1999 2000 2001
  */
  SIGNAL_THD;
  SHUTDOWN_THD;
unknown's avatar
unknown committed
2002 2003 2004 2005
  MY_INIT(argv[0]);		// init my_sys library & pthreads
  tzset();			// Set tzname

  start_time=time((time_t*) 0);
unknown's avatar
unknown committed
2006

unknown's avatar
unknown committed
2007 2008 2009 2010 2011 2012 2013 2014
#ifdef OS2
  {
    // fix timezone for daylight saving
    struct tm *ts = localtime(&start_time);
    if (ts->tm_isdst > 0)
      _timezone -= 3600;
  }
#endif
unknown's avatar
unknown committed
2015 2016 2017 2018
#ifdef HAVE_TZNAME
  {
    struct tm tm_tmp;
    localtime_r(&start_time,&tm_tmp);
unknown's avatar
unknown committed
2019
    strmov(time_zone,tzname[tm_tmp.tm_isdst != 0 ? 1 : 0]);
unknown's avatar
unknown committed
2020 2021 2022
  }
#endif

unknown's avatar
unknown committed
2023 2024
  if (gethostname(glob_hostname,sizeof(glob_hostname)-4) < 0)
    strmov(glob_hostname,"mysql");
unknown's avatar
unknown committed
2025
  strmake(pidfile_name, glob_hostname, sizeof(pidfile_name)-5);
2026
  strmov(fn_ext(pidfile_name),".pid");		// Add proper extension
unknown's avatar
unknown committed
2027
#ifndef DBUG_OFF
2028 2029 2030
  strxmov(strend(server_version),MYSQL_SERVER_SUFFIX,"-debug",NullS);
#else
  strmov(strend(server_version),MYSQL_SERVER_SUFFIX);
unknown's avatar
unknown committed
2031 2032 2033 2034 2035 2036 2037 2038
#endif
#ifdef _CUSTOMSTARTUPCONFIG_
  if (_cust_check_startup())
  {
    /* _cust_check_startup will report startup failure error */
    exit( 1 );
  }
#endif
2039
  load_defaults(MYSQL_CONFIG_NAME,load_default_groups,&argc,&argv);
unknown's avatar
unknown committed
2040
  defaults_argv=argv;
unknown's avatar
unknown committed
2041 2042 2043

  /* Get default temporary directory */
  opt_mysql_tmpdir=getenv("TMPDIR");	/* Use this if possible */
unknown's avatar
unknown committed
2044
#if defined( __WIN__) || defined(OS2)
unknown's avatar
unknown committed
2045 2046 2047 2048
  if (!opt_mysql_tmpdir)
    opt_mysql_tmpdir=getenv("TEMP");
  if (!opt_mysql_tmpdir)
    opt_mysql_tmpdir=getenv("TMP");
unknown's avatar
unknown committed
2049
#endif
unknown's avatar
unknown committed
2050 2051
  if (!opt_mysql_tmpdir || !opt_mysql_tmpdir[0])
    opt_mysql_tmpdir=(char*) P_tmpdir;		/* purecov: inspected */
unknown's avatar
unknown committed
2052 2053 2054 2055 2056 2057 2058 2059 2060 2061

  set_options();
  get_options(argc,argv);
  if (opt_log || opt_update_log || opt_slow_log || opt_bin_log)
    strcat(server_version,"-log");
  DBUG_PRINT("info",("%s  Ver %s for %s on %s\n",my_progname,
		     server_version, SYSTEM_TYPE,MACHINE_TYPE));

  /* These must be set early */

2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077
  (void) pthread_mutex_init(&LOCK_mysql_create_db,MY_MUTEX_INIT_SLOW);
  (void) pthread_mutex_init(&LOCK_Acl,MY_MUTEX_INIT_SLOW);
  (void) pthread_mutex_init(&LOCK_grant,MY_MUTEX_INIT_FAST);
  (void) pthread_mutex_init(&LOCK_open,MY_MUTEX_INIT_FAST);
  (void) pthread_mutex_init(&LOCK_thread_count,MY_MUTEX_INIT_FAST);
  (void) pthread_mutex_init(&LOCK_mapped_file,MY_MUTEX_INIT_SLOW);
  (void) pthread_mutex_init(&LOCK_status,MY_MUTEX_INIT_FAST);
  (void) pthread_mutex_init(&LOCK_error_log,MY_MUTEX_INIT_FAST);
  (void) pthread_mutex_init(&LOCK_delayed_insert,MY_MUTEX_INIT_FAST);
  (void) pthread_mutex_init(&LOCK_delayed_status,MY_MUTEX_INIT_FAST);
  (void) pthread_mutex_init(&LOCK_delayed_create,MY_MUTEX_INIT_SLOW);
  (void) pthread_mutex_init(&LOCK_manager,MY_MUTEX_INIT_FAST);
  (void) pthread_mutex_init(&LOCK_crypt,MY_MUTEX_INIT_FAST);
  (void) pthread_mutex_init(&LOCK_bytes_sent,MY_MUTEX_INIT_FAST);
  (void) pthread_mutex_init(&LOCK_bytes_received,MY_MUTEX_INIT_FAST);
  (void) pthread_mutex_init(&LOCK_user_conn, MY_MUTEX_INIT_FAST);
2078
  (void) pthread_mutex_init(&LOCK_rpl_status, MY_MUTEX_INIT_FAST);
2079
  (void) pthread_mutex_init(&LOCK_active_mi, MY_MUTEX_INIT_FAST);
2080
  (void) pthread_mutex_init(&LOCK_global_system_variables, MY_MUTEX_INIT_FAST);
unknown's avatar
unknown committed
2081 2082 2083 2084
  (void) pthread_cond_init(&COND_thread_count,NULL);
  (void) pthread_cond_init(&COND_refresh,NULL);
  (void) pthread_cond_init(&COND_thread_cache,NULL);
  (void) pthread_cond_init(&COND_flush_thread_cache,NULL);
2085
  (void) pthread_cond_init(&COND_manager,NULL);
2086
  (void) pthread_cond_init(&COND_rpl_status, NULL);
2087
  init_signals();
unknown's avatar
unknown committed
2088

unknown's avatar
unknown committed
2089
  if (set_default_charset_by_name(sys_charset.value, MYF(MY_WME)))
2090
    exit(1);
unknown's avatar
unknown committed
2091 2092 2093 2094 2095
  charsets_list = list_charsets(MYF(MY_COMPILED_SETS|MY_CONFIG_SETS));

#ifdef HAVE_OPENSSL
  if (opt_use_ssl)
  {
2096 2097 2098 2099
    /* having ssl_acceptor_fd != 0 signals the use of SSL */
    ssl_acceptor_fd= new_VioSSLAcceptorFd(opt_ssl_key, opt_ssl_cert,
					  opt_ssl_ca, opt_ssl_capath,
					  opt_ssl_cipher);
unknown's avatar
unknown committed
2100
    DBUG_PRINT("info",("ssl_acceptor_fd: %lx", (long) ssl_acceptor_fd));
unknown's avatar
unknown committed
2101
    if (!ssl_acceptor_fd)
unknown's avatar
unknown committed
2102
      opt_use_ssl = 0;
unknown's avatar
unknown committed
2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117
  }
#endif /* HAVE_OPENSSL */

#ifdef HAVE_LIBWRAP
  libwrapName= my_progname+dirname_length(my_progname);
  openlog(libwrapName, LOG_PID, LOG_AUTH);
#endif

  if (!(opt_specialflag & SPECIAL_NO_PRIOR))
    my_pthread_setprio(pthread_self(),CONNECT_PRIOR);
  /* Parameter for threads created for connections */
  (void) pthread_attr_init(&connection_attrib);
  (void) pthread_attr_setdetachstate(&connection_attrib,
				     PTHREAD_CREATE_DETACHED);
  pthread_attr_setstacksize(&connection_attrib,thread_stack);
2118
#ifdef HAVE_PTHREAD_ATTR_GETSTACKSIZE
2119 2120
  {
    /* Retrieve used stack size;  Needed for checking stack overflows */
2121
    size_t stack_size= 0;
2122
    pthread_attr_getstacksize(&connection_attrib, &stack_size);
2123
    /* We must check if stack_size = 0 as Solaris 2.9 can return 0 here */
unknown's avatar
unknown committed
2124
    if (stack_size && stack_size < thread_stack)
2125
    {
2126 2127 2128
      if (global_system_variables.log_warnings)
	sql_print_error("Warning: Asked for %ld thread stack, but got %ld",
			thread_stack, stack_size);
2129 2130 2131
      thread_stack= stack_size;
    }
  }
2132
#endif
unknown's avatar
unknown committed
2133 2134 2135 2136
  if (!(opt_specialflag & SPECIAL_NO_PRIOR))
    my_pthread_attr_setprio(&connection_attrib,WAIT_PRIOR);
  pthread_attr_setscope(&connection_attrib, PTHREAD_SCOPE_SYSTEM);

unknown's avatar
unknown committed
2137
#if defined( SET_RLIMIT_NOFILE) || defined( OS2)
2138
  /* connections and databases needs lots of files */
unknown's avatar
unknown committed
2139 2140 2141
  {
    uint wanted_files=10+(uint) max(max_connections*5,
				    max_connections+table_cache_size*2);
unknown's avatar
unknown committed
2142 2143
    set_if_bigger(wanted_files, open_files_limit);
    // Note that some system returns 0 if we succeed here:
unknown's avatar
unknown committed
2144
    uint files=set_maximum_open_files(wanted_files);
unknown's avatar
unknown committed
2145
    if (files && files < wanted_files && ! open_files_limit)
unknown's avatar
unknown committed
2146
    {
2147 2148
      max_connections=	(ulong) min((files-10),max_connections);
      table_cache_size= (ulong) max((files-10-max_connections)/2,64);
unknown's avatar
unknown committed
2149 2150 2151 2152 2153 2154 2155 2156 2157 2158 2159
      DBUG_PRINT("warning",
		 ("Changed limits: max_connections: %ld  table_cache: %ld",
		  max_connections,table_cache_size));
      sql_print_error("Warning: Changed limits: max_connections: %ld  table_cache: %ld",max_connections,table_cache_size);
    }
  }
#endif
  unireg_init(opt_specialflag); /* Set up extern variabels */
  init_errmessage();		/* Read error messages from file */
  lex_init();
  item_init();
unknown's avatar
unknown committed
2160
  set_var_init();
unknown's avatar
unknown committed
2161 2162 2163 2164 2165 2166
  mysys_uses_curses=0;
#ifdef USE_REGEX
  regex_init();
#endif
  select_thread=pthread_self();
  select_thread_in_use=1;
unknown's avatar
unknown committed
2167
  if (use_temp_pool && bitmap_init(&temp_pool,1024,1))
unknown's avatar
unknown committed
2168
    unireg_abort(1);
unknown's avatar
unknown committed
2169 2170

  /*
2171
    We have enough space for fiddling with the argv, continue
unknown's avatar
unknown committed
2172 2173
  */
  umask(((~my_umask) & 0666));
unknown's avatar
unknown committed
2174
  check_data_home(mysql_real_data_home);
unknown's avatar
unknown committed
2175 2176 2177 2178
  if (my_setwd(mysql_real_data_home,MYF(MY_WME)))
  {
    unireg_abort(1);				/* purecov: inspected */
  }
unknown's avatar
unknown committed
2179
  mysql_data_home= mysql_data_home_buff;
unknown's avatar
unknown committed
2180 2181 2182 2183 2184
  mysql_data_home[0]=FN_CURLIB;		// all paths are relative from here
  mysql_data_home[1]=0;
  server_init();
  table_cache_init();
  hostname_cache_init();
unknown's avatar
unknown committed
2185 2186
  query_cache_result_size_limit(query_cache_limit);
  query_cache_resize(query_cache_size);
unknown's avatar
unknown committed
2187 2188 2189
  randominit(&sql_rand,(ulong) start_time,(ulong) start_time/2);
  reset_floating_point_exceptions();
  init_thr_lock();
2190
  init_slave_list();
unknown's avatar
unknown committed
2191 2192 2193 2194
#ifdef HAVE_OPENSSL
  if (des_key_file)
    load_des_key_file(des_key_file);
#endif /* HAVE_OPENSSL */
unknown's avatar
unknown committed
2195

unknown's avatar
unknown committed
2196 2197
  /* Setup log files */
  if (opt_log)
2198 2199
    open_log(&mysql_log, glob_hostname, opt_logname, ".log", NullS,
	     LOG_NORMAL);
unknown's avatar
unknown committed
2200
  if (opt_update_log)
unknown's avatar
unknown committed
2201
  {
unknown's avatar
unknown committed
2202
    open_log(&mysql_update_log, glob_hostname, opt_update_logname, "",
2203
	     NullS, LOG_NEW);
unknown's avatar
unknown committed
2204 2205
    using_update_log=1;
  }
2206
 
unknown's avatar
unknown committed
2207
  if (opt_slow_log)
unknown's avatar
unknown committed
2208
    open_log(&mysql_slow_log, glob_hostname, opt_slow_logname, "-slow.log",
2209
	     NullS, LOG_NORMAL);
2210 2211

  if (opt_error_log)
2212
  {
2213 2214 2215 2216 2217 2218 2219
    if (!log_error_file_ptr[0])
      fn_format(log_error_file, glob_hostname, mysql_data_home, ".err", 0);
    else
      fn_format(log_error_file, log_error_file_ptr, mysql_data_home, ".err",
		MY_UNPACK_FILENAME | MY_SAFE_PATH);
    if (!log_error_file[0])
      opt_error_log= 1;				// Too long file name
unknown's avatar
unknown committed
2220 2221 2222
    else
    {
      if (freopen(log_error_file, "a+", stdout))
2223 2224
	freopen(log_error_file, "a+", stderr);
    }
2225
  }
unknown's avatar
unknown committed
2226 2227 2228
  if (ha_init())
  {
    sql_print_error("Can't init databases");
2229 2230
    if (unix_sock != INVALID_SOCKET)
      unlink(mysql_unix_port);
unknown's avatar
unknown committed
2231
    unireg_abort(1);
unknown's avatar
unknown committed
2232
  }
unknown's avatar
unknown committed
2233
  ha_key_cache();
unknown's avatar
unknown committed
2234
#if defined(HAVE_MLOCKALL) && defined(MCL_CURRENT)
2235 2236 2237 2238 2239 2240 2241 2242 2243 2244 2245
  if (locked_in_memory && !geteuid())
  {
    if (mlockall(MCL_CURRENT))
    {
      sql_print_error("Warning: Failed to lock memory. Errno: %d\n",errno);
    }
    else
      locked_in_memory=1;
  }
#else
  locked_in_memory=0;
2246
#endif
2247

2248
  if (opt_myisam_log)
2249 2250
    (void) mi_log(1);
  ft_init_stopwords();
unknown's avatar
unknown committed
2251 2252 2253 2254 2255 2256 2257 2258 2259 2260 2261 2262 2263 2264 2265

#ifdef __WIN__
  if (!opt_console)
    FreeConsole();				// Remove window
#endif

  /*
    init signals & alarm
    After this we can't quit by a simple unireg_abort
  */
  error_handler_hook = my_message_sql;
  if (pthread_key_create(&THR_THD,NULL) || pthread_key_create(&THR_NET,NULL) ||
      pthread_key_create(&THR_MALLOC,NULL))
  {
    sql_print_error("Can't create thread-keys");
2266 2267
    if (unix_sock != INVALID_SOCKET)
      unlink(mysql_unix_port);
unknown's avatar
unknown committed
2268
    unireg_abort(1);
unknown's avatar
unknown committed
2269
  }
2270
  start_signal_handler();				// Creates pidfile
unknown's avatar
unknown committed
2271
  if (acl_init((THD*) 0, opt_noacl))
unknown's avatar
unknown committed
2272
  {
unknown's avatar
unknown committed
2273
    abort_loop=1;
unknown's avatar
unknown committed
2274
    select_thread_in_use=0;
unknown's avatar
unknown committed
2275 2276 2277
#ifndef __NETWARE__
    (void) pthread_kill(signal_thread, MYSQL_KILL_SIGNAL);
#endif /* __NETWARE__ */
2278
#ifndef __WIN__
2279
    if (!opt_bootstrap)
2280
      (void) my_delete(pidfile_name,MYF(MY_WME));	// Not needed anymore
2281
#endif
2282 2283
    if (unix_sock != INVALID_SOCKET)
      unlink(mysql_unix_port);
unknown's avatar
unknown committed
2284
    unireg_abort(1);
unknown's avatar
unknown committed
2285 2286
  }
  if (!opt_noacl)
unknown's avatar
unknown committed
2287
    (void) grant_init((THD*) 0);
unknown's avatar
unknown committed
2288
  init_max_user_conn();
2289
  init_update_queries();
2290
  DBUG_ASSERT(current_thd == 0);
unknown's avatar
unknown committed
2291 2292 2293 2294 2295

#ifdef HAVE_DLOPEN
  if (!opt_noacl)
    udf_init();
#endif
2296 2297
  /* init_slave() must be called after the thread keys are created */
  init_slave();
unknown's avatar
unknown committed
2298

2299
  DBUG_ASSERT(current_thd == 0);
2300 2301 2302 2303 2304 2305 2306 2307 2308 2309 2310 2311 2312 2313 2314 2315 2316 2317 2318 2319 2320 2321
  if (opt_bin_log && !server_id)
  {
    server_id= !master_host ? 1 : 2;
    switch (server_id) {
#ifdef EXTRA_DEBUG
    case 1:
      sql_print_error("\
Warning: You have enabled the binary log, but you haven't set server-id:\n\
Updates will be logged to the binary log, but connections to slaves will\n\
not be accepted.");
      break;
#endif
    case 2:
      sql_print_error("\
Warning: You should set server-id to a non-0 value if master_host is set.\n\
The server will not act as a slave.");
      break;
    }
  }
  if (opt_bin_log)
  {
    open_log(&mysql_bin_log, glob_hostname, opt_bin_logname, "-bin",
2322
	     opt_binlog_index_name,LOG_BIN);
2323 2324 2325
    using_update_log=1;
  }

unknown's avatar
unknown committed
2326 2327 2328
  if (opt_bootstrap)
  {
    int error=bootstrap(stdin);
2329
    end_thr_alarm(1);				// Don't allow alarms
unknown's avatar
unknown committed
2330 2331 2332 2333 2334 2335
    unireg_abort(error ? 1 : 0);
  }
  if (opt_init_file)
  {
    if (read_init_file(opt_init_file))
    {
2336
      end_thr_alarm(1);				// Don't allow alarms
unknown's avatar
unknown committed
2337 2338 2339 2340
      unireg_abort(1);
    }
  }
  (void) thr_setconcurrency(concurrency);	// 10 by default
unknown's avatar
unknown committed
2341
#if defined(__WIN__) && !defined(EMBEDDED_LIBRARY)	  //IRENA
unknown's avatar
unknown committed
2342
  {
unknown's avatar
unknown committed
2343
    hEventShutdown=CreateEvent(0, FALSE, FALSE, shutdown_event_name);
unknown's avatar
unknown committed
2344 2345 2346 2347 2348 2349 2350 2351
    pthread_t hThread;
    if (pthread_create(&hThread,&connection_attrib,handle_shutdown,0))
      sql_print_error("Warning: Can't create thread to handle shutdown requests");

    // On "Stop Service" we have to do regular shutdown
    Service.SetShutdownEvent(hEventShutdown);
  }
#endif
unknown's avatar
unknown committed
2352 2353 2354 2355 2356 2357 2358 2359
#ifdef OS2
  {
    pthread_cond_init( &eventShutdown, NULL);
    pthread_t hThread;
    if (pthread_create(&hThread,&connection_attrib,handle_shutdown,0))
      sql_print_error("Warning: Can't create thread to handle shutdown requests");
  }
#endif
unknown's avatar
unknown committed
2360

unknown's avatar
unknown committed
2361
  if (
2362
#ifdef HAVE_BERKELEY_DB
unknown's avatar
unknown committed
2363
      !berkeley_skip ||
2364
#endif
unknown's avatar
unknown committed
2365
      (flush_time && flush_time != ~(ulong) 0L))
unknown's avatar
unknown committed
2366 2367
  {
    pthread_t hThread;
2368 2369
    if (pthread_create(&hThread,&connection_attrib,handle_manager,0))
      sql_print_error("Warning: Can't create thread to manage maintenance");
unknown's avatar
unknown committed
2370 2371
  }

2372 2373 2374
  printf(ER(ER_READY),my_progname,server_version,
	 ((unix_sock == INVALID_SOCKET) ? (char*) "" : mysql_unix_port),
	 mysql_port);
unknown's avatar
unknown committed
2375 2376 2377
  fflush(stdout);

#ifdef __NT__
unknown's avatar
unknown committed
2378
  if (hPipe == INVALID_HANDLE_VALUE &&
unknown's avatar
unknown committed
2379
      (!have_tcpip || opt_disable_networking))
unknown's avatar
unknown committed
2380
  {
unknown's avatar
unknown committed
2381
    sql_print_error("TCP/IP or --enable-named-pipe should be configured on NT OS");
2382
	unireg_abort(1);
unknown's avatar
unknown committed
2383 2384 2385 2386 2387 2388 2389 2390
  }
  else
  {
    pthread_mutex_lock(&LOCK_thread_count);
    (void) pthread_cond_init(&COND_handler_count,NULL);
    {
      pthread_t hThread;
      handler_count=0;
unknown's avatar
unknown committed
2391
      if (hPipe != INVALID_HANDLE_VALUE && opt_enable_named_pipe)
unknown's avatar
unknown committed
2392 2393 2394 2395 2396 2397 2398 2399 2400
      {
	handler_count++;
	if (pthread_create(&hThread,&connection_attrib,
			   handle_connections_namedpipes, 0))
	{
	  sql_print_error("Warning: Can't create thread to handle named pipes");
	  handler_count--;
	}
      }
2401
      if (have_tcpip && !opt_disable_networking)
unknown's avatar
unknown committed
2402 2403 2404 2405 2406 2407 2408 2409 2410 2411 2412 2413 2414 2415 2416 2417
      {
	handler_count++;
	if (pthread_create(&hThread,&connection_attrib,
			   handle_connections_sockets, 0))
	{
	  sql_print_error("Warning: Can't create thread to handle named pipes");
	  handler_count--;
	}
      }
      while (handler_count > 0)
	pthread_cond_wait(&COND_handler_count,&LOCK_thread_count);
    }
    pthread_mutex_unlock(&LOCK_thread_count);
  }
#else
  handle_connections_sockets(0);
unknown's avatar
unknown committed
2418
#ifdef EXTRA_DEBUG2
unknown's avatar
unknown committed
2419 2420 2421 2422 2423 2424 2425 2426 2427
  sql_print_error("Exiting main thread");
#endif
#endif /* __NT__ */

  /* (void) pthread_attr_destroy(&connection_attrib); */

  DBUG_PRINT("quit",("Exiting main thread"));

#ifndef __WIN__
unknown's avatar
unknown committed
2428
#ifdef EXTRA_DEBUG2
unknown's avatar
unknown committed
2429 2430 2431
  sql_print_error("Before Lock_thread_count");
#endif
  (void) pthread_mutex_lock(&LOCK_thread_count);
unknown's avatar
unknown committed
2432
  DBUG_PRINT("quit", ("Got thread_count mutex"));
unknown's avatar
unknown committed
2433 2434
  select_thread_in_use=0;			// For close_connections
  (void) pthread_mutex_unlock(&LOCK_thread_count);
2435
  (void) pthread_cond_broadcast(&COND_thread_count);
unknown's avatar
unknown committed
2436
#ifdef EXTRA_DEBUG2
unknown's avatar
unknown committed
2437 2438
  sql_print_error("After lock_thread_count");
#endif
unknown's avatar
merge  
unknown committed
2439
#endif /* __WIN__ */
2440

unknown's avatar
unknown committed
2441 2442 2443 2444 2445
  /* Wait until cleanup is done */
  (void) pthread_mutex_lock(&LOCK_thread_count);
  while (!ready_to_exit)
    pthread_cond_wait(&COND_thread_count,&LOCK_thread_count);
  (void) pthread_mutex_unlock(&LOCK_thread_count);
unknown's avatar
merge  
unknown committed
2446 2447

#if defined(__WIN__) && !defined(EMBEDDED_LIBRARY)
unknown's avatar
merge  
unknown committed
2448 2449 2450 2451
  if (Service.IsNT() && start_mode)
    Service.Stop();
  else
  {
unknown's avatar
unknown committed
2452
    Service.SetShutdownEvent(0);
unknown's avatar
merge  
unknown committed
2453 2454 2455
    if (hEventShutdown)
      CloseHandle(hEventShutdown);
  }
unknown's avatar
unknown committed
2456
#endif
unknown's avatar
unknown committed
2457 2458 2459 2460 2461 2462 2463 2464 2465 2466 2467 2468 2469 2470 2471 2472
#ifndef __NETWARE__
  {
    uint i;
    /*
      Wait up to 10 seconds for signal thread to die. We use this mainly to
      avoid getting warnings that my_thread_end has not been called
    */
    for (i= 0 ; i < 100 && signal_thread_in_use; i++)
    {
      if (pthread_kill(signal_thread, MYSQL_KILL_SIGNAL))
	break;
      my_sleep(100);				// Give it time to die
    }
  }
#endif
  clean_up_mutexes();
unknown's avatar
unknown committed
2473
  my_end(opt_endinfo ? MY_CHECK_ERROR | MY_GIVE_INFO : 0);
unknown's avatar
unknown committed
2474 2475 2476 2477 2478
  exit(0);
  return(0);					/* purecov: deadcode */
}


2479 2480 2481 2482 2483
/****************************************************************************
  Main and thread entry function for Win32
  (all this is needed only to run mysqld as a service on WinNT)
****************************************************************************/

unknown's avatar
unknown committed
2484
#if defined(__WIN__) && !defined(EMBEDDED_LIBRARY)
unknown's avatar
unknown committed
2485 2486
int mysql_service(void *p)
{
2487 2488 2489 2490
  if (use_opt_args)
    win_main(opt_argc, opt_argv);
  else
    win_main(Service.my_argc, Service.my_argv);
unknown's avatar
unknown committed
2491 2492 2493
  return 0;
}

2494 2495 2496 2497 2498 2499 2500 2501 2502 2503 2504 2505 2506 2507 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
/*
  Handle basic handling of services, like installation and removal

  SYNOPSIS
    default_service_handling()
    argv		Pointer to argument list 
    servicename		Internal name of service
    displayname		Display name of service (in taskbar ?)
    file_path		Path to this program

  RETURN VALUES
    0		option handled
    1		Could not handle option
 */

bool default_service_handling(char **argv,
			      const char *servicename,
			      const char *displayname,
			      const char *file_path)
{
  if (Service.got_service_option(argv, "install"))
  {
    Service.Install(1, servicename, displayname, file_path);
    return 0;
  }
  if (Service.got_service_option(argv, "install-manual"))
  {
    Service.Install(0, servicename, displayname, file_path);
    return 0;
  }
  if (Service.got_service_option(argv, "remove"))
  {
    Service.Remove(servicename);
    return 0;
  }
  return 1;
}


unknown's avatar
unknown committed
2533 2534
int main(int argc, char **argv)
{
2535 2536 2537 2538 2539 2540 2541 2542

  /* When several instances are running on the same machine, we
     need to have an  unique  named  hEventShudown  through the
     application PID e.g.: MySQLShutdown1890; MySQLShutdown2342
  */ 
  int2str((int) GetCurrentProcessId(),strmov(shutdown_event_name,
          "MySQLShutdown"), 10);
  
unknown's avatar
unknown committed
2543
  if (Service.GetOS())	/* true NT family */
unknown's avatar
unknown committed
2544
  {
unknown's avatar
unknown committed
2545
    char file_path[FN_REFLEN];
2546 2547
    my_path(file_path, argv[0], "");		      /* Find name in path */
    fn_format(file_path,argv[0],file_path,"",1+4+16); /* Force full path */
unknown's avatar
unknown committed
2548

unknown's avatar
unknown committed
2549
    if (argc == 2)
unknown's avatar
unknown committed
2550
    {	
2551 2552 2553 2554
      if (!default_service_handling(argv,MYSQL_SERVICENAME, MYSQL_SERVICENAME,
				   file_path))
	return 0;
      if (Service.IsService(argv[1]))
unknown's avatar
unknown committed
2555 2556
      {
        /* start an optional service */
2557
        load_default_groups[0]= argv[1];
unknown's avatar
unknown committed
2558
        start_mode= 1;
2559
        Service.Init(argv[1], mysql_service);
unknown's avatar
unknown committed
2560 2561 2562 2563
        return 0;
      }
    }
    else if (argc == 3) /* install or remove any optional service */
unknown's avatar
unknown committed
2564
    {
2565
      /* Add service name after filename */
unknown's avatar
unknown committed
2566
      uint length=strlen(file_path);
2567 2568
      *strxnmov(file_path + length, sizeof(file_path)-length-2, " ",
		argv[2], NullS)= '\0';
2569 2570 2571 2572

      if (!default_service_handling(argv, argv[2], argv[2], file_path))
	return 0;
      if (Service.IsService(argv[2]))
unknown's avatar
unknown committed
2573
      {
2574 2575 2576 2577
	/*
	  mysqld was started as
	  mysqld --defaults-file=my_path\my.ini service-name
	*/
2578
	use_opt_args=1;
2579
	opt_argc= 2;				// Skip service-name
2580 2581
	opt_argv=argv;
	start_mode= 1;
2582
	Service.Init(argv[2], mysql_service);
2583
	return 0;
unknown's avatar
unknown committed
2584 2585
      }
    }
2586 2587 2588 2589 2590 2591 2592
    else if (argc == 4)
    {
      /*
	Install an optional service with optional config file
	mysqld --install-manual mysqldopt --defaults-file=c:\miguel\my.ini
      */
      uint length=strlen(file_path);
2593 2594
      *strxnmov(file_path + length, sizeof(file_path)-length-2, " ",
		argv[3], " ", argv[2], NullS)= '\0';
2595 2596 2597
      if (!default_service_handling(argv, argv[2], argv[2], file_path))
	return 0;
    }
unknown's avatar
unknown committed
2598
    else if (argc == 1 && Service.IsService(MYSQL_SERVICENAME))
unknown's avatar
unknown committed
2599
    {
unknown's avatar
unknown committed
2600 2601 2602
      /* start the default service */
      start_mode= 1;
      Service.Init(MYSQL_SERVICENAME, mysql_service);
unknown's avatar
unknown committed
2603 2604 2605
      return 0;
    }
  }
unknown's avatar
unknown committed
2606
  /* Start as standalone server */
unknown's avatar
unknown committed
2607 2608 2609 2610 2611 2612 2613 2614
  Service.my_argc=argc;
  Service.my_argv=argv;
  mysql_service(NULL);
  return 0;
}
#endif


2615 2616 2617 2618 2619
/*
  Execute all commands from a file. Used by the mysql_install_db script to
  create MySQL privilege tables without having to start a full MySQL server.
*/

unknown's avatar
unknown committed
2620 2621 2622 2623
static int bootstrap(FILE *file)
{
  THD *thd= new THD;
  int error;
2624
  DBUG_ENTER("bootstrap");
unknown's avatar
unknown committed
2625

unknown's avatar
unknown committed
2626 2627
  thd->bootstrap=1;
  thd->client_capabilities=0;
unknown's avatar
unknown committed
2628
  my_net_init(&thd->net,(st_vio*) 0);
unknown's avatar
unknown committed
2629
  thd->max_client_packet_length= thd->net.max_packet;
unknown's avatar
unknown committed
2630
  thd->master_access= ~0;
2631
  thd->thread_id=thread_id++;
unknown's avatar
unknown committed
2632
  thread_count++;
2633 2634 2635 2636 2637 2638

  bootstrap_file=file;
  if (pthread_create(&thd->real_id,&connection_attrib,handle_bootstrap,
		     (void*) thd))
  {
    sql_print_error("Warning: Can't create thread to handle bootstrap");    
2639
    DBUG_RETURN(-1);
2640 2641 2642 2643 2644 2645 2646 2647 2648 2649
  }
  /* Wait for thread to die */
  (void) pthread_mutex_lock(&LOCK_thread_count);
  while (thread_count)
  {
    (void) pthread_cond_wait(&COND_thread_count,&LOCK_thread_count);
    DBUG_PRINT("quit",("One thread died (count=%u)",thread_count));
  }
  (void) pthread_mutex_unlock(&LOCK_thread_count);
  error= thd->fatal_error;
unknown's avatar
unknown committed
2650
  net_end(&thd->net);
unknown's avatar
unknown committed
2651
  thd->cleanup();
unknown's avatar
unknown committed
2652
  delete thd;
2653
  DBUG_RETURN(error);
unknown's avatar
unknown committed
2654 2655 2656 2657 2658 2659 2660 2661 2662 2663 2664 2665 2666 2667 2668 2669 2670 2671 2672 2673
}

static bool read_init_file(char *file_name)
{
  FILE *file;
  DBUG_ENTER("read_init_file");
  DBUG_PRINT("enter",("name: %s",file_name));
  if (!(file=my_fopen(file_name,O_RDONLY,MYF(MY_WME))))
    return(1);
  bootstrap(file);				/* Ignore errors from this */
  (void) my_fclose(file,MYF(MY_WME));
  return 0;
}


static void create_new_thread(THD *thd)
{
  DBUG_ENTER("create_new_thread");

  NET *net=&thd->net;				// For easy ref
unknown's avatar
unknown committed
2674
  net->read_timeout = (uint) connect_timeout;
unknown's avatar
unknown committed
2675 2676 2677 2678 2679 2680
  if (protocol_version > 9)
    net->return_errno=1;

  /* don't allow too many connections */
  if (thread_count - delayed_insert_threads >= max_connections+1 || abort_loop)
  {
unknown's avatar
unknown committed
2681
    DBUG_PRINT("error",("Too many connections"));
unknown's avatar
unknown committed
2682 2683 2684 2685
    close_connection(net,ER_CON_COUNT_ERROR);
    delete thd;
    DBUG_VOID_RETURN;
  }
2686
  pthread_mutex_lock(&LOCK_thread_count);
unknown's avatar
unknown committed
2687 2688 2689 2690
  if (thread_count-delayed_insert_threads > max_used_connections)
    max_used_connections=thread_count-delayed_insert_threads;
  thd->thread_id=thread_id++;
  for (uint i=0; i < 8 ; i++)			// Generate password teststring
2691
    thd->scramble[i]= (char) (my_rnd(&sql_rand)*94+33);
unknown's avatar
unknown committed
2692
  thd->scramble[8]=0;
2693

unknown's avatar
unknown committed
2694 2695 2696
  thd->real_id=pthread_self();			// Keep purify happy

  /* Start a new thread to handle connection */
2697
#ifdef ONE_THREAD
unknown's avatar
unknown committed
2698 2699 2700 2701 2702 2703 2704 2705 2706 2707 2708 2709 2710 2711 2712 2713 2714 2715 2716 2717
  if (test_flags & TEST_NO_THREADS)		// For debugging under Linux
  {
    thread_cache_size=0;			// Safety
    thread_count++;
    threads.append(thd);
    thd->real_id=pthread_self();
    (void) pthread_mutex_unlock(&LOCK_thread_count);
    handle_one_connection((void*) thd);
  }
  else
#endif
  {
    if (cached_thread_count > wake_thread)
    {
      start_cached_thread(thd);
    }
    else
    {
      int error;
      thread_count++;
2718
      thread_created++;
unknown's avatar
unknown committed
2719 2720 2721 2722 2723 2724 2725 2726 2727 2728 2729 2730 2731
      threads.append(thd);
      DBUG_PRINT("info",(("creating thread %d"), thd->thread_id));
      thd->connect_time = time(NULL);
      if ((error=pthread_create(&thd->real_id,&connection_attrib,
				handle_one_connection,
				(void*) thd)))
      {
	DBUG_PRINT("error",
		   ("Can't create thread to handle request (error %d)",
		    error));
	thread_count--;
	thd->killed=1;				// Safety
	(void) pthread_mutex_unlock(&LOCK_thread_count);
2732
	statistic_increment(aborted_connects,&LOCK_status);
unknown's avatar
unknown committed
2733 2734 2735 2736 2737 2738 2739 2740
	net_printf(net,ER_CANT_CREATE_THREAD,error);
	(void) pthread_mutex_lock(&LOCK_thread_count);
	close_connection(net,0,0);
	delete thd;
	(void) pthread_mutex_unlock(&LOCK_thread_count);
	DBUG_VOID_RETURN;
      }
    }
2741 2742
    (void) pthread_mutex_unlock(&LOCK_thread_count);

unknown's avatar
unknown committed
2743
  }
2744
  DBUG_PRINT("info",("Thread created"));
unknown's avatar
unknown committed
2745 2746 2747
  DBUG_VOID_RETURN;
}

unknown's avatar
unknown committed
2748 2749 2750 2751
#ifdef SIGNALS_DONT_BREAK_READ
inline void kill_broken_server()
{
  /* hack to get around signals ignored in syscalls for problem OS's */
unknown's avatar
unknown committed
2752 2753 2754 2755
  if (
#if !defined(__NETWARE__)
      unix_sock == INVALID_SOCKET ||
#endif
2756
      (!opt_disable_networking && ip_sock == INVALID_SOCKET))
unknown's avatar
unknown committed
2757 2758
  {
    select_thread_in_use = 0;
2759 2760 2761
#ifdef __NETWARE__
    kill_server(MYSQL_KILL_SIGNAL); /* never returns */
#else
unknown's avatar
unknown committed
2762
    kill_server((void*)MYSQL_KILL_SIGNAL); /* never returns */
2763
#endif /* __NETWARE__ */
unknown's avatar
unknown committed
2764 2765 2766 2767 2768 2769
  }
}
#define MAYBE_BROKEN_SYSCALL kill_broken_server();
#else
#define MAYBE_BROKEN_SYSCALL
#endif
unknown's avatar
unknown committed
2770 2771 2772

	/* Handle new connections and spawn new process to handle them */

unknown's avatar
unknown committed
2773 2774
extern "C" pthread_handler_decl(handle_connections_sockets,
				arg __attribute__((unused)))
unknown's avatar
unknown committed
2775 2776 2777 2778 2779 2780 2781 2782
{
  my_socket sock,new_sock;
  uint error_count=0;
  uint max_used_connection= (uint) (max(ip_sock,unix_sock)+1);
  fd_set readFDs,clientFDs;
  THD *thd;
  struct sockaddr_in cAddr;
  int ip_flags=0,socket_flags=0,flags;
unknown's avatar
unknown committed
2783
  st_vio *vio_tmp;
unknown's avatar
unknown committed
2784 2785 2786 2787 2788 2789 2790 2791 2792 2793 2794 2795 2796 2797 2798 2799
  DBUG_ENTER("handle_connections_sockets");

  LINT_INIT(new_sock);

  (void) my_pthread_getprio(pthread_self());		// For debugging

  FD_ZERO(&clientFDs);
  if (ip_sock != INVALID_SOCKET)
  {
    FD_SET(ip_sock,&clientFDs);
#ifdef HAVE_FCNTL
    ip_flags = fcntl(ip_sock, F_GETFL, 0);
#endif
  }
#ifdef HAVE_SYS_UN_H
  FD_SET(unix_sock,&clientFDs);
unknown's avatar
unknown committed
2800
#ifdef HAVE_FCNTL
unknown's avatar
unknown committed
2801
  socket_flags=fcntl(unix_sock, F_GETFL, 0);
unknown's avatar
unknown committed
2802
#endif
unknown's avatar
unknown committed
2803 2804 2805
#endif

  DBUG_PRINT("general",("Waiting for connections."));
unknown's avatar
unknown committed
2806
  MAYBE_BROKEN_SYSCALL;
unknown's avatar
unknown committed
2807 2808 2809
  while (!abort_loop)
  {
    readFDs=clientFDs;
2810
#ifdef HPUX10
unknown's avatar
unknown committed
2811 2812 2813 2814 2815
    if (select(max_used_connection,(int*) &readFDs,0,0,0) < 0)
      continue;
#else
    if (select((int) max_used_connection,&readFDs,0,0,0) < 0)
    {
unknown's avatar
unknown committed
2816
      if (socket_errno != SOCKET_EINTR)
unknown's avatar
unknown committed
2817 2818
      {
	if (!select_errors++ && !abort_loop)	/* purecov: inspected */
unknown's avatar
unknown committed
2819
	  sql_print_error("mysqld: Got error %d from select",socket_errno); /* purecov: inspected */
unknown's avatar
unknown committed
2820
      }
unknown's avatar
unknown committed
2821
      MAYBE_BROKEN_SYSCALL
unknown's avatar
unknown committed
2822 2823
      continue;
    }
2824
#endif	/* HPUX10 */
unknown's avatar
unknown committed
2825
    if (abort_loop)
unknown's avatar
unknown committed
2826 2827
    {
      MAYBE_BROKEN_SYSCALL;
unknown's avatar
unknown committed
2828
      break;
unknown's avatar
unknown committed
2829
    }
unknown's avatar
unknown committed
2830

2831
    /* Is this a new connection request ? */
unknown's avatar
unknown committed
2832 2833 2834 2835 2836 2837 2838 2839 2840 2841 2842 2843 2844 2845 2846 2847 2848 2849 2850 2851 2852 2853 2854 2855 2856 2857 2858 2859
#ifdef HAVE_SYS_UN_H
    if (FD_ISSET(unix_sock,&readFDs))
    {
      sock = unix_sock;
      flags= socket_flags;
    }
    else
#endif
    {
      sock = ip_sock;
      flags= ip_flags;
    }

#if !defined(NO_FCNTL_NONBLOCK)
    if (!(test_flags & TEST_BLOCKING))
    {
#if defined(O_NONBLOCK)
      fcntl(sock, F_SETFL, flags | O_NONBLOCK);
#elif defined(O_NDELAY)
      fcntl(sock, F_SETFL, flags | O_NDELAY);
#endif
    }
#endif /* NO_FCNTL_NONBLOCK */
    for (uint retry=0; retry < MAX_ACCEPT_RETRY; retry++)
    {
      size_socket length=sizeof(struct sockaddr_in);
      new_sock = accept(sock, my_reinterpret_cast(struct sockaddr *) (&cAddr),
			&length);
unknown's avatar
unknown committed
2860 2861 2862 2863 2864 2865 2866
#ifdef __NETWARE__ 
      // TODO: temporary fix, waiting for TCP/IP fix - DEFECT000303149
      if ((new_sock == INVALID_SOCKET) && (socket_errno == EINVAL))
      {
        kill_server(SIGTERM);
      }
#endif
unknown's avatar
unknown committed
2867 2868
      if (new_sock != INVALID_SOCKET ||
	  (socket_errno != SOCKET_EINTR && socket_errno != SOCKET_EAGAIN))
unknown's avatar
unknown committed
2869
	break;
unknown's avatar
unknown committed
2870
      MAYBE_BROKEN_SYSCALL;
unknown's avatar
unknown committed
2871 2872 2873 2874 2875 2876 2877 2878 2879 2880 2881 2882
#if !defined(NO_FCNTL_NONBLOCK)
      if (!(test_flags & TEST_BLOCKING))
      {
	if (retry == MAX_ACCEPT_RETRY - 1)
	  fcntl(sock, F_SETFL, flags);		// Try without O_NONBLOCK
      }
#endif
    }
#if !defined(NO_FCNTL_NONBLOCK)
    if (!(test_flags & TEST_BLOCKING))
      fcntl(sock, F_SETFL, flags);
#endif
unknown's avatar
unknown committed
2883
    if (new_sock == INVALID_SOCKET)
unknown's avatar
unknown committed
2884 2885 2886
    {
      if ((error_count++ & 255) == 0)		// This can happen often
	sql_perror("Error in accept");
unknown's avatar
unknown committed
2887
      MAYBE_BROKEN_SYSCALL;
unknown's avatar
unknown committed
2888
      if (socket_errno == SOCKET_ENFILE || socket_errno == SOCKET_EMFILE)
unknown's avatar
unknown committed
2889 2890 2891 2892 2893 2894 2895 2896 2897 2898 2899
	sleep(1);				// Give other threads some time
      continue;
    }

#ifdef HAVE_LIBWRAP
    {
      if (sock == ip_sock)
      {
	struct request_info req;
	signal(SIGCHLD, SIG_DFL);
	request_init(&req, RQ_DAEMON, libwrapName, RQ_FILE, new_sock, NULL);
2900 2901
	my_fromhost(&req);
	if (!my_hosts_access(&req))
unknown's avatar
unknown committed
2902
	{
unknown's avatar
unknown committed
2903 2904 2905 2906 2907
	  /*
	    This may be stupid but refuse() includes an exit(0)
	    which we surely don't want...
	    clean_exit() - same stupid thing ...
	  */
2908 2909
	  syslog(deny_severity, "refused connect from %s",
		 my_eval_client(&req));
unknown's avatar
unknown committed
2910

unknown's avatar
unknown committed
2911 2912 2913 2914 2915 2916
	  /*
	    C++ sucks (the gibberish in front just translates the supplied
	    sink function pointer in the req structure from a void (*sink)();
	    to a void(*sink)(int) if you omit the cast, the C++ compiler
	    will cry...
	  */
unknown's avatar
unknown committed
2917 2918 2919
	  if (req.sink)
	    ((void (*)(int))req.sink)(req.fd);

2920
	  (void) shutdown(new_sock,2);
unknown's avatar
unknown committed
2921 2922 2923 2924 2925 2926 2927 2928 2929 2930 2931 2932 2933 2934 2935 2936 2937 2938 2939 2940 2941 2942 2943 2944 2945 2946
	  (void) closesocket(new_sock);
	  continue;
	}
      }
    }
#endif /* HAVE_LIBWRAP */

    {
      size_socket dummyLen;
      struct sockaddr dummy;
      dummyLen = sizeof(struct sockaddr);
      if (getsockname(new_sock,&dummy, &dummyLen) < 0)
      {
	sql_perror("Error on new connection socket");
	(void) shutdown(new_sock,2);
	(void) closesocket(new_sock);
	continue;
      }
    }

    /*
    ** Don't allow too many connections
    */

    if (!(thd= new THD))
    {
unknown's avatar
unknown committed
2947 2948
      (void) shutdown(new_sock,2);
      VOID(closesocket(new_sock));
unknown's avatar
unknown committed
2949 2950 2951
      continue;
    }
    if (!(vio_tmp=vio_new(new_sock,
2952
			  sock == unix_sock ? VIO_TYPE_SOCKET :
unknown's avatar
unknown committed
2953
			  VIO_TYPE_TCPIP,
2954
			  sock == unix_sock)) ||
unknown's avatar
unknown committed
2955 2956 2957 2958 2959 2960 2961 2962 2963 2964 2965 2966 2967
	my_net_init(&thd->net,vio_tmp))
    {
      if (vio_tmp)
	vio_delete(vio_tmp);
      else
      {
	(void) shutdown(new_sock,2);
	(void) closesocket(new_sock);
      }
      delete thd;
      continue;
    }
    if (sock == unix_sock)
2968
      thd->host=(char*) localhost;
unknown's avatar
unknown committed
2969 2970 2971
    create_new_thread(thd);
  }

unknown's avatar
unknown committed
2972 2973 2974 2975 2976
#ifdef OS2
  // kill server must be invoked from thread 1!
  kill_server(MYSQL_KILL_SIGNAL);
#endif

unknown's avatar
unknown committed
2977 2978 2979 2980
#ifdef __NT__
  pthread_mutex_lock(&LOCK_thread_count);
  handler_count--;
  pthread_mutex_unlock(&LOCK_thread_count);
unknown's avatar
unknown committed
2981
  pthread_cond_signal(&COND_handler_count);
unknown's avatar
unknown committed
2982 2983 2984 2985 2986 2987
#endif
  DBUG_RETURN(0);
}


#ifdef __NT__
2988
extern "C" pthread_handler_decl(handle_connections_namedpipes,arg)
unknown's avatar
unknown committed
2989 2990 2991 2992 2993 2994 2995 2996 2997 2998 2999 3000 3001 3002 3003
{
  HANDLE hConnectedPipe;
  BOOL fConnected;
  THD *thd;
  my_thread_init();
  DBUG_ENTER("handle_connections_namedpipes");
  (void) my_pthread_getprio(pthread_self());		// For debugging

  DBUG_PRINT("general",("Waiting for named pipe connections."));
  while (!abort_loop)
  {
    /* wait for named pipe connection */
    fConnected = ConnectNamedPipe( hPipe, NULL );
    if (abort_loop)
      break;
unknown's avatar
unknown committed
3004
    if (!fConnected)
unknown's avatar
unknown committed
3005
      fConnected = GetLastError() == ERROR_PIPE_CONNECTED;
unknown's avatar
unknown committed
3006
    if (!fConnected)
unknown's avatar
unknown committed
3007 3008 3009 3010 3011 3012 3013 3014
    {
      CloseHandle( hPipe );
      if ((hPipe = CreateNamedPipe(szPipeName,
				   PIPE_ACCESS_DUPLEX,
				   PIPE_TYPE_BYTE |
				   PIPE_READMODE_BYTE |
				   PIPE_WAIT,
				   PIPE_UNLIMITED_INSTANCES,
3015
				   (int) global_system_variables.net_buffer_length,
unknown's avatar
unknown committed
3016
				   (int) global_system_variables.net_buffer_length,
unknown's avatar
unknown committed
3017 3018 3019 3020 3021 3022 3023 3024 3025 3026 3027 3028 3029 3030 3031 3032
				   NMPWAIT_USE_DEFAULT_WAIT,
				   &saPipeSecurity )) ==
	  INVALID_HANDLE_VALUE )
      {
	sql_perror("Can't create new named pipe!");
	break;					// Abort
      }
    }
    hConnectedPipe = hPipe;
    /* create new pipe for new connection */
    if ((hPipe = CreateNamedPipe(szPipeName,
				 PIPE_ACCESS_DUPLEX,
				 PIPE_TYPE_BYTE |
				 PIPE_READMODE_BYTE |
				 PIPE_WAIT,
				 PIPE_UNLIMITED_INSTANCES,
3033 3034
				 (int) global_system_variables.net_buffer_length,
				 (int) global_system_variables.net_buffer_length,
unknown's avatar
unknown committed
3035 3036 3037 3038 3039 3040 3041 3042 3043
				 NMPWAIT_USE_DEFAULT_WAIT,
				 &saPipeSecurity)) ==
	INVALID_HANDLE_VALUE)
    {
      sql_perror("Can't create new named pipe!");
      hPipe=hConnectedPipe;
      continue;					// We have to try again
    }

unknown's avatar
unknown committed
3044
    if (!(thd = new THD))
unknown's avatar
unknown committed
3045 3046 3047 3048 3049 3050 3051 3052 3053 3054 3055 3056 3057
    {
      DisconnectNamedPipe( hConnectedPipe );
      CloseHandle( hConnectedPipe );
      continue;
    }
    if (!(thd->net.vio = vio_new_win32pipe(hConnectedPipe)) ||
	my_net_init(&thd->net, thd->net.vio))
    {
      close_connection(&thd->net,ER_OUT_OF_RESOURCES);
      delete thd;
      continue;
    }
    /* host name is unknown */
3058
    thd->host = my_strdup(localhost,MYF(0)); /* Host is unknown */
unknown's avatar
unknown committed
3059 3060 3061 3062 3063 3064
    create_new_thread(thd);
  }

  pthread_mutex_lock(&LOCK_thread_count);
  handler_count--;
  pthread_mutex_unlock(&LOCK_thread_count);
3065
  pthread_cond_signal(&COND_handler_count);
unknown's avatar
unknown committed
3066 3067 3068 3069 3070 3071 3072 3073 3074
  DBUG_RETURN(0);
}
#endif /* __NT__ */


/******************************************************************************
** handle start options
******************************************************************************/

3075
enum options {
3076 3077 3078 3079 3080 3081 3082 3083 3084 3085 3086 3087 3088 3089
  OPT_ISAM_LOG=256,            OPT_SKIP_NEW, 
  OPT_SKIP_GRANT,              OPT_SKIP_LOCK, 
  OPT_ENABLE_LOCK,             OPT_USE_LOCKING,
  OPT_SOCKET,                  OPT_UPDATE_LOG, 
  OPT_BIN_LOG,                 OPT_SKIP_RESOLVE, 
  OPT_SKIP_NETWORKING,         OPT_BIN_LOG_INDEX,
  OPT_BIND_ADDRESS,            OPT_PID_FILE,
  OPT_SKIP_PRIOR,              OPT_BIG_TABLES,    
  OPT_STANDALONE,              OPT_ONE_THREAD,
  OPT_CONSOLE,                 OPT_LOW_PRIORITY_UPDATES,
  OPT_SKIP_HOST_CACHE,         OPT_LONG_FORMAT,   
  OPT_FLUSH,                   OPT_SAFE, 
  OPT_BOOTSTRAP,               OPT_SKIP_SHOW_DB,
  OPT_TABLE_TYPE,              OPT_INIT_FILE,   
3090 3091
  OPT_DELAY_KEY_WRITE_ALL,     OPT_SLOW_QUERY_LOG, 
  OPT_DELAY_KEY_WRITE,	       OPT_CHARSETS_DIR,
3092 3093 3094
  OPT_BDB_HOME,                OPT_BDB_LOG,  
  OPT_BDB_TMP,                 OPT_BDB_NOSYNC,
  OPT_BDB_LOCK,                OPT_BDB_SKIP, 
unknown's avatar
unknown committed
3095
  OPT_BDB_NO_RECOVER,	       OPT_BDB_SHARED,
3096 3097 3098 3099
  OPT_MASTER_HOST,             OPT_MASTER_USER,
  OPT_MASTER_PASSWORD,         OPT_MASTER_PORT,
  OPT_MASTER_INFO_FILE,        OPT_MASTER_CONNECT_RETRY,
  OPT_MASTER_RETRY_COUNT,
unknown's avatar
unknown committed
3100 3101 3102
  OPT_MASTER_SSL,              OPT_MASTER_SSL_KEY,
  OPT_MASTER_SSL_CERT,         OPT_MASTER_SSL_CAPATH,
  OPT_MASTER_SSL_CIPHER,
3103 3104 3105 3106 3107 3108 3109 3110 3111 3112 3113 3114 3115 3116 3117 3118 3119 3120 3121 3122 3123 3124 3125 3126 3127 3128 3129 3130 3131 3132 3133 3134 3135 3136 3137 3138 3139 3140 3141 3142 3143
  OPT_SQL_BIN_UPDATE_SAME,     OPT_REPLICATE_DO_DB,      
  OPT_REPLICATE_IGNORE_DB,     OPT_LOG_SLAVE_UPDATES,
  OPT_BINLOG_DO_DB,            OPT_BINLOG_IGNORE_DB,
  OPT_WANT_CORE,               OPT_CONCURRENT_INSERT,
  OPT_MEMLOCK,                 OPT_MYISAM_RECOVER,
  OPT_REPLICATE_REWRITE_DB,    OPT_SERVER_ID, 
  OPT_SKIP_SLAVE_START,        OPT_SKIP_INNOBASE,
  OPT_SAFEMALLOC_MEM_LIMIT,    OPT_REPLICATE_DO_TABLE, 
  OPT_REPLICATE_IGNORE_TABLE,  OPT_REPLICATE_WILD_DO_TABLE, 
  OPT_REPLICATE_WILD_IGNORE_TABLE, 
  OPT_DISCONNECT_SLAVE_EVENT_COUNT, 
  OPT_ABORT_SLAVE_EVENT_COUNT,
  OPT_INNODB_DATA_HOME_DIR,
  OPT_INNODB_DATA_FILE_PATH,
  OPT_INNODB_LOG_GROUP_HOME_DIR, 
  OPT_INNODB_LOG_ARCH_DIR, 
  OPT_INNODB_LOG_ARCHIVE, 
  OPT_INNODB_FLUSH_LOG_AT_TRX_COMMIT, 
  OPT_INNODB_FLUSH_METHOD, 
  OPT_INNODB_FAST_SHUTDOWN, 
  OPT_SAFE_SHOW_DB,
  OPT_INNODB_SKIP, OPT_SKIP_SAFEMALLOC,
  OPT_TEMP_POOL, OPT_TX_ISOLATION,
  OPT_SKIP_STACK_TRACE, OPT_SKIP_SYMLINKS,
  OPT_MAX_BINLOG_DUMP_EVENTS, OPT_SPORADIC_BINLOG_DUMP_FAIL,
  OPT_SAFE_USER_CREATE, OPT_SQL_MODE,
  OPT_HAVE_NAMED_PIPE,
  OPT_DO_PSTACK, OPT_REPORT_HOST,
  OPT_REPORT_USER, OPT_REPORT_PASSWORD, OPT_REPORT_PORT,
  OPT_SHOW_SLAVE_AUTH_INFO, OPT_OLD_RPL_COMPAT,
  OPT_SLAVE_LOAD_TMPDIR, OPT_NO_MIX_TYPE,
  OPT_RPL_RECOVERY_RANK,OPT_INIT_RPL_ROLE,
  OPT_RELAY_LOG, OPT_RELAY_LOG_INDEX, OPT_RELAY_LOG_INFO_FILE,
  OPT_SLAVE_SKIP_ERRORS, OPT_DES_KEY_FILE, OPT_LOCAL_INFILE,
  OPT_RECKLESS_SLAVE,
  OPT_SSL_SSL, OPT_SSL_KEY, OPT_SSL_CERT, OPT_SSL_CA,
  OPT_SSL_CAPATH, OPT_SSL_CIPHER,
  OPT_BACK_LOG, OPT_BINLOG_CACHE_SIZE,
  OPT_CONNECT_TIMEOUT, OPT_DELAYED_INSERT_TIMEOUT,
  OPT_DELAYED_INSERT_LIMIT, OPT_DELAYED_QUEUE_SIZE,
  OPT_FLUSH_TIME, OPT_FT_MIN_WORD_LEN,
3144
  OPT_FT_MAX_WORD_LEN, OPT_FT_MAX_WORD_LEN_FOR_SORT, OPT_FT_STOPWORD_FILE,
3145 3146 3147 3148 3149 3150 3151 3152
  OPT_INTERACTIVE_TIMEOUT, OPT_JOIN_BUFF_SIZE,
  OPT_KEY_BUFFER_SIZE, OPT_LONG_QUERY_TIME,
  OPT_LOWER_CASE_TABLE_NAMES, OPT_MAX_ALLOWED_PACKET,
  OPT_MAX_BINLOG_CACHE_SIZE, OPT_MAX_BINLOG_SIZE,
  OPT_MAX_CONNECTIONS, OPT_MAX_CONNECT_ERRORS,
  OPT_MAX_DELAYED_THREADS, OPT_MAX_HEP_TABLE_SIZE,
  OPT_MAX_JOIN_SIZE, OPT_MAX_SORT_LENGTH,
  OPT_MAX_TMP_TABLES, OPT_MAX_USER_CONNECTIONS,
unknown's avatar
unknown committed
3153
  OPT_MAX_WRITE_LOCK_COUNT, OPT_BULK_INSERT_BUFFER_SIZE,
3154 3155 3156 3157
  OPT_MYISAM_BLOCK_SIZE, OPT_MYISAM_MAX_EXTRA_SORT_FILE_SIZE,
  OPT_MYISAM_MAX_SORT_FILE_SIZE, OPT_MYISAM_SORT_BUFFER_SIZE,
  OPT_NET_BUFFER_LENGTH, OPT_NET_RETRY_COUNT,
  OPT_NET_READ_TIMEOUT, OPT_NET_WRITE_TIMEOUT,
unknown's avatar
unknown committed
3158
  OPT_OPEN_FILES_LIMIT, 
3159
  OPT_QUERY_CACHE_LIMIT, OPT_QUERY_CACHE_SIZE,
unknown's avatar
unknown committed
3160
  OPT_QUERY_CACHE_TYPE, OPT_RECORD_BUFFER,
3161
  OPT_RECORD_RND_BUFFER, OPT_RELAY_LOG_SPACE_LIMIT,
3162
  OPT_SLAVE_NET_TIMEOUT, OPT_SLAVE_COMPRESSED_PROTOCOL, OPT_SLOW_LAUNCH_TIME,
3163
  OPT_READONLY, OPT_DEBUGGING,
3164 3165 3166
  OPT_SORT_BUFFER, OPT_TABLE_CACHE,
  OPT_THREAD_CONCURRENCY, OPT_THREAD_CACHE_SIZE,
  OPT_TMP_TABLE_SIZE, OPT_THREAD_STACK,
3167
  OPT_WAIT_TIMEOUT, OPT_MYISAM_REPAIR_THREADS,
3168 3169 3170 3171 3172 3173 3174 3175 3176 3177
  OPT_INNODB_MIRRORED_LOG_GROUPS,
  OPT_INNODB_LOG_FILES_IN_GROUP,
  OPT_INNODB_LOG_FILE_SIZE,
  OPT_INNODB_LOG_BUFFER_SIZE,
  OPT_INNODB_BUFFER_POOL_SIZE,
  OPT_INNODB_ADDITIONAL_MEM_POOL_SIZE,
  OPT_INNODB_FILE_IO_THREADS,
  OPT_INNODB_LOCK_WAIT_TIMEOUT,
  OPT_INNODB_THREAD_CONCURRENCY,
  OPT_INNODB_FORCE_RECOVERY,
3178
  OPT_INNODB_MAX_DIRTY_PAGES_PCT,
3179 3180
  OPT_BDB_CACHE_SIZE,
  OPT_BDB_LOG_BUFFER_SIZE,
unknown's avatar
unknown committed
3181
  OPT_BDB_MAX_LOCK,
3182
  OPT_ERROR_LOG_FILE
unknown's avatar
unknown committed
3183
};
3184

3185 3186 3187

#define LONG_TIMEOUT ((ulong) 3600L*24L*365L)

unknown's avatar
unknown committed
3188
struct my_option my_long_options[] =
3189 3190 3191 3192 3193 3194 3195
{
  {"ansi", 'a', "Use ANSI SQL syntax instead of MySQL syntax", 0, 0, 0,
   GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"basedir", 'b',
   "Path to installation directory. All paths are usually resolved relative to this.",
   (gptr*) &mysql_home_ptr, (gptr*) &mysql_home_ptr, 0, GET_STR, REQUIRED_ARG,
   0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
3196
#ifdef HAVE_BERKELEY_DB
3197 3198 3199 3200 3201 3202 3203 3204 3205 3206 3207 3208 3209 3210 3211 3212 3213 3214 3215 3216 3217 3218 3219 3220 3221 3222 3223 3224 3225 3226 3227
  {"bdb-home", OPT_BDB_HOME, "Berkeley home directory", (gptr*) &berkeley_home,
   (gptr*) &berkeley_home, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"bdb-lock-detect", OPT_BDB_LOCK,
   "Berkeley lock detect (DEFAULT, OLDEST, RANDOM or YOUNGEST, # sec)",
   0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"bdb-logdir", OPT_BDB_LOG, "Berkeley DB log file directory",
   (gptr*) &berkeley_logdir, (gptr*) &berkeley_logdir, 0, GET_STR,
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"bdb-no-recover", OPT_BDB_NO_RECOVER,
   "Don't try to recover Berkeley DB tables on start", 0, 0, 0, GET_NO_ARG,
   NO_ARG, 0, 0, 0, 0, 0, 0},
  {"bdb-no-sync", OPT_BDB_NOSYNC, "Don't synchronously flush logs", 0, 0, 0,
   GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"bdb-shared-data", OPT_BDB_SHARED,
   "Start Berkeley DB in multi-process mode", 0, 0, 0, GET_NO_ARG, NO_ARG, 0,
   0, 0, 0, 0, 0},
  {"bdb-tmpdir", OPT_BDB_TMP, "Berkeley DB tempfile name",
   (gptr*) &berkeley_tmpdir, (gptr*) &berkeley_tmpdir, 0, GET_STR,
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
#endif /* HAVE_BERKELEY_DB */
  {"skip-bdb", OPT_BDB_SKIP, "Don't use berkeley db (will save memory)",
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"big-tables", OPT_BIG_TABLES, 
   "Allow big result sets by saving all temporary sets on file (Solves most 'table full' errors)",
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"binlog-do-db", OPT_BINLOG_DO_DB,
   "Tells the master it should log updates for the specified database, and exclude all others not explicitly mentioned.",
   0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"binlog-ignore-db", OPT_BINLOG_IGNORE_DB, 
   "Tells the master that updates to the given database should not be logged tothe binary log",
   0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3228 3229 3230
  {"bind-address", OPT_BIND_ADDRESS, "IP address to bind to",
   (gptr*) &my_bind_addr_str, (gptr*) &my_bind_addr_str, 0, GET_STR,
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3231 3232
  {"bootstrap", OPT_BOOTSTRAP, "Used by mysql installation scripts", 0, 0, 0,
   GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
3233
  {"console", OPT_CONSOLE, "Write error output on screen; Don't remove the console window on windows",
3234 3235
   (gptr*) &opt_console, (gptr*) &opt_console, 0, GET_BOOL, NO_ARG, 0, 0, 0,
   0, 0, 0},
3236
#ifdef __WIN__
3237 3238 3239 3240 3241 3242 3243 3244 3245 3246 3247 3248 3249 3250 3251 3252 3253 3254 3255 3256 3257 3258 3259 3260 3261 3262 3263 3264 3265 3266
  {"standalone", OPT_STANDALONE,
  "Dummy option to start as a standalone program (NT)", 0, 0, 0, GET_NO_ARG,
   NO_ARG, 0, 0, 0, 0, 0, 0},
#endif
  {"core-file", OPT_WANT_CORE, "Write core on errors", 0, 0, 0, GET_NO_ARG,
   NO_ARG, 0, 0, 0, 0, 0, 0},
  {"chroot", 'r', "Chroot mysqld daemon during startup.",
   (gptr*) &mysqld_chroot, (gptr*) &mysqld_chroot, 0, GET_STR, REQUIRED_ARG,
   0, 0, 0, 0, 0, 0},
  {"character-sets-dir", OPT_CHARSETS_DIR,
   "Directory where character sets are", (gptr*) &charsets_dir,
   (gptr*) &charsets_dir, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"datadir", 'h', "Path to the database root", (gptr*) &mysql_data_home,
   (gptr*) &mysql_data_home, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
#ifndef DBUG_OFF
  {"debug", '#', "Debug log.", (gptr*) &default_dbug_option,
   (gptr*) &default_dbug_option, 0, GET_STR, OPT_ARG, 0, 0, 0, 0, 0, 0},
#ifdef SAFEMALLOC
  {"skip-safemalloc", OPT_SKIP_SAFEMALLOC,
   "Don't use the memory allocation checking", 0, 0, 0, GET_NO_ARG, NO_ARG,
   0, 0, 0, 0, 0, 0},
#endif
#endif
#ifdef HAVE_OPENSSL
  {"des-key-file", OPT_DES_KEY_FILE, 
   "Load keys for des_encrypt() and des_encrypt from given file",
   (gptr*) &des_key_file, (gptr*) &des_key_file, 0, GET_STR, REQUIRED_ARG,
   0, 0, 0, 0, 0, 0},
#endif /* HAVE_OPENSSL */
  {"default-character-set", 'C', "Set the default character set",
unknown's avatar
unknown committed
3267 3268
   (gptr*) &sys_charset.value, (gptr*) &sys_charset.value, 0, GET_STR,
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0 },
3269
  {"default-table-type", OPT_TABLE_TYPE,
unknown's avatar
unknown committed
3270
   "Set the default table type for tables", 0, 0,
3271
   0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3272 3273 3274
  {"delay-key-write", OPT_DELAY_KEY_WRITE, "Type of DELAY_KEY_WRITE",
   0,0,0, GET_STR, OPT_ARG, 0, 0, 0, 0, 0, 0},
  {"delay-key-write-for-all-tables", OPT_DELAY_KEY_WRITE_ALL,
3275
   "Don't flush key buffers between writes for any MyISAM table (Deprecated option, use --delay-key-write=all instead)",
3276
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
3277
  {"enable-locking", OPT_ENABLE_LOCK,
3278
   "Deprecated option, use --external-locking instead",
3279 3280
   (gptr*) &opt_external_locking, (gptr*) &opt_external_locking,
   0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
3281 3282 3283 3284 3285 3286 3287 3288 3289 3290 3291 3292 3293 3294
#ifdef __NT__
  {"enable-named-pipe", OPT_HAVE_NAMED_PIPE, "Enable the named pipe (NT)",
   (gptr*) &opt_enable_named_pipe, (gptr*) &opt_enable_named_pipe, 0, GET_BOOL,
   NO_ARG, 0, 0, 0, 0, 0, 0},
#endif
  {"enable-pstack", OPT_DO_PSTACK, "Print a symbolic stack trace on failure",
   (gptr*) &opt_do_pstack, (gptr*) &opt_do_pstack, 0, GET_BOOL, NO_ARG, 0, 0,
   0, 0, 0, 0},
  {"exit-info", 'T', "Used for debugging;  Use at your own risk!", 0, 0, 0,
   GET_LONG, OPT_ARG, 0, 0, 0, 0, 0, 0},
  {"flush", OPT_FLUSH, "Flush tables to disk between SQL commands", 0, 0, 0,
   GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
  /* We must always support the next option to make scripts like mysqltest
     easier to do */
3295 3296 3297 3298
  {"gdb", OPT_DEBUGGING,
   "Set up signals usable for debugging",
   (gptr*) &opt_debugging, (gptr*) &opt_debugging,
   0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
3299 3300 3301 3302 3303
  {"init-rpl-role", OPT_INIT_RPL_ROLE, "Set the replication role", 0, 0, 0,
   GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"innodb_data_file_path", OPT_INNODB_DATA_FILE_PATH,
   "Path to individual files and their sizes",
   0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
3304
#ifdef HAVE_INNOBASE_DB
3305 3306 3307 3308 3309 3310 3311 3312 3313 3314 3315 3316 3317 3318 3319
  {"innodb_data_home_dir", OPT_INNODB_DATA_HOME_DIR,
   "The common part for Innodb table spaces", (gptr*) &innobase_data_home_dir,
   (gptr*) &innobase_data_home_dir, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0,
   0},
  {"innodb_log_group_home_dir", OPT_INNODB_LOG_GROUP_HOME_DIR,
   "Path to innodb log files.", (gptr*) &innobase_log_group_home_dir, 
   (gptr*) &innobase_log_group_home_dir, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0,
   0, 0},
  {"innodb_log_arch_dir", OPT_INNODB_LOG_ARCH_DIR,
   "Where full logs should be archived", (gptr*) &innobase_log_arch_dir,
   (gptr*) &innobase_log_arch_dir, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"innodb_log_archive", OPT_INNODB_LOG_ARCHIVE,
   "Set to 1 if you want to have logs archived", 0, 0, 0, GET_LONG, OPT_ARG,
   0, 0, 0, 0, 0, 0},
  {"innodb_flush_log_at_trx_commit", OPT_INNODB_FLUSH_LOG_AT_TRX_COMMIT,
unknown's avatar
unknown committed
3320
   "Set to 0 (write and flush once per second), 1 (write and flush at each commit) or 2 (write at commit, flush once per second)",
3321 3322
   (gptr*) &innobase_flush_log_at_trx_commit,
   (gptr*) &innobase_flush_log_at_trx_commit,
unknown's avatar
unknown committed
3323
   0, GET_UINT, OPT_ARG,  1, 0, 2, 0, 0, 0},
3324 3325 3326 3327 3328 3329
  {"innodb_flush_method", OPT_INNODB_FLUSH_METHOD,
   "With which method to flush data", (gptr*) &innobase_unix_file_flush_method,
   (gptr*) &innobase_unix_file_flush_method, 0, GET_STR, REQUIRED_ARG, 0, 0, 0,
   0, 0, 0},
  {"innodb_fast_shutdown", OPT_INNODB_FAST_SHUTDOWN,
   "Speeds up server shutdown process", (gptr*) &innobase_fast_shutdown,
3330
   (gptr*) &innobase_fast_shutdown, 0, GET_BOOL, NO_ARG, 1, 0, 0, 0, 0, 0},
3331 3332 3333 3334
  {"innodb_max_dirty_pages_pct", OPT_INNODB_MAX_DIRTY_PAGES_PCT,
   "Percentage of dirty pages allowed in bufferpool", (gptr*) &srv_max_buf_pool_modified_pct,
   (gptr*) &srv_max_buf_pool_modified_pct, 0, GET_ULONG, REQUIRED_ARG, 90, 0, 100, 0, 0, 0},
   
3335 3336 3337 3338 3339 3340 3341 3342 3343 3344 3345 3346 3347 3348
#endif /* End HAVE_INNOBASE_DB */
  {"help", '?', "Display this help and exit", 0, 0, 0, GET_NO_ARG, NO_ARG, 0,
   0, 0, 0, 0, 0},
  {"init-file", OPT_INIT_FILE, "Read SQL commands from this file at startup",
   (gptr*) &opt_init_file, (gptr*) &opt_init_file, 0, GET_STR, REQUIRED_ARG,
   0, 0, 0, 0, 0, 0},
  {"log", 'l', "Log connections and queries to file", (gptr*) &opt_logname,
   (gptr*) &opt_logname, 0, GET_STR, OPT_ARG, 0, 0, 0, 0, 0, 0},
  {"language", 'L',
   "Client error messages in given language. May be given as a full path",
   (gptr*) &language_ptr, (gptr*) &language_ptr, 0, GET_STR, REQUIRED_ARG,
   0, 0, 0, 0, 0, 0},
  {"local-infile", OPT_LOCAL_INFILE,
   "Enable/disable LOAD DATA LOCAL INFILE (takes values 1|0)",
unknown's avatar
unknown committed
3349 3350
   (gptr*) &opt_local_infile,
   (gptr*) &opt_local_infile, 0, GET_BOOL, OPT_ARG,
3351
   1, 0, 0, 0, 0, 0},
3352
  {"log-bin", OPT_BIN_LOG,
3353
   "Log update queries in binary format",
3354
   (gptr*) &opt_bin_logname, (gptr*) &opt_bin_logname, 0, GET_STR_ALLOC,
unknown's avatar
unknown committed
3355
   OPT_ARG, 0, 0, 0, 0, 0, 0},
3356 3357 3358 3359 3360 3361 3362 3363 3364 3365 3366 3367 3368 3369 3370 3371 3372 3373
  {"log-bin-index", OPT_BIN_LOG_INDEX,
   "File that holds the names for last binary log files",
   (gptr*) &opt_binlog_index_name, (gptr*) &opt_binlog_index_name, 0, GET_STR,
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"log-isam", OPT_ISAM_LOG, "Log all MyISAM changes to file",
   (gptr*) &myisam_log_filename, (gptr*) &myisam_log_filename, 0, GET_STR,
   OPT_ARG, 0, 0, 0, 0, 0, 0},
  {"log-update", OPT_UPDATE_LOG,
   "Log updates to file.# where # is a unique number if not given.",
   (gptr*) &opt_update_logname, (gptr*) &opt_update_logname, 0, GET_STR,
   OPT_ARG, 0, 0, 0, 0, 0, 0},
  {"log-slow-queries", OPT_SLOW_QUERY_LOG,
   "Log slow queries to this log file. Defaults logging to hostname-slow.log",
   (gptr*) &opt_slow_logname, (gptr*) &opt_slow_logname, 0, GET_STR, OPT_ARG,
   0, 0, 0, 0, 0, 0},
  {"log-long-format", OPT_LONG_FORMAT,
   "Log some extra information to update log", 0, 0, 0, GET_NO_ARG, NO_ARG,
   0, 0, 0, 0, 0, 0},
3374
  {"log-slave-updates", OPT_LOG_SLAVE_UPDATES,
unknown's avatar
unknown committed
3375
   "Tells the slave to log the updates from the slave thread to the binary log. You will need to turn it on if you plan to daisy-chain the slaves.",
3376 3377 3378
   (gptr*) &opt_log_slave_updates, (gptr*) &opt_log_slave_updates, 0, GET_BOOL,
   NO_ARG, 0, 0, 0, 0, 0, 0},
  {"low-priority-updates", OPT_LOW_PRIORITY_UPDATES,
unknown's avatar
unknown committed
3379 3380 3381 3382
   "INSERT/DELETE/UPDATE has lower priority than selects",
   (gptr*) &global_system_variables.low_priority_updates,
   (gptr*) &max_system_variables.low_priority_updates,
   0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
3383
  {"master-host", OPT_MASTER_HOST,
3384 3385 3386 3387 3388 3389 3390 3391 3392 3393 3394 3395 3396 3397 3398 3399 3400 3401 3402 3403 3404
   "Master hostname or IP address for replication. If not set, the slave thread will not be started. Note that the setting of master-host will be ignored if there exists a valid master.info file.",
   (gptr*) &master_host, (gptr*) &master_host, 0, GET_STR, REQUIRED_ARG, 0, 0,
   0, 0, 0, 0},
  {"master-user", OPT_MASTER_USER,
   "The username the slave thread will use for authentication when connecting to the master. The user must have FILE privilege. If the master user is not set, user test is assumed. The value in master.info will take precedence if it can be read.",
   (gptr*) &master_user, (gptr*) &master_user, 0, GET_STR, REQUIRED_ARG, 0, 0,
   0, 0, 0, 0},
  {"master-password", OPT_MASTER_PASSWORD,
   "The password the slave thread will authenticate with when connecting to the master. If not set, an empty password is assumed.The value in master.info will take precedence if it can be read.",
   0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"master-port", OPT_MASTER_PORT,
   "The port the master is listening on. If not set, the compiled setting of MYSQL_PORT is assumed. If you have not tinkered with configure options, this should be 3306. The value in master.info will take precedence if it can be read",
   (gptr*) &master_port, (gptr*) &master_port, 0, GET_UINT, REQUIRED_ARG,
   MYSQL_PORT, 0, 0, 0, 0, 0},
  {"master-connect-retry", OPT_MASTER_CONNECT_RETRY,
   "The number of seconds the slave thread will sleep before retrying to connect to the master in case the master goes down or the connection is lost.",
   (gptr*) &master_connect_retry, (gptr*) &master_connect_retry, 0, GET_UINT,
   REQUIRED_ARG, 60, 0, 0, 0, 0, 0},
  {"master-retry-count", OPT_MASTER_RETRY_COUNT,
   "The number of tries the slave will make to connect to the master before giving up.",
   (gptr*) &master_retry_count, (gptr*) &master_retry_count, 0, GET_ULONG,
3405
   REQUIRED_ARG, 3600*24, 0, 0, 0, 0, 0},
3406
  {"master-info-file", OPT_MASTER_INFO_FILE,
3407 3408
   "The location and name of the file that remembers the master and where the I/O replication \
thread is in the master's binlogs.",
3409 3410 3411
   (gptr*) &master_info_file, (gptr*) &master_info_file, 0, GET_STR,
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"master-ssl", OPT_MASTER_SSL,
3412
   "Planned to enable the slave to connect to the master using SSL. Does nothing yet.",
3413 3414 3415
   (gptr*) &master_ssl, (gptr*) &master_ssl, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0,
   0, 0},
  {"master-ssl-key", OPT_MASTER_SSL_KEY,
3416 3417
   "Master SSL keyfile name. Only applies if you have enabled master-ssl. Does \
nothing yet.",
3418 3419 3420
   (gptr*) &master_ssl_key, (gptr*) &master_ssl_key, 0, GET_STR, OPT_ARG,
   0, 0, 0, 0, 0, 0},
  {"master-ssl-cert", OPT_MASTER_SSL_CERT,
3421 3422
   "Master SSL certificate file name. Only applies if you have enabled \
master-ssl. Does nothing yet.",
3423 3424
   (gptr*) &master_ssl_cert, (gptr*) &master_ssl_cert, 0, GET_STR, OPT_ARG,
   0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
3425
  {"master-ssl-capath", OPT_MASTER_SSL_CAPATH,
3426 3427
   "Master SSL CA path. Only applies if you have enabled master-ssl. \
Does nothing yet.",
unknown's avatar
unknown committed
3428 3429 3430
   (gptr*) &master_ssl_capath, (gptr*) &master_ssl_capath, 0, GET_STR, OPT_ARG,
   0, 0, 0, 0, 0, 0},
  {"master-ssl-cipher", OPT_MASTER_SSL_CIPHER,
3431 3432
   "Master SSL cipher. Only applies if you have enabled master-ssl. \
Does nothing yet.",
unknown's avatar
unknown committed
3433
   (gptr*) &master_ssl_cipher, (gptr*) &master_ssl_capath, 0, GET_STR, OPT_ARG,
3434 3435 3436 3437 3438 3439 3440 3441
   0, 0, 0, 0, 0, 0},
  {"myisam-recover", OPT_MYISAM_RECOVER,
   "Syntax: myisam-recover[=option[,option...]], where option can be DEFAULT, BACKUP or FORCE.",
   (gptr*) &myisam_recover_options_str, (gptr*) &myisam_recover_options_str, 0,
   GET_STR, OPT_ARG, 0, 0, 0, 0, 0, 0},
  {"memlock", OPT_MEMLOCK, "Lock mysqld in memory", (gptr*) &locked_in_memory,
   (gptr*) &locked_in_memory, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"disconnect-slave-event-count", OPT_DISCONNECT_SLAVE_EVENT_COUNT,
3442
   "Option used by mysql-test for debugging and testing of replication",
3443 3444 3445 3446
   (gptr*) &disconnect_slave_event_count,
   (gptr*) &disconnect_slave_event_count, 0, GET_INT, REQUIRED_ARG, 0, 0, 0,
   0, 0, 0},
  {"abort-slave-event-count", OPT_ABORT_SLAVE_EVENT_COUNT,
3447
   "Option used by mysql-test for debugging and testing of replication",
3448 3449
   (gptr*) &abort_slave_event_count,  (gptr*) &abort_slave_event_count,
   0, GET_INT, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3450 3451
  {"max-binlog-dump-events", OPT_MAX_BINLOG_DUMP_EVENTS,
   "Option used by mysql-test for debugging and testing of replication",
3452 3453
   (gptr*) &max_binlog_dump_events, (gptr*) &max_binlog_dump_events, 0,
   GET_INT, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3454 3455
  {"sporadic-binlog-dump-fail", OPT_SPORADIC_BINLOG_DUMP_FAIL,
   "Option used by mysql-test for debugging and testing of replication",
3456 3457 3458 3459 3460 3461
   (gptr*) &opt_sporadic_binlog_dump_fail,
   (gptr*) &opt_sporadic_binlog_dump_fail, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0,
   0},
  {"safemalloc-mem-limit", OPT_SAFEMALLOC_MEM_LIMIT,
   "Simulate memory shortage when compiled with the --with-debug=full option",
   0, 0, 0, GET_ULL, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
3462
  {"new", 'n', "Use some 4.1 features and syntax (4.1 compatibility mode)",
3463 3464 3465
   (gptr*) &global_system_variables.new_mode,
   (gptr*) &max_system_variables.new_mode,
   0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
3466
#ifdef NOT_YET
unknown's avatar
unknown committed
3467
  {"no-mix-table-types", OPT_NO_MIX_TYPE, "Don't allow commands with uses two different table types",
3468 3469 3470
   (gptr*) &opt_no_mix_types, (gptr*) &opt_no_mix_types, 0, GET_BOOL, NO_ARG,
   0, 0, 0, 0, 0, 0},
#endif
3471
  {"old-protocol", 'o', "Use the old (3.20) protocol client/server protocol",
3472 3473
   (gptr*) &protocol_version, (gptr*) &protocol_version, 0, GET_UINT, NO_ARG,
   PROTOCOL_VERSION, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
3474 3475
  {"old-rpl-compat", OPT_OLD_RPL_COMPAT,
   "Use old LOAD DATA format in the binary log (don't save data in file)",
3476 3477
   (gptr*) &opt_old_rpl_compat, (gptr*) &opt_old_rpl_compat, 0, GET_BOOL,
   NO_ARG, 0, 0, 0, 0, 0, 0},
3478
#ifdef ONE_THREAD
3479 3480 3481 3482 3483 3484 3485
  {"one-thread", OPT_ONE_THREAD,
   "Only use one thread (for debugging under Linux)", 0, 0, 0, GET_NO_ARG,
   NO_ARG, 0, 0, 0, 0, 0, 0},
#endif
  {"pid-file", OPT_PID_FILE, "Pid file used by safe_mysqld",
   (gptr*) &pidfile_name_ptr, (gptr*) &pidfile_name_ptr, 0, GET_STR,
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
3486 3487
  {"log-error", OPT_ERROR_LOG_FILE, "Log error file",
   (gptr*) &log_error_file_ptr, (gptr*) &log_error_file_ptr, 0, GET_STR,
3488
   OPT_ARG, 0, 0, 0, 0, 0, 0},
3489 3490 3491 3492 3493 3494 3495 3496 3497 3498 3499 3500 3501 3502 3503 3504 3505 3506 3507 3508 3509 3510 3511
  {"port", 'P', "Port number to use for connection.", (gptr*) &mysql_port,
   (gptr*) &mysql_port, 0, GET_UINT, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"replicate-do-db", OPT_REPLICATE_DO_DB,
   "Tells the slave thread to restrict replication to the specified database. To specify more than one database, use the directive multiple times, once for each database. Note that this will only work if you do not use cross-database queries such as UPDATE some_db.some_table SET foo='bar' while having selected a different or no database. If you need cross database updates to work, make sure you have 3.23.28 or later, and use replicate-wild-do-table=db_name.%.",
   0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"replicate-do-table", OPT_REPLICATE_DO_TABLE,
   "Tells the slave thread to restrict replication to the specified table. To specify more than one table, use the directive multiple times, once for each table. This will work for cross-database updates, in contrast to replicate-do-db.",
   0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"replicate-wild-do-table", OPT_REPLICATE_WILD_DO_TABLE,
   "Tells the slave thread to restrict replication to the tables that match the specified wildcard pattern. To specify more than one table, use the directive multiple times, once for each table. This will work for cross-database updates. Example: replicate-wild-do-table=foo%.bar% will replicate only updates to tables in all databases that start with foo and whose table names start with bar",
   0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"replicate-ignore-db", OPT_REPLICATE_IGNORE_DB,
   "Tells the slave thread to not replicate to the specified database. To specify more than one database to ignore, use the directive multiple times, once for each database. This option will not work if you use cross database updates. If you need cross database updates to work, make sure you have 3.23.28 or later, and use replicate-wild-ignore-table=db_name.%. ",
   0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"replicate-ignore-table", OPT_REPLICATE_IGNORE_TABLE,
   "Tells the slave thread to not replicate to the specified table. To specify more than one table to ignore, use the directive multiple times, once for each table. This will work for cross-datbase updates, in contrast to replicate-ignore-db.",
   0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"replicate-wild-ignore-table", OPT_REPLICATE_WILD_IGNORE_TABLE,
   "Tells the slave thread to not replicate to the tables that match the given wildcard pattern. To specify more than one table to ignore, use the directive multiple times, once for each table. This will work for cross-database updates. Example: replicate-wild-ignore-table=foo%.bar% will not do updates to tables in databases that start with foo and whose table names start with bar.",
   0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"replicate-rewrite-db", OPT_REPLICATE_REWRITE_DB,
   "Updates to a database with a different name than the original. Example: replicate-rewrite-db=master_db_name->slave_db_name",
   0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3512
  // In replication, we may need to tell the other servers how to connect
3513 3514 3515 3516 3517 3518 3519 3520 3521 3522 3523 3524 3525 3526
  {"report-host", OPT_REPORT_HOST,
   "Hostname or IP of the slave to be reported to to the master during slave registration. Will appear in the output of SHOW SLAVE HOSTS. Leave unset if you do not want the slave to register itself with the master. Note that it is not sufficient for the master to simply read the IP of the slave off the socket once the slave connects. Due to NAT and other routing issues, that IP may not be valid for connecting to the slave from the master or other hosts.",
   (gptr*) &report_host, (gptr*) &report_host, 0, GET_STR, REQUIRED_ARG, 0, 0,
   0, 0, 0, 0},
  {"report-user", OPT_REPORT_USER, "Undocumented", (gptr*) &report_user,
   (gptr*) &report_user, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"report-password", OPT_REPORT_PASSWORD, "Undocumented",
   (gptr*) &report_password, (gptr*) &report_password, 0, GET_STR,
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"report-port", OPT_REPORT_PORT,
   "Port for connecting to slave reported to the master during slave registration. Set it only if the slave is listening on a non-default port or if you have a special tunnel from the master or other clients to the slave. If not sure, leave this option unset.",
   (gptr*) &report_port, (gptr*) &report_port, 0, GET_UINT, REQUIRED_ARG,
   MYSQL_PORT, 0, 0, 0, 0, 0},
  {"rpl-recovery-rank", OPT_RPL_RECOVERY_RANK, "Undocumented",
3527
   (gptr*) &rpl_recovery_rank, (gptr*) &rpl_recovery_rank, 0, GET_ULONG,
3528
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3529 3530
  {"relay-log", OPT_RELAY_LOG, 
   "The location and name to use for relay logs",
3531
   (gptr*) &opt_relay_logname, (gptr*) &opt_relay_logname, 0,
3532
   GET_STR_ALLOC, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3533 3534 3535
  {"relay-log-index", OPT_RELAY_LOG_INDEX, 
   "The location and name to use for the file that keeps a list of the last \
relay logs",
3536 3537 3538 3539
   (gptr*) &opt_relaylog_index_name, (gptr*) &opt_relaylog_index_name, 0,
   GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"safe-mode", OPT_SAFE, "Skip some optimize stages (for testing).",
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
3540
#ifndef TO_BE_DELETED
3541
  {"safe-show-database", OPT_SAFE_SHOW_DB,
3542
   "Deprecated option; One should use GRANT SHOW DATABASES instead...",
3543
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
3544
#endif
3545 3546 3547 3548 3549 3550
  {"safe-user-create", OPT_SAFE_USER_CREATE,
   "Don't allow new user creation by the user who has no write privileges to the mysql.user table",
   (gptr*) &opt_safe_user_create, (gptr*) &opt_safe_user_create, 0, GET_BOOL,
   NO_ARG, 0, 0, 0, 0, 0, 0},
  {"server-id",	OPT_SERVER_ID,
   "Uniquely identifies the server instance in the community of replication partners",
unknown's avatar
unknown committed
3551
   (gptr*) &server_id, (gptr*) &server_id, 0, GET_ULONG, REQUIRED_ARG, 0, 0, 0,
3552 3553 3554 3555
   0, 0, 0},
  {"set-variable", 'O',
   "Change the value of a variable. Please note that this option is deprecated;you can set variables directly with --variable-name=value.",
   0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
3556 3557
  {"show-slave-auth-info", OPT_SHOW_SLAVE_AUTH_INFO,
   "Show user and password in SHOW SLAVE STATUS",
3558 3559 3560 3561 3562
   (gptr*) &opt_show_slave_auth_info, (gptr*) &opt_show_slave_auth_info, 0,
   GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"concurrent-insert", OPT_CONCURRENT_INSERT,
   "Use concurrent insert with MyISAM. Disable with prefix --skip-",
   (gptr*) &myisam_concurrent_insert, (gptr*) &myisam_concurrent_insert,
unknown's avatar
unknown committed
3563
   0, GET_BOOL, NO_ARG, 1, 0, 0, 0, 0, 0},
3564 3565 3566 3567 3568 3569 3570
  {"skip-grant-tables", OPT_SKIP_GRANT,
   "Start without grant tables. This gives all users FULL ACCESS to all tables!",
   (gptr*) &opt_noacl, (gptr*) &opt_noacl, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0,
   0},
  {"skip-innodb", OPT_INNODB_SKIP, "Don't use Innodb (will save memory)",
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"skip-locking", OPT_SKIP_LOCK,
3571
   "Deprecated option, use --skip-external-locking instead",
3572 3573 3574 3575 3576 3577 3578 3579 3580 3581 3582 3583 3584 3585 3586 3587 3588 3589 3590 3591
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"skip-host-cache", OPT_SKIP_HOST_CACHE, "Don't cache host names", 0, 0, 0,
   GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"skip-name-resolve", OPT_SKIP_RESOLVE,
   "Don't resolve hostnames. All hostnames are IP's or 'localhost'",
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"skip-networking", OPT_SKIP_NETWORKING,
   "Don't allow connection with TCP/IP.", 0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0,
   0, 0, 0},
  {"skip-new", OPT_SKIP_NEW, "Don't use new, possible wrong routines.",
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"skip-show-database", OPT_SKIP_SHOW_DB,
   "Don't allow 'SHOW DATABASE' commands", 0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0,
   0, 0, 0, 0},
  {"skip-slave-start", OPT_SKIP_SLAVE_START,
   "If set, slave is not autostarted.", (gptr*) &opt_skip_slave_start,
   (gptr*) &opt_skip_slave_start, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"skip-stack-trace", OPT_SKIP_STACK_TRACE,
   "Don't print a stack trace on failure", 0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0,
   0, 0, 0, 0},
unknown's avatar
unknown committed
3592
  {"skip-symlink", OPT_SKIP_SYMLINKS, "Don't allow symlinking of tables. Depricated option.  Use --skip-symbolic-links instead",
3593 3594 3595 3596
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"skip-thread-priority", OPT_SKIP_PRIOR,
   "Don't give threads different priorities.", 0, 0, 0, GET_NO_ARG, NO_ARG, 0,
   0, 0, 0, 0, 0},
3597 3598 3599
  {"relay-log-info-file", OPT_RELAY_LOG_INFO_FILE, 
   "The location and name of the file that remembers where the SQL replication \
thread is in the relay logs",
3600 3601
   (gptr*) &relay_log_info_file, (gptr*) &relay_log_info_file, 0, GET_STR,
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3602 3603 3604
  {"slave-load-tmpdir", OPT_SLAVE_LOAD_TMPDIR, 
   "The location where the slave should put its temporary files when \
replicating a LOAD DATA INFILE command",
3605
   (gptr*) &slave_load_tmpdir, (gptr*) &slave_load_tmpdir, 0, GET_STR_ALLOC,
3606 3607
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"slave-skip-errors", OPT_SLAVE_SKIP_ERRORS,
3608
   "Tells the slave thread to continue replication when a query returns an error from the provided list",
3609 3610 3611 3612 3613 3614 3615 3616 3617 3618 3619 3620
   0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"socket", OPT_SOCKET, "Socket file to use for connection",
   (gptr*) &mysql_unix_port, (gptr*) &mysql_unix_port, 0, GET_STR,
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"sql-bin-update-same", OPT_SQL_BIN_UPDATE_SAME,
   "If set, setting SQL_LOG_BIN to a value will automatically set SQL_LOG_UPDATE to the same value and vice versa.",
   (gptr*) &opt_sql_bin_update, (gptr*) &opt_sql_bin_update, 0, GET_BOOL,
   NO_ARG, 0, 0, 0, 0, 0, 0},
  {"sql-mode", OPT_SQL_MODE,
   "Syntax: sql-mode=option[,option[,option...]] where option can be one of: REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, SERIALIZE, ONLY_FULL_GROUP_BY, NO_UNSIGNED_SUBTRACTION.",
   (gptr*) &sql_mode_str, (gptr*) &sql_mode_str, 0, GET_STR, REQUIRED_ARG, 0,
   0, 0, 0, 0, 0},
3621
#ifdef HAVE_OPENSSL
3622 3623 3624
#include "sslopt-longopts.h"
#endif
  {"temp-pool", OPT_TEMP_POOL, 
3625
   "Using this option will cause most temporary files created to use a small set of names, rather than a unique name for each new file.",
unknown's avatar
unknown committed
3626 3627
   (gptr*) &use_temp_pool, (gptr*) &use_temp_pool, 0, GET_BOOL, NO_ARG, 1,
   0, 0, 0, 0, 0},
unknown's avatar
unknown committed
3628 3629
  {"tmpdir", 't', "Path for temporary files", (gptr*) &opt_mysql_tmpdir,
   (gptr*) &opt_mysql_tmpdir, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3630
  {"transaction-isolation", OPT_TX_ISOLATION,
3631 3632
   "Default transaction isolation level", 0, 0, 0, GET_STR, REQUIRED_ARG, 0,
   0, 0, 0, 0, 0},
3633 3634 3635
  {"external-locking", OPT_USE_LOCKING, "Use system (external) locking.  With this option enabled you can run myisamchk to test (not repair) tables while the MySQL server is running",
   (gptr*) &opt_external_locking, (gptr*) &opt_external_locking,
   0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
3636 3637 3638 3639
  {"use-symbolic-links", 's', "Enable symbolic link support. Depricated option; Use --symbolic-links instead",
   (gptr*) &my_use_symdir, (gptr*) &my_use_symdir, 0, GET_BOOL, NO_ARG,
   IF_PURIFY(0,1), 0, 0, 0, 0, 0},
  {"--symbolic-links", 's', "Enable symbolic link support",
3640
   (gptr*) &my_use_symdir, (gptr*) &my_use_symdir, 0, GET_BOOL, NO_ARG,
unknown's avatar
unknown committed
3641
   IF_PURIFY(0,1), 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
3642 3643
  {"user", 'u', "Run mysqld daemon as user", 0, 0, 0, GET_STR, REQUIRED_ARG,
   0, 0, 0, 0, 0, 0},
3644 3645 3646 3647
  {"version", 'V', "Output version information and exit", 0, 0, 0, GET_NO_ARG,
   NO_ARG, 0, 0, 0, 0, 0, 0},
  {"version", 'v', "Synonym for option -v", 0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0,
   0, 0, 0, 0},
unknown's avatar
unknown committed
3648 3649 3650 3651 3652 3653 3654
  {"log-warnings", 'W', "Log some not critical warnings to the log file",
   (gptr*) &global_system_variables.log_warnings,
   (gptr*) &max_system_variables.log_warnings, 0, GET_BOOL, NO_ARG, 0, 0, 0,
   0, 0, 0},
  {"warnings", 'W', "Deprecated ; Use --log-warnings instead",
   (gptr*) &global_system_variables.log_warnings,
   (gptr*) &max_system_variables.log_warnings, 0, GET_BOOL, NO_ARG, 0, 0, 0,
3655 3656
   0, 0, 0},
  { "back_log", OPT_BACK_LOG,
3657 3658
    "The number of outstanding connection requests MySQL can have. This comes into play when the main MySQL thread gets very many connection requests in a very short time.",
    (gptr*) &back_log, (gptr*) &back_log, 0, GET_ULONG,
3659
    REQUIRED_ARG, 50, 1, 65535, 0, 1, 0 },
unknown's avatar
unknown committed
3660
#ifdef HAVE_BERKELEY_DB
3661
  { "bdb_cache_size", OPT_BDB_CACHE_SIZE,
3662
    "The buffer that is allocated to cache index and rows for BDB tables.",
3663 3664 3665 3666 3667 3668 3669 3670 3671 3672 3673 3674 3675 3676 3677 3678 3679 3680 3681 3682 3683
    (gptr*) &berkeley_cache_size, (gptr*) &berkeley_cache_size, 0, GET_ULONG,
    REQUIRED_ARG, KEY_CACHE_SIZE, 20*1024, (long) ~0, 0, IO_SIZE, 0},
  {"bdb_log_buffer_size", OPT_BDB_LOG_BUFFER_SIZE,
   "The buffer that is allocated to cache index and rows for BDB tables.",
   (gptr*) &berkeley_log_buffer_size, (gptr*) &berkeley_log_buffer_size, 0,
   GET_ULONG, REQUIRED_ARG, 0, 256*1024L, ~0L, 0, 1024, 0},
  {"bdb_max_lock", OPT_BDB_MAX_LOCK,
   "The maximum number of locks you can have active on a BDB table.",
   (gptr*) &berkeley_max_lock, (gptr*) &berkeley_max_lock, 0, GET_ULONG,
   REQUIRED_ARG, 10000, 0, (long) ~0, 0, 1, 0},
  /* QQ: The following should be removed soon! */
  {"bdb_lock_max", OPT_BDB_MAX_LOCK, "Synonym for bdb_max_lock",
   (gptr*) &berkeley_max_lock, (gptr*) &berkeley_max_lock, 0, GET_ULONG,
   REQUIRED_ARG, 10000, 0, (long) ~0, 0, 1, 0},
#endif /* HAVE_BERKELEY_DB */
  {"binlog_cache_size", OPT_BINLOG_CACHE_SIZE,
   "The size of the cache to hold the SQL statements for the binary log during a transaction. If you often use big, multi-statement transactions you can increase this to get more performance.",
   (gptr*) &binlog_cache_size, (gptr*) &binlog_cache_size, 0, GET_ULONG,
   REQUIRED_ARG, 32*1024L, IO_SIZE, ~0L, 0, IO_SIZE, 0},
  {"connect_timeout", OPT_CONNECT_TIMEOUT, 
   "The number of seconds the mysqld server is waiting for a connect packet before responding with Bad handshake",
unknown's avatar
unknown committed
3684 3685
    (gptr*) &connect_timeout, (gptr*) &connect_timeout,
   0, GET_ULONG, REQUIRED_ARG, CONNECT_TIMEOUT, 2, LONG_TIMEOUT, 0, 1, 0 },
3686
  {"delayed_insert_timeout", OPT_DELAYED_INSERT_TIMEOUT,
3687
   "How long a INSERT DELAYED thread should wait for INSERT statements before terminating.",
3688 3689 3690 3691 3692 3693 3694 3695 3696 3697 3698 3699 3700 3701 3702 3703 3704
   (gptr*) &delayed_insert_timeout, (gptr*) &delayed_insert_timeout, 0,
   GET_ULONG, REQUIRED_ARG, DELAYED_WAIT_TIMEOUT, 1, LONG_TIMEOUT, 0, 1, 0},
  {"delayed_insert_limit", OPT_DELAYED_INSERT_LIMIT,
   "After inserting delayed_insert_limit rows, the INSERT DELAYED handler will check if there are any SELECT statements pending. If so, it allows these to execute before continuing.",
    (gptr*) &delayed_insert_limit, (gptr*) &delayed_insert_limit, 0, GET_ULONG,
    REQUIRED_ARG, DELAYED_LIMIT, 1, ~0L, 0, 1, 0},
  { "delayed_queue_size", OPT_DELAYED_QUEUE_SIZE,
    "What size queue (in rows) should be allocated for handling INSERT DELAYED. If the queue becomes full, any client that does INSERT DELAYED will wait until there is room in the queue again.",
    (gptr*) &delayed_queue_size, (gptr*) &delayed_queue_size, 0, GET_ULONG,
    REQUIRED_ARG, DELAYED_QUEUE_SIZE, 1, ~0L, 0, 1, 0},
  { "flush_time", OPT_FLUSH_TIME,
    "A dedicated thread is created to flush all tables at the given interval.",
    (gptr*) &flush_time, (gptr*) &flush_time, 0, GET_ULONG, REQUIRED_ARG,
    FLUSH_TIME, 0, LONG_TIMEOUT, 0, 1, 0},
  { "ft_min_word_len", OPT_FT_MIN_WORD_LEN,
    "The minimum length of the word to be included in a FULLTEXT index. Note: FULLTEXT indexes must be rebuilt after changing this variable.",
    (gptr*) &ft_min_word_len, (gptr*) &ft_min_word_len, 0, GET_ULONG,
3705
    REQUIRED_ARG, 4, 1, HA_FT_MAXLEN, 0, 1, 0},
3706 3707 3708 3709 3710
  { "ft_max_word_len", OPT_FT_MAX_WORD_LEN,
    "The maximum length of the word to be included in a FULLTEXT index. Note: FULLTEXT indexes must be rebuilt after changing this variable.",
    (gptr*) &ft_max_word_len, (gptr*) &ft_max_word_len, 0, GET_ULONG,
    REQUIRED_ARG, HA_FT_MAXLEN, 10, HA_FT_MAXLEN, 0, 1, 0},
  { "ft_max_word_len_for_sort", OPT_FT_MAX_WORD_LEN_FOR_SORT,
3711 3712 3713 3714 3715 3716 3717
    "The maximum length of the word for repair_by_sorting. Longer words are included the slow way. The lower this value, the more words will be put in one sort bucket.",
    (gptr*) &ft_max_word_len_for_sort, (gptr*) &ft_max_word_len_for_sort, 0, GET_ULONG,
    REQUIRED_ARG, 20, 4, HA_FT_MAXLEN, 0, 1, 0},
  { "ft_stopword_file", OPT_FT_STOPWORD_FILE,
    "Use stopwords from this file instead of built-in list.",
    (gptr*) &ft_stopword_file, (gptr*) &ft_stopword_file, 0, GET_STR,
    REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
3718
#ifdef HAVE_INNOBASE_DB
3719 3720 3721 3722 3723 3724 3725 3726 3727 3728 3729 3730 3731 3732 3733 3734 3735 3736 3737 3738 3739 3740 3741 3742 3743 3744 3745 3746 3747 3748 3749 3750 3751 3752 3753 3754 3755 3756 3757 3758 3759 3760 3761 3762 3763
  {"innodb_mirrored_log_groups", OPT_INNODB_MIRRORED_LOG_GROUPS,
   "Number of identical copies of log groups we keep for the database. Currently this should be set to 1.", 
   (gptr*) &innobase_mirrored_log_groups,
   (gptr*) &innobase_mirrored_log_groups, 0, GET_LONG, REQUIRED_ARG, 1, 1, 10,
   0, 1, 0},
  {"innodb_log_files_in_group", OPT_INNODB_LOG_FILES_IN_GROUP,
   "Number of log files in the log group. InnoDB writes to the files in a circular fashion. Value 3 is recommended here.",
   (gptr*) &innobase_log_files_in_group, (gptr*) &innobase_log_files_in_group,
   0, GET_LONG, REQUIRED_ARG, 2, 2, 100, 0, 1, 0},
  {"innodb_log_file_size", OPT_INNODB_LOG_FILE_SIZE,
   "Size of each log file in a log group in megabytes.",
   (gptr*) &innobase_log_file_size, (gptr*) &innobase_log_file_size, 0,
   GET_LONG, REQUIRED_ARG, 5*1024*1024L, 1*1024*1024L, ~0L, 0, 1024*1024L, 0},
  {"innodb_log_buffer_size", OPT_INNODB_LOG_BUFFER_SIZE,
   "The size of the buffer which InnoDB uses to write log to the log files on disk.",
   (gptr*) &innobase_log_buffer_size, (gptr*) &innobase_log_buffer_size, 0,
   GET_LONG, REQUIRED_ARG, 1024*1024L, 256*1024L, ~0L, 0, 1024, 0},
  {"innodb_buffer_pool_size", OPT_INNODB_BUFFER_POOL_SIZE,
   "The size of the memory buffer InnoDB uses to cache data and indexes of its tables.",
   (gptr*) &innobase_buffer_pool_size, (gptr*) &innobase_buffer_pool_size, 0,
   GET_LONG, REQUIRED_ARG, 8*1024*1024L, 1024*1024L, ~0L, 0, 1024*1024L, 0},
  {"innodb_additional_mem_pool_size", OPT_INNODB_ADDITIONAL_MEM_POOL_SIZE,
   "Size of a memory pool InnoDB uses to store data dictionary information and other internal data structures.",
   (gptr*) &innobase_additional_mem_pool_size,
   (gptr*) &innobase_additional_mem_pool_size, 0, GET_LONG, REQUIRED_ARG,
   1*1024*1024L, 512*1024L, ~0L, 0, 1024, 0},
  {"innodb_file_io_threads", OPT_INNODB_FILE_IO_THREADS,
   "Number of file I/O threads in InnoDB.", (gptr*) &innobase_file_io_threads,
   (gptr*) &innobase_file_io_threads, 0, GET_LONG, REQUIRED_ARG, 4, 4, 64, 0,
   1, 0},
  {"innodb_lock_wait_timeout", OPT_INNODB_LOCK_WAIT_TIMEOUT,
   "Timeout in seconds an InnoDB transaction may wait for a lock before being rolled back.",
   (gptr*) &innobase_lock_wait_timeout, (gptr*) &innobase_lock_wait_timeout,
   0, GET_LONG, REQUIRED_ARG, 50, 1, 1024 * 1024 * 1024, 0, 1, 0},
  {"innodb_thread_concurrency", OPT_INNODB_THREAD_CONCURRENCY,
   "Helps in performance tuning in heavily concurrent environments.",
   (gptr*) &innobase_thread_concurrency, (gptr*) &innobase_thread_concurrency,
   0, GET_LONG, REQUIRED_ARG, 8, 1, 1000, 0, 1, 0},
  {"innodb_force_recovery", OPT_INNODB_FORCE_RECOVERY,
   "Helps to save your data in case the disk image of the database becomes corrupt.",
   (gptr*) &innobase_force_recovery, (gptr*) &innobase_force_recovery, 0,
   GET_LONG, REQUIRED_ARG, 0, 0, 6, 0, 1, 0},
#endif /* HAVE_INNOBASE_DB */
  {"interactive_timeout", OPT_INTERACTIVE_TIMEOUT,
   "The number of seconds the server waits for activity on an interactive connection before closing it.",
3764 3765
   (gptr*) &global_system_variables.net_interactive_timeout,
   (gptr*) &max_system_variables.net_interactive_timeout, 0,
3766 3767 3768
   GET_ULONG, REQUIRED_ARG, NET_WAIT_TIMEOUT, 1, LONG_TIMEOUT, 0, 1, 0},
  {"join_buffer_size", OPT_JOIN_BUFF_SIZE,
   "The size of the buffer that is used for full joins.",
3769 3770
   (gptr*) &global_system_variables.join_buff_size,
   (gptr*) &max_system_variables.join_buff_size, 0, GET_ULONG,
3771 3772 3773 3774
   REQUIRED_ARG, 128*1024L, IO_SIZE*2+MALLOC_OVERHEAD, ~0L, MALLOC_OVERHEAD,
   IO_SIZE, 0},
  {"key_buffer_size", OPT_KEY_BUFFER_SIZE,
   "The size of the buffer used for index blocks. Increase this to get better index handling (for all reads and multiple writes) to as much as you can afford; 64M on a 256M machine that mainly runs MySQL is quite common.",
3775 3776 3777
   (gptr*) &keybuff_size, (gptr*) &keybuff_size, 0, GET_ULL,
   REQUIRED_ARG, KEY_CACHE_SIZE, MALLOC_OVERHEAD, (long) ~0, MALLOC_OVERHEAD,
   IO_SIZE, 0},
3778 3779
  {"long_query_time", OPT_LONG_QUERY_TIME,
   "Log all queries that have taken more than long_query_time seconds to execute to file.",
3780 3781
   (gptr*) &global_system_variables.long_query_time,
   (gptr*) &max_system_variables.long_query_time, 0, GET_ULONG,
3782 3783 3784
   REQUIRED_ARG, 10, 1, LONG_TIMEOUT, 0, 1, 0},
  {"lower_case_table_names", OPT_LOWER_CASE_TABLE_NAMES,
   "If set to 1 table names are stored in lowercase on disk and table names will be case-insensitive.",
3785
   (gptr*) &lower_case_table_names,
3786
   (gptr*) &lower_case_table_names, 0, GET_BOOL, NO_ARG,
3787 3788 3789 3790 3791
#ifdef FN_NO_CASE_SENCE
    1
#else
    0
#endif
3792
   , 0, 1, 0, 1, 0},
3793 3794
  {"max_allowed_packet", OPT_MAX_ALLOWED_PACKET,
   "Max packetlength to send/receive from to server.",
unknown's avatar
unknown committed
3795 3796
   (gptr*) &global_system_variables.max_allowed_packet,
   (gptr*) &max_system_variables.max_allowed_packet, 0, GET_ULONG,
3797
   REQUIRED_ARG, 1024*1024L, 80, 1024L*1024L*1024L, MALLOC_OVERHEAD, 1024, 0},
3798 3799 3800 3801 3802 3803 3804 3805 3806 3807 3808 3809 3810 3811 3812 3813 3814
  {"max_binlog_cache_size", OPT_MAX_BINLOG_CACHE_SIZE,
   "Can be used to restrict the total size used to cache a multi-transaction query.",
   (gptr*) &max_binlog_cache_size, (gptr*) &max_binlog_cache_size, 0,
   GET_ULONG, REQUIRED_ARG, ~0L, IO_SIZE, ~0L, 0, IO_SIZE, 0},
  {"max_binlog_size", OPT_MAX_BINLOG_SIZE,
   "Binary log will be rotated automatically when the size crosses the limit.",
   (gptr*) &max_binlog_size, (gptr*) &max_binlog_size, 0, GET_ULONG,
   REQUIRED_ARG, 1024*1024L*1024L, 1024, 1024*1024L*1024L, 0, 1, 0},
  {"max_connections", OPT_MAX_CONNECTIONS,
   "The number of simultaneous clients allowed.", (gptr*) &max_connections,
   (gptr*) &max_connections, 0, GET_ULONG, REQUIRED_ARG, 100, 1, 16384, 0, 1,
   0},
  {"max_connect_errors", OPT_MAX_CONNECT_ERRORS,
   "If there is more than this number of interrupted connections from a host this host will be blocked from further connections.",
   (gptr*) &max_connect_errors, (gptr*) &max_connect_errors, 0, GET_ULONG,
    REQUIRED_ARG, MAX_CONNECT_ERRORS, 1, ~0L, 0, 1, 0},
  {"max_delayed_threads", OPT_MAX_DELAYED_THREADS,
3815
   "Don't start more than this number of threads to handle INSERT DELAYED statements. If set to zero, which means INSERT DELAYED is not used.",
3816
   (gptr*) &max_insert_delayed_threads, (gptr*) &max_insert_delayed_threads,
3817
   0, GET_ULONG, REQUIRED_ARG, 20, 0, 16384, 0, 1, 0},
3818 3819
  {"max_heap_table_size", OPT_MAX_HEP_TABLE_SIZE,
   "Don't allow creation of heap tables bigger than this.",
3820 3821
   (gptr*) &global_system_variables.max_heap_table_size,
   (gptr*) &max_system_variables.max_heap_table_size, 0, GET_ULONG,
3822 3823 3824
   REQUIRED_ARG, 16*1024*1024L, 16384, ~0L, MALLOC_OVERHEAD, 1024, 0},
  {"max_join_size", OPT_MAX_JOIN_SIZE,
   "Joins that are probably going to read more than max_join_size records return an error.",
3825
   (gptr*) &global_system_variables.max_join_size,
3826
   (gptr*) &max_system_variables.max_join_size, 0, GET_HA_ROWS, REQUIRED_ARG,
3827 3828 3829
   ~0L, 1, ~0L, 0, 1, 0},
  {"max_sort_length", OPT_MAX_SORT_LENGTH,
   "The number of bytes to use when sorting BLOB or TEXT values (only the first max_sort_length bytes of each value are used; the rest are ignored).",
unknown's avatar
unknown committed
3830 3831
   (gptr*) &global_system_variables.max_sort_length,
   (gptr*) &max_system_variables.max_sort_length, 0, GET_ULONG,
3832 3833 3834
   REQUIRED_ARG, 1024, 4, 8192*1024L, 0, 1, 0},
  {"max_tmp_tables", OPT_MAX_TMP_TABLES,
   "Maximum number of temporary tables a client can keep open at a time.",
3835 3836
   (gptr*) &global_system_variables.max_tmp_tables,
   (gptr*) &max_system_variables.max_tmp_tables, 0, GET_ULONG,
3837 3838 3839 3840 3841 3842 3843 3844 3845
   REQUIRED_ARG, 32, 1, ~0L, 0, 1, 0},
  {"max_user_connections", OPT_MAX_USER_CONNECTIONS,
   "The maximum number of active connections for a single user (0 = no limit).",
   (gptr*) &max_user_connections, (gptr*) &max_user_connections, 0, GET_ULONG,
   REQUIRED_ARG, 0, 1, ~0L, 0, 1, 0},
  {"max_write_lock_count", OPT_MAX_WRITE_LOCK_COUNT,
   "After this many write locks, allow some read locks to run in between.",
   (gptr*) &max_write_lock_count, (gptr*) &max_write_lock_count, 0, GET_ULONG,
   REQUIRED_ARG, ~0L, 1, ~0L, 0, 1, 0},
unknown's avatar
unknown committed
3846
  {"bulk_insert_buffer_size", OPT_BULK_INSERT_BUFFER_SIZE,
3847
   "Size of tree cache used in bulk insert optimisation. Note that this is a limit per thread!",
unknown's avatar
unknown committed
3848 3849
   (gptr*) &global_system_variables.bulk_insert_buff_size,
   (gptr*) &max_system_variables.bulk_insert_buff_size,
3850
   0, GET_ULONG, REQUIRED_ARG, 8192*1024, 0, ~0L, 0, 1, 0},
3851
  {"myisam_block_size", OPT_MYISAM_BLOCK_SIZE,
unknown's avatar
unknown committed
3852 3853
   "Block size to be used for MyISAM index pages",
   (gptr*) &opt_myisam_block_size,
3854 3855 3856 3857
   (gptr*) &opt_myisam_block_size, 0, GET_ULONG, REQUIRED_ARG,
   MI_KEY_BLOCK_LENGTH, MI_MIN_KEY_BLOCK_LENGTH, MI_MAX_KEY_BLOCK_LENGTH,
   0, MI_MIN_KEY_BLOCK_LENGTH, 0},
  {"myisam_max_extra_sort_file_size", OPT_MYISAM_MAX_EXTRA_SORT_FILE_SIZE,
unknown's avatar
unknown committed
3858
   "Used to help MySQL to decide when to use the slow but safe key cache index create method",
3859 3860
   (gptr*) &global_system_variables.myisam_max_extra_sort_file_size,
   (gptr*) &max_system_variables.myisam_max_extra_sort_file_size,
unknown's avatar
unknown committed
3861
   0, GET_ULL, REQUIRED_ARG, (ulonglong) MI_MAX_TEMP_LENGTH,
3862
   0, (ulonglong) MAX_FILE_SIZE, 0, 1, 0},
3863
  {"myisam_max_sort_file_size", OPT_MYISAM_MAX_SORT_FILE_SIZE,
unknown's avatar
unknown committed
3864
   "Don't use the fast sort index method to created index if the temporary file would get bigger than this!",
3865 3866
   (gptr*) &global_system_variables.myisam_max_sort_file_size,
   (gptr*) &max_system_variables.myisam_max_sort_file_size, 0,
3867 3868
   GET_ULL, REQUIRED_ARG, (longlong) LONG_MAX, 0, (ulonglong) MAX_FILE_SIZE,
   0, 1024*1024, 0},
3869 3870 3871 3872 3873
  {"myisam_repair_threads", OPT_MYISAM_REPAIR_THREADS,
   "Number of threads to use when repairing MyISAM tables. The value of 1 disables parallel repair.",
   (gptr*) &global_system_variables.myisam_repair_threads,
   (gptr*) &max_system_variables.myisam_repair_threads, 0,
   GET_ULONG, REQUIRED_ARG, 1, 1, ~0L, 0, 1, 0},
3874 3875
  {"myisam_sort_buffer_size", OPT_MYISAM_SORT_BUFFER_SIZE,
   "The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE.",
unknown's avatar
unknown committed
3876 3877
   (gptr*) &global_system_variables.myisam_sort_buff_size,
   (gptr*) &max_system_variables.myisam_sort_buff_size, 0,
3878 3879
   GET_ULONG, REQUIRED_ARG, 8192*1024, 4, ~0L, 0, 1, 0},
  {"net_buffer_length", OPT_NET_BUFFER_LENGTH,
3880
   "Buffer length for TCP/IP and socket communication.",
unknown's avatar
unknown committed
3881 3882 3883
   (gptr*) &global_system_variables.net_buffer_length,
   (gptr*) &max_system_variables.net_buffer_length, 0, GET_ULONG,
   REQUIRED_ARG, 16384, 1024, 1024*1024L, 0, 1024, 0},
3884 3885
  {"net_retry_count", OPT_NET_RETRY_COUNT,
   "If a read on a communication port is interrupted, retry this many times before giving up.",
3886 3887
   (gptr*) &global_system_variables.net_retry_count,
   (gptr*) &max_system_variables.net_retry_count,0,
3888 3889 3890
   GET_ULONG, REQUIRED_ARG, MYSQLD_NET_RETRY_COUNT, 1, ~0L, 0, 1, 0},
  {"net_read_timeout", OPT_NET_READ_TIMEOUT,
   "Number of seconds to wait for more data from a connection before aborting the read.",
unknown's avatar
unknown committed
3891 3892
   (gptr*) &global_system_variables.net_read_timeout,
   (gptr*) &max_system_variables.net_read_timeout, 0, GET_ULONG,
3893 3894 3895
   REQUIRED_ARG, NET_READ_TIMEOUT, 1, LONG_TIMEOUT, 0, 1, 0},
  {"net_write_timeout", OPT_NET_WRITE_TIMEOUT,
   "Number of seconds to wait for a block to be written to a connection  before aborting the write.",
unknown's avatar
unknown committed
3896 3897
   (gptr*) &global_system_variables.net_write_timeout,
   (gptr*) &max_system_variables.net_write_timeout, 0, GET_ULONG,
3898 3899 3900 3901 3902
   REQUIRED_ARG, NET_WRITE_TIMEOUT, 1, LONG_TIMEOUT, 0, 1, 0},
  {"open_files_limit", OPT_OPEN_FILES_LIMIT,
   "If this is not 0, then mysqld will use this value to reserve file descriptors to use with setrlimit(). If this value is 0 then mysqld will reserve max_connections*5 or max_connections + table_cache*2 (whichever is larger) number of files.",
   (gptr*) &open_files_limit, (gptr*) &open_files_limit, 0, GET_ULONG,
   REQUIRED_ARG, 0, 0, 65535, 0, 1, 0},
unknown's avatar
unknown committed
3903
#ifdef HAVE_QUERY_CACHE
3904 3905 3906
  {"query_cache_limit", OPT_QUERY_CACHE_LIMIT,
   "Don't cache results that are bigger than this.",
   (gptr*) &query_cache_limit, (gptr*) &query_cache_limit, 0, GET_ULONG,
3907
   REQUIRED_ARG, 1024*1024L, 0, (longlong) ULONG_MAX, 0, 1, 0},
3908
#endif /*HAVE_QUERY_CACHE*/
3909 3910 3911
  {"query_cache_size", OPT_QUERY_CACHE_SIZE,
   "The memory allocated to store results from old queries.",
   (gptr*) &query_cache_size, (gptr*) &query_cache_size, 0, GET_ULONG,
unknown's avatar
unknown committed
3912
   REQUIRED_ARG, 0, 0, (longlong) ULONG_MAX, 0, 1024, 0},
3913
#ifdef HAVE_QUERY_CACHE
unknown's avatar
unknown committed
3914
  {"query_cache_type", OPT_QUERY_CACHE_TYPE,
3915
   "0 = OFF = Don't cache or retrieve results. 1 = ON = Cache all results except SELECT SQL_NO_CACHE ... queries. 2 = DEMAND = Cache only SELECT SQL_CACHE ... queries.",
unknown's avatar
unknown committed
3916 3917 3918
   (gptr*) &global_system_variables.query_cache_type,
   (gptr*) &max_system_variables.query_cache_type,
   0, GET_ULONG, REQUIRED_ARG, 1, 0, 2, 0, 1, 0},
unknown's avatar
unknown committed
3919
#endif /*HAVE_QUERY_CACHE*/
unknown's avatar
unknown committed
3920
  {"read_buffer_size", OPT_RECORD_BUFFER,
3921
   "Each thread that does a sequential scan allocates a buffer of this size for each table it scans. If you do many sequential scans, you may want to increase this value.",
unknown's avatar
unknown committed
3922 3923
   (gptr*) &global_system_variables.read_buff_size,
   (gptr*) &max_system_variables.read_buff_size,0, GET_ULONG, REQUIRED_ARG,
3924
   128*1024L, IO_SIZE*2+MALLOC_OVERHEAD, ~0L, MALLOC_OVERHEAD, IO_SIZE, 0},
unknown's avatar
unknown committed
3925
  {"read_rnd_buffer_size", OPT_RECORD_RND_BUFFER,
3926
   "When reading rows in sorted order after a sort, the rows are read through this buffer to avoid a disk seeks. If not set, then it's set to the value of record_buffer.",
unknown's avatar
unknown committed
3927 3928 3929
   (gptr*) &global_system_variables.read_rnd_buff_size,
   (gptr*) &max_system_variables.read_rnd_buff_size, 0,
   GET_ULONG, REQUIRED_ARG, 256*1024L, IO_SIZE*2+MALLOC_OVERHEAD,
3930
   ~0L, MALLOC_OVERHEAD, IO_SIZE, 0},
unknown's avatar
unknown committed
3931 3932 3933 3934 3935
  {"record_buffer", OPT_RECORD_BUFFER,
   "Alias for read_buffer_size",
   (gptr*) &global_system_variables.read_buff_size,
   (gptr*) &max_system_variables.read_buff_size,0, GET_ULONG, REQUIRED_ARG,
   128*1024L, IO_SIZE*2+MALLOC_OVERHEAD, ~0L, MALLOC_OVERHEAD, IO_SIZE, 0},
3936
  {"relay_log_space_limit", OPT_RELAY_LOG_SPACE_LIMIT,
3937
   "Maximum space to use for all relay logs",
3938 3939
   (gptr*) &relay_log_space_limit,
   (gptr*) &relay_log_space_limit, 0, GET_ULL, REQUIRED_ARG, 0L, 0L,
3940
   (longlong) ULONG_MAX, 0, 1, 0},
3941 3942 3943 3944 3945
  {"slave_compressed_protocol", OPT_SLAVE_COMPRESSED_PROTOCOL,
   "Use compression on master/slave protocol",
   (gptr*) &opt_slave_compressed_protocol,
   (gptr*) &opt_slave_compressed_protocol,
   0, GET_BOOL, REQUIRED_ARG, 0, 0, 1, 0, 1, 0},
3946
  {"slave_net_timeout", OPT_SLAVE_NET_TIMEOUT,
unknown's avatar
unknown committed
3947 3948
   "Number of seconds to wait for more data from a master/slave connection before aborting the read.",
   (gptr*) &slave_net_timeout, (gptr*) &slave_net_timeout, 0,
3949
   GET_ULONG, REQUIRED_ARG, SLAVE_NET_TIMEOUT, 1, LONG_TIMEOUT, 0, 1, 0},
3950 3951 3952 3953 3954
  {"read-only", OPT_READONLY,
   "Make all tables readonly, with the expections for replications (slave) threads and users with the SUPER privilege",
   (gptr*) &opt_readonly,
   (gptr*) &opt_readonly,
   0, GET_BOOL, NO_ARG, 0, 0, 1, 0, 1, 0},
3955 3956 3957 3958
  {"slow_launch_time", OPT_SLOW_LAUNCH_TIME,
   "If creating the thread takes longer than this value (in seconds), the Slow_launch_threads counter will be incremented.",
   (gptr*) &slow_launch_time, (gptr*) &slow_launch_time, 0, GET_ULONG,
   REQUIRED_ARG, 2L, 0L, LONG_TIMEOUT, 0, 1, 0},
unknown's avatar
unknown committed
3959
  {"sort_buffer_size", OPT_SORT_BUFFER,
3960
   "Each thread that needs to do a sort allocates a buffer of this size.",
3961 3962
   (gptr*) &global_system_variables.sortbuff_size,
   (gptr*) &max_system_variables.sortbuff_size, 0, GET_ULONG, REQUIRED_ARG,
3963 3964 3965 3966 3967 3968 3969 3970 3971 3972 3973 3974 3975 3976 3977 3978
   MAX_SORT_MEMORY, MIN_SORT_MEMORY+MALLOC_OVERHEAD*2, ~0L, MALLOC_OVERHEAD,
   1, 0},
  {"table_cache", OPT_TABLE_CACHE,
   "The number of open tables for all threads.", (gptr*) &table_cache_size,
   (gptr*) &table_cache_size, 0, GET_ULONG, REQUIRED_ARG, 64, 1, 16384, 0, 1,
   0},
  {"thread_concurrency", OPT_THREAD_CONCURRENCY,
   "Permits the application to give the threads system a hint for the desired number of threads that should be run at the same time.",
   (gptr*) &concurrency, (gptr*) &concurrency, 0, GET_ULONG, REQUIRED_ARG,
   DEFAULT_CONCURRENCY, 1, 512, 0, 1, 0},
  {"thread_cache_size", OPT_THREAD_CACHE_SIZE,
   "How many threads we should keep in a cache for reuse.",
   (gptr*) &thread_cache_size, (gptr*) &thread_cache_size, 0, GET_ULONG,
   REQUIRED_ARG, 0, 0, 16384, 0, 1, 0},
  {"tmp_table_size", OPT_TMP_TABLE_SIZE,
   "If an in-memory temporary table exceeds this size, MySQL will automatically convert it to an on-disk MyISAM table.",
3979 3980
   (gptr*) &global_system_variables.tmp_table_size,
   (gptr*) &max_system_variables.tmp_table_size, 0, GET_ULONG,
3981 3982 3983 3984 3985 3986 3987
   REQUIRED_ARG, 32*1024*1024L, 1024, ~0L, 0, 1, 0},
  {"thread_stack", OPT_THREAD_STACK,
   "The stack size for each thread.", (gptr*) &thread_stack,
   (gptr*) &thread_stack, 0, GET_ULONG, REQUIRED_ARG,DEFAULT_THREAD_STACK,
   1024*32, ~0L, 0, 1024, 0},
  {"wait_timeout", OPT_WAIT_TIMEOUT,
   "The number of seconds the server waits for activity on a connection before closing it",
3988 3989
   (gptr*) &global_system_variables.net_wait_timeout,
   (gptr*) &max_system_variables.net_wait_timeout, 0, GET_ULONG,
3990 3991
   REQUIRED_ARG, NET_WAIT_TIMEOUT, 1, LONG_TIMEOUT, 0, 1, 0},
  {0, 0, 0, 0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0}
3992
};
unknown's avatar
unknown committed
3993 3994 3995


struct show_var_st status_vars[]= {
3996 3997 3998 3999
  {"Aborted_clients",          (char*) &aborted_threads,        SHOW_LONG},
  {"Aborted_connects",         (char*) &aborted_connects,       SHOW_LONG},
  {"Bytes_received",           (char*) &bytes_received,         SHOW_LONG},
  {"Bytes_sent",               (char*) &bytes_sent,             SHOW_LONG},
4000 4001 4002 4003 4004 4005 4006 4007 4008 4009 4010 4011 4012 4013
  {"Com_admin_commands",       (char*) &com_other,		SHOW_LONG},
  {"Com_alter_table",	       (char*) (com_stat+(uint) SQLCOM_ALTER_TABLE),SHOW_LONG},
  {"Com_analyze",	       (char*) (com_stat+(uint) SQLCOM_ANALYZE),SHOW_LONG},
  {"Com_backup_table",	       (char*) (com_stat+(uint) SQLCOM_BACKUP_TABLE),SHOW_LONG},
  {"Com_begin",		       (char*) (com_stat+(uint) SQLCOM_BEGIN),SHOW_LONG},
  {"Com_change_db",	       (char*) (com_stat+(uint) SQLCOM_CHANGE_DB),SHOW_LONG},
  {"Com_change_master",	       (char*) (com_stat+(uint) SQLCOM_CHANGE_MASTER),SHOW_LONG},
  {"Com_check",		       (char*) (com_stat+(uint) SQLCOM_CHECK),SHOW_LONG},
  {"Com_commit",	       (char*) (com_stat+(uint) SQLCOM_COMMIT),SHOW_LONG},
  {"Com_create_db",	       (char*) (com_stat+(uint) SQLCOM_CREATE_DB),SHOW_LONG},
  {"Com_create_function",      (char*) (com_stat+(uint) SQLCOM_CREATE_FUNCTION),SHOW_LONG},
  {"Com_create_index",	       (char*) (com_stat+(uint) SQLCOM_CREATE_INDEX),SHOW_LONG},
  {"Com_create_table",	       (char*) (com_stat+(uint) SQLCOM_CREATE_TABLE),SHOW_LONG},
  {"Com_delete",	       (char*) (com_stat+(uint) SQLCOM_DELETE),SHOW_LONG},
4014
  {"Com_delete_multi",	       (char*) (com_stat+(uint) SQLCOM_DELETE_MULTI),SHOW_LONG},
4015 4016 4017 4018 4019 4020
  {"Com_drop_db",	       (char*) (com_stat+(uint) SQLCOM_DROP_DB),SHOW_LONG},
  {"Com_drop_function",	       (char*) (com_stat+(uint) SQLCOM_DROP_FUNCTION),SHOW_LONG},
  {"Com_drop_index",	       (char*) (com_stat+(uint) SQLCOM_DROP_INDEX),SHOW_LONG},
  {"Com_drop_table",	       (char*) (com_stat+(uint) SQLCOM_DROP_TABLE),SHOW_LONG},
  {"Com_flush",		       (char*) (com_stat+(uint) SQLCOM_FLUSH),SHOW_LONG},
  {"Com_grant",		       (char*) (com_stat+(uint) SQLCOM_GRANT),SHOW_LONG},
unknown's avatar
unknown committed
4021
  {"Com_ha_close",	       (char*) (com_stat+(uint) SQLCOM_HA_CLOSE),SHOW_LONG},
4022 4023
  {"Com_ha_open",	       (char*) (com_stat+(uint) SQLCOM_HA_OPEN),SHOW_LONG},
  {"Com_ha_read",	       (char*) (com_stat+(uint) SQLCOM_HA_READ),SHOW_LONG},
4024 4025 4026 4027
  {"Com_insert",	       (char*) (com_stat+(uint) SQLCOM_INSERT),SHOW_LONG},
  {"Com_insert_select",	       (char*) (com_stat+(uint) SQLCOM_INSERT_SELECT),SHOW_LONG},
  {"Com_kill",		       (char*) (com_stat+(uint) SQLCOM_KILL),SHOW_LONG},
  {"Com_load",		       (char*) (com_stat+(uint) SQLCOM_LOAD),SHOW_LONG},
4028
  {"Com_load_master_data",    (char*) (com_stat+(uint) SQLCOM_LOAD_MASTER_DATA),SHOW_LONG},
4029 4030 4031 4032 4033 4034 4035 4036 4037 4038 4039 4040
  {"Com_load_master_table",    (char*) (com_stat+(uint) SQLCOM_LOAD_MASTER_TABLE),SHOW_LONG},
  {"Com_lock_tables",	       (char*) (com_stat+(uint) SQLCOM_LOCK_TABLES),SHOW_LONG},
  {"Com_optimize",	       (char*) (com_stat+(uint) SQLCOM_OPTIMIZE),SHOW_LONG},
  {"Com_purge",		       (char*) (com_stat+(uint) SQLCOM_PURGE),SHOW_LONG},
  {"Com_rename_table",	       (char*) (com_stat+(uint) SQLCOM_RENAME_TABLE),SHOW_LONG},
  {"Com_repair",	       (char*) (com_stat+(uint) SQLCOM_REPAIR),SHOW_LONG},
  {"Com_replace",	       (char*) (com_stat+(uint) SQLCOM_REPLACE),SHOW_LONG},
  {"Com_replace_select",       (char*) (com_stat+(uint) SQLCOM_REPLACE_SELECT),SHOW_LONG},
  {"Com_reset",		       (char*) (com_stat+(uint) SQLCOM_RESET),SHOW_LONG},
  {"Com_restore_table",	       (char*) (com_stat+(uint) SQLCOM_RESTORE_TABLE),SHOW_LONG},
  {"Com_revoke",	       (char*) (com_stat+(uint) SQLCOM_REVOKE),SHOW_LONG},
  {"Com_rollback",	       (char*) (com_stat+(uint) SQLCOM_ROLLBACK),SHOW_LONG},
4041
  {"Com_savepoint",	       (char*) (com_stat+(uint) SQLCOM_SAVEPOINT),SHOW_LONG},
4042 4043
  {"Com_select",	       (char*) (com_stat+(uint) SQLCOM_SELECT),SHOW_LONG},
  {"Com_set_option",	       (char*) (com_stat+(uint) SQLCOM_SET_OPTION),SHOW_LONG},
4044
  {"Com_show_binlog_events",   (char*) (com_stat+(uint) SQLCOM_SHOW_BINLOG_EVENTS),SHOW_LONG},
4045 4046 4047 4048 4049 4050 4051
  {"Com_show_binlogs",	       (char*) (com_stat+(uint) SQLCOM_SHOW_BINLOGS),SHOW_LONG},
  {"Com_show_create",	       (char*) (com_stat+(uint) SQLCOM_SHOW_CREATE),SHOW_LONG},
  {"Com_show_databases",       (char*) (com_stat+(uint) SQLCOM_SHOW_DATABASES),SHOW_LONG},
  {"Com_show_fields",	       (char*) (com_stat+(uint) SQLCOM_SHOW_FIELDS),SHOW_LONG},
  {"Com_show_grants",	       (char*) (com_stat+(uint) SQLCOM_SHOW_GRANTS),SHOW_LONG},
  {"Com_show_keys",	       (char*) (com_stat+(uint) SQLCOM_SHOW_KEYS),SHOW_LONG},
  {"Com_show_logs",	       (char*) (com_stat+(uint) SQLCOM_SHOW_LOGS),SHOW_LONG},
4052
  {"Com_show_master_status",   (char*) (com_stat+(uint) SQLCOM_SHOW_MASTER_STAT),SHOW_LONG},
4053
  {"Com_show_new_master",      (char*) (com_stat+(uint) SQLCOM_SHOW_NEW_MASTER),SHOW_LONG},
4054 4055
  {"Com_show_open_tables",     (char*) (com_stat+(uint) SQLCOM_SHOW_OPEN_TABLES),SHOW_LONG},
  {"Com_show_processlist",     (char*) (com_stat+(uint) SQLCOM_SHOW_PROCESSLIST),SHOW_LONG},
4056
  {"Com_show_slave_hosts",     (char*) (com_stat+(uint) SQLCOM_SHOW_SLAVE_HOSTS),SHOW_LONG},
4057
  {"Com_show_slave_status",    (char*) (com_stat+(uint) SQLCOM_SHOW_SLAVE_STAT),SHOW_LONG},
4058
  {"Com_show_status",	       (char*) (com_stat+(uint) SQLCOM_SHOW_STATUS),SHOW_LONG},
unknown's avatar
unknown committed
4059
  {"Com_show_innodb_status",   (char*) (com_stat+(uint) SQLCOM_SHOW_INNODB_STATUS),SHOW_LONG},
4060 4061 4062 4063 4064 4065 4066
  {"Com_show_tables",	       (char*) (com_stat+(uint) SQLCOM_SHOW_TABLES),SHOW_LONG},
  {"Com_show_variables",       (char*) (com_stat+(uint) SQLCOM_SHOW_VARIABLES),SHOW_LONG},
  {"Com_slave_start",	       (char*) (com_stat+(uint) SQLCOM_SLAVE_START),SHOW_LONG},
  {"Com_slave_stop",	       (char*) (com_stat+(uint) SQLCOM_SLAVE_STOP),SHOW_LONG},
  {"Com_truncate",	       (char*) (com_stat+(uint) SQLCOM_TRUNCATE),SHOW_LONG},
  {"Com_unlock_tables",	       (char*) (com_stat+(uint) SQLCOM_UNLOCK_TABLES),SHOW_LONG},
  {"Com_update",	       (char*) (com_stat+(uint) SQLCOM_UPDATE),SHOW_LONG},
4067
  {"Connections",              (char*) &thread_id,              SHOW_LONG_CONST},
4068
  {"Created_tmp_disk_tables",  (char*) &created_tmp_disk_tables,SHOW_LONG},
4069
  {"Created_tmp_tables",       (char*) &created_tmp_tables,     SHOW_LONG},
4070
  {"Created_tmp_files",	       (char*) &my_tmp_file_created,	SHOW_LONG},
4071
  {"Delayed_insert_threads",   (char*) &delayed_insert_threads, SHOW_LONG_CONST},
4072 4073 4074
  {"Delayed_writes",           (char*) &delayed_insert_writes,  SHOW_LONG},
  {"Delayed_errors",           (char*) &delayed_insert_errors,  SHOW_LONG},
  {"Flush_commands",           (char*) &refresh_version,        SHOW_LONG_CONST},
4075
  {"Handler_commit",           (char*) &ha_commit_count,        SHOW_LONG},
4076 4077 4078 4079 4080 4081 4082
  {"Handler_delete",           (char*) &ha_delete_count,        SHOW_LONG},
  {"Handler_read_first",       (char*) &ha_read_first_count,    SHOW_LONG},
  {"Handler_read_key",         (char*) &ha_read_key_count,      SHOW_LONG},
  {"Handler_read_next",        (char*) &ha_read_next_count,     SHOW_LONG},
  {"Handler_read_prev",        (char*) &ha_read_prev_count,     SHOW_LONG},
  {"Handler_read_rnd",         (char*) &ha_read_rnd_count,      SHOW_LONG},
  {"Handler_read_rnd_next",    (char*) &ha_read_rnd_next_count, SHOW_LONG},
4083
  {"Handler_rollback",         (char*) &ha_rollback_count,      SHOW_LONG},
4084 4085 4086 4087 4088 4089 4090 4091 4092 4093 4094
  {"Handler_update",           (char*) &ha_update_count,        SHOW_LONG},
  {"Handler_write",            (char*) &ha_write_count,         SHOW_LONG},
  {"Key_blocks_used",          (char*) &_my_blocks_used,        SHOW_LONG_CONST},
  {"Key_read_requests",        (char*) &_my_cache_r_requests,   SHOW_LONG},
  {"Key_reads",                (char*) &_my_cache_read,         SHOW_LONG},
  {"Key_write_requests",       (char*) &_my_cache_w_requests,   SHOW_LONG},
  {"Key_writes",               (char*) &_my_cache_write,        SHOW_LONG},
  {"Max_used_connections",     (char*) &max_used_connections,   SHOW_LONG},
  {"Not_flushed_key_blocks",   (char*) &_my_blocks_changed,     SHOW_LONG_CONST},
  {"Not_flushed_delayed_rows", (char*) &delayed_rows_in_use,    SHOW_LONG_CONST},
  {"Open_tables",              (char*) 0,                       SHOW_OPENTABLES},
unknown's avatar
unknown committed
4095 4096
  {"Open_files",               (char*) &my_file_opened,         SHOW_LONG_CONST},
  {"Open_streams",             (char*) &my_stream_opened,       SHOW_LONG_CONST},
4097 4098
  {"Opened_tables",            (char*) &opened_tables,          SHOW_LONG},
  {"Questions",                (char*) 0,                       SHOW_QUESTION},
unknown's avatar
unknown committed
4099
#ifdef HAVE_QUERY_CACHE
unknown's avatar
unknown committed
4100
  {"Qcache_queries_in_cache",  (char*) &query_cache.queries_in_cache, SHOW_LONG_CONST},
unknown's avatar
unknown committed
4101 4102
  {"Qcache_inserts",           (char*) &query_cache.inserts,    SHOW_LONG},
  {"Qcache_hits",              (char*) &query_cache.hits,       SHOW_LONG},
4103
  {"Qcache_lowmem_prunes",     (char*) &query_cache.lowmem_prunes, SHOW_LONG},
unknown's avatar
unknown committed
4104
  {"Qcache_not_cached",        (char*) &query_cache.refused,    SHOW_LONG},
unknown's avatar
unknown committed
4105 4106 4107 4108 4109 4110
  {"Qcache_free_memory",       (char*) &query_cache.free_memory, 
   SHOW_LONG_CONST},
  {"Qcache_free_blocks",       (char*) &query_cache.free_memory_blocks,
   SHOW_LONG_CONST},
  {"Qcache_total_blocks",      (char*) &query_cache.total_blocks,
   SHOW_LONG_CONST},
unknown's avatar
unknown committed
4111
#endif /*HAVE_QUERY_CACHE*/
unknown's avatar
unknown committed
4112
  {"Rpl_status",               (char*) 0,                 SHOW_RPL_STATUS},
4113 4114 4115 4116 4117
  {"Select_full_join",         (char*) &select_full_join_count, SHOW_LONG},
  {"Select_full_range_join",   (char*) &select_full_range_join_count, SHOW_LONG},
  {"Select_range",             (char*) &select_range_count, 	SHOW_LONG},
  {"Select_range_check",       (char*) &select_range_check_count, SHOW_LONG},
  {"Select_scan",	       (char*) &select_scan_count,	SHOW_LONG},
4118
  {"Slave_open_temp_tables",   (char*) &slave_open_temp_tables, SHOW_LONG},
4119
  {"Slave_running",            (char*) 0, SHOW_SLAVE_RUNNING},
4120 4121
  {"Slow_launch_threads",      (char*) &slow_launch_threads,    SHOW_LONG},
  {"Slow_queries",             (char*) &long_query_count,       SHOW_LONG},
4122
  {"Sort_merge_passes",	       (char*) &filesort_merge_passes,  SHOW_LONG},
4123 4124 4125
  {"Sort_range",	       (char*) &filesort_range_count,   SHOW_LONG},
  {"Sort_rows",		       (char*) &filesort_rows,	        SHOW_LONG},
  {"Sort_scan",		       (char*) &filesort_scan_count,    SHOW_LONG},
unknown's avatar
unknown committed
4126
#ifdef HAVE_OPENSSL
4127 4128 4129 4130 4131 4132 4133 4134 4135 4136 4137 4138 4139 4140 4141 4142 4143 4144 4145 4146 4147 4148 4149
  {"Ssl_accepts",              (char*) 0,  	SHOW_SSL_CTX_SESS_ACCEPT},
  {"Ssl_finished_accepts",     (char*) 0,  	SHOW_SSL_CTX_SESS_ACCEPT_GOOD},
  {"Ssl_finished_connects",    (char*) 0,  	SHOW_SSL_CTX_SESS_CONNECT_GOOD},
  {"Ssl_accept_renegotiates",  (char*) 0, 	SHOW_SSL_CTX_SESS_ACCEPT_RENEGOTIATE},
  {"Ssl_connect_renegotiates", (char*) 0, 	SHOW_SSL_CTX_SESS_CONNECT_RENEGOTIATE},
  {"Ssl_callback_cache_hits",  (char*) 0,	SHOW_SSL_CTX_SESS_CB_HITS},
  {"Ssl_session_cache_hits",   (char*) 0,	SHOW_SSL_CTX_SESS_HITS},
  {"Ssl_session_cache_misses", (char*) 0,	SHOW_SSL_CTX_SESS_MISSES},
  {"Ssl_session_cache_timeouts", (char*) 0,	SHOW_SSL_CTX_SESS_TIMEOUTS},
  {"Ssl_used_session_cache_entries",(char*) 0,	SHOW_SSL_CTX_SESS_NUMBER},
  {"Ssl_client_connects",      (char*) 0,	SHOW_SSL_CTX_SESS_CONNECT},
  {"Ssl_session_cache_overflows", (char*) 0,	SHOW_SSL_CTX_SESS_CACHE_FULL},
  {"Ssl_session_cache_size",   (char*) 0,	SHOW_SSL_CTX_SESS_GET_CACHE_SIZE},
  {"Ssl_session_cache_mode",   (char*) 0,	SHOW_SSL_CTX_GET_SESSION_CACHE_MODE},
  {"Ssl_sessions_reused",      (char*) 0,	SHOW_SSL_SESSION_REUSED},
  {"Ssl_ctx_verify_mode",      (char*) 0,	SHOW_SSL_CTX_GET_VERIFY_MODE},
  {"Ssl_ctx_verify_depth",     (char*) 0,	SHOW_SSL_CTX_GET_VERIFY_DEPTH},
  {"Ssl_verify_mode",          (char*) 0,	SHOW_SSL_GET_VERIFY_MODE},
  {"Ssl_verify_depth",         (char*) 0,	SHOW_SSL_GET_VERIFY_DEPTH},
  {"Ssl_version",   	       (char*) 0,  	SHOW_SSL_GET_VERSION},
  {"Ssl_cipher",               (char*) 0,  	SHOW_SSL_GET_CIPHER},
  {"Ssl_cipher_list",          (char*) 0,  	SHOW_SSL_GET_CIPHER_LIST},
  {"Ssl_default_timeout",      (char*) 0,  	SHOW_SSL_GET_DEFAULT_TIMEOUT},
unknown's avatar
unknown committed
4150
#endif /* HAVE_OPENSSL */
unknown's avatar
unknown committed
4151 4152
  {"Table_locks_immediate",    (char*) &locks_immediate,        SHOW_LONG},
  {"Table_locks_waited",       (char*) &locks_waited,           SHOW_LONG},
4153
  {"Threads_cached",           (char*) &cached_thread_count,    SHOW_LONG_CONST},
4154
  {"Threads_created",	       (char*) &thread_created,		SHOW_LONG_CONST},
4155 4156 4157 4158
  {"Threads_connected",        (char*) &thread_count,           SHOW_INT_CONST},
  {"Threads_running",          (char*) &thread_running,         SHOW_INT_CONST},
  {"Uptime",                   (char*) 0,                       SHOW_STARTTIME},
  {NullS, NullS, SHOW_LONG}
unknown's avatar
unknown committed
4159 4160 4161 4162 4163 4164 4165 4166
};

static void print_version(void)
{
  printf("%s  Ver %s for %s on %s\n",my_progname,
	 server_version,SYSTEM_TYPE,MACHINE_TYPE);
}

unknown's avatar
unknown committed
4167 4168 4169
static void use_help(void)
{
  print_version();
4170
  printf("Use '--help' or '--no-defaults --help' for a list of available options\n");
unknown's avatar
unknown committed
4171
}
unknown's avatar
unknown committed
4172

unknown's avatar
unknown committed
4173 4174 4175
static void usage(void)
{
  print_version();
unknown's avatar
unknown committed
4176 4177 4178 4179 4180
  puts("\
Copyright (C) 2000 MySQL AB, by Monty and others\n\
This software comes with ABSOLUTELY NO WARRANTY. This is free software,\n\
and you are welcome to modify and redistribute it under the GPL license\n\
Starts the MySQL server\n");
unknown's avatar
unknown committed
4181 4182 4183 4184

  printf("Usage: %s [OPTIONS]\n", my_progname);
#ifdef __WIN__
  puts("NT and Win32 specific options:\n\
4185 4186
  --install                     Install the default service (NT)\n\
  --install-manual              Install the default service started manually (NT)\n\
unknown's avatar
unknown committed
4187 4188
  --install service_name        Install an optional service (NT)\n\
  --install-manual service_name Install an optional service started manually (NT)\n\
4189
  --remove                      Remove the default service from the service list (NT)\n\
unknown's avatar
unknown committed
4190 4191 4192
  --remove service_name         Remove the service_name from the service list (NT)\n\
  --enable-named-pipe           Only to be used for the	default server (NT)\n\
  --standalone                  Dummy option to start as a standalone server (NT)\
unknown's avatar
unknown committed
4193
");
4194
  puts("");
unknown's avatar
unknown committed
4195
#endif
4196
  print_defaults(MYSQL_CONFIG_NAME,load_default_groups);
unknown's avatar
unknown committed
4197 4198 4199
  puts("");
  fix_paths();
  set_ports();
4200 4201 4202 4203

  my_print_help(my_long_options);
  my_print_variables(my_long_options);

unknown's avatar
unknown committed
4204
  puts("\n\
unknown's avatar
unknown committed
4205
To see what values a running MySQL server is using, type\n\
unknown's avatar
unknown committed
4206
'mysqladmin variables' instead of 'mysqld --help'.");
unknown's avatar
unknown committed
4207 4208 4209 4210 4211 4212 4213 4214 4215
}


static void set_options(void)
{
#if !defined( my_pthread_setprio ) && !defined( HAVE_PTHREAD_SETSCHEDPARAM )
  opt_specialflag |= SPECIAL_NO_PRIOR;
#endif

unknown's avatar
unknown committed
4216
  sys_charset.value= (char*) MYSQL_CHARSET;
unknown's avatar
unknown committed
4217 4218
  (void) strmake(language, LANGUAGE, sizeof(language)-1);
  (void) strmake(mysql_real_data_home, get_relative_path(DATADIR),
unknown's avatar
unknown committed
4219
		 sizeof(mysql_real_data_home)-1);
unknown's avatar
unknown committed
4220 4221 4222

  /* Set default values for some variables */
  global_system_variables.table_type=DB_TYPE_MYISAM;
unknown's avatar
unknown committed
4223
  global_system_variables.tx_isolation=ISO_REPEATABLE_READ;
4224 4225 4226 4227
  global_system_variables.select_limit= HA_POS_ERROR;
  max_system_variables.select_limit=    HA_POS_ERROR;
  global_system_variables.max_join_size= HA_POS_ERROR;
  max_system_variables.max_join_size=    HA_POS_ERROR;
unknown's avatar
unknown committed
4228

unknown's avatar
unknown committed
4229 4230
#if defined(__WIN__) || defined(__NETWARE__)
  /* Allow Win32 and NetWare users to move MySQL anywhere */
unknown's avatar
unknown committed
4231 4232 4233 4234 4235 4236 4237 4238
  {
    char prg_dev[LIBLEN];
    my_path(prg_dev,my_progname,"mysql/bin");
    strcat(prg_dev,"/../");			// Remove 'bin' to get base dir
    cleanup_dirname(mysql_home,prg_dev);
  }
#else
  const char *tmpenv;
unknown's avatar
unknown committed
4239
  if (!(tmpenv = getenv("MY_BASEDIR_VERSION")))
unknown's avatar
unknown committed
4240
    tmpenv = DEFAULT_MYSQL_HOME;
unknown's avatar
unknown committed
4241
  (void) strmake(mysql_home, tmpenv, sizeof(mysql_home)-1);
unknown's avatar
unknown committed
4242 4243
#endif

4244
  my_disable_locking=myisam_single_user= 1;
4245
  opt_external_locking=0;
unknown's avatar
unknown committed
4246 4247 4248 4249
  my_bind_addr = htonl( INADDR_ANY );
}


4250
extern "C" my_bool
4251 4252
get_one_option(int optid, const struct my_option *opt __attribute__((unused)),
	       char *argument)
unknown's avatar
unknown committed
4253
{
4254 4255
  switch(optid) {
  case '#':
4256
#ifndef DBUG_OFF
4257 4258 4259 4260 4261 4262 4263 4264
    DBUG_PUSH(argument ? argument : default_dbug_option);
#endif
    opt_endinfo=1;				/* unireg: memory allocation */
    break;
  case 'a':
    opt_sql_mode = (MODE_REAL_AS_FLOAT | MODE_PIPES_AS_CONCAT |
		    MODE_ANSI_QUOTES | MODE_IGNORE_SPACE | MODE_SERIALIZABLE
		    | MODE_ONLY_FULL_GROUP_BY);
unknown's avatar
unknown committed
4265
    global_system_variables.tx_isolation= ISO_SERIALIZABLE;
4266 4267 4268 4269 4270 4271 4272 4273 4274
    break;
  case 'b':
    strmake(mysql_home,argument,sizeof(mysql_home)-1);
    break;
  case 'l':
    opt_log=1;
    break;
  case 'h':
    strmake(mysql_real_data_home,argument, sizeof(mysql_real_data_home)-1);
4275 4276
    /* Correct pointer set by my_getopt (for embedded library) */
    mysql_data_home= mysql_real_data_home;
4277
    break;
4278 4279
  case 'u':
    if (!mysqld_user)
unknown's avatar
unknown committed
4280
      mysqld_user= argument;
4281
    else
unknown's avatar
unknown committed
4282
      fprintf(stderr, "Warning: Ignoring user change to '%s' because the user was set to '%s' earlier on the command line\n", argument, mysqld_user);
4283
    break;
4284 4285 4286 4287 4288 4289 4290 4291 4292 4293
  case 'L':
    strmake(language, argument, sizeof(language)-1);
    break;
  case 'o':
    protocol_version=PROTOCOL_VERSION-1;
    break;
  case OPT_SLAVE_SKIP_ERRORS:
    init_slave_skip_errors(argument);
    break;
  case OPT_SAFEMALLOC_MEM_LIMIT:
4294
#if !defined(DBUG_OFF) && defined(SAFEMALLOC)
4295
    sf_malloc_mem_limit = atoi(argument);
4296
#endif
4297
    break;
4298 4299 4300 4301 4302 4303 4304 4305
#ifdef EMBEDDED_LIBRARY
  case OPT_MAX_ALLOWED_PACKET:
    max_allowed_packet= atoi(argument);
    break;
  case OPT_NET_BUFFER_LENGTH:
    net_buffer_length=  atoi(argument);
    break;
#endif
4306
#include <sslopt-case.h>
4307 4308 4309 4310 4311 4312 4313 4314 4315 4316
  case 'v':
  case 'V':
    print_version();
    exit(0);
  case 'I':
  case '?':
    usage();
    exit(0);
  case 'T':
    test_flags= argument ? (uint) atoi(argument) : 0;
4317
    test_flags&= ~TEST_NO_THREADS;
4318 4319 4320 4321 4322 4323 4324 4325 4326 4327 4328 4329 4330 4331
    opt_endinfo=1;
    break;
  case (int) OPT_BIG_TABLES:
    thd_startup_options|=OPTION_BIG_TABLES;
    break;
  case (int) OPT_ISAM_LOG:
    opt_myisam_log=1;
    break;
  case (int) OPT_UPDATE_LOG:
    opt_update_log=1;
    break;
  case (int) OPT_BIN_LOG:
    opt_bin_log=1;
    break;
4332 4333 4334
  case (int) OPT_ERROR_LOG_FILE:
    opt_error_log= 1;
    break;
4335
  case (int) OPT_INIT_RPL_ROLE:
4336 4337 4338
  {
    int role;
    if ((role=find_type(argument, &rpl_role_typelib, 2)) <= 0)
4339
    {
4340 4341
      fprintf(stderr, "Unknown replication role: %s\n", argument);
      exit(1);
4342
    }
4343 4344 4345
    rpl_status = (role == 1) ?  RPL_AUTH_MASTER : RPL_IDLE_SLAVE;
    break;
  }
4346
  case (int)OPT_REPLICATE_IGNORE_DB:
4347 4348 4349 4350 4351 4352 4353 4354 4355 4356 4357 4358 4359 4360 4361 4362
  {
    i_string *db = new i_string(argument);
    replicate_ignore_db.push_back(db);
    break;
  }
  case (int)OPT_REPLICATE_DO_DB:
  {
    i_string *db = new i_string(argument);
    replicate_do_db.push_back(db);
    break;
  }
  case (int)OPT_REPLICATE_REWRITE_DB:
  {
    char* key = argument,*p, *val;
    
    if (!(p= strstr(argument, "->")))
4363
    {
4364 4365 4366
      fprintf(stderr,
	      "Bad syntax in replicate-rewrite-db - missing '->'!\n");
      exit(1);
4367
    }
4368 4369 4370 4371
    val= p--;
    while (isspace(*p) && p > argument)
      *p-- = 0;
    if (p == argument)
4372
    {
4373 4374 4375
      fprintf(stderr,
	      "Bad syntax in replicate-rewrite-db - empty FROM db!\n");
      exit(1);
4376
    }
4377 4378 4379 4380 4381
    *val= 0;
    val+= 2;
    while (*val && isspace(*val))
      *val++;
    if (!*val)
4382
    {
4383 4384 4385
      fprintf(stderr,
	      "Bad syntax in replicate-rewrite-db - empty TO db!\n");
      exit(1);
4386 4387
    }

4388 4389 4390 4391 4392
    i_string_pair *db_pair = new i_string_pair(key, val);
    replicate_rewrite_db.push_back(db_pair);
    break;
  }

4393
  case (int)OPT_BINLOG_IGNORE_DB:
4394 4395 4396 4397 4398
  {
    i_string *db = new i_string(argument);
    binlog_ignore_db.push_back(db);
    break;
  }
4399
  case (int)OPT_BINLOG_DO_DB:
4400 4401 4402 4403 4404
  {
    i_string *db = new i_string(argument);
    binlog_do_db.push_back(db);
    break;
  }
4405
  case (int)OPT_REPLICATE_DO_TABLE:
4406 4407 4408 4409
  {
    if (!do_table_inited)
      init_table_rule_hash(&replicate_do_table, &do_table_inited);
    if (add_table_rule(&replicate_do_table, argument))
4410
    {
4411 4412
      fprintf(stderr, "Could not add do table rule '%s'!\n", argument);
      exit(1);
4413
    }
4414 4415 4416
    table_rules_on = 1;
    break;
  }
4417
  case (int)OPT_REPLICATE_WILD_DO_TABLE:
4418 4419 4420 4421 4422
  {
    if (!wild_do_table_inited)
      init_table_rule_array(&replicate_wild_do_table,
			    &wild_do_table_inited);
    if (add_wild_table_rule(&replicate_wild_do_table, argument))
4423
    {
4424 4425
      fprintf(stderr, "Could not add do table rule '%s'!\n", argument);
      exit(1);
4426
    }
4427 4428 4429
    table_rules_on = 1;
    break;
  }
4430
  case (int)OPT_REPLICATE_WILD_IGNORE_TABLE:
4431 4432 4433 4434 4435
  {
    if (!wild_ignore_table_inited)
      init_table_rule_array(&replicate_wild_ignore_table,
			    &wild_ignore_table_inited);
    if (add_wild_table_rule(&replicate_wild_ignore_table, argument))
4436
    {
4437 4438
      fprintf(stderr, "Could not add ignore table rule '%s'!\n", argument);
      exit(1);
4439
    }
4440 4441 4442
    table_rules_on = 1;
    break;
  }
4443
  case (int)OPT_REPLICATE_IGNORE_TABLE:
4444 4445 4446 4447
  {
    if (!ignore_table_inited)
      init_table_rule_hash(&replicate_ignore_table, &ignore_table_inited);
    if (add_table_rule(&replicate_ignore_table, argument))
4448
    {
4449 4450
      fprintf(stderr, "Could not add ignore table rule '%s'!\n", argument);
      exit(1);
4451
    }
4452 4453 4454
    table_rules_on = 1;
    break;
  }
4455 4456 4457 4458 4459 4460 4461 4462 4463
  case (int) OPT_SLOW_QUERY_LOG:
    opt_slow_log=1;
    break;
  case (int)OPT_RECKLESS_SLAVE:
    opt_reckless_slave = 1;
    init_slave_skip_errors("all");
    break;
  case (int) OPT_SKIP_NEW:
    opt_specialflag|= SPECIAL_NO_NEW_FUNC;
4464
    delay_key_write_options= (uint) DELAY_KEY_WRITE_NONE;
4465 4466 4467
    myisam_concurrent_insert=0;
    myisam_recover_options= HA_RECOVER_NONE;
    my_use_symdir=0;
4468
    ha_open_options&= ~(HA_OPEN_ABORT_IF_CRASHED | HA_OPEN_DELAY_KEY_WRITE);
unknown's avatar
unknown committed
4469
#ifdef HAVE_QUERY_CACHE
4470 4471 4472 4473 4474
    query_cache_size=0;
#endif
    break;
  case (int) OPT_SAFE:
    opt_specialflag|= SPECIAL_SAFE_MODE;
4475
    delay_key_write_options= (uint) DELAY_KEY_WRITE_NONE;
4476 4477
    myisam_recover_options= HA_RECOVER_DEFAULT;
    ha_open_options&= ~(HA_OPEN_DELAY_KEY_WRITE);
4478 4479 4480 4481 4482
    break;
  case (int) OPT_SKIP_PRIOR:
    opt_specialflag|= SPECIAL_NO_PRIOR;
    break;
  case (int) OPT_SKIP_LOCK:
4483
    opt_external_locking=0;
4484 4485 4486 4487 4488 4489 4490 4491 4492 4493 4494 4495 4496 4497 4498 4499 4500 4501
    break;
  case (int) OPT_SKIP_HOST_CACHE:
    opt_specialflag|= SPECIAL_NO_HOST_CACHE;
    break;
  case (int) OPT_SKIP_RESOLVE:
    opt_specialflag|=SPECIAL_NO_RESOLVE;
    break;
  case (int) OPT_LONG_FORMAT:
    opt_specialflag|=SPECIAL_LONG_LOG_FORMAT;
    break;
  case (int) OPT_SKIP_NETWORKING:
    opt_disable_networking=1;
    mysql_port=0;
    break;
  case (int) OPT_SKIP_SHOW_DB:
    opt_skip_show_db=1;
    opt_specialflag|=SPECIAL_SKIP_SHOW_DB;
    break;
4502
#ifdef ONE_THREAD
4503 4504
  case (int) OPT_ONE_THREAD:
    test_flags |= TEST_NO_THREADS;
4505
#endif
4506 4507 4508 4509 4510 4511 4512 4513 4514 4515 4516 4517 4518 4519 4520 4521 4522 4523
    break;
  case (int) OPT_WANT_CORE:
    test_flags |= TEST_CORE_ON_SIGNAL;
    break;
  case (int) OPT_SKIP_STACK_TRACE:
    test_flags|=TEST_NO_STACKTRACE;
    break;
  case (int) OPT_SKIP_SYMLINKS:
    my_use_symdir=0;
    break;
  case (int) OPT_BIND_ADDRESS:
    if (argument && isdigit(argument[0]))
    {
      my_bind_addr = (ulong) inet_addr(argument);
    }
    else
    {
      struct hostent *ent;
4524
      if (argument || argument[0])
4525
	ent=gethostbyname(argument);
unknown's avatar
unknown committed
4526 4527
      else
      {
4528 4529
	char myhostname[255];
	if (gethostname(myhostname,sizeof(myhostname)) < 0)
unknown's avatar
unknown committed
4530
	{
4531
	  sql_perror("Can't start server: cannot get my own hostname!");
unknown's avatar
unknown committed
4532 4533
	  exit(1);
	}
4534
	ent=gethostbyname(myhostname);
unknown's avatar
unknown committed
4535
      }
4536 4537 4538 4539 4540 4541 4542 4543 4544 4545 4546
      if (!ent)
      {
	sql_perror("Can't start server: cannot resolve hostname!");
	exit(1);
      }
      my_bind_addr = (ulong) ((in_addr*)ent->h_addr_list[0])->s_addr;
    }
    break;
  case (int) OPT_PID_FILE:
    strmake(pidfile_name, argument, sizeof(pidfile_name)-1);
    break;
unknown's avatar
unknown committed
4547
#ifdef __WIN__
4548 4549
  case (int) OPT_STANDALONE:		/* Dummy option for NT */
    break;
unknown's avatar
unknown committed
4550
#endif
4551 4552 4553 4554
  case OPT_CONSOLE:
    if (opt_console)
      opt_error_log= 0;			// Force logs to stdout
    break;
4555
  case (int) OPT_FLUSH:
4556
#ifdef HAVE_ISAM
4557 4558 4559 4560 4561 4562 4563
    nisam_flush=1;
#endif
    myisam_flush=1;
    flush_time=0;			// No auto flush
    break;
  case OPT_LOW_PRIORITY_UPDATES:
    thr_upgraded_concurrent_insert_lock= TL_WRITE_LOW_PRIORITY;
unknown's avatar
unknown committed
4564
    global_system_variables.low_priority_updates=1;
4565 4566 4567 4568 4569
    break;
  case OPT_BOOTSTRAP:
    opt_noacl=opt_bootstrap=1;
    break;
  case OPT_TABLE_TYPE:
4570 4571 4572
  {
    int type;
    if ((type=find_type(argument, &ha_table_typelib, 2)) <= 0)
unknown's avatar
unknown committed
4573
    {
4574 4575
      fprintf(stderr,"Unknown table type: %s\n",argument);
      exit(1);
unknown's avatar
unknown committed
4576
    }
unknown's avatar
unknown committed
4577
    global_system_variables.table_type= type-1;
4578 4579
    break;
  }
4580 4581 4582
  case OPT_SERVER_ID:
    server_id_supplied = 1;
    break;
4583 4584 4585 4586
  case OPT_DELAY_KEY_WRITE_ALL:
    if (argument != disabled_my_option)
      argument= (char*) "ALL";
    /* Fall through */
4587
  case OPT_DELAY_KEY_WRITE:
4588 4589 4590 4591 4592 4593 4594 4595 4596 4597 4598 4599 4600 4601
    if (argument == disabled_my_option)
      delay_key_write_options= (uint) DELAY_KEY_WRITE_NONE;
    else if (! argument)
      delay_key_write_options= (uint) DELAY_KEY_WRITE_ON;
    else
    {
      int type;
      if ((type=find_type(argument, &delay_key_write_typelib, 2)) <= 0)
      {
	fprintf(stderr,"Unknown delay_key_write type: %s\n",argument);
	exit(1);
      }
      delay_key_write_options= (uint) type-1;
    }
4602 4603 4604 4605 4606 4607
    break;
  case OPT_CHARSETS_DIR:
    strmake(mysql_charsets_dir, argument, sizeof(mysql_charsets_dir)-1);
    charsets_dir = mysql_charsets_dir;
    break;
  case OPT_TX_ISOLATION:
4608 4609 4610
  {
    int type;
    if ((type=find_type(argument, &tx_isolation_typelib, 2)) <= 0)
unknown's avatar
unknown committed
4611
    {
4612 4613
      fprintf(stderr,"Unknown transaction isolation type: %s\n",argument);
      exit(1);
unknown's avatar
unknown committed
4614
    }
unknown's avatar
unknown committed
4615
    global_system_variables.tx_isolation= (type-1);
4616 4617
    break;
  }
unknown's avatar
unknown committed
4618
#ifdef HAVE_BERKELEY_DB
4619 4620 4621 4622 4623 4624 4625
  case OPT_BDB_NOSYNC:
    berkeley_env_flags|=DB_TXN_NOSYNC;
    break;
  case OPT_BDB_NO_RECOVER:
    berkeley_init_flags&= ~(DB_RECOVER);
    break;
  case OPT_BDB_LOCK:
4626 4627 4628 4629 4630
  {
    int type;
    if ((type=find_type(argument, &berkeley_lock_typelib, 2)) > 0)
      berkeley_lock_type=berkeley_lock_types[type-1];
    else
unknown's avatar
unknown committed
4631
    {
4632 4633
      if (test_if_int(argument,(uint) strlen(argument)))
	berkeley_lock_scan_time=atoi(argument);
unknown's avatar
unknown committed
4634 4635
      else
      {
4636 4637
	fprintf(stderr,"Unknown lock type: %s\n",argument);
	exit(1);
unknown's avatar
unknown committed
4638 4639
      }
    }
4640 4641
    break;
  }
4642 4643 4644 4645
  case OPT_BDB_SHARED:
    berkeley_init_flags&= ~(DB_PRIVATE);
    berkeley_shared_data=1;
    break;
4646
#endif /* HAVE_BERKELEY_DB */
4647
  case OPT_BDB_SKIP:
4648
#ifdef HAVE_BERKELEY_DB
4649 4650
    berkeley_skip=1;
    have_berkeley_db=SHOW_OPTION_DISABLED;
unknown's avatar
unknown committed
4651
#endif
4652 4653
    break;
  case OPT_INNODB_SKIP:
4654
#ifdef HAVE_INNOBASE_DB
4655 4656
    innodb_skip=1;
    have_innodb=SHOW_OPTION_DISABLED;
unknown's avatar
unknown committed
4657
#endif
4658 4659
    break;
  case OPT_INNODB_DATA_FILE_PATH:
unknown's avatar
unknown committed
4660
#ifdef HAVE_INNOBASE_DB
4661
    innobase_data_file_path=argument;
4662
#endif
4663
    break;
4664
#ifdef HAVE_INNOBASE_DB
4665 4666 4667 4668 4669 4670
  case OPT_INNODB_LOG_ARCHIVE:
    innobase_log_archive= argument ? test(atoi(argument)) : 1;
    break;
  case OPT_INNODB_FAST_SHUTDOWN:
    innobase_fast_shutdown= argument ? test(atoi(argument)) : 1;
    break;
4671
#endif /* HAVE_INNOBASE_DB */
4672
  case OPT_MYISAM_RECOVER:
4673 4674
  {
    if (!argument || !argument[0])
4675
    {
4676 4677
      myisam_recover_options=    HA_RECOVER_DEFAULT;
      myisam_recover_options_str= myisam_recover_typelib.type_names[0];
4678
    }
4679
    else
4680
    {
4681 4682 4683
      myisam_recover_options_str=argument;
      if ((myisam_recover_options=
	   find_bit_type(argument, &myisam_recover_typelib)) == ~(ulong) 0)
4684
      {
4685
	fprintf(stderr, "Unknown option to myisam-recover: %s\n",argument);
4686 4687 4688
	exit(1);
      }
    }
4689 4690 4691 4692 4693 4694 4695 4696 4697 4698 4699 4700
    ha_open_options|=HA_OPEN_ABORT_IF_CRASHED;
    break;
  }
  case OPT_SQL_MODE:
  {
    sql_mode_str = argument;
    if ((opt_sql_mode =
	 find_bit_type(argument, &sql_mode_typelib)) == ~(ulong) 0)
    {
      fprintf(stderr, "Unknown option to sql-mode: %s\n", argument);
      exit(1);
    }
unknown's avatar
unknown committed
4701 4702
    global_system_variables.tx_isolation= ((opt_sql_mode & MODE_SERIALIZABLE) ?
					   ISO_SERIALIZABLE :
unknown's avatar
unknown committed
4703
					   ISO_REPEATABLE_READ);
4704 4705
    break;
  }
4706 4707 4708 4709
  case OPT_MASTER_PASSWORD:
    master_password=argument;
    break;
  case OPT_SKIP_SAFEMALLOC:
4710
#ifdef SAFEMALLOC
4711
    sf_malloc_quick=1;
4712
#endif
4713
    break;
unknown's avatar
unknown committed
4714
  }
4715 4716 4717 4718 4719 4720 4721 4722 4723
  return 0;
}
	/* Initiates DEBUG - but no debugging here ! */

static void get_options(int argc,char **argv)
{
  int ho_error;

  if ((ho_error=handle_options(&argc, &argv, my_long_options, get_one_option)))
4724
    exit(ho_error);
4725

unknown's avatar
unknown committed
4726
#if defined(HAVE_BROKEN_REALPATH)
4727 4728 4729 4730 4731 4732 4733 4734 4735 4736
  my_use_symdir=0;
  my_disable_symlinks=1;
  have_symlink=SHOW_OPTION_NO;
#else
  if (!my_use_symdir)
  {
    my_disable_symlinks=1;
    have_symlink=SHOW_OPTION_DISABLED;
  }
#endif
4737 4738 4739 4740 4741 4742
  if (opt_debugging)
  {
    /* Allow break with SIGINT, no core or stack trace */
    test_flags|= TEST_SIGINT | TEST_NO_STACKTRACE;
    test_flags&= ~TEST_CORE_ON_SIGNAL;
  }
4743 4744 4745
  /* Set global MyISAM variables from delay_key_write_options */
  fix_delay_key_write((THD*) 0, OPT_GLOBAL);

4746 4747
  if (mysqld_chroot)
    set_root(mysqld_chroot);
unknown's avatar
unknown committed
4748
  fix_paths();
unknown's avatar
unknown committed
4749

unknown's avatar
unknown committed
4750 4751 4752 4753
  /*
    Set some global variables from the global_system_variables
    In most cases the global variables will not be used
  */
4754
  my_disable_locking= myisam_single_user= test(opt_external_locking == 0);
unknown's avatar
unknown committed
4755
  my_default_record_cache_size=global_system_variables.read_buff_size;
4756
  myisam_max_temp_length=
4757
    (my_off_t) global_system_variables.myisam_max_sort_file_size;
4758
  myisam_max_extra_temp_length= 
4759
    (my_off_t) global_system_variables.myisam_max_extra_sort_file_size;
unknown's avatar
unknown committed
4760

unknown's avatar
unknown committed
4761
  /* Set global variables based on startup options */
unknown's avatar
unknown committed
4762
  myisam_block_size=(uint) 1 << my_bit_log2(opt_myisam_block_size);
unknown's avatar
unknown committed
4763 4764 4765 4766 4767 4768
}


static char *get_relative_path(const char *path)
{
  if (test_if_hard_path(path) &&
4769
      is_prefix(path,DEFAULT_MYSQL_HOME) &&
unknown's avatar
unknown committed
4770 4771
      strcmp(DEFAULT_MYSQL_HOME,FN_ROOTDIR))
  {
unknown's avatar
unknown committed
4772
    path+=(uint) strlen(DEFAULT_MYSQL_HOME);
unknown's avatar
unknown committed
4773 4774 4775 4776 4777 4778 4779
    while (*path == FN_LIBCHAR)
      path++;
  }
  return (char*) path;
}


4780 4781 4782 4783 4784 4785 4786 4787 4788 4789 4790 4791 4792 4793 4794 4795 4796 4797 4798 4799 4800 4801
/*
  Fix filename and replace extension where 'dir' is relative to
  mysql_real_data_home.
  Return 1 if len(path) > FN_REFLEN
*/

bool
fn_format_relative_to_data_home(my_string to, const char *name,
				const char *dir, const char *extension)
{
  char tmp_path[FN_REFLEN];
  if (!test_if_hard_path(dir))
  {
    strxnmov(tmp_path,sizeof(tmp_path)-1, mysql_real_data_home,
	     dir, NullS);
    dir=tmp_path;
  }
  return !fn_format(to, name, dir, extension,
		    MY_REPLACE_EXT | MY_UNPACK_FILENAME | MY_SAFE_PATH);
}


unknown's avatar
unknown committed
4802 4803
static void fix_paths(void)
{
4804
  char buff[FN_REFLEN],*pos;
4805
  convert_dirname(mysql_home,mysql_home,NullS);
4806
  /* Resolve symlinks to allow 'mysql_home' to be a relative symlink */
4807
  my_realpath(mysql_home,mysql_home,MYF(0));
4808 4809 4810 4811 4812 4813 4814
  /* Ensure that mysql_home ends in FN_LIBCHAR */
  pos=strend(mysql_home);
  if (pos[-1] != FN_LIBCHAR)
  {
    pos[0]= FN_LIBCHAR;
    pos[1]= 0;
  }
4815 4816
  convert_dirname(mysql_real_data_home,mysql_real_data_home,NullS);
  convert_dirname(language,language,NullS);
unknown's avatar
unknown committed
4817 4818 4819 4820
  (void) my_load_path(mysql_home,mysql_home,""); // Resolve current dir
  (void) my_load_path(mysql_real_data_home,mysql_real_data_home,mysql_home);
  (void) my_load_path(pidfile_name,pidfile_name,mysql_real_data_home);

unknown's avatar
unknown committed
4821
  char *sharedir=get_relative_path(SHAREDIR);
unknown's avatar
unknown committed
4822
  if (test_if_hard_path(sharedir))
unknown's avatar
unknown committed
4823
    strmake(buff,sharedir,sizeof(buff)-1);		/* purecov: tested */
unknown's avatar
unknown committed
4824
  else
unknown's avatar
unknown committed
4825
    strxnmov(buff,sizeof(buff)-1,mysql_home,sharedir,NullS);
4826
  convert_dirname(buff,buff,NullS);
unknown's avatar
unknown committed
4827 4828 4829 4830 4831
  (void) my_load_path(language,language,buff);

  /* If --character-sets-dir isn't given, use shared library dir */
  if (charsets_dir != mysql_charsets_dir)
  {
unknown's avatar
unknown committed
4832 4833
    strxnmov(mysql_charsets_dir, sizeof(mysql_charsets_dir)-1, buff,
	     CHARSET_DIR, NullS);
unknown's avatar
unknown committed
4834 4835 4836
    charsets_dir=mysql_charsets_dir;
  }

unknown's avatar
unknown committed
4837
  char *end=convert_dirname(buff, opt_mysql_tmpdir, NullS);
4838 4839
  if (!(mysql_tmpdir= my_memdup((byte*) buff,(uint) (end-buff)+1,
				MYF(MY_FAE))))
unknown's avatar
unknown committed
4840
    exit(1);
4841 4842
  if (!slave_load_tmpdir)
  {
unknown's avatar
unknown committed
4843 4844
    if (!(slave_load_tmpdir = (char*) my_strdup(mysql_tmpdir, MYF(MY_FAE))))
      exit(1);
4845
  }
unknown's avatar
unknown committed
4846 4847 4848
}


unknown's avatar
unknown committed
4849

unknown's avatar
unknown committed
4850 4851 4852 4853 4854 4855 4856 4857 4858 4859 4860 4861 4862 4863
#ifdef SET_RLIMIT_NOFILE
static uint set_maximum_open_files(uint max_file_limit)
{
  struct rlimit rlimit;
  ulong old_cur;

  if (!getrlimit(RLIMIT_NOFILE,&rlimit))
  {
    old_cur=rlimit.rlim_cur;
    if (rlimit.rlim_cur >= max_file_limit)	// Nothing to do
      return rlimit.rlim_cur;			/* purecov: inspected */
    rlimit.rlim_cur=rlimit.rlim_max=max_file_limit;
    if (setrlimit(RLIMIT_NOFILE,&rlimit))
    {
unknown's avatar
unknown committed
4864 4865
      sql_print_error("Warning: setrlimit couldn't increase number of open files to more than %lu (request: %u)",
		      old_cur, max_file_limit);	/* purecov: inspected */
unknown's avatar
unknown committed
4866 4867 4868 4869 4870 4871
      max_file_limit=old_cur;
    }
    else
    {
      (void) getrlimit(RLIMIT_NOFILE,&rlimit);
      if ((uint) rlimit.rlim_cur != max_file_limit)
unknown's avatar
unknown committed
4872 4873 4874
	sql_print_error("Warning: setrlimit returned ok, but didn't change limits. Max open files is %ld (request: %u)",
			(ulong) rlimit.rlim_cur,
			max_file_limit); /* purecov: inspected */
unknown's avatar
unknown committed
4875 4876 4877 4878 4879 4880 4881
      max_file_limit=rlimit.rlim_cur;
    }
  }
  return max_file_limit;
}
#endif

unknown's avatar
unknown committed
4882 4883 4884 4885 4886 4887 4888 4889 4890 4891 4892 4893 4894 4895 4896 4897 4898 4899 4900 4901 4902 4903 4904
#ifdef OS2
static uint set_maximum_open_files(uint max_file_limit)
{
   LONG     cbReqCount;
   ULONG    cbCurMaxFH, cbCurMaxFH0;
   APIRET   ulrc;

   // get current limit
   cbReqCount = 0;
   DosSetRelMaxFH( &cbReqCount, &cbCurMaxFH0);

   // set new limit
   cbReqCount = max_file_limit - cbCurMaxFH0;
   ulrc = DosSetRelMaxFH( &cbReqCount, &cbCurMaxFH);
   if (ulrc) {
      sql_print_error("Warning: DosSetRelMaxFH couldn't increase number of open files to more than %d",
         cbCurMaxFH0);
      cbCurMaxFH = cbCurMaxFH0;
   }

   return cbCurMaxFH;
}
#endif
unknown's avatar
unknown committed
4905

4906 4907 4908 4909
/*
  Return a bitfield from a string of substrings separated by ','
  returns ~(ulong) 0 on error.
*/
4910 4911 4912 4913 4914 4915 4916 4917 4918 4919 4920 4921 4922 4923

static ulong find_bit_type(const char *x, TYPELIB *bit_lib)
{
  bool found_end;
  int  found_count;
  const char *end,*i,*j;
  const char **array, *pos;
  ulong found,found_int,bit;
  DBUG_ENTER("find_bit_type");
  DBUG_PRINT("enter",("x: '%s'",x));

  found=0;
  found_end= 0;
  pos=(my_string) x;
4924 4925 4926
  while (*pos == ' ') pos++;
  found_end= *pos == 0;
  while (!found_end)
4927 4928 4929 4930
  {
    if (!*(end=strcend(pos,',')))		/* Let end point at fieldend */
    {
      while (end > pos && end[-1] == ' ')
unknown's avatar
unknown committed
4931
	end--;					/* Skip end-space */
4932 4933 4934 4935 4936 4937 4938 4939 4940 4941 4942 4943 4944 4945 4946 4947 4948 4949 4950 4951 4952 4953 4954 4955 4956 4957 4958
      found_end=1;
    }
    found_int=0; found_count=0;
    for (array=bit_lib->type_names, bit=1 ; (i= *array++) ; bit<<=1)
    {
      j=pos;
      while (j != end)
      {
	if (toupper(*i++) != toupper(*j++))
	  goto skipp;
      }
      found_int=bit;
      if (! *i)
      {
	found_count=1;
	break;
      }
      else if (j != pos)			// Half field found
      {
	found_count++;				// Could be one of two values
      }
skipp: ;
    }
    if (found_count != 1)
      DBUG_RETURN(~(ulong) 0);				// No unique value
    found|=found_int;
    pos=end+1;
4959
  }
4960 4961 4962 4963 4964 4965

  DBUG_PRINT("exit",("bit-field: %ld",(ulong) found));
  DBUG_RETURN(found);
} /* find_bit_type */


unknown's avatar
unknown committed
4966
/*****************************************************************************
4967
  Instantiate templates
unknown's avatar
unknown committed
4968 4969 4970 4971 4972 4973 4974
*****************************************************************************/

#ifdef __GNUC__
/* Used templates */
template class I_List<THD>;
template class I_List_iterator<THD>;
template class I_List<i_string>;
4975
template class I_List<i_string_pair>;
unknown's avatar
unknown committed
4976 4977

FIX_GCC_LINKING_PROBLEM
unknown's avatar
unknown committed
4978
#endif