314
314
uint64_t connect_timeout;
315
315
uint32_t server_id;
316
ulong table_cache_size, table_def_size;
316
uint64_t table_cache_size;
317
uint64_t table_def_size;
317
318
ulong what_to_log;
318
ulong slow_launch_time, slave_open_temp_tables;
319
uint64_t slow_launch_time;
320
ulong slave_open_temp_tables;
319
321
ulong open_files_limit;
320
ulong max_binlog_size;
321
ulong max_relay_log_size;
322
ulong slave_net_timeout;
323
ulong slave_trans_retries;
322
uint64_t max_binlog_size;
323
uint64_t max_relay_log_size;
324
uint64_t slave_net_timeout;
325
uint64_t slave_trans_retries;
324
326
bool slave_allow_batching;
325
327
ulong slave_exec_mode_options;
326
328
const char *slave_exec_mode_str= "STRICT";
327
ulong thread_cache_size= 0;
329
uint64_t thread_cache_size= 0;
328
330
uint64_t thread_pool_size= 0;
329
331
uint64_t binlog_cache_size= 0;
330
332
uint64_t max_binlog_cache_size= 0;
334
336
ulong specialflag= 0;
335
337
ulong binlog_cache_use= 0;
336
338
ulong binlog_cache_disk_use= 0;
337
ulong max_connections;
338
ulong max_connect_errors;
339
uint64_t max_connections;
340
uint64_t max_connect_errors;
339
341
ulong thread_id=1L;
340
342
pid_t current_pid;
341
343
ulong slow_launch_threads = 0;
342
ulong sync_binlog_period;
344
uint64_t sync_binlog_period;
343
345
uint64_t expire_logs_days= 0;
344
ulong rpl_recovery_rank=0;
345
346
const char *log_output_str= "FILE";
347
348
const double log_10[] = {
1939
1940
table_cache_size);
1940
1941
if (global_system_variables.log_warnings)
1941
1942
sql_print_warning(_("Changed limits: max_open_files: %u "
1942
"max_connections: %ld table_cache: %ld"),
1943
"max_connections: %"PRIu64" table_cache: %"PRIu64""),
1943
1944
files, max_connections, table_cache_size);
1945
1946
else if (global_system_variables.log_warnings)
2295
2296
if (opt_bin_log && drizzle_bin_log.open(opt_bin_logname, LOG_BIN, 0,
2296
WRITE_CACHE, 0, max_binlog_size, 0))
2297
WRITE_CACHE, 0, max_binlog_size, 0))
2297
2298
unireg_abort(1);
2299
2300
if (opt_bin_log && expire_logs_days)
3371
3372
REQUIRED_ARG, 32, 1, ULONG_MAX, 0, 1, 0},
3372
3373
{"max_write_lock_count", OPT_MAX_WRITE_LOCK_COUNT,
3373
3374
N_("After this many write locks, allow some read locks to run in between."),
3374
(char**) &max_write_lock_count, (char**) &max_write_lock_count, 0, GET_ULONG,
3375
(char**) &max_write_lock_count, (char**) &max_write_lock_count, 0, GET_ULL,
3375
3376
REQUIRED_ARG, ULONG_MAX, 1, ULONG_MAX, 0, 1, 0},
3376
3377
{"min_examined_row_limit", OPT_MIN_EXAMINED_ROW_LIMIT,
3377
3378
N_("Don't log queries which examine less than min_examined_row_limit "
3449
3450
"descriptors to use with setrlimit(). If this value is 0 then drizzled "
3450
3451
"will reserve max_connections*5 or max_connections + table_cache*2 "
3451
3452
"(whichever is larger) number of files."),
3452
(char**) &open_files_limit, (char**) &open_files_limit, 0, GET_ULONG,
3453
(char**) &open_files_limit, (char**) &open_files_limit, 0, GET_ULL,
3453
3454
REQUIRED_ARG, 0, 0, OS_FILE_LIMIT, 0, 1, 0},
3454
3455
{"optimizer_prune_level", OPT_OPTIMIZER_PRUNE_LEVEL,
3455
3456
N_("Controls the heuristic(s) applied during query optimization to prune "
3545
3546
N_("Number of seconds to wait for more data from a master/slave connection "
3546
3547
"before aborting the read."),
3547
3548
(char**) &slave_net_timeout, (char**) &slave_net_timeout, 0,
3548
GET_ULONG, REQUIRED_ARG, SLAVE_NET_TIMEOUT, 1, LONG_TIMEOUT, 0, 1, 0},
3549
GET_UINT, REQUIRED_ARG, SLAVE_NET_TIMEOUT, 1, LONG_TIMEOUT, 0, 1, 0},
3549
3550
{"slave_transaction_retries", OPT_SLAVE_TRANS_RETRIES,
3550
3551
N_("Number of times the slave SQL thread will retry a transaction in case "
3551
3552
"it failed with a deadlock or elapsed lock wait timeout, "
3552
3553
"before giving up and stopping."),
3553
3554
(char**) &slave_trans_retries, (char**) &slave_trans_retries, 0,
3554
GET_ULONG, REQUIRED_ARG, 10L, 0L, (int64_t) ULONG_MAX, 0, 1, 0},
3555
GET_ULL, REQUIRED_ARG, 10L, 0L, (int64_t) ULONG_MAX, 0, 1, 0},
3555
3556
{"slave-allow-batching", OPT_SLAVE_ALLOW_BATCHING,
3556
3557
N_("Allow slave to batch requests."),
3557
3558
(char**) &slave_allow_batching, (char**) &slave_allow_batching,
3559
3560
{"slow_launch_time", OPT_SLOW_LAUNCH_TIME,
3560
3561
N_("If creating the thread takes longer than this value (in seconds), the "
3561
3562
"Slow_launch_threads counter will be incremented."),
3562
(char**) &slow_launch_time, (char**) &slow_launch_time, 0, GET_ULONG,
3563
(char**) &slow_launch_time, (char**) &slow_launch_time, 0, GET_ULL,
3563
3564
REQUIRED_ARG, 2L, 0L, LONG_TIMEOUT, 0, 1, 0},
3564
3565
{"sort_buffer_size", OPT_SORT_BUFFER,
3565
3566
N_("Each thread that needs to do a sort allocates a buffer of this size."),
3570
3571
{"sync-binlog", OPT_SYNC_BINLOG,
3571
3572
N_("Synchronously flush binary log to disk after every #th event. "
3572
3573
"Use 0 (default) to disable synchronous flushing."),
3573
(char**) &sync_binlog_period, (char**) &sync_binlog_period, 0, GET_ULONG,
3574
(char**) &sync_binlog_period, (char**) &sync_binlog_period, 0, GET_ULL,
3574
3575
REQUIRED_ARG, 0, 0, ULONG_MAX, 0, 1, 0},
3575
3576
{"table_definition_cache", OPT_TABLE_DEF_CACHE,
3576
3577
N_("The number of cached table definitions."),
3577
3578
(char**) &table_def_size, (char**) &table_def_size,
3578
0, GET_ULONG, REQUIRED_ARG, 128, 1, 512*1024L, 0, 1, 0},
3579
0, GET_ULL, REQUIRED_ARG, 128, 1, 512*1024L, 0, 1, 0},
3579
3580
{"table_open_cache", OPT_TABLE_OPEN_CACHE,
3580
3581
N_("The number of cached open tables."),
3581
3582
(char**) &table_cache_size, (char**) &table_cache_size, 0, GET_ULONG,
3584
3585
N_("Timeout in seconds to wait for a table level lock before returning an "
3585
3586
"error. Used only if the connection has active cursors."),
3586
3587
(char**) &table_lock_wait_timeout, (char**) &table_lock_wait_timeout,
3587
0, GET_ULONG, REQUIRED_ARG, 50, 1, 1024 * 1024 * 1024, 0, 1, 0},
3588
0, GET_ULL, REQUIRED_ARG, 50, 1, 1024 * 1024 * 1024, 0, 1, 0},
3588
3589
{"thread_cache_size", OPT_THREAD_CACHE_SIZE,
3589
3590
N_("How many threads we should keep in a cache for reuse."),
3590
3591
(char**) &thread_cache_size, (char**) &thread_cache_size, 0, GET_ULONG,