mysqld.cc 170 KB
Newer Older
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1
/* Copyright (C) 2000-2003 MySQL AB
2

bk@work.mysql.com's avatar
bk@work.mysql.com 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

bk@work.mysql.com's avatar
bk@work.mysql.com 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

bk@work.mysql.com's avatar
bk@work.mysql.com 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>
bk@work.mysql.com's avatar
bk@work.mysql.com committed
20
#include "sql_acl.h"
21
#include "slave.h"
22
#include "sql_repl.h"
23
#include "repl_failsafe.h"
24
#include "stacktrace.h"
bk@work.mysql.com's avatar
bk@work.mysql.com 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
bk@work.mysql.com's avatar
bk@work.mysql.com committed
31 32 33 34
#include "ha_myisam.h"
#include <nisam.h>
#include <thr_alarm.h>
#include <ft_global.h>
35
#include <assert.h>
bk@work.mysql.com's avatar
bk@work.mysql.com 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

45 46 47 48 49 50
#ifdef PURIFY
#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__ */

58 59 60 61
#if defined(HAVE_DEC_3_2_THREADS) || defined(SIGNALS_DONT_BREAK_READ)
#define HAVE_CLOSE_SERVER_SOCK 1
#endif  

bk@work.mysql.com's avatar
bk@work.mysql.com 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
bk@work.mysql.com's avatar
bk@work.mysql.com committed
67
#endif
68
#include <my_getopt.h>
bk@work.mysql.com's avatar
bk@work.mysql.com 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

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
79 80 81
#if defined(OS2)
#  include <sys/un.h>
#elif !defined( __WIN__)
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
82
#  ifndef __NETWARE__
bk@work.mysql.com's avatar
bk@work.mysql.com committed
83
#include <sys/resource.h>
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
84
#  endif /* __NETWARE__ */
bk@work.mysql.com's avatar
bk@work.mysql.com 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>
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
96
#endif /* __WIN__ */
bk@work.mysql.com's avatar
bk@work.mysql.com 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
bk@work.mysql.com's avatar
bk@work.mysql.com committed
116 117
#endif /* HAVE_LIBWRAP */

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

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi 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__ */

serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
131
#ifdef _AIX41
132
int initgroups(const char *,unsigned int);
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
133 134
#endif

bk@work.mysql.com's avatar
bk@work.mysql.com 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 */
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));
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
151
#else
152 153 154
 fpsetmask(~(FP_X_INV |             FP_X_OFL | FP_X_UFL | FP_X_DZ |
	     FP_X_IMP));
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
155 156 157 158 159
}
#else
#define reset_floating_point_exceptions()
#endif /* __FreeBSD__ && HAVE_IEEEFP_H */

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
160 161
} /* cplusplus */

bk@work.mysql.com's avatar
bk@work.mysql.com 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)
bk@work.mysql.com's avatar
bk@work.mysql.com 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");
bk@work.mysql.com's avatar
bk@work.mysql.com 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;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
201 202
#endif

monty@donna.mysql.fi's avatar
monty@donna.mysql.fi committed
203 204 205 206 207 208 209 210 211 212 213 214 215 216
/* Set prefix for windows binary */
#ifdef __WIN__
#undef MYSQL_SERVER_SUFFIX
#ifdef __NT__
#if defined(HAVE_INNOBASE_DB) || defined(HAVE_BERKELEY_DB)
#define MYSQL_SERVER_SUFFIX "-max-nt"
#else
#define MYSQL_SERVER_SUFFIX "-nt"
#endif /* ...DB */
#elif defined(HAVE_INNOBASE_DB) || defined(HAVE_BERKELEY_DB)
#define MYSQL_SERVER_SUFFIX "-max"
#else
#define MYSQL_SERVER_SUFFIX ""
#endif /* __NT__ */
217
#endif /* __WIN__ */
monty@donna.mysql.fi's avatar
monty@donna.mysql.fi 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
225
SHOW_COMP_OPTION have_innodb=SHOW_OPTION_YES;
226
#else
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
tonu@x153.internalnet's avatar
tonu@x153.internalnet committed
240
SHOW_COMP_OPTION have_openssl=SHOW_OPTION_YES;
241
#else
tonu@x153.internalnet's avatar
tonu@x153.internalnet 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
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
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi 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

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

267 268 269
#ifdef HAVE_LIBWRAP
char *libwrapName= NULL;
#endif
270 271 272 273

/*
  Variables to store startup options
*/
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; 
281

282
ulong back_log, connect_timeout, concurrency;
283
char mysql_home[FN_REFLEN], pidfile_name[FN_REFLEN], time_zone[30];
284
char log_error_file[FN_REFLEN];
285
bool opt_log, opt_update_log, opt_bin_log, opt_slow_log;
286
bool opt_error_log= IF_WIN(1,0);
287
bool opt_disable_networking=0, opt_skip_show_db=0;
288
my_bool opt_enable_named_pipe= 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;
291

292
static bool opt_do_pstack = 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
293
static ulong opt_specialflag=SPECIAL_ENGLISH;
294

295 296
static ulong opt_myisam_block_size;
static my_socket unix_sock= INVALID_SOCKET,ip_sock= INVALID_SOCKET;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
297
static my_string opt_logname=0,opt_update_logname=0,
298
       opt_binlog_index_name = 0,opt_slow_logname=0;
299

300 301
static char* mysql_home_ptr= mysql_home;
static char* pidfile_name_ptr= pidfile_name;
302
char* log_error_file_ptr= log_error_file;
bk@work.mysql.com's avatar
bk@work.mysql.com 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

310
volatile bool  mqh_used = 0;
311
FILE *bootstrap_file=0;
312
int segfaulted = 0; // ensure we do not enter SIGSEGV handler twice
bk@work.mysql.com's avatar
bk@work.mysql.com committed
313

314 315 316 317
/*
  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
*/
bk@work.mysql.com's avatar
bk@work.mysql.com committed
318 319

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

325
#include "sslopt-vars.h"
bk@work.mysql.com's avatar
bk@work.mysql.com committed
326
#ifdef HAVE_OPENSSL
327
char *des_key_file = 0;
328
struct st_VioSSLAcceptorFd *ssl_acceptor_fd= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
329 330
#endif /* HAVE_OPENSSL */

sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
331
I_List <i_string_pair> replicate_rewrite_db;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
332 333 334 335
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;

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

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

bk@work.mysql.com's avatar
bk@work.mysql.com committed
366 367
volatile ulong cached_thread_count=0;

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

381
ulong master_retry_count=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
382 383
ulong bytes_sent = 0L, bytes_received = 0L;

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

417
static char *opt_bin_logname = 0;
418
char *opt_relay_logname = 0, *opt_relaylog_index_name=0;
419
char server_version[SERVER_VERSION_LENGTH]=MYSQL_SERVER_VERSION;
bk@work.mysql.com's avatar
bk@work.mysql.com 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";
424
ulong rpl_recovery_rank=0;
425

426
my_string mysql_unix_port=NULL, opt_mysql_tmpdir=NULL, mysql_tmpdir=NULL;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
427
ulong my_bind_addr;			/* the address we bind to */
428
char *my_bind_addr_str;
bk@work.mysql.com's avatar
bk@work.mysql.com 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};
440

441
MY_BITMAP temp_pool;
442
my_bool use_temp_pool=0;
443

bk@work.mysql.com's avatar
bk@work.mysql.com 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;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
454

455 456
pthread_cond_t COND_refresh,COND_thread_count, COND_slave_stopped,
	       COND_slave_start;
bk@work.mysql.com's avatar
bk@work.mysql.com 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>
464
#if !defined(EMBEDDED_LIBRARY)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
465
HANDLE hEventShutdown;
466
static char shutdown_event_name[40];
bk@work.mysql.com's avatar
bk@work.mysql.com committed
467 468 469
#include "nt_servc.h"
static	 NTService  Service;	      // Service object for WinNT
#endif
470
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
471

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi 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);
bk@work.mysql.com's avatar
bk@work.mysql.com 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);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
484
static int bootstrap(FILE *file);
485
static void close_server_sock();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
486 487
static bool read_init_file(char *file_name);
#ifdef __NT__
488
extern "C" pthread_handler_decl(handle_connections_namedpipes,arg);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
489
#endif
490
extern "C" pthread_handler_decl(handle_slave,arg);
bk@work.mysql.com's avatar
bk@work.mysql.com 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);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
495
static void clean_up(bool print_message);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
496
static void clean_up_mutexes(void);
bk@work.mysql.com's avatar
bk@work.mysql.com 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)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
517
  {
518 519
    DBUG_PRINT("quit",("killing manager thread: %lx",manager_thread));
   (void) pthread_cond_signal(&COND_manager);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
520
  }
521
  (void) pthread_mutex_unlock(&LOCK_manager);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
522 523

  /* kill connection thread */
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
524
#if !defined(__WIN__) && !defined(__EMX__) && !defined(OS2) && !defined(__NETWARE__)
bk@work.mysql.com's avatar
bk@work.mysql.com 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);
bk@work.mysql.com's avatar
bk@work.mysql.com 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
549
    close_server_sock();
bk@work.mysql.com's avatar
bk@work.mysql.com 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__
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
567
  if (hPipe != INVALID_HANDLE_VALUE && opt_enable_named_pipe)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
568
  {
monty@hundin.mysql.fi's avatar
merge  
monty@hundin.mysql.fi committed
569
    HANDLE temp;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
570
    DBUG_PRINT( "quit", ("Closing named pipes") );
571
     
monty@hundin.mysql.fi's avatar
merge  
monty@hundin.mysql.fi 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);
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
588 589 590 591 592 593 594 595 596 597 598 599
  }
#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
  end_thr_alarm();			 // Don't allow alarms
600
  end_slave();
bk@work.mysql.com's avatar
bk@work.mysql.com 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;
616 617
      pthread_mutex_lock(&tmp->mysys_var->mutex);
      if (tmp->mysys_var->current_cond)
bk@work.mysql.com's avatar
bk@work.mysql.com 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);
      }
623
      pthread_mutex_unlock(&tmp->mysys_var->mutex);
bk@work.mysql.com's avatar
bk@work.mysql.com 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 */

633
  (void) my_net_init(&net, (st_vio*) 0);
bk@work.mysql.com's avatar
bk@work.mysql.com 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;
}

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
670

671
static void close_server_sock()
672
{
673
#ifdef HAVE_CLOSE_SERVER_SOCK
674
  DBUG_ENTER("close_server_sock");
675 676 677
  my_socket tmp_sock;
  tmp_sock=ip_sock;
  if (tmp_sock != INVALID_SOCKET)
678 679
  {
    ip_sock=INVALID_SOCKET;
680
    DBUG_PRINT("info",("calling shutdown on TCP/IP socket"));
681
    VOID(shutdown(tmp_sock,2));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
682
#if defined(__NETWARE__)
683
    /*
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi 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
690
  }
691 692
  tmp_sock=unix_sock;
  if (tmp_sock != INVALID_SOCKET)
693
  {
694
    unix_sock=INVALID_SOCKET;
695
    DBUG_PRINT("info",("calling shutdown on unix socket"));
696
    VOID(shutdown(tmp_sock,2));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
697
#if defined(__NETWARE__)
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
698
    /*
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
699
      The following code is disabled for normal systems as it causes MySQL
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi 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));
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
704
#endif
705 706 707 708
    VOID(unlink(mysql_unix_port));
  }
  DBUG_VOID_RETURN;
#endif
709
}
710

711

bk@work.mysql.com's avatar
bk@work.mysql.com committed
712 713 714 715
void kill_mysql(void)
{
  DBUG_ENTER("kill_mysql");

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

bk@work.mysql.com's avatar
bk@work.mysql.com committed
721
#if defined(__WIN__)
722
#if !defined(EMBEDDED_LIBRARY)
bk@work.mysql.com's avatar
bk@work.mysql.com 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);
    */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
734
  }
735
#endif
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
736 737
#elif defined(OS2)
  pthread_cond_signal( &eventShutdown);		// post semaphore
bk@work.mysql.com's avatar
bk@work.mysql.com committed
738
#elif defined(HAVE_PTHREAD_KILL)
739
  if (pthread_kill(signal_thread, MYSQL_KILL_SIGNAL))
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);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
745
#endif
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)
750 751
  {
    pthread_t tmp;
752
    abort_loop=1;
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");
  }
757
#endif    
758
  DBUG_VOID_RETURN;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
759 760 761 762 763
}


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

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
764
#if defined(OS2) || defined(__NETWARE__)
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
765
extern "C" void kill_server(int sig_ptr)
766
#define RETURN_FROM_KILL_SERVER DBUG_VOID_RETURN
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
767
#elif !defined(__WIN__)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
768
static void *kill_server(void *sig_ptr)
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
769
#define RETURN_FROM_KILL_SERVER DBUG_RETURN(0)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
770 771
#else
static void __cdecl kill_server(int sig_ptr)
miguel@hegel.local's avatar
miguel@hegel.local committed
772
#define RETURN_FROM_KILL_SERVER DBUG_VOID_RETURN
bk@work.mysql.com's avatar
bk@work.mysql.com 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
bk@work.mysql.com's avatar
bk@work.mysql.com 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 */

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
789
#if defined(__NETWARE__) || (defined(USE_ONE_SIGNAL_HAND) && !defined(__WIN__) && !defined(OS2))
bk@work.mysql.com's avatar
bk@work.mysql.com 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();
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
797 798 799 800

#ifdef __NETWARE__
  pthread_join(select_thread, NULL);		// wait for main thread
#else
bk@work.mysql.com's avatar
bk@work.mysql.com committed
801
  pthread_exit(0);				/* purecov: deadcode */
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
802 803
#endif /* __NETWARE__ */

bk@work.mysql.com's avatar
bk@work.mysql.com committed
804 805 806 807
  RETURN_FROM_KILL_SERVER;
}


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi 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)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
810
{
811
  SHUTDOWN_THD;
bk@work.mysql.com's avatar
bk@work.mysql.com 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

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi 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)
bk@work.mysql.com's avatar
bk@work.mysql.com 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());
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
832 833 834
#ifdef DONT_REMEMBER_SIGNAL
  sigset(sig,print_signal_warning);		/* int. thread system calls */
#endif
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
835
#if !defined(__WIN__) && !defined(OS2) && !defined(__NETWARE__)
bk@work.mysql.com's avatar
bk@work.mysql.com 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().
*/
bk@work.mysql.com's avatar
bk@work.mysql.com committed
854

855
void unireg_end(void)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
856
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
857
  clean_up(1);
858
  my_thread_end();
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
859
#ifndef __NETWARE__
860 861 862
#ifdef SIGNALS_DONT_BREAK_READ
  exit(0);
#else
bk@work.mysql.com's avatar
bk@work.mysql.com committed
863
  pthread_exit(0);				// Exit is in main thread
864
#endif
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
865
#endif /* __NETWARE__ */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
866 867 868
}


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


883
void clean_up(bool print_message)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
884 885 886 887
{
  DBUG_PRINT("exit",("clean_up"));
  if (cleanup_done++)
    return; /* purecov: inspected */
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
888 889 890 891 892 893

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

sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
894 895
  if (use_slave_mask)
    bitmap_free(&slave_error_mask);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
896 897
  acl_free(1);
  grant_free();
898
  query_cache_destroy();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
899 900 901 902
  table_cache_free();
  hostname_cache_free();
  item_user_lock_free();
  lex_free();				/* Free some memory */
903
  set_var_free();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
904 905 906 907
#ifdef HAVE_DLOPEN
  if (!opt_noacl)
    udf_free();
#endif
908
  (void) ha_panic(HA_PANIC_CLOSE);	/* close all tables and logs */
909
  end_key_cache();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
910 911 912
#ifdef USE_RAID
  end_raid();
#endif
913 914
  if (defaults_argv)
    free_defaults(defaults_argv);
915
  my_free(charsets_list, MYF(MY_ALLOW_ZERO_PTR));
916
  my_free(mysql_tmpdir,MYF(MY_ALLOW_ZERO_PTR));
917
  my_free(slave_load_tmpdir,MYF(MY_ALLOW_ZERO_PTR));
918
  x_free(opt_bin_logname);
919
  x_free(opt_relay_logname);
920
  bitmap_free(&temp_pool);
921
  free_max_user_conn();
922
  end_slave_list();
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
923 924 925
#ifdef HAVE_OPENSSL
  free_des_key_file();
#endif /* HAVE_OPENSSL */
926 927 928
#ifdef USE_REGEX
  regex_end();
#endif
929

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


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981
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_timezone);
  (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);
}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
982 983 984 985 986 987 988 989

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

static void set_ports()
{
  char	*env;
990
  if (!mysql_port && !opt_disable_networking)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014
  {					// 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)
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1015
#if !defined(__WIN__) && !defined(OS2) && !defined(__NETWARE__)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037
    struct passwd *ent;

  // don't bother if we aren't superuser
  if (geteuid())
  {
    if (user)
      fprintf(stderr,
	      "Warning: One can only use the --user switch if running as root\n");
    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

1038
  uid_t uid;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1039 1040
  if (!(ent = getpwnam(user)))
  {
1041 1042 1043 1044 1045 1046 1047 1048 1049
    // 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
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1050
  }
1051 1052
  else
  {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1053
#ifdef HAVE_INITGROUPS
1054
    initgroups((char*) user,ent->pw_gid);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1055
#endif
1056 1057 1058 1059 1060 1061
    if (setgid(ent->pw_gid) == -1)
    {
      sql_perror("setgid");
      unireg_abort(1);
    }
    uid=ent->pw_uid;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1062
  }
1063 1064

  if (setuid(uid) == -1)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075
  {
    sql_perror("setuid");
    unireg_abort(1);
  }
#endif
}

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

static void set_root(const char *path)
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1076
#if !defined(__WIN__) && !defined(__EMX__) && !defined(OS2) && !defined(__NETWARE__)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1077 1078 1079 1080 1081
  if (chroot(path) == -1)
  {
    sql_perror("chroot");
    unireg_abort(1);
  }
1082
  my_setwd("/", MYF(0));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 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
#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));
1124 1125
    if (bind(ip_sock, my_reinterpret_cast(struct sockaddr *) (&IPaddr),
	     sizeof(IPaddr)) < 0)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1126 1127
    {
      DBUG_PRINT("error",("Got error: %d from bind",socket_errno));
1128
      sql_perror("Can't start server: Bind on TCP/IP port");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1129 1130 1131
      sql_print_error("Do you already have another mysqld server running on port: %d ?",mysql_port);
      unireg_abort(1);
    }
1132
    if (listen(ip_sock,(int) back_log) < 0)
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
1133
    {
1134
      sql_perror("Can't start server: listen() on TCP/IP port");
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
1135
      sql_print_error("Error:  listen() on TCP/IP failed with error %d",
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1136
		      socket_errno);
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
1137 1138
      unireg_abort(1);
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1139
  }
1140
  set_user(mysqld_user);		// Works also with mysqld_user==NULL
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1141 1142 1143

#ifdef __NT__
  /* create named pipe */
1144 1145
  if (Service.IsNT() && mysql_unix_port[0] && !opt_bootstrap &&
      opt_enable_named_pipe)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169
  {
    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,
1170 1171
				 (int) global_system_variables.net_buffer_length,
				 (int) global_system_variables.net_buffer_length,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188
				 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

1189
#if defined(HAVE_SYS_UN_H)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219
  /*
  ** 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
1220 1221
    if (listen(unix_sock,(int) back_log) < 0)
      sql_print_error("Warning:  listen() on Unix socket failed with error %d",
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1222
		      socket_errno);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242
  }
#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;
  if (!strcmp(s,"parse error"))
    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)
{
1243
  st_vio* vio;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263
  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 */

1264
extern "C" sig_handler end_thread_signal(int sig __attribute__((unused)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1265 1266 1267
{
  THD *thd=current_thd;
  DBUG_ENTER("end_thread_signal");
1268
  if (thd && ! thd->bootstrap)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1269 1270 1271 1272 1273 1274 1275 1276
    end_thread(thd,0);
  DBUG_VOID_RETURN;				/* purecov: deadcode */
}


void end_thread(THD *thd, bool put_in_cache)
{
  DBUG_ENTER("end_thread");
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1277
  thd->cleanup();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1278 1279 1280
  (void) pthread_mutex_lock(&LOCK_thread_count);
  thread_count--;
  delete thd;
1281

1282 1283
  if (put_in_cache && cached_thread_count < thread_cache_size &&
      ! abort_loop && !kill_cached_threads)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296
  {
    /* 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();
1297
      thd->real_id=pthread_self();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1298
      (void) thd->store_globals();
1299
      threads.append(thd);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1300 1301 1302 1303 1304 1305 1306 1307 1308
      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);
1309
  /* It's safe to broadcast outside a lock (COND... is not deleted here) */
1310
  (void) pthread_cond_broadcast(&COND_thread_count);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1311
  DBUG_PRINT("info", ("unlocked thread_count mutex"))
1312
#ifdef ONE_THREAD
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347
  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);
}


1348 1349 1350 1351 1352
/*
  Aborts a thread nicely. Commes here on SIGPIPE
  TODO: One should have to fix that thr_alarm know about this
  thread too.
*/
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1353 1354

#ifdef THREAD_SPECIFIC_SIGPIPE
1355
extern "C" sig_handler abort_thread(int sig __attribute__((unused)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1356 1357 1358 1359 1360 1361 1362 1363 1364 1365
{
  THD *thd=current_thd;
  DBUG_ENTER("abort_thread");
  if (thd)
    thd->killed=1;
  DBUG_VOID_RETURN;
}
#endif

/******************************************************************************
1366 1367 1368
  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
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1369 1370
******************************************************************************/

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1371
#if defined(__WIN__) || defined(OS2)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1372 1373 1374 1375 1376
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) ;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1377
#if defined(__WIN__)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1378
  signal(SIGBREAK,SIG_IGN);	//ignore SIGBREAK for NT
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1379 1380 1381
#else
  signal(SIGBREAK, kill_server);
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1382 1383
}

1384
static void start_signal_handler(void)
1385 1386 1387 1388
{}

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

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 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
#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)
{
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1452 1453 1454
#elif defined(__EMX__)
static void sig_reload(int signo)
{
1455 1456
 // Flush everything
  reload_acl_and_cache((THD*) 0,REFRESH_LOG, (TABLE_LIST*) 0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1457 1458 1459 1460 1461
  signal(signo, SIG_ACK);
}

static void sig_kill(int signo)
{
1462
  if (!kill_in_progress)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479
  {
    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();
1480
  SIGNAL_THD;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1481
}
1482 1483

static void start_signal_handler(void)
1484
{}
1485

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1486
static void check_data_home(const char *path)
1487
{}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1488

1489
#else /* if ! __WIN__ && ! __EMX__ */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1490

1491 1492
#ifdef HAVE_LINUXTHREADS
#define UNSAFE_DEFAULT_LINUX_THREADS 200
1493
#endif
1494

1495
extern "C" sig_handler handle_segfault(int sig)
1496
{
1497
  THD *thd=current_thd;
1498 1499 1500 1501 1502 1503
  /*
    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
  */
1504
  if (segfaulted)
1505 1506 1507 1508
  {
    fprintf(stderr, "Fatal signal %d while backtracing\n", sig);
    exit(1);
  }
1509
  
1510
  segfaulted = 1;
1511
  fprintf(stderr,"\
1512
mysqld got signal %d;\n\
1513
This could be because you hit a bug. It is also possible that this binary\n\
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1514
or one of the libraries it was linked against is corrupt, improperly built,\n\
1515 1516 1517 1518 1519
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\
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1520
and this may fail.\n\n");
1521
  fprintf(stderr, "key_buffer_size=%lu\n", (ulong) keybuff_size);
1522 1523
  fprintf(stderr, "read_buffer_size=%ld\n", global_system_variables.read_buff_size);
  fprintf(stderr, "sort_buffer_size=%ld\n", thd->variables.sortbuff_size);
1524 1525 1526 1527
  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\
1528
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = %ld K\n\
1529 1530 1531
bytes of memory\n", ((ulong) keybuff_size +
		     (global_system_variables.read_buff_size +
		      thd->variables.sortbuff_size) *
1532
		     max_connections)/ 1024);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1533
  fprintf(stderr, "Hope that's ok; if not, decrease some variables in the equation.\n\n");
1534
  
1535
#if defined(HAVE_LINUXTHREADS)
1536 1537 1538 1539
  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\
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1540 1541
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\
1542 1543 1544 1545
the thread stack. Please read http://www.mysql.com/doc/L/i/Linux.html\n\n",
	    thread_count);
  }
#endif /* HAVE_LINUXTHREADS */
1546

1547
#ifdef HAVE_STACKTRACE
1548
  if (!(test_flags & TEST_NO_STACKTRACE))
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1549
  {
1550
    fprintf(stderr,"thd=%p\n",thd);
1551 1552
    print_stacktrace(thd ? (gptr) thd->thread_stack : (gptr) 0,
		     thread_stack);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1553
  }
1554 1555 1556 1557 1558 1559
  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);
1560
    fprintf(stderr, "\n\
1561 1562
Successfully dumped variables, if you ran with --log, take a look at the\n\
details of what thread %ld did to cause the crash.  In some cases of really\n\
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1563
bad corruption, the values shown above may be invalid.\n\n",
1564 1565 1566
	  thd->thread_id);
  }
  fprintf(stderr, "\
1567
The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains\n\
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1568
information that should help you find out what is causing the crash.\n");
1569
  fflush(stderr);
1570 1571
#endif /* HAVE_STACKTRACE */

1572
 if (test_flags & TEST_CORE_ON_SIGNAL)
1573 1574 1575
 {
   fprintf(stderr, "Writing a core file\n");
   fflush(stderr);
1576
   write_core(sig);
1577
 }
1578
 exit(1);
1579 1580
}

1581 1582 1583 1584 1585 1586
#ifndef SA_RESETHAND
#define SA_RESETHAND 0
#endif
#ifndef SA_NODEFER
#define SA_NODEFER 0
#endif
1587

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1588 1589 1590 1591 1592 1593 1594
static void init_signals(void)
{
  sigset_t set;
  DBUG_ENTER("init_signals");

  sigset(THR_KILL_SIGNAL,end_thread_signal);
  sigset(THR_SERVER_ALARM,print_signal_warning); // Should never be called!
1595

sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
1596
  if (!(test_flags & TEST_NO_STACKTRACE) || (test_flags & TEST_CORE_ON_SIGNAL))
1597
  {
1598 1599 1600 1601 1602
    struct sigaction sa;
    sa.sa_flags = SA_RESETHAND | SA_NODEFER;
    sigemptyset(&sa.sa_mask);
    sigprocmask(SIG_SETMASK,&sa.sa_mask,NULL);

1603
    init_stacktrace();
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1604 1605 1606
#if defined(__amiga__)
    sa.sa_handler=(void(*)())handle_segfault;
#else
1607
    sa.sa_handler=handle_segfault;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1608
#endif
1609
    sigaction(SIGSEGV, &sa, NULL);
1610
#ifdef SIGBUS
1611
    sigaction(SIGBUS, &sa, NULL);
1612
#endif
1613
    sigaction(SIGILL, &sa, NULL);
1614
    sigaction(SIGFPE, &sa, NULL);
1615
  }
1616 1617 1618 1619 1620 1621 1622

#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;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1623
    if (setrlimit(RLIMIT_CORE, &rl) && global_system_variables.log_warnings)
1624 1625 1626
      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
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638
  (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);
1639 1640
  sigset(SIGTERM, print_signal_warning);	// If it's blocked by parent
  sigset(SIGHUP, print_signal_warning);		// If it's blocked by parent
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1641 1642 1643 1644 1645 1646 1647
#ifdef SIGTSTP
  sigaddset(&set,SIGTSTP);
#endif
  sigaddset(&set,THR_SERVER_ALARM);
  sigdelset(&set,THR_KILL_SIGNAL);		// May be SIGINT
  sigdelset(&set,THR_CLIENT_ALARM);		// For alarms
  (void) pthread_sigmask(SIG_SETMASK,&set,NULL);
1648 1649 1650 1651 1652 1653 1654 1655 1656
  DBUG_VOID_RETURN;
}


static void start_signal_handler(void)
{
  int error;
  pthread_attr_t thr_attr;
  DBUG_ENTER("start_signal_handler");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 1680 1681

  (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;
}


1682
/* This threads handles all signals and alarms */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1683 1684

/* ARGSUSED */
1685
extern "C" void *signal_hand(void *arg __attribute__((unused)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1686 1687 1688 1689 1690
{
  sigset_t set;
  int sig;
  my_thread_init();				// Init new thread
  DBUG_ENTER("signal_hand");
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1691 1692
  signal_thread_in_use= 1;

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1693 1694 1695 1696 1697
  /*
    Setup alarm handler
    The two extra handlers are for slave threads
  */
  init_thr_alarm(max_connections+max_insert_delayed_threads+2);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714
#if SIGINT != THR_KILL_SIGNAL
  (void) sigemptyset(&set);			// Setup up SIGINT for debug
  (void) sigaddset(&set,SIGINT);		// For debugging
  (void) pthread_sigmask(SIG_UNBLOCK,&set,NULL);
#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) */
1715
  if (!opt_bootstrap)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1716
  {
1717 1718
    File pidFile;
    if ((pidFile = my_create(pidfile_name,0664, O_WRONLY, MYF(MY_WME))) >= 0)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1719
    {
1720 1721
      char buff[21];
      sprintf(buff,"%lu",(ulong) getpid());
1722
      (void) my_write(pidFile, buff,strlen(buff),MYF(MY_WME));
1723
      (void) my_close(pidFile,MYF(0));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1724 1725
    }
  }
1726 1727 1728 1729 1730 1731 1732
#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 */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1733

1734 1735 1736 1737 1738 1739 1740
  /*
    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.
  */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1741 1742
  (void) pthread_mutex_lock(&LOCK_thread_count);
  (void) pthread_mutex_unlock(&LOCK_thread_count);
1743
  (void) pthread_cond_broadcast(&COND_thread_count);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1744

1745
  (void) pthread_sigmask(SIG_BLOCK,&set,NULL);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1746 1747 1748 1749 1750
  for (;;)
  {
    int error;					// Used when debugging
    if (shutdown_in_progress && !abort_loop)
    {
1751
      sig= SIGTERM;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1752 1753 1754 1755 1756
      error=0;
    }
    else
      while ((error=my_sigwait(&set,&sig)) == EINTR) ;
    if (cleanup_done)
1757 1758
    {
      my_thread_end();
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1759
      signal_thread_in_use= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1760
      pthread_exit(0);				// Safety
1761
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1762 1763 1764 1765 1766 1767 1768 1769 1770 1771 1772 1773 1774 1775 1776 1777 1778 1779 1780
    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
1781
	kill_server((void*) sig);	// MIT THREAD has a alarm thread
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1782 1783 1784 1785
#endif
      }
      break;
    case SIGHUP:
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1786 1787 1788 1789 1790 1791 1792 1793 1794
      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
      }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1795 1796 1797 1798 1799 1800 1801 1802
      break;
#ifdef USE_ONE_SIGNAL_HAND
    case THR_SERVER_ALARM:
      process_alarm(sig);			// Trigger alarms.
      break;
#endif
    default:
#ifdef EXTRA_DEBUG
1803
      sql_print_error("Warning: Got signal: %d  error: %d",sig,error); /* purecov: tested */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1804 1805 1806 1807 1808 1809 1810
#endif
      break;					/* purecov: tested */
    }
  }
  return(0);					/* purecov: deadcode */
}

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1811
static void check_data_home(const char *path)
1812
{}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1813

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1814 1815 1816 1817
#endif	/* __WIN__*/


/*
1818 1819
  All global error messages are sent here where the first one is stored for
  the client
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1820 1821 1822 1823
*/


/* ARGSUSED */
1824 1825
extern "C" int my_message_sql(uint error, const char *str,
			      myf MyFlags __attribute__((unused)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1826 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836 1837 1838 1839 1840 1841 1842
{
  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);
}

1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853

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

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


bk@work.mysql.com's avatar
bk@work.mysql.com committed
1854 1855 1856 1857 1858 1859 1860
#ifdef __WIN__

struct utsname
{
  char nodename[FN_REFLEN];
};

1861

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1862 1863 1864 1865 1866 1867
int uname(struct utsname *a)
{
  return -1;
}


1868
extern "C" pthread_handler_decl(handle_shutdown,arg)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1869 1870
{
  MSG msg;
1871
  SHUTDOWN_THD;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1872 1873 1874 1875
  my_thread_init();

  /* this call should create the message queue for this thread */
  PeekMessage(&msg, NULL, 1, 65534,PM_NOREMOVE);
1876
#if !defined(EMBEDDED_LIBRARY)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1877
  if (WaitForSingleObject(hEventShutdown,INFINITE)==WAIT_OBJECT_0)
1878
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1879 1880 1881 1882
     kill_server(MYSQL_KILL_SIGNAL);
  return 0;
}

1883
int STDCALL handle_kill(ulong ctrl_type)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1884 1885 1886 1887 1888 1889 1890 1891 1892 1893 1894
{
  if (ctrl_type == CTRL_CLOSE_EVENT ||
      ctrl_type == CTRL_SHUTDOWN_EVENT)
  {
    kill_server(MYSQL_KILL_SIGNAL);
    return TRUE;
  }
  return FALSE;
}
#endif

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1895
#ifdef OS2
1896
extern "C" pthread_handler_decl(handle_shutdown,arg)
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1897
{
1898
  SHUTDOWN_THD;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1899 1900 1901 1902 1903 1904 1905 1906
  my_thread_init();

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

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

1907 1908 1909 1910
  /*
    Exit main loop on main thread, so kill will be done from
    main thread (this is thread 2)
  */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1911 1912 1913
  abort_loop = 1;

  // unblock select()
1914 1915
  so_cancel(ip_sock);
  so_cancel(unix_sock);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1916 1917 1918 1919 1920

  return 0;
}
#endif

1921

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1922 1923
const char *load_default_groups[]= { "mysqld","server",0 };

1924 1925 1926 1927 1928
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)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1929 1930 1931 1932
{
  char tmp[FN_REFLEN];
  if (!opt_name || !opt_name[0])
  {
1933 1934 1935
    /*
      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.
1936 1937
    */
    strmake(tmp,hostname,FN_REFLEN-5);
1938
    strmov(fn_ext(tmp),extension);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1939 1940
    opt_name=tmp;
  }
1941
  // get rid of extension if the log is binary to avoid problems
1942 1943
  if (type == LOG_BIN)
  {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1944
    char *p = fn_ext(opt_name);
1945
    if (p)
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1946 1947 1948 1949 1950
    {
      uint length=(uint) (p-opt_name);
      strmake(tmp,opt_name,min(length,FN_REFLEN));
      opt_name=tmp;
    }
1951
  }
1952 1953 1954
  return log->open(opt_name, type, 0, index_file_name,
		   (read_append) ? SEQ_READ_APPEND : WRITE_CACHE,
		   no_auto_events);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968
}



#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
1969
  MAIN_THD;
1970 1971 1972 1973
  /*
    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.
1974 1975 1976
  */
  SIGNAL_THD;
  SHUTDOWN_THD;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1977 1978 1979 1980
  MY_INIT(argv[0]);		// init my_sys library & pthreads
  tzset();			// Set tzname

  start_time=time((time_t*) 0);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1981

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1982 1983 1984 1985 1986 1987 1988 1989
#ifdef OS2
  {
    // fix timezone for daylight saving
    struct tm *ts = localtime(&start_time);
    if (ts->tm_isdst > 0)
      _timezone -= 3600;
  }
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1990 1991 1992 1993 1994
#ifdef HAVE_TZNAME
#if defined(HAVE_LOCALTIME_R) && defined(_REENTRANT)
  {
    struct tm tm_tmp;
    localtime_r(&start_time,&tm_tmp);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1995
    strmov(time_zone,tzname[tm_tmp.tm_isdst != 0 ? 1 : 0]);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1996 1997 1998 1999 2000
  }
#else
  {
    struct tm *start_tm;
    start_tm=localtime(&start_time);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2001
    strmov(time_zone,tzname[start_tm->tm_isdst != 0 ? 1 : 0]);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2002 2003 2004 2005
  }
#endif
#endif

2006 2007
  if (gethostname(glob_hostname,sizeof(glob_hostname)-4) < 0)
    strmov(glob_hostname,"mysql");
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2008
  strmake(pidfile_name, glob_hostname, sizeof(pidfile_name)-5);
2009
  strmov(fn_ext(pidfile_name),".pid");		// Add proper extension
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2010
#ifndef DBUG_OFF
2011 2012 2013
  strxmov(strend(server_version),MYSQL_SERVER_SUFFIX,"-debug",NullS);
#else
  strmov(strend(server_version),MYSQL_SERVER_SUFFIX);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2014 2015 2016 2017 2018 2019 2020 2021
#endif
#ifdef _CUSTOMSTARTUPCONFIG_
  if (_cust_check_startup())
  {
    /* _cust_check_startup will report startup failure error */
    exit( 1 );
  }
#endif
2022
  load_defaults(MYSQL_CONFIG_NAME,load_default_groups,&argc,&argv);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2023
  defaults_argv=argv;
2024 2025 2026

  /* Get default temporary directory */
  opt_mysql_tmpdir=getenv("TMPDIR");	/* Use this if possible */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2027
#if defined( __WIN__) || defined(OS2)
2028 2029 2030 2031
  if (!opt_mysql_tmpdir)
    opt_mysql_tmpdir=getenv("TEMP");
  if (!opt_mysql_tmpdir)
    opt_mysql_tmpdir=getenv("TMP");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2032
#endif
2033 2034
  if (!opt_mysql_tmpdir || !opt_mysql_tmpdir[0])
    opt_mysql_tmpdir=(char*) P_tmpdir;		/* purecov: inspected */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2035 2036 2037 2038 2039 2040 2041 2042 2043 2044

  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 */

2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061
  (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_timezone,MY_MUTEX_INIT_FAST);
  (void) pthread_mutex_init(&LOCK_user_conn, MY_MUTEX_INIT_FAST);
2062
  (void) pthread_mutex_init(&LOCK_rpl_status, MY_MUTEX_INIT_FAST);
2063
  (void) pthread_mutex_init(&LOCK_active_mi, MY_MUTEX_INIT_FAST);
2064
  (void) pthread_mutex_init(&LOCK_global_system_variables, MY_MUTEX_INIT_FAST);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2065 2066 2067 2068
  (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);
2069
  (void) pthread_cond_init(&COND_manager,NULL);
2070
  (void) pthread_cond_init(&COND_rpl_status, NULL);
2071
  init_signals();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2072

2073
  if (set_default_charset_by_name(sys_charset.value, MYF(MY_WME)))
2074
    exit(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2075 2076 2077 2078 2079
  charsets_list = list_charsets(MYF(MY_COMPILED_SETS|MY_CONFIG_SETS));

#ifdef HAVE_OPENSSL
  if (opt_use_ssl)
  {
2080 2081 2082 2083
    /* 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);
2084
    DBUG_PRINT("info",("ssl_acceptor_fd: %lx", (long) ssl_acceptor_fd));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2085
    if (!ssl_acceptor_fd)
2086
      opt_use_ssl = 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101
  }
#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);
2102
#ifdef HAVE_PTHREAD_ATTR_GETSTACKSIZE
2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113
  {
    /* Retrieve used stack size;  Needed for checking stack overflows */
    size_t stack_size;
    pthread_attr_getstacksize(&connection_attrib, &stack_size);
    if (global_system_variables.log_warnings && stack_size != thread_stack)
    {
      sql_print_error("Warning: Asked for %ld thread stack, but got %ld",
		      thread_stack, stack_size);
      thread_stack= stack_size;
    }
  }
2114
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2115 2116 2117 2118
  if (!(opt_specialflag & SPECIAL_NO_PRIOR))
    my_pthread_attr_setprio(&connection_attrib,WAIT_PRIOR);
  pthread_attr_setscope(&connection_attrib, PTHREAD_SCOPE_SYSTEM);

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2119
#if defined( SET_RLIMIT_NOFILE) || defined( OS2)
2120
  /* connections and databases needs lots of files */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2121 2122 2123
  {
    uint wanted_files=10+(uint) max(max_connections*5,
				    max_connections+table_cache_size*2);
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
2124 2125
    set_if_bigger(wanted_files, open_files_limit);
    // Note that some system returns 0 if we succeed here:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2126
    uint files=set_maximum_open_files(wanted_files);
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
2127
    if (files && files < wanted_files && ! open_files_limit)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2128
    {
2129 2130
      max_connections=	(ulong) min((files-10),max_connections);
      table_cache_size= (ulong) max((files-10-max_connections)/2,64);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2131 2132 2133 2134 2135 2136 2137 2138 2139 2140 2141
      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();
2142
  set_var_init();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2143 2144 2145 2146 2147 2148
  mysys_uses_curses=0;
#ifdef USE_REGEX
  regex_init();
#endif
  select_thread=pthread_self();
  select_thread_in_use=1;
sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
2149
  if (use_temp_pool && bitmap_init(&temp_pool,1024,1))
2150
    unireg_abort(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2151 2152

  /*
2153
    We have enough space for fiddling with the argv, continue
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2154 2155
  */
  umask(((~my_umask) & 0666));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2156
  check_data_home(mysql_real_data_home);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2157 2158 2159 2160
  if (my_setwd(mysql_real_data_home,MYF(MY_WME)))
  {
    unireg_abort(1);				/* purecov: inspected */
  }
2161
  mysql_data_home= mysql_data_home_buff;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2162 2163 2164 2165 2166
  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();
2167 2168
  query_cache_result_size_limit(query_cache_limit);
  query_cache_resize(query_cache_size);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2169 2170 2171
  randominit(&sql_rand,(ulong) start_time,(ulong) start_time/2);
  reset_floating_point_exceptions();
  init_thr_lock();
2172
  init_slave_list();
2173 2174 2175 2176
#ifdef HAVE_OPENSSL
  if (des_key_file)
    load_des_key_file(des_key_file);
#endif /* HAVE_OPENSSL */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2177

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2178 2179
  /* Setup log files */
  if (opt_log)
2180 2181
    open_log(&mysql_log, glob_hostname, opt_logname, ".log", NullS,
	     LOG_NORMAL);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2182
  if (opt_update_log)
2183
  {
2184
    open_log(&mysql_update_log, glob_hostname, opt_update_logname, "",
2185
	     NullS, LOG_NEW);
2186 2187
    using_update_log=1;
  }
2188
 
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2189
  if (opt_slow_log)
2190
    open_log(&mysql_slow_log, glob_hostname, opt_slow_logname, "-slow.log",
2191
	     NullS, LOG_NORMAL);
2192 2193

  if (opt_error_log)
2194
  {
2195 2196 2197 2198 2199 2200 2201
    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
2202 2203 2204
    else
    {
      if (freopen(log_error_file, "a+", stdout))
2205 2206
	freopen(log_error_file, "a+", stderr);
    }
2207
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2208 2209 2210
  if (ha_init())
  {
    sql_print_error("Can't init databases");
2211 2212
    if (unix_sock != INVALID_SOCKET)
      unlink(mysql_unix_port);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2213
    unireg_abort(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2214
  }
2215
  ha_key_cache();
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
2216
#if defined(HAVE_MLOCKALL) && defined(MCL_CURRENT)
2217 2218 2219 2220 2221 2222 2223 2224 2225 2226 2227
  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;
2228
#endif
2229

2230
  if (opt_myisam_log)
2231 2232
    (void) mi_log(1);
  ft_init_stopwords();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2233 2234 2235 2236 2237 2238 2239 2240 2241 2242 2243 2244 2245 2246 2247

#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");
2248 2249
    if (unix_sock != INVALID_SOCKET)
      unlink(mysql_unix_port);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2250
    unireg_abort(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2251
  }
2252
  start_signal_handler();				// Creates pidfile
2253
  if (acl_init((THD*) 0, opt_noacl))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2254
  {
2255
    abort_loop=1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2256
    select_thread_in_use=0;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2257 2258 2259
#ifndef __NETWARE__
    (void) pthread_kill(signal_thread, MYSQL_KILL_SIGNAL);
#endif /* __NETWARE__ */
2260
#ifndef __WIN__
2261
    if (!opt_bootstrap)
2262
      (void) my_delete(pidfile_name,MYF(MY_WME));	// Not needed anymore
2263
#endif
2264 2265
    if (unix_sock != INVALID_SOCKET)
      unlink(mysql_unix_port);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2266
    unireg_abort(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2267 2268
  }
  if (!opt_noacl)
2269
    (void) grant_init((THD*) 0);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2270
  init_max_user_conn();
2271
  init_update_queries();
2272
  DBUG_ASSERT(current_thd == 0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2273 2274 2275 2276 2277

#ifdef HAVE_DLOPEN
  if (!opt_noacl)
    udf_init();
#endif
2278 2279 2280
  /* init_slave() must be called after the thread keys are created */
  init_slave();
  
2281
  DBUG_ASSERT(current_thd == 0);
2282 2283 2284 2285 2286 2287 2288 2289 2290 2291 2292 2293 2294 2295 2296 2297 2298 2299 2300 2301 2302 2303
  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",
2304
	     opt_binlog_index_name,LOG_BIN);
2305 2306 2307
    using_update_log=1;
  }

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2308 2309 2310 2311 2312 2313 2314 2315 2316 2317 2318 2319 2320 2321 2322 2323

  if (opt_bootstrap)
  {
    int error=bootstrap(stdin);
    end_thr_alarm();				// Don't allow alarms
    unireg_abort(error ? 1 : 0);
  }
  if (opt_init_file)
  {
    if (read_init_file(opt_init_file))
    {
      end_thr_alarm();				// Don't allow alarms
      unireg_abort(1);
    }
  }
  (void) thr_setconcurrency(concurrency);	// 10 by default
2324
#if defined(__WIN__) && !defined(EMBEDDED_LIBRARY)	  //IRENA
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2325
  {
2326
    hEventShutdown=CreateEvent(0, FALSE, FALSE, shutdown_event_name);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2327 2328 2329 2330 2331 2332 2333 2334
    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
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2335 2336 2337 2338 2339 2340 2341 2342
#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
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2343

2344
  if (
2345
#ifdef HAVE_BERKELEY_DB
2346
      !berkeley_skip ||
2347
#endif
2348
      (flush_time && flush_time != ~(ulong) 0L))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2349 2350
  {
    pthread_t hThread;
2351 2352
    if (pthread_create(&hThread,&connection_attrib,handle_manager,0))
      sql_print_error("Warning: Can't create thread to manage maintenance");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2353 2354
  }

2355 2356 2357
  printf(ER(ER_READY),my_progname,server_version,
	 ((unix_sock == INVALID_SOCKET) ? (char*) "" : mysql_unix_port),
	 mysql_port);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2358 2359 2360
  fflush(stdout);

#ifdef __NT__
2361
  if (hPipe == INVALID_HANDLE_VALUE &&
2362
      (!have_tcpip || opt_disable_networking))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2363
  {
2364
    sql_print_error("TCP/IP or --enable-named-pipe should be configured on NT OS");
2365
	unireg_abort(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2366 2367 2368 2369 2370 2371 2372 2373
  }
  else
  {
    pthread_mutex_lock(&LOCK_thread_count);
    (void) pthread_cond_init(&COND_handler_count,NULL);
    {
      pthread_t hThread;
      handler_count=0;
2374
      if (hPipe != INVALID_HANDLE_VALUE && opt_enable_named_pipe)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2375 2376 2377 2378 2379 2380 2381 2382 2383
      {
	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--;
	}
      }
2384
      if (have_tcpip && !opt_disable_networking)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2385 2386 2387 2388 2389 2390 2391 2392 2393 2394 2395 2396 2397 2398 2399 2400
      {
	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);
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
2401
#ifdef EXTRA_DEBUG2
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2402 2403 2404 2405 2406 2407 2408 2409 2410
  sql_print_error("Exiting main thread");
#endif
#endif /* __NT__ */

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

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

#ifndef __WIN__
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
2411
#ifdef EXTRA_DEBUG2
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2412 2413 2414
  sql_print_error("Before Lock_thread_count");
#endif
  (void) pthread_mutex_lock(&LOCK_thread_count);
2415
  DBUG_PRINT("quit", ("Got thread_count mutex"));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2416 2417
  select_thread_in_use=0;			// For close_connections
  (void) pthread_mutex_unlock(&LOCK_thread_count);
2418
  (void) pthread_cond_broadcast(&COND_thread_count);
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
2419
#ifdef EXTRA_DEBUG2
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2420 2421
  sql_print_error("After lock_thread_count");
#endif
monty@hundin.mysql.fi's avatar
merge  
monty@hundin.mysql.fi committed
2422
#endif /* __WIN__ */
2423

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2424 2425 2426 2427 2428
  /* 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);
monty@hundin.mysql.fi's avatar
merge  
monty@hundin.mysql.fi committed
2429 2430

#if defined(__WIN__) && !defined(EMBEDDED_LIBRARY)
monty@hundin.mysql.fi's avatar
merge  
monty@hundin.mysql.fi committed
2431 2432 2433 2434
  if (Service.IsNT() && start_mode)
    Service.Stop();
  else
  {
monty@donna.mysql.fi's avatar
monty@donna.mysql.fi committed
2435
    Service.SetShutdownEvent(0);
monty@hundin.mysql.fi's avatar
merge  
monty@hundin.mysql.fi committed
2436 2437 2438
    if (hEventShutdown)
      CloseHandle(hEventShutdown);
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2439
#endif
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2440 2441 2442 2443 2444 2445 2446 2447 2448 2449 2450 2451 2452 2453 2454 2455
#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();
2456
  my_end(opt_endinfo ? MY_CHECK_ERROR | MY_GIVE_INFO : 0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2457 2458 2459 2460 2461
  exit(0);
  return(0);					/* purecov: deadcode */
}


2462 2463 2464 2465 2466
/****************************************************************************
  Main and thread entry function for Win32
  (all this is needed only to run mysqld as a service on WinNT)
****************************************************************************/

2467
#if defined(__WIN__) && !defined(EMBEDDED_LIBRARY)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2468 2469
int mysql_service(void *p)
{
2470 2471 2472 2473
  if (use_opt_args)
    win_main(opt_argc, opt_argv);
  else
    win_main(Service.my_argc, Service.my_argv);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2474 2475 2476
  return 0;
}

2477 2478 2479 2480 2481 2482 2483 2484 2485 2486 2487 2488 2489 2490 2491 2492 2493 2494 2495 2496 2497 2498 2499 2500 2501 2502 2503 2504 2505 2506 2507 2508 2509 2510 2511 2512 2513 2514 2515
/*
  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;
}


bk@work.mysql.com's avatar
bk@work.mysql.com committed
2516 2517
int main(int argc, char **argv)
{
2518 2519 2520 2521 2522 2523 2524 2525

  /* 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);
  
2526
  if (Service.GetOS())	/* true NT family */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2527
  {
2528
    char file_path[FN_REFLEN];
2529 2530
    my_path(file_path, argv[0], "");		      /* Find name in path */
    fn_format(file_path,argv[0],file_path,"",1+4+16); /* Force full path */
2531

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2532
    if (argc == 2)
2533
    {	
2534 2535 2536 2537
      if (!default_service_handling(argv,MYSQL_SERVICENAME, MYSQL_SERVICENAME,
				   file_path))
	return 0;
      if (Service.IsService(argv[1]))
2538 2539
      {
        /* start an optional service */
2540
        load_default_groups[0]= argv[1];
2541
        start_mode= 1;
2542
        Service.Init(argv[1], mysql_service);
2543 2544 2545 2546
        return 0;
      }
    }
    else if (argc == 3) /* install or remove any optional service */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2547
    {
2548
      /* Add service name after filename */
2549
      uint length=strlen(file_path);
2550 2551
      *strxnmov(file_path + length, sizeof(file_path)-length-2, " ",
		argv[2], NullS)= '\0';
2552 2553 2554 2555

      if (!default_service_handling(argv, argv[2], argv[2], file_path))
	return 0;
      if (Service.IsService(argv[2]))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2556
      {
2557 2558 2559 2560 2561
	/* start an optional service */
	use_opt_args=1;
	opt_argc=argc;
	opt_argv=argv;
	start_mode= 1;
2562
	Service.Init(argv[2], mysql_service);
2563
	return 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2564 2565
      }
    }
2566 2567 2568 2569 2570 2571 2572
    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);
2573 2574
      *strxnmov(file_path + length, sizeof(file_path)-length-2, " ",
		argv[3], " ", argv[2], NullS)= '\0';
2575 2576 2577
      if (!default_service_handling(argv, argv[2], argv[2], file_path))
	return 0;
    }
2578
    else if (argc == 1 && Service.IsService(MYSQL_SERVICENAME))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2579
    {
2580 2581 2582
      /* start the default service */
      start_mode= 1;
      Service.Init(MYSQL_SERVICENAME, mysql_service);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2583 2584 2585
      return 0;
    }
  }
2586
  /* Start as standalone server */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2587 2588 2589 2590 2591 2592 2593 2594
  Service.my_argc=argc;
  Service.my_argv=argv;
  mysql_service(NULL);
  return 0;
}
#endif


2595 2596 2597 2598 2599
/*
  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.
*/

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2600 2601 2602 2603
static int bootstrap(FILE *file)
{
  THD *thd= new THD;
  int error;
2604
  DBUG_ENTER("bootstrap");
2605

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2606 2607
  thd->bootstrap=1;
  thd->client_capabilities=0;
2608
  my_net_init(&thd->net,(st_vio*) 0);
2609
  thd->max_client_packet_length= thd->net.max_packet;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2610
  thd->master_access= ~0;
2611
  thd->thread_id=thread_id++;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2612
  thread_count++;
2613 2614 2615 2616 2617 2618

  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");    
2619
    DBUG_RETURN(-1);
2620 2621 2622 2623 2624 2625 2626 2627 2628 2629
  }
  /* 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;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2630
  net_end(&thd->net);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2631
  thd->cleanup();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2632
  delete thd;
2633
  DBUG_RETURN(error);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2634 2635 2636 2637 2638 2639 2640 2641 2642 2643 2644 2645 2646 2647 2648 2649 2650 2651 2652 2653
}

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
2654
  net->read_timeout = (uint) connect_timeout;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2655 2656 2657 2658 2659 2660
  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)
  {
jcole@tetra.spaceapes.com's avatar
jcole@tetra.spaceapes.com committed
2661
    DBUG_PRINT("error",("Too many connections"));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2662 2663 2664 2665
    close_connection(net,ER_CON_COUNT_ERROR);
    delete thd;
    DBUG_VOID_RETURN;
  }
2666
  pthread_mutex_lock(&LOCK_thread_count);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2667 2668 2669 2670 2671 2672
  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
    thd->scramble[i]= (char) (rnd(&sql_rand)*94+33);
  thd->scramble[8]=0;
2673

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2674 2675 2676
  thd->real_id=pthread_self();			// Keep purify happy

  /* Start a new thread to handle connection */
2677
#ifdef ONE_THREAD
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2678 2679 2680 2681 2682 2683 2684 2685 2686 2687 2688 2689 2690 2691 2692 2693 2694 2695 2696 2697
  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++;
2698
      thread_created++;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2699 2700 2701 2702 2703 2704 2705 2706 2707 2708 2709 2710 2711 2712 2713 2714 2715 2716 2717 2718 2719
      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);
	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;
      }
    }
2720 2721
    (void) pthread_mutex_unlock(&LOCK_thread_count);

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2722
  }
2723
  DBUG_PRINT("info",("Thread created"));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2724 2725 2726
  DBUG_VOID_RETURN;
}

2727 2728 2729 2730
#ifdef SIGNALS_DONT_BREAK_READ
inline void kill_broken_server()
{
  /* hack to get around signals ignored in syscalls for problem OS's */
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2731 2732 2733 2734
  if (
#if !defined(__NETWARE__)
      unix_sock == INVALID_SOCKET ||
#endif
2735
      (!opt_disable_networking && ip_sock == INVALID_SOCKET))
2736 2737
  {
    select_thread_in_use = 0;
2738 2739 2740
#ifdef __NETWARE__
    kill_server(MYSQL_KILL_SIGNAL); /* never returns */
#else
2741
    kill_server((void*)MYSQL_KILL_SIGNAL); /* never returns */
2742
#endif /* __NETWARE__ */
2743 2744 2745 2746 2747 2748
  }
}
#define MAYBE_BROKEN_SYSCALL kill_broken_server();
#else
#define MAYBE_BROKEN_SYSCALL
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2749 2750 2751

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

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2752 2753
extern "C" pthread_handler_decl(handle_connections_sockets,
				arg __attribute__((unused)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2754 2755 2756 2757 2758 2759 2760 2761
{
  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;
2762
  st_vio *vio_tmp;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2763 2764 2765 2766 2767 2768 2769 2770 2771 2772 2773 2774 2775 2776 2777 2778
  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);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2779
#ifdef HAVE_FCNTL
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2780
  socket_flags=fcntl(unix_sock, F_GETFL, 0);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2781
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2782 2783 2784
#endif

  DBUG_PRINT("general",("Waiting for connections."));
2785
  MAYBE_BROKEN_SYSCALL;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2786 2787 2788
  while (!abort_loop)
  {
    readFDs=clientFDs;
2789
#ifdef HPUX10
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2790 2791 2792 2793 2794
    if (select(max_used_connection,(int*) &readFDs,0,0,0) < 0)
      continue;
#else
    if (select((int) max_used_connection,&readFDs,0,0,0) < 0)
    {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2795
      if (socket_errno != SOCKET_EINTR)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2796 2797
      {
	if (!select_errors++ && !abort_loop)	/* purecov: inspected */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2798
	  sql_print_error("mysqld: Got error %d from select",socket_errno); /* purecov: inspected */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2799
      }
2800
      MAYBE_BROKEN_SYSCALL
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2801 2802
      continue;
    }
2803
#endif	/* HPUX10 */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2804
    if (abort_loop)
2805 2806
    {
      MAYBE_BROKEN_SYSCALL;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2807
      break;
2808
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2809

2810
    /* Is this a new connection request ? */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2811 2812 2813 2814 2815 2816 2817 2818 2819 2820 2821 2822 2823 2824 2825 2826 2827 2828 2829 2830 2831 2832 2833 2834 2835 2836 2837 2838
#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);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2839 2840 2841 2842 2843 2844 2845
#ifdef __NETWARE__ 
      // TODO: temporary fix, waiting for TCP/IP fix - DEFECT000303149
      if ((new_sock == INVALID_SOCKET) && (socket_errno == EINVAL))
      {
        kill_server(SIGTERM);
      }
#endif
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2846 2847
      if (new_sock != INVALID_SOCKET ||
	  (socket_errno != SOCKET_EINTR && socket_errno != SOCKET_EAGAIN))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2848
	break;
2849
      MAYBE_BROKEN_SYSCALL;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2850 2851 2852 2853 2854 2855 2856 2857 2858 2859 2860 2861
#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
2862
    if (new_sock == INVALID_SOCKET)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2863 2864 2865
    {
      if ((error_count++ & 255) == 0)		// This can happen often
	sql_perror("Error in accept");
2866
      MAYBE_BROKEN_SYSCALL;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2867
      if (socket_errno == SOCKET_ENFILE || socket_errno == SOCKET_EMFILE)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2868 2869 2870 2871 2872 2873 2874 2875 2876 2877 2878
	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);
2879 2880
	my_fromhost(&req);
	if (!my_hosts_access(&req))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2881
	{
2882 2883 2884 2885 2886
	  /*
	    This may be stupid but refuse() includes an exit(0)
	    which we surely don't want...
	    clean_exit() - same stupid thing ...
	  */
2887 2888
	  syslog(deny_severity, "refused connect from %s",
		 my_eval_client(&req));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2889

2890 2891 2892 2893 2894 2895
	  /*
	    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...
	  */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2896 2897 2898
	  if (req.sink)
	    ((void (*)(int))req.sink)(req.fd);

2899
	  (void) shutdown(new_sock,2);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2900 2901 2902 2903 2904 2905 2906 2907 2908 2909 2910 2911 2912 2913 2914 2915 2916 2917 2918 2919 2920 2921 2922 2923 2924 2925
	  (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))
    {
2926 2927
      (void) shutdown(new_sock,2);
      VOID(closesocket(new_sock));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2928 2929 2930
      continue;
    }
    if (!(vio_tmp=vio_new(new_sock,
2931
			  sock == unix_sock ? VIO_TYPE_SOCKET :
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2932
			  VIO_TYPE_TCPIP,
2933
			  sock == unix_sock)) ||
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2934 2935 2936 2937 2938 2939 2940 2941 2942 2943 2944 2945 2946
	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)
2947
      thd->host=(char*) localhost;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2948 2949 2950
    create_new_thread(thd);
  }

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2951 2952 2953 2954 2955
#ifdef OS2
  // kill server must be invoked from thread 1!
  kill_server(MYSQL_KILL_SIGNAL);
#endif

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2956 2957 2958 2959
#ifdef __NT__
  pthread_mutex_lock(&LOCK_thread_count);
  handler_count--;
  pthread_mutex_unlock(&LOCK_thread_count);
2960
  pthread_cond_signal(&COND_handler_count);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2961 2962 2963 2964 2965 2966
#endif
  DBUG_RETURN(0);
}


#ifdef __NT__
2967
extern "C" pthread_handler_decl(handle_connections_namedpipes,arg)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2968 2969 2970 2971 2972 2973 2974 2975 2976 2977 2978 2979 2980 2981 2982
{
  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;
2983
    if (!fConnected)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2984
      fConnected = GetLastError() == ERROR_PIPE_CONNECTED;
2985
    if (!fConnected)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2986 2987 2988 2989 2990 2991 2992 2993
    {
      CloseHandle( hPipe );
      if ((hPipe = CreateNamedPipe(szPipeName,
				   PIPE_ACCESS_DUPLEX,
				   PIPE_TYPE_BYTE |
				   PIPE_READMODE_BYTE |
				   PIPE_WAIT,
				   PIPE_UNLIMITED_INSTANCES,
2994
				   (int) global_system_variables.net_buffer_length,
miguel@hegel.br's avatar
miguel@hegel.br committed
2995
				   (int) global_system_variables.net_buffer_length,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2996 2997 2998 2999 3000 3001 3002 3003 3004 3005 3006 3007 3008 3009 3010 3011
				   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,
3012 3013
				 (int) global_system_variables.net_buffer_length,
				 (int) global_system_variables.net_buffer_length,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3014 3015 3016 3017 3018 3019 3020 3021 3022
				 NMPWAIT_USE_DEFAULT_WAIT,
				 &saPipeSecurity)) ==
	INVALID_HANDLE_VALUE)
    {
      sql_perror("Can't create new named pipe!");
      hPipe=hConnectedPipe;
      continue;					// We have to try again
    }

3023
    if (!(thd = new THD))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3024 3025 3026 3027 3028 3029 3030 3031 3032 3033 3034 3035 3036
    {
      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 */
3037
    thd->host = my_strdup(localhost,MYF(0)); /* Host is unknown */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3038 3039 3040 3041 3042 3043
    create_new_thread(thd);
  }

  pthread_mutex_lock(&LOCK_thread_count);
  handler_count--;
  pthread_mutex_unlock(&LOCK_thread_count);
3044
  pthread_cond_signal(&COND_handler_count);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3045 3046 3047 3048 3049 3050 3051 3052 3053
  DBUG_RETURN(0);
}
#endif /* __NT__ */


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

3054
enum options {
3055 3056 3057 3058 3059 3060 3061 3062 3063 3064 3065 3066 3067 3068
  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,   
3069 3070
  OPT_DELAY_KEY_WRITE_ALL,     OPT_SLOW_QUERY_LOG, 
  OPT_DELAY_KEY_WRITE,	       OPT_CHARSETS_DIR,
3071 3072 3073
  OPT_BDB_HOME,                OPT_BDB_LOG,  
  OPT_BDB_TMP,                 OPT_BDB_NOSYNC,
  OPT_BDB_LOCK,                OPT_BDB_SKIP, 
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3074
  OPT_BDB_NO_RECOVER,	       OPT_BDB_SHARED,
3075 3076 3077 3078
  OPT_MASTER_HOST,             OPT_MASTER_USER,
  OPT_MASTER_PASSWORD,         OPT_MASTER_PORT,
  OPT_MASTER_INFO_FILE,        OPT_MASTER_CONNECT_RETRY,
  OPT_MASTER_RETRY_COUNT,
3079 3080 3081
  OPT_MASTER_SSL,              OPT_MASTER_SSL_KEY,
  OPT_MASTER_SSL_CERT,         OPT_MASTER_SSL_CAPATH,
  OPT_MASTER_SSL_CIPHER,
3082 3083 3084 3085 3086 3087 3088 3089 3090 3091 3092 3093 3094 3095 3096 3097 3098 3099 3100 3101 3102 3103 3104 3105 3106 3107 3108 3109 3110 3111 3112 3113 3114 3115 3116 3117 3118 3119 3120 3121 3122
  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,
3123
  OPT_FT_MAX_WORD_LEN, OPT_FT_MAX_WORD_LEN_FOR_SORT, OPT_FT_STOPWORD_FILE,
3124 3125 3126 3127 3128 3129 3130 3131
  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,
3132
  OPT_MAX_WRITE_LOCK_COUNT, OPT_BULK_INSERT_BUFFER_SIZE,
3133 3134 3135 3136
  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,
3137
  OPT_OPEN_FILES_LIMIT, 
3138
  OPT_QUERY_CACHE_LIMIT, OPT_QUERY_CACHE_SIZE,
3139
  OPT_QUERY_CACHE_TYPE, OPT_RECORD_BUFFER,
3140
  OPT_RECORD_RND_BUFFER, OPT_RELAY_LOG_SPACE_LIMIT,
3141
  OPT_SLAVE_NET_TIMEOUT, OPT_SLAVE_COMPRESSED_PROTOCOL, OPT_SLOW_LAUNCH_TIME,
3142 3143 3144 3145 3146 3147 3148 3149 3150 3151 3152 3153 3154 3155 3156 3157
  OPT_SORT_BUFFER, OPT_TABLE_CACHE,
  OPT_THREAD_CONCURRENCY, OPT_THREAD_CACHE_SIZE,
  OPT_TMP_TABLE_SIZE, OPT_THREAD_STACK,
  OPT_WAIT_TIMEOUT,
  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,
  OPT_BDB_CACHE_SIZE,
  OPT_BDB_LOG_BUFFER_SIZE,
3158
  OPT_BDB_MAX_LOCK,
3159
  OPT_ERROR_LOG_FILE
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3160
};
3161

3162 3163 3164

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

3165
struct my_option my_long_options[] =
3166 3167 3168 3169 3170 3171 3172
{
  {"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},
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3173
#ifdef HAVE_BERKELEY_DB
3174 3175 3176 3177 3178 3179 3180 3181 3182 3183 3184 3185 3186 3187 3188 3189 3190 3191 3192 3193 3194 3195 3196 3197 3198 3199 3200 3201 3202 3203 3204
  {"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},
3205 3206 3207
  {"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},
3208 3209
  {"bootstrap", OPT_BOOTSTRAP, "Used by mysql installation scripts", 0, 0, 0,
   GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
3210
  {"console", OPT_CONSOLE, "Write error output on screen; Don't remove the console window on windows",
3211 3212
   (gptr*) &opt_console, (gptr*) &opt_console, 0, GET_BOOL, NO_ARG, 0, 0, 0,
   0, 0, 0},
3213
#ifdef __WIN__
3214 3215 3216 3217 3218 3219 3220 3221 3222 3223 3224 3225 3226 3227 3228 3229 3230 3231 3232 3233 3234 3235 3236 3237 3238 3239 3240 3241 3242 3243
  {"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",
3244 3245
   (gptr*) &sys_charset.value, (gptr*) &sys_charset.value, 0, GET_STR,
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0 },
3246
  {"default-table-type", OPT_TABLE_TYPE,
3247
   "Set the default table type for tables", 0, 0,
3248
   0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3249 3250 3251
  {"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,
3252
   "Don't flush key buffers between writes for any MyISAM table (Deprecated option, use --delay-key-write=all instead)",
3253
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
3254
  {"enable-locking", OPT_ENABLE_LOCK,
3255
   "Deprecated option, use --external-locking instead",
3256 3257
   (gptr*) &opt_external_locking, (gptr*) &opt_external_locking,
   0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
3258 3259 3260 3261 3262 3263 3264 3265 3266 3267 3268 3269 3270 3271 3272 3273 3274 3275 3276
#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 */
  {"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},
3277
#ifdef HAVE_INNOBASE_DB
3278 3279 3280 3281 3282 3283 3284 3285 3286 3287 3288 3289 3290 3291 3292
  {"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,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3293
   "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)",
3294 3295
   (gptr*) &innobase_flush_log_at_trx_commit,
   (gptr*) &innobase_flush_log_at_trx_commit,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3296
   0, GET_UINT, OPT_ARG,  0, 0, 2, 0, 0, 0},
3297 3298 3299 3300 3301 3302
  {"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,
3303
   (gptr*) &innobase_fast_shutdown, 0, GET_BOOL, NO_ARG, 1, 0, 0, 0, 0, 0},
3304 3305 3306 3307 3308 3309 3310 3311 3312 3313 3314 3315 3316 3317
#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)",
3318 3319
   (gptr*) &opt_local_infile,
   (gptr*) &opt_local_infile, 0, GET_BOOL, OPT_ARG,
3320
   1, 0, 0, 0, 0, 0},
3321 3322
  {"log-bin", OPT_BIN_LOG,
   "Log queries in new binary format (for replication)",
3323
   (gptr*) &opt_bin_logname, (gptr*) &opt_bin_logname, 0, GET_STR_ALLOC,
3324
   OPT_ARG, 0, 0, 0, 0, 0, 0},
3325 3326 3327 3328 3329 3330 3331 3332 3333 3334 3335 3336 3337 3338 3339 3340 3341 3342 3343
  {"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},
  {"log-slave-updates", OPT_LOG_SLAVE_UPDATES, 
3344
   "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.",
3345 3346 3347
   (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,
3348 3349 3350 3351
   "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},
3352 3353 3354 3355 3356 3357 3358 3359 3360 3361 3362 3363 3364 3365 3366 3367 3368 3369 3370 3371 3372 3373
  {"master-host", OPT_MASTER_HOST, 
   "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,
3374
   REQUIRED_ARG, 3600*24, 0, 0, 0, 0, 0},
3375 3376 3377 3378 3379 3380 3381 3382 3383 3384 3385 3386 3387 3388 3389 3390
  {"master-info-file", OPT_MASTER_INFO_FILE,
   "The location of the file that remembers where we left off on the master during the replication process. The default is `master.info' in the data directory. You should not need to change this.",
   (gptr*) &master_info_file, (gptr*) &master_info_file, 0, GET_STR,
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"master-ssl", OPT_MASTER_SSL,
   "Turn SSL on for replication. Be warned that is this is a relatively new feature.",
   (gptr*) &master_ssl, (gptr*) &master_ssl, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0,
   0, 0},
  {"master-ssl-key", OPT_MASTER_SSL_KEY,
   "Master SSL keyfile name. Only applies if you have enabled master-ssl.",
   (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,
   "Master SSL certificate file name. Only applies if you have enabled master-ssl.",
   (gptr*) &master_ssl_cert, (gptr*) &master_ssl_cert, 0, GET_STR, OPT_ARG,
   0, 0, 0, 0, 0, 0},
3391 3392 3393 3394 3395 3396 3397
  {"master-ssl-capath", OPT_MASTER_SSL_CAPATH,
   "Master SSL CA path. Only applies if you have enabled master-ssl.",
   (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,
   "Master SSL cipher. Only applies if you have enabled master-ssl.",
   (gptr*) &master_ssl_cipher, (gptr*) &master_ssl_capath, 0, GET_STR, OPT_ARG,
3398 3399 3400 3401 3402 3403 3404 3405
   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,
3406
   "Option used by mysql-test for debugging and testing of replication",
3407 3408 3409 3410
   (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,
3411
   "Option used by mysql-test for debugging and testing of replication",
3412 3413
   (gptr*) &abort_slave_event_count,  (gptr*) &abort_slave_event_count,
   0, GET_INT, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3414 3415
  {"max-binlog-dump-events", OPT_MAX_BINLOG_DUMP_EVENTS,
   "Option used by mysql-test for debugging and testing of replication",
3416 3417
   (gptr*) &max_binlog_dump_events, (gptr*) &max_binlog_dump_events, 0,
   GET_INT, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3418 3419
  {"sporadic-binlog-dump-fail", OPT_SPORADIC_BINLOG_DUMP_FAIL,
   "Option used by mysql-test for debugging and testing of replication",
3420 3421 3422 3423 3424 3425 3426 3427
   (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},
  {"new", 'n', "Use very new possible 'unsafe' functions", 0, 0, 0, GET_NO_ARG,
   NO_ARG, 0, 0, 0, 0, 0, 0},
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3428
#ifdef NOT_YET
3429
  {"no-mix-table-types", OPT_NO_MIX_TYPE, "Don't allow commands with uses two different table types",
3430 3431 3432
   (gptr*) &opt_no_mix_types, (gptr*) &opt_no_mix_types, 0, GET_BOOL, NO_ARG,
   0, 0, 0, 0, 0, 0},
#endif
3433
  {"old-protocol", 'o', "Use the old (3.20) protocol client/server protocol",
3434 3435
   (gptr*) &protocol_version, (gptr*) &protocol_version, 0, GET_UINT, NO_ARG,
   PROTOCOL_VERSION, 0, 0, 0, 0, 0},
3436 3437
  {"old-rpl-compat", OPT_OLD_RPL_COMPAT,
   "Use old LOAD DATA format in the binary log (don't save data in file)",
3438 3439
   (gptr*) &opt_old_rpl_compat, (gptr*) &opt_old_rpl_compat, 0, GET_BOOL,
   NO_ARG, 0, 0, 0, 0, 0, 0},
3440
#ifdef ONE_THREAD
3441 3442 3443 3444 3445 3446 3447
  {"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},
3448 3449
  {"log-error", OPT_ERROR_LOG_FILE, "Log error file",
   (gptr*) &log_error_file_ptr, (gptr*) &log_error_file_ptr, 0, GET_STR,
3450
   OPT_ARG, 0, 0, 0, 0, 0, 0},
3451 3452
  {"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},
3453
  {"reckless-slave", OPT_RECKLESS_SLAVE, "For debugging", 0, 0, 0, GET_NO_ARG,
3454 3455 3456 3457 3458 3459 3460 3461 3462 3463 3464 3465 3466 3467 3468 3469 3470 3471 3472 3473 3474 3475
   NO_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},
3476
  // In replication, we may need to tell the other servers how to connect
3477 3478 3479 3480 3481 3482 3483 3484 3485 3486 3487 3488 3489 3490
  {"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",
3491
   (gptr*) &rpl_recovery_rank, (gptr*) &rpl_recovery_rank, 0, GET_ULONG,
3492 3493 3494
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"relay-log", OPT_RELAY_LOG, "Undocumented",
   (gptr*) &opt_relay_logname, (gptr*) &opt_relay_logname, 0,
3495
   GET_STR_ALLOC, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3496 3497 3498 3499 3500
  {"relay-log-index", OPT_RELAY_LOG_INDEX, "Undocumented",
   (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},
3501
#ifndef TO_BE_DELETED
3502
  {"safe-show-database", OPT_SAFE_SHOW_DB,
3503
   "Deprecated option; One should use GRANT SHOW DATABASES instead...",
3504
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
3505
#endif
3506 3507 3508 3509 3510 3511
  {"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",
3512
   (gptr*) &server_id, (gptr*) &server_id, 0, GET_ULONG, REQUIRED_ARG, 0, 0, 0,
3513 3514 3515 3516
   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},
3517 3518
  {"show-slave-auth-info", OPT_SHOW_SLAVE_AUTH_INFO,
   "Show user and password in SHOW SLAVE STATUS",
3519 3520 3521 3522 3523
   (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,
3524
   0, GET_BOOL, NO_ARG, 1, 0, 0, 0, 0, 0},
3525 3526 3527 3528 3529 3530 3531
  {"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,
3532
   "Deprecated option, use --skip-external-locking instead",
3533 3534 3535 3536 3537 3538 3539 3540 3541 3542 3543 3544 3545 3546 3547 3548 3549 3550 3551 3552 3553 3554 3555 3556 3557 3558 3559 3560 3561
   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},
  {"skip-symlink", OPT_SKIP_SYMLINKS, "Don't allow symlinking of tables",
   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},
  {"relay-log-info-file", OPT_RELAY_LOG_INFO_FILE, "Undocumented",
   (gptr*) &relay_log_info_file, (gptr*) &relay_log_info_file, 0, GET_STR,
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"slave-load-tmpdir", OPT_SLAVE_LOAD_TMPDIR, "Undocumented",
3562
   (gptr*) &slave_load_tmpdir, (gptr*) &slave_load_tmpdir, 0, GET_STR_ALLOC,
3563 3564
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"slave-skip-errors", OPT_SLAVE_SKIP_ERRORS,
3565
   "Tells the slave thread to continue replication when a query returns an error from the provided list",
3566 3567 3568 3569 3570 3571 3572 3573 3574 3575 3576 3577
   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},
3578
#ifdef HAVE_OPENSSL
3579 3580 3581
#include "sslopt-longopts.h"
#endif
  {"temp-pool", OPT_TEMP_POOL, 
3582
   "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.",
3583 3584
   (gptr*) &use_temp_pool, (gptr*) &use_temp_pool, 0, GET_BOOL, NO_ARG, 1,
   0, 0, 0, 0, 0},
3585 3586
  {"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},
3587
  {"transaction-isolation", OPT_TX_ISOLATION,
3588 3589
   "Default transaction isolation level", 0, 0, 0, GET_STR, REQUIRED_ARG, 0,
   0, 0, 0, 0, 0},
3590 3591 3592
  {"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},
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3593
#ifdef USE_SYMDIR
3594
  {"use-symbolic-links", 's', "Enable symbolic link support",
3595
   (gptr*) &my_use_symdir, (gptr*) &my_use_symdir, 0, GET_BOOL, NO_ARG,
3596
   IF_PURIFY(0,1), 0, 0, 0, 0, 0},
3597 3598 3599 3600 3601 3602 3603
#endif
  {"user", 'u', "Run mysqld daemon as user", (gptr*) &mysqld_user,
   (gptr*) &mysqld_user, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"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},
3604 3605 3606 3607 3608 3609 3610
  {"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,
3611 3612
   0, 0, 0},
  { "back_log", OPT_BACK_LOG,
3613 3614
    "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,
3615
    REQUIRED_ARG, 50, 1, 65535, 0, 1, 0 },
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3616
#ifdef HAVE_BERKELEY_DB
3617
  { "bdb_cache_size", OPT_BDB_CACHE_SIZE,
3618
    "The buffer that is allocated to cache index and rows for BDB tables.",
3619 3620 3621 3622 3623 3624 3625 3626 3627 3628 3629 3630 3631 3632 3633 3634 3635 3636 3637 3638 3639
    (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",
3640 3641
    (gptr*) &connect_timeout, (gptr*) &connect_timeout,
   0, GET_ULONG, REQUIRED_ARG, CONNECT_TIMEOUT, 2, LONG_TIMEOUT, 0, 1, 0 },
3642
  {"delayed_insert_timeout", OPT_DELAYED_INSERT_TIMEOUT,
3643
   "How long a INSERT DELAYED thread should wait for INSERT statements before terminating.",
3644 3645 3646 3647 3648 3649 3650 3651 3652 3653 3654 3655 3656 3657 3658 3659 3660
   (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,
3661
    REQUIRED_ARG, 4, 1, HA_FT_MAXLEN, 0, 1, 0},
3662 3663 3664 3665 3666
  { "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,
3667 3668 3669 3670 3671 3672 3673
    "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},
3674
#ifdef HAVE_INNOBASE_DB
3675 3676 3677 3678 3679 3680 3681 3682 3683 3684 3685 3686 3687 3688 3689 3690 3691 3692 3693 3694 3695 3696 3697 3698 3699 3700 3701 3702 3703 3704 3705 3706 3707 3708 3709 3710 3711 3712 3713 3714 3715 3716 3717 3718 3719
  {"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.",
3720 3721
   (gptr*) &global_system_variables.net_interactive_timeout,
   (gptr*) &max_system_variables.net_interactive_timeout, 0,
3722 3723 3724
   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.",
3725 3726
   (gptr*) &global_system_variables.join_buff_size,
   (gptr*) &max_system_variables.join_buff_size, 0, GET_ULONG,
3727 3728 3729 3730
   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.",
3731 3732 3733
   (gptr*) &keybuff_size, (gptr*) &keybuff_size, 0, GET_ULL,
   REQUIRED_ARG, KEY_CACHE_SIZE, MALLOC_OVERHEAD, (long) ~0, MALLOC_OVERHEAD,
   IO_SIZE, 0},
3734 3735
  {"long_query_time", OPT_LONG_QUERY_TIME,
   "Log all queries that have taken more than long_query_time seconds to execute to file.",
3736 3737
   (gptr*) &global_system_variables.long_query_time,
   (gptr*) &max_system_variables.long_query_time, 0, GET_ULONG,
3738 3739 3740
   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.",
3741
   (gptr*) &lower_case_table_names,
3742
   (gptr*) &lower_case_table_names, 0, GET_BOOL, NO_ARG,
3743 3744 3745 3746 3747
#ifdef FN_NO_CASE_SENCE
    1
#else
    0
#endif
3748
   , 0, 1, 0, 1, 0},
3749 3750
  {"max_allowed_packet", OPT_MAX_ALLOWED_PACKET,
   "Max packetlength to send/receive from to server.",
3751 3752
   (gptr*) &global_system_variables.max_allowed_packet,
   (gptr*) &max_system_variables.max_allowed_packet, 0, GET_ULONG,
3753
   REQUIRED_ARG, 1024*1024L, 80, 1024L*1024L*1024L, MALLOC_OVERHEAD, 1024, 0},
3754 3755 3756 3757 3758 3759 3760 3761 3762 3763 3764 3765 3766 3767 3768 3769 3770 3771 3772 3773 3774 3775
  {"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,
   "Don't start more than this number of threads to handle INSERT DELAYED statements.",
   (gptr*) &max_insert_delayed_threads, (gptr*) &max_insert_delayed_threads,
   0, GET_ULONG, REQUIRED_ARG, 20, 1, 16384, 0, 1, 0},
  {"max_heap_table_size", OPT_MAX_HEP_TABLE_SIZE,
   "Don't allow creation of heap tables bigger than this.",
3776 3777
   (gptr*) &global_system_variables.max_heap_table_size,
   (gptr*) &max_system_variables.max_heap_table_size, 0, GET_ULONG,
3778 3779 3780
   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.",
3781
   (gptr*) &global_system_variables.max_join_size,
3782
   (gptr*) &max_system_variables.max_join_size, 0, GET_HA_ROWS, REQUIRED_ARG,
3783 3784 3785
   ~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).",
3786 3787
   (gptr*) &global_system_variables.max_sort_length,
   (gptr*) &max_system_variables.max_sort_length, 0, GET_ULONG,
3788 3789 3790
   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.",
3791 3792
   (gptr*) &global_system_variables.max_tmp_tables,
   (gptr*) &max_system_variables.max_tmp_tables, 0, GET_ULONG,
3793 3794 3795 3796 3797 3798 3799 3800 3801
   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},
3802
  {"bulk_insert_buffer_size", OPT_BULK_INSERT_BUFFER_SIZE,
3803
   "Size of tree cache used in bulk insert optimisation. Note that this is a limit per thread!",
3804 3805
   (gptr*) &global_system_variables.bulk_insert_buff_size,
   (gptr*) &max_system_variables.bulk_insert_buff_size,
3806
   0, GET_ULONG, REQUIRED_ARG, 8192*1024, 0, ~0L, 0, 1, 0},
3807
  {"myisam_block_size", OPT_MYISAM_BLOCK_SIZE,
3808 3809
   "Block size to be used for MyISAM index pages",
   (gptr*) &opt_myisam_block_size,
3810 3811 3812 3813
   (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,
3814
   "Used to help MySQL to decide when to use the slow but safe key cache index create method",
3815 3816
   (gptr*) &global_system_variables.myisam_max_extra_sort_file_size,
   (gptr*) &max_system_variables.myisam_max_extra_sort_file_size,
3817
   0, GET_ULL, REQUIRED_ARG, (ulonglong) MI_MAX_TEMP_LENGTH,
3818
   0, ~0L, 0, 1, 0},
3819
  {"myisam_max_sort_file_size", OPT_MYISAM_MAX_SORT_FILE_SIZE,
3820
   "Don't use the fast sort index method to created index if the temporary file would get bigger than this!",
3821 3822
   (gptr*) &global_system_variables.myisam_max_sort_file_size,
   (gptr*) &max_system_variables.myisam_max_sort_file_size, 0,
3823
   GET_ULL, REQUIRED_ARG, (longlong) LONG_MAX, 0, ~0L, 0, 1024*1024, 0},
3824 3825
  {"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.",
3826 3827
   (gptr*) &global_system_variables.myisam_sort_buff_size,
   (gptr*) &max_system_variables.myisam_sort_buff_size, 0,
3828 3829
   GET_ULONG, REQUIRED_ARG, 8192*1024, 4, ~0L, 0, 1, 0},
  {"net_buffer_length", OPT_NET_BUFFER_LENGTH,
3830 3831 3832 3833
   "Buffer length for TCP/IP and socket communication.", 
   (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},
3834 3835
  {"net_retry_count", OPT_NET_RETRY_COUNT,
   "If a read on a communication port is interrupted, retry this many times before giving up.",
3836 3837
   (gptr*) &global_system_variables.net_retry_count,
   (gptr*) &max_system_variables.net_retry_count,0,
3838 3839 3840
   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.",
3841 3842
   (gptr*) &global_system_variables.net_read_timeout,
   (gptr*) &max_system_variables.net_read_timeout, 0, GET_ULONG,
3843 3844 3845
   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.",
3846 3847
   (gptr*) &global_system_variables.net_write_timeout,
   (gptr*) &max_system_variables.net_write_timeout, 0, GET_ULONG,
3848 3849 3850 3851 3852
   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},
3853
#ifdef HAVE_QUERY_CACHE
3854 3855 3856
  {"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,
3857
   REQUIRED_ARG, 1024*1024L, 0, (longlong) ULONG_MAX, 0, 1, 0},
3858
#endif /*HAVE_QUERY_CACHE*/
3859 3860 3861
  {"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,
3862
   REQUIRED_ARG, 0, 0, (longlong) ULONG_MAX, 0, 1024, 0},
3863
#ifdef HAVE_QUERY_CACHE
3864
  {"query_cache_type", OPT_QUERY_CACHE_TYPE,
3865
   "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.",
3866 3867 3868
   (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},
3869
#endif /*HAVE_QUERY_CACHE*/
3870
  {"read_buffer_size", OPT_RECORD_BUFFER,
3871
   "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.",
3872 3873
   (gptr*) &global_system_variables.read_buff_size,
   (gptr*) &max_system_variables.read_buff_size,0, GET_ULONG, REQUIRED_ARG,
3874
   128*1024L, IO_SIZE*2+MALLOC_OVERHEAD, ~0L, MALLOC_OVERHEAD, IO_SIZE, 0},
3875
  {"read_rnd_buffer_size", OPT_RECORD_RND_BUFFER,
3876
   "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.",
3877 3878 3879
   (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,
3880
   ~0L, MALLOC_OVERHEAD, IO_SIZE, 0},
3881 3882 3883 3884 3885
  {"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},
3886
  {"relay_log_space_limit", OPT_RELAY_LOG_SPACE_LIMIT,
3887 3888 3889
   "Max space to use for all relay logs",
   (gptr*) &relay_log_space_limit,
   (gptr*) &relay_log_space_limit, 0, GET_ULL, REQUIRED_ARG, 0L, 0L,
3890
   (longlong) ULONG_MAX, 0, 1, 0},
3891 3892 3893 3894 3895
  {"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},
3896
  {"slave_net_timeout", OPT_SLAVE_NET_TIMEOUT,
3897 3898
   "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,
3899 3900 3901 3902 3903
   GET_ULONG, REQUIRED_ARG, SLAVE_NET_TIMEOUT, 1, LONG_TIMEOUT, 0, 1, 0},
  {"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},
3904
  {"sort_buffer_size", OPT_SORT_BUFFER,
3905
   "Each thread that needs to do a sort allocates a buffer of this size.",
3906 3907
   (gptr*) &global_system_variables.sortbuff_size,
   (gptr*) &max_system_variables.sortbuff_size, 0, GET_ULONG, REQUIRED_ARG,
3908 3909 3910 3911 3912 3913 3914 3915 3916 3917 3918 3919 3920 3921 3922 3923
   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.",
3924 3925
   (gptr*) &global_system_variables.tmp_table_size,
   (gptr*) &max_system_variables.tmp_table_size, 0, GET_ULONG,
3926 3927 3928 3929 3930 3931 3932
   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",
3933 3934
   (gptr*) &global_system_variables.net_wait_timeout,
   (gptr*) &max_system_variables.net_wait_timeout, 0, GET_ULONG,
3935 3936
   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}
3937
};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3938 3939 3940


struct show_var_st status_vars[]= {
3941 3942 3943 3944
  {"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},
3945 3946 3947 3948 3949 3950 3951 3952 3953 3954 3955 3956 3957 3958
  {"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},
3959
  {"Com_delete_multi",	       (char*) (com_stat+(uint) SQLCOM_DELETE_MULTI),SHOW_LONG},
3960 3961 3962 3963 3964 3965
  {"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},
3966
  {"Com_ha_close",	       (char*) (com_stat+(uint) SQLCOM_HA_CLOSE),SHOW_LONG},
3967 3968
  {"Com_ha_open",	       (char*) (com_stat+(uint) SQLCOM_HA_OPEN),SHOW_LONG},
  {"Com_ha_read",	       (char*) (com_stat+(uint) SQLCOM_HA_READ),SHOW_LONG},
3969 3970 3971 3972
  {"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},
3973
  {"Com_load_master_data",    (char*) (com_stat+(uint) SQLCOM_LOAD_MASTER_DATA),SHOW_LONG},
3974 3975 3976 3977 3978 3979 3980 3981 3982 3983 3984 3985 3986 3987
  {"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},
  {"Com_select",	       (char*) (com_stat+(uint) SQLCOM_SELECT),SHOW_LONG},
  {"Com_set_option",	       (char*) (com_stat+(uint) SQLCOM_SET_OPTION),SHOW_LONG},
3988
  {"Com_show_binlog_events",   (char*) (com_stat+(uint) SQLCOM_SHOW_BINLOG_EVENTS),SHOW_LONG},
3989 3990 3991 3992 3993 3994 3995
  {"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},
3996
  {"Com_show_master_status",   (char*) (com_stat+(uint) SQLCOM_SHOW_MASTER_STAT),SHOW_LONG},
3997
  {"Com_show_new_master",      (char*) (com_stat+(uint) SQLCOM_SHOW_NEW_MASTER),SHOW_LONG},
3998 3999
  {"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},
4000
  {"Com_show_slave_hosts",     (char*) (com_stat+(uint) SQLCOM_SHOW_SLAVE_HOSTS),SHOW_LONG},
4001
  {"Com_show_slave_status",    (char*) (com_stat+(uint) SQLCOM_SHOW_SLAVE_STAT),SHOW_LONG},
4002
  {"Com_show_status",	       (char*) (com_stat+(uint) SQLCOM_SHOW_STATUS),SHOW_LONG},
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4003
  {"Com_show_innodb_status",   (char*) (com_stat+(uint) SQLCOM_SHOW_INNODB_STATUS),SHOW_LONG},
4004 4005 4006 4007 4008 4009 4010
  {"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},
4011
  {"Connections",              (char*) &thread_id,              SHOW_LONG_CONST},
4012
  {"Created_tmp_disk_tables",  (char*) &created_tmp_disk_tables,SHOW_LONG},
4013
  {"Created_tmp_tables",       (char*) &created_tmp_tables,     SHOW_LONG},
4014
  {"Created_tmp_files",	       (char*) &my_tmp_file_created,	SHOW_LONG},
4015
  {"Delayed_insert_threads",   (char*) &delayed_insert_threads, SHOW_LONG_CONST},
4016 4017 4018
  {"Delayed_writes",           (char*) &delayed_insert_writes,  SHOW_LONG},
  {"Delayed_errors",           (char*) &delayed_insert_errors,  SHOW_LONG},
  {"Flush_commands",           (char*) &refresh_version,        SHOW_LONG_CONST},
4019
  {"Handler_commit",           (char*) &ha_commit_count,        SHOW_LONG},
4020 4021 4022 4023 4024 4025 4026
  {"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},
4027
  {"Handler_rollback",         (char*) &ha_rollback_count,      SHOW_LONG},
4028 4029 4030 4031 4032 4033 4034 4035 4036 4037 4038
  {"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},
4039 4040
  {"Open_files",               (char*) &my_file_opened,         SHOW_LONG_CONST},
  {"Open_streams",             (char*) &my_stream_opened,       SHOW_LONG_CONST},
4041 4042
  {"Opened_tables",            (char*) &opened_tables,          SHOW_LONG},
  {"Questions",                (char*) 0,                       SHOW_QUESTION},
4043
#ifdef HAVE_QUERY_CACHE
4044
  {"Qcache_queries_in_cache",  (char*) &query_cache.queries_in_cache, SHOW_LONG_CONST},
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4045 4046
  {"Qcache_inserts",           (char*) &query_cache.inserts,    SHOW_LONG},
  {"Qcache_hits",              (char*) &query_cache.hits,       SHOW_LONG},
4047
  {"Qcache_lowmem_prunes",     (char*) &query_cache.lowmem_prunes, SHOW_LONG},
4048
  {"Qcache_not_cached",        (char*) &query_cache.refused,    SHOW_LONG},
4049 4050 4051 4052 4053 4054
  {"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},
4055
#endif /*HAVE_QUERY_CACHE*/
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4056
  {"Rpl_status",               (char*) 0,                 SHOW_RPL_STATUS},
4057 4058 4059 4060 4061
  {"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},
4062
  {"Slave_open_temp_tables",   (char*) &slave_open_temp_tables, SHOW_LONG},
4063
  {"Slave_running",            (char*) 0, SHOW_SLAVE_RUNNING},
4064 4065
  {"Slow_launch_threads",      (char*) &slow_launch_threads,    SHOW_LONG},
  {"Slow_queries",             (char*) &long_query_count,       SHOW_LONG},
4066
  {"Sort_merge_passes",	       (char*) &filesort_merge_passes,  SHOW_LONG},
4067 4068 4069
  {"Sort_range",	       (char*) &filesort_range_count,   SHOW_LONG},
  {"Sort_rows",		       (char*) &filesort_rows,	        SHOW_LONG},
  {"Sort_scan",		       (char*) &filesort_scan_count,    SHOW_LONG},
tonu@x153.internalnet's avatar
tonu@x153.internalnet committed
4070
#ifdef HAVE_OPENSSL
4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 4081 4082 4083 4084 4085 4086 4087 4088 4089 4090 4091 4092 4093
  {"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},
tonu@x153.internalnet's avatar
tonu@x153.internalnet committed
4094
#endif /* HAVE_OPENSSL */
4095 4096
  {"Table_locks_immediate",    (char*) &locks_immediate,        SHOW_LONG},
  {"Table_locks_waited",       (char*) &locks_waited,           SHOW_LONG},
4097
  {"Threads_cached",           (char*) &cached_thread_count,    SHOW_LONG_CONST},
4098
  {"Threads_created",	       (char*) &thread_created,		SHOW_LONG_CONST},
4099 4100 4101 4102
  {"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}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4103 4104 4105 4106 4107 4108 4109 4110
};

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

4111 4112 4113
static void use_help(void)
{
  print_version();
4114
  printf("Use '--help' or '--no-defaults --help' for a list of available options\n");
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4115
}
4116

bk@work.mysql.com's avatar
bk@work.mysql.com committed
4117 4118 4119
static void usage(void)
{
  print_version();
4120 4121 4122 4123 4124
  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");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4125 4126 4127 4128

  printf("Usage: %s [OPTIONS]\n", my_progname);
#ifdef __WIN__
  puts("NT and Win32 specific options:\n\
4129 4130
  --install                     Install the default service (NT)\n\
  --install-manual              Install the default service started manually (NT)\n\
4131 4132
  --install service_name        Install an optional service (NT)\n\
  --install-manual service_name Install an optional service started manually (NT)\n\
4133
  --remove                      Remove the default service from the service list (NT)\n\
4134 4135 4136
  --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)\
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4137
");
4138
  puts("");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4139
#endif
4140
  print_defaults(MYSQL_CONFIG_NAME,load_default_groups);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4141 4142 4143
  puts("");
  fix_paths();
  set_ports();
4144 4145 4146 4147

  my_print_help(my_long_options);
  my_print_variables(my_long_options);

4148
  puts("\n\
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4149
To see what values a running MySQL server is using, type\n\
4150
'mysqladmin variables' instead of 'mysqld --help'.");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4151 4152 4153 4154 4155 4156 4157 4158 4159
}


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

4160
  sys_charset.value= (char*) MYSQL_CHARSET;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4161 4162
  (void) strmake(language, LANGUAGE, sizeof(language)-1);
  (void) strmake(mysql_real_data_home, get_relative_path(DATADIR),
4163
		 sizeof(mysql_real_data_home)-1);
4164 4165 4166

  /* Set default values for some variables */
  global_system_variables.table_type=DB_TYPE_MYISAM;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4167
  global_system_variables.tx_isolation=ISO_REPEATABLE_READ;
4168 4169 4170 4171
  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;
4172

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4173 4174
#if defined(__WIN__) || defined(__NETWARE__)
  /* Allow Win32 and NetWare users to move MySQL anywhere */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4175 4176 4177 4178 4179 4180 4181 4182
  {
    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;
4183
  if (!(tmpenv = getenv("MY_BASEDIR_VERSION")))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4184
    tmpenv = DEFAULT_MYSQL_HOME;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4185
  (void) strmake(mysql_home, tmpenv, sizeof(mysql_home)-1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4186 4187
#endif

4188
  my_disable_locking=myisam_single_user= 1;
4189
  opt_external_locking=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4190 4191 4192 4193
  my_bind_addr = htonl( INADDR_ANY );
}


4194
extern "C" my_bool
4195 4196
get_one_option(int optid, const struct my_option *opt __attribute__((unused)),
	       char *argument)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4197
{
4198 4199
  switch(optid) {
  case '#':
4200
#ifndef DBUG_OFF
4201 4202 4203 4204 4205 4206 4207 4208
    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);
4209
    global_system_variables.tx_isolation= ISO_SERIALIZABLE;
4210 4211 4212 4213 4214 4215 4216 4217 4218
    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);
4219 4220
    /* Correct pointer set by my_getopt (for embedded library) */
    mysql_data_home= mysql_real_data_home;
4221 4222 4223 4224 4225 4226 4227 4228 4229 4230 4231 4232 4233 4234
    break;
  case 'L':
    strmake(language, argument, sizeof(language)-1);
    break;
  case 'n':
    opt_specialflag|= SPECIAL_NEW_FUNC;
    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:
4235
#if !defined(DBUG_OFF) && defined(SAFEMALLOC)      
4236
    safemalloc_mem_limit = atoi(argument);
4237
#endif      
4238
    break;
4239 4240 4241 4242 4243 4244 4245 4246
#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
4247
#include <sslopt-case.h>
4248 4249 4250 4251 4252 4253 4254 4255 4256 4257
  case 'v':
  case 'V':
    print_version();
    exit(0);
  case 'I':
  case '?':
    usage();
    exit(0);
  case 'T':
    test_flags= argument ? (uint) atoi(argument) : 0;
4258
    test_flags&= ~TEST_NO_THREADS;
4259 4260 4261 4262 4263 4264 4265 4266 4267 4268 4269 4270 4271 4272
    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;
4273 4274 4275
  case (int) OPT_ERROR_LOG_FILE:
    opt_error_log= 1;
    break;
4276
  case (int) OPT_INIT_RPL_ROLE:
4277 4278 4279
  {
    int role;
    if ((role=find_type(argument, &rpl_role_typelib, 2)) <= 0)
4280
    {
4281 4282
      fprintf(stderr, "Unknown replication role: %s\n", argument);
      exit(1);
4283
    }
4284 4285 4286
    rpl_status = (role == 1) ?  RPL_AUTH_MASTER : RPL_IDLE_SLAVE;
    break;
  }
4287
  case (int)OPT_REPLICATE_IGNORE_DB:
4288 4289 4290 4291 4292 4293 4294 4295 4296 4297 4298 4299 4300 4301 4302 4303
  {
    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, "->")))
4304
    {
4305 4306 4307
      fprintf(stderr,
	      "Bad syntax in replicate-rewrite-db - missing '->'!\n");
      exit(1);
4308
    }
4309 4310 4311 4312
    val= p--;
    while (isspace(*p) && p > argument)
      *p-- = 0;
    if (p == argument)
4313
    {
4314 4315 4316
      fprintf(stderr,
	      "Bad syntax in replicate-rewrite-db - empty FROM db!\n");
      exit(1);
4317
    }
4318 4319 4320 4321 4322
    *val= 0;
    val+= 2;
    while (*val && isspace(*val))
      *val++;
    if (!*val)
4323
    {
4324 4325 4326
      fprintf(stderr,
	      "Bad syntax in replicate-rewrite-db - empty TO db!\n");
      exit(1);
4327 4328
    }

4329 4330 4331 4332 4333
    i_string_pair *db_pair = new i_string_pair(key, val);
    replicate_rewrite_db.push_back(db_pair);
    break;
  }

4334
  case (int)OPT_BINLOG_IGNORE_DB:
4335 4336 4337 4338 4339
  {
    i_string *db = new i_string(argument);
    binlog_ignore_db.push_back(db);
    break;
  }
4340
  case (int)OPT_BINLOG_DO_DB:
4341 4342 4343 4344 4345
  {
    i_string *db = new i_string(argument);
    binlog_do_db.push_back(db);
    break;
  }
4346
  case (int)OPT_REPLICATE_DO_TABLE:
4347 4348 4349 4350
  {
    if (!do_table_inited)
      init_table_rule_hash(&replicate_do_table, &do_table_inited);
    if (add_table_rule(&replicate_do_table, argument))
4351
    {
4352 4353
      fprintf(stderr, "Could not add do table rule '%s'!\n", argument);
      exit(1);
4354
    }
4355 4356 4357
    table_rules_on = 1;
    break;
  }
4358
  case (int)OPT_REPLICATE_WILD_DO_TABLE:
4359 4360 4361 4362 4363
  {
    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))
4364
    {
4365 4366
      fprintf(stderr, "Could not add do table rule '%s'!\n", argument);
      exit(1);
4367
    }
4368 4369 4370
    table_rules_on = 1;
    break;
  }
4371
  case (int)OPT_REPLICATE_WILD_IGNORE_TABLE:
4372 4373 4374 4375 4376
  {
    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))
4377
    {
4378 4379
      fprintf(stderr, "Could not add ignore table rule '%s'!\n", argument);
      exit(1);
4380
    }
4381 4382 4383
    table_rules_on = 1;
    break;
  }
4384
  case (int)OPT_REPLICATE_IGNORE_TABLE:
4385 4386 4387 4388
  {
    if (!ignore_table_inited)
      init_table_rule_hash(&replicate_ignore_table, &ignore_table_inited);
    if (add_table_rule(&replicate_ignore_table, argument))
4389
    {
4390 4391
      fprintf(stderr, "Could not add ignore table rule '%s'!\n", argument);
      exit(1);
4392
    }
4393 4394 4395
    table_rules_on = 1;
    break;
  }
4396 4397 4398 4399 4400 4401 4402 4403 4404
  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;
4405
    delay_key_write_options= (uint) DELAY_KEY_WRITE_NONE;
4406 4407 4408 4409 4410
    myisam_concurrent_insert=0;
    myisam_recover_options= HA_RECOVER_NONE;
    my_disable_symlinks=1;
    my_use_symdir=0;
    have_symlink=SHOW_OPTION_DISABLED;
4411
    ha_open_options&= ~(HA_OPEN_ABORT_IF_CRASHED | HA_OPEN_DELAY_KEY_WRITE);
4412
#ifdef HAVE_QUERY_CACHE
4413 4414 4415 4416 4417
    query_cache_size=0;
#endif
    break;
  case (int) OPT_SAFE:
    opt_specialflag|= SPECIAL_SAFE_MODE;
4418
    delay_key_write_options= (uint) DELAY_KEY_WRITE_NONE;
4419 4420
    myisam_recover_options= HA_RECOVER_DEFAULT;
    ha_open_options&= ~(HA_OPEN_DELAY_KEY_WRITE);
4421 4422 4423 4424 4425
    break;
  case (int) OPT_SKIP_PRIOR:
    opt_specialflag|= SPECIAL_NO_PRIOR;
    break;
  case (int) OPT_SKIP_LOCK:
4426
    opt_external_locking=0;
4427 4428 4429 4430 4431 4432 4433 4434 4435 4436 4437 4438 4439 4440 4441 4442 4443 4444
    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;
4445
#ifdef ONE_THREAD
4446 4447
  case (int) OPT_ONE_THREAD:
    test_flags |= TEST_NO_THREADS;
4448
#endif
4449 4450 4451 4452 4453 4454 4455 4456 4457 4458 4459 4460 4461 4462 4463 4464 4465 4466 4467 4468
    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_disable_symlinks=1;
    my_use_symdir=0;
    have_symlink=SHOW_OPTION_DISABLED;
    break;
  case (int) OPT_BIND_ADDRESS:
    if (argument && isdigit(argument[0]))
    {
      my_bind_addr = (ulong) inet_addr(argument);
    }
    else
    {
      struct hostent *ent;
4469
      if (argument || argument[0])
4470
	ent=gethostbyname(argument);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4471 4472
      else
      {
4473 4474
	char myhostname[255];
	if (gethostname(myhostname,sizeof(myhostname)) < 0)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4475
	{
4476
	  sql_perror("Can't start server: cannot get my own hostname!");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4477 4478
	  exit(1);
	}
4479
	ent=gethostbyname(myhostname);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4480
      }
4481 4482 4483 4484 4485 4486 4487 4488 4489 4490 4491
      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;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4492
#ifdef __WIN__
4493 4494
  case (int) OPT_STANDALONE:		/* Dummy option for NT */
    break;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4495
#endif
4496 4497 4498 4499
  case OPT_CONSOLE:
    if (opt_console)
      opt_error_log= 0;			// Force logs to stdout
    break;
4500
  case (int) OPT_FLUSH:
4501
#ifdef HAVE_ISAM
4502 4503 4504 4505 4506 4507 4508
    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;
4509
    global_system_variables.low_priority_updates=1;
4510 4511 4512 4513 4514
    break;
  case OPT_BOOTSTRAP:
    opt_noacl=opt_bootstrap=1;
    break;
  case OPT_TABLE_TYPE:
4515 4516 4517
  {
    int type;
    if ((type=find_type(argument, &ha_table_typelib, 2)) <= 0)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4518
    {
4519 4520
      fprintf(stderr,"Unknown table type: %s\n",argument);
      exit(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4521
    }
4522
    global_system_variables.table_type= type-1;
4523 4524
    break;
  }
4525 4526 4527
  case OPT_SERVER_ID:
    server_id_supplied = 1;
    break;
4528 4529 4530 4531
  case OPT_DELAY_KEY_WRITE_ALL:
    if (argument != disabled_my_option)
      argument= (char*) "ALL";
    /* Fall through */
4532
  case OPT_DELAY_KEY_WRITE:
4533 4534 4535 4536 4537 4538 4539 4540 4541 4542 4543 4544 4545 4546
    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;
    }
4547 4548 4549 4550 4551 4552
    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:
4553 4554 4555
  {
    int type;
    if ((type=find_type(argument, &tx_isolation_typelib, 2)) <= 0)
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
4556
    {
4557 4558
      fprintf(stderr,"Unknown transaction isolation type: %s\n",argument);
      exit(1);
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
4559
    }
4560
    global_system_variables.tx_isolation= (type-1);
4561 4562
    break;
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4563
#ifdef HAVE_BERKELEY_DB
4564 4565 4566 4567 4568 4569 4570
  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:
4571 4572 4573 4574 4575
  {
    int type;
    if ((type=find_type(argument, &berkeley_lock_typelib, 2)) > 0)
      berkeley_lock_type=berkeley_lock_types[type-1];
    else
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4576
    {
4577 4578
      if (test_if_int(argument,(uint) strlen(argument)))
	berkeley_lock_scan_time=atoi(argument);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4579 4580
      else
      {
4581 4582
	fprintf(stderr,"Unknown lock type: %s\n",argument);
	exit(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4583 4584
      }
    }
4585 4586
    break;
  }
4587 4588 4589 4590
  case OPT_BDB_SHARED:
    berkeley_init_flags&= ~(DB_PRIVATE);
    berkeley_shared_data=1;
    break;
4591
#endif /* HAVE_BERKELEY_DB */
4592
  case OPT_BDB_SKIP:
4593
#ifdef HAVE_BERKELEY_DB
4594 4595
    berkeley_skip=1;
    have_berkeley_db=SHOW_OPTION_DISABLED;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
4596
#endif
4597 4598
    break;
  case OPT_INNODB_SKIP:
4599
#ifdef HAVE_INNOBASE_DB
4600 4601
    innodb_skip=1;
    have_innodb=SHOW_OPTION_DISABLED;
4602
#endif
4603 4604
    break;
  case OPT_INNODB_DATA_FILE_PATH:
4605
#ifdef HAVE_INNOBASE_DB
4606
    innobase_data_file_path=argument;
4607
#endif
4608
    break;
4609
#ifdef HAVE_INNOBASE_DB
4610 4611 4612 4613 4614 4615
  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;
4616
#endif /* HAVE_INNOBASE_DB */
4617
  case OPT_MYISAM_RECOVER:
4618 4619
  {
    if (!argument || !argument[0])
4620
    {
4621 4622
      myisam_recover_options=    HA_RECOVER_DEFAULT;
      myisam_recover_options_str= myisam_recover_typelib.type_names[0];
4623
    }
4624
    else
4625
    {
4626 4627 4628
      myisam_recover_options_str=argument;
      if ((myisam_recover_options=
	   find_bit_type(argument, &myisam_recover_typelib)) == ~(ulong) 0)
4629
      {
4630
	fprintf(stderr, "Unknown option to myisam-recover: %s\n",argument);
4631 4632 4633
	exit(1);
      }
    }
4634 4635 4636 4637 4638 4639 4640 4641 4642 4643 4644 4645
    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);
    }
4646 4647
    global_system_variables.tx_isolation= ((opt_sql_mode & MODE_SERIALIZABLE) ?
					   ISO_SERIALIZABLE :
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4648
					   ISO_REPEATABLE_READ);
4649 4650
    break;
  }
4651 4652 4653 4654
  case OPT_MASTER_PASSWORD:
    master_password=argument;
    break;
  case OPT_SKIP_SAFEMALLOC:
4655
#ifdef SAFEMALLOC
4656
    sf_malloc_quick=1;
4657
#endif
4658
    break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4659
  }
4660 4661 4662 4663 4664 4665 4666 4667 4668
  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)))
4669
    exit(ho_error);
4670

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4671
#if defined(HAVE_BROKEN_REALPATH)
4672 4673 4674 4675 4676 4677 4678 4679 4680 4681 4682 4683 4684
  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
  /* Set global MyISAM variables from delay_key_write_options */
  fix_delay_key_write((THD*) 0, OPT_GLOBAL);

4685 4686
  if (mysqld_chroot)
    set_root(mysqld_chroot);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4687
  fix_paths();
4688

4689 4690 4691 4692
  /*
    Set some global variables from the global_system_variables
    In most cases the global variables will not be used
  */
4693
  my_disable_locking= myisam_single_user= test(opt_external_locking == 0);
4694
  my_default_record_cache_size=global_system_variables.read_buff_size;
4695
  myisam_max_temp_length=
4696
    (my_off_t) min(global_system_variables.myisam_max_sort_file_size,
4697 4698
		   (ulonglong) MAX_FILE_SIZE);
  myisam_max_extra_temp_length= 
4699
    (my_off_t) min(global_system_variables.myisam_max_extra_sort_file_size,
4700
		   (ulonglong) MAX_FILE_SIZE);
4701

4702
  /* Set global variables based on startup options */
4703
  myisam_block_size=(uint) 1 << my_bit_log2(opt_myisam_block_size);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4704 4705 4706 4707 4708 4709
}


static char *get_relative_path(const char *path)
{
  if (test_if_hard_path(path) &&
4710
      is_prefix(path,DEFAULT_MYSQL_HOME) &&
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4711 4712
      strcmp(DEFAULT_MYSQL_HOME,FN_ROOTDIR))
  {
4713
    path+=(uint) strlen(DEFAULT_MYSQL_HOME);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4714 4715 4716 4717 4718 4719 4720
    while (*path == FN_LIBCHAR)
      path++;
  }
  return (char*) path;
}


4721 4722 4723 4724 4725 4726 4727 4728 4729 4730 4731 4732 4733 4734 4735 4736 4737 4738 4739 4740 4741 4742
/*
  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);
}


bk@work.mysql.com's avatar
bk@work.mysql.com committed
4743 4744
static void fix_paths(void)
{
4745
  char buff[FN_REFLEN],*pos;
4746
  convert_dirname(mysql_home,mysql_home,NullS);
4747
  /* Resolve symlinks to allow 'mysql_home' to be a relative symlink */
4748
  my_realpath(mysql_home,mysql_home,MYF(0));
4749 4750 4751 4752 4753 4754 4755
  /* Ensure that mysql_home ends in FN_LIBCHAR */
  pos=strend(mysql_home);
  if (pos[-1] != FN_LIBCHAR)
  {
    pos[0]= FN_LIBCHAR;
    pos[1]= 0;
  }
4756 4757
  convert_dirname(mysql_real_data_home,mysql_real_data_home,NullS);
  convert_dirname(language,language,NullS);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4758 4759 4760 4761
  (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);

4762
  char *sharedir=get_relative_path(SHAREDIR);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4763
  if (test_if_hard_path(sharedir))
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4764
    strmake(buff,sharedir,sizeof(buff)-1);		/* purecov: tested */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4765
  else
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4766
    strxnmov(buff,sizeof(buff)-1,mysql_home,sharedir,NullS);
4767
  convert_dirname(buff,buff,NullS);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4768 4769 4770 4771 4772
  (void) my_load_path(language,language,buff);

  /* If --character-sets-dir isn't given, use shared library dir */
  if (charsets_dir != mysql_charsets_dir)
  {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4773 4774
    strxnmov(mysql_charsets_dir, sizeof(mysql_charsets_dir)-1, buff,
	     CHARSET_DIR, NullS);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4775 4776 4777
    charsets_dir=mysql_charsets_dir;
  }

4778
  char *end=convert_dirname(buff, opt_mysql_tmpdir, NullS);
4779 4780
  if (!(mysql_tmpdir= my_memdup((byte*) buff,(uint) (end-buff)+1,
				MYF(MY_FAE))))
4781
    exit(1);
4782 4783
  if (!slave_load_tmpdir)
  {
4784 4785
    if (!(slave_load_tmpdir = (char*) my_strdup(mysql_tmpdir, MYF(MY_FAE))))
      exit(1);
4786
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4787 4788 4789
}


4790

bk@work.mysql.com's avatar
bk@work.mysql.com committed
4791 4792 4793 4794 4795 4796 4797 4798 4799 4800 4801 4802 4803 4804
#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))
    {
4805 4806
      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 */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4807 4808 4809 4810 4811 4812
      max_file_limit=old_cur;
    }
    else
    {
      (void) getrlimit(RLIMIT_NOFILE,&rlimit);
      if ((uint) rlimit.rlim_cur != max_file_limit)
4813 4814 4815
	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 */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4816 4817 4818 4819 4820 4821 4822
      max_file_limit=rlimit.rlim_cur;
    }
  }
  return max_file_limit;
}
#endif

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4823 4824 4825 4826 4827 4828 4829 4830 4831 4832 4833 4834 4835 4836 4837 4838 4839 4840 4841 4842 4843 4844 4845
#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
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4846

4847 4848 4849 4850
/*
  Return a bitfield from a string of substrings separated by ','
  returns ~(ulong) 0 on error.
*/
4851 4852 4853 4854 4855 4856 4857 4858 4859 4860 4861 4862 4863 4864

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;
4865 4866 4867
  while (*pos == ' ') pos++;
  found_end= *pos == 0;
  while (!found_end)
4868 4869 4870 4871
  {
    if (!*(end=strcend(pos,',')))		/* Let end point at fieldend */
    {
      while (end > pos && end[-1] == ' ')
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4872
	end--;					/* Skip end-space */
4873 4874 4875 4876 4877 4878 4879 4880 4881 4882 4883 4884 4885 4886 4887 4888 4889 4890 4891 4892 4893 4894 4895 4896 4897 4898 4899
      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;
4900
  }
4901 4902 4903 4904 4905 4906

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


bk@work.mysql.com's avatar
bk@work.mysql.com committed
4907
/*****************************************************************************
4908
  Instantiate templates
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4909 4910 4911 4912 4913 4914 4915
*****************************************************************************/

#ifdef __GNUC__
/* Used templates */
template class I_List<THD>;
template class I_List_iterator<THD>;
template class I_List<i_string>;
4916
template class I_List<i_string_pair>;
4917 4918

FIX_GCC_LINKING_PROBLEM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4919
#endif