~drizzle-trunk/drizzle/development : revision 619

2884

{"completion-type", OPT_COMPLETION_TYPE,

2885

N_("Default completion type."),

2886

(char**) &global_system_variables.completion_type,

2887

(char**) &max_system_variables.completion_type, 0, GET_ULONG,

2887

(char**) &max_system_variables.completion_type, 0, GET_UINT,

2888

REQUIRED_ARG, 0, 0, 2, 0, 1, 0},

2889

{"console", OPT_CONSOLE,

2890

N_("Write error output on screen."),

3209

"a limit per thread!"),

3210

(char**) &global_system_variables.bulk_insert_buff_size,

3211

(char**) &max_system_variables.bulk_insert_buff_size,

3212

0, GET_ULONG, REQUIRED_ARG, 8192*1024, 0, ULONG_MAX, 0, 1, 0},

3212

0, GET_ULL, REQUIRED_ARG, 8192*1024, 0, ULONG_MAX, 0, 1, 0},

3213

{ "connect_timeout", OPT_CONNECT_TIMEOUT,

3214

N_("The number of seconds the drizzled server is waiting for a connect "

3215

"packet before responding with 'Bad handshake'."),

3234

N_("Precision of the result of '/' operator will be increased on that "

3235

"value."),

3236

(char**) &global_system_variables.div_precincrement,

3237

(char**) &max_system_variables.div_precincrement, 0, GET_ULONG,

3237

(char**) &max_system_variables.div_precincrement, 0, GET_UINT,

3238

REQUIRED_ARG, 4, 0, DECIMAL_MAX_SCALE, 0, 0, 0},

3239

{ "expire_logs_days", OPT_EXPIRE_LOGS_DAYS,

3240

N_("If non-zero, binary logs will be purged after expire_logs_days "

3376

N_("Don't log queries which examine less than min_examined_row_limit "

3377

"rows to file."),

3378

(char**) &global_system_variables.min_examined_row_limit,

3379

(char**) &max_system_variables.min_examined_row_limit, 0, GET_ULONG,

3379

(char**) &max_system_variables.min_examined_row_limit, 0, GET_ULL,

3380

REQUIRED_ARG, 0, 0, ULONG_MAX, 0, 1L, 0},

3381

{"myisam_block_size", OPT_MYISAM_BLOCK_SIZE,

3382

N_("Block size to be used for MyISAM index pages."),

3451

(char**) &open_files_limit, (char**) &open_files_limit, 0, GET_ULONG,

3452

REQUIRED_ARG, 0, 0, OS_FILE_LIMIT, 0, 1, 0},

3453

{"optimizer_prune_level", OPT_OPTIMIZER_PRUNE_LEVEL,

3454

N_("Controls the heuristic(s) applied during query optimization to prune "

3455

"less-promising partial plans from the optimizer search space. Meaning: "

3456

"0 - do not apply any heuristic, thus perform exhaustive search; "

3457

"1 - prune plans based on number of retrieved rows."),

3458

(char**) &global_system_variables.optimizer_prune_level,

3459

(char**) &max_system_variables.optimizer_prune_level,

3460

0, GET_ULONG, OPT_ARG, 1, 0, 1, 0, 1, 0},

3454

N_("Controls the heuristic(s) applied during query optimization to prune "

3455

"less-promising partial plans from the optimizer search space. Meaning: "

3456

"false - do not apply any heuristic, thus perform exhaustive search; "

3457

"true - prune plans based on number of retrieved rows."),

3458

(char**) &global_system_variables.optimizer_prune_level,

3459

(char**) &max_system_variables.optimizer_prune_level,

3460

0, GET_BOOL, OPT_ARG, 1, 0, 1, 0, 1, 0},

3461

{"optimizer_search_depth", OPT_OPTIMIZER_SEARCH_DEPTH,

3462

N_("Maximum depth of search performed by the query optimizer. Values "

3463

"larger than the number of relations in a query result in better query "

3469

"testing/comparison)."),

3470

(char**) &global_system_variables.optimizer_search_depth,

3471

(char**) &max_system_variables.optimizer_search_depth,

3472

0, GET_ULONG, OPT_ARG, MAX_TABLES+1, 0, MAX_TABLES+2, 0, 1, 0},

3472

0, GET_UINT, OPT_ARG, MAX_TABLES+1, 0, MAX_TABLES+2, 0, 1, 0},

3473

{"plugin_dir", OPT_PLUGIN_DIR,

3474

N_("Directory for plugins."),

3475

(char**) &opt_plugin_dir_ptr, (char**) &opt_plugin_dir_ptr, 0,

3483

{"preload_buffer_size", OPT_PRELOAD_BUFFER_SIZE,

3484

N_("The size of the buffer that is allocated when preloading indexes"),

3485

(char**) &global_system_variables.preload_buff_size,

3486

(char**) &max_system_variables.preload_buff_size, 0, GET_ULONG,

3486

(char**) &max_system_variables.preload_buff_size, 0, GET_ULL,

3487

REQUIRED_ARG, 32*1024L, 1024, 1024*1024*1024L, 0, 1, 0},

3488

{"query_alloc_block_size", OPT_QUERY_ALLOC_BLOCK_SIZE,

3489

N_("Allocation block size for query parsing and execution"),

3503

REQUIRED_ARG, RANGE_ALLOC_BLOCK_SIZE, RANGE_ALLOC_BLOCK_SIZE, ULONG_MAX,

3504

0, 1024, 0},

3505

{"read_buffer_size", OPT_RECORD_BUFFER,

3506

N_("Each thread that does a sequential scan allocates a buffer of this "

3507

"size for each table it scans. If you do many sequential scans, you may "

3508

"want to increase this value."),

3509

(char**) &global_system_variables.read_buff_size,

3510

(char**) &max_system_variables.read_buff_size,0, GET_ULONG, REQUIRED_ARG,

3511

128*1024L, IO_SIZE*2+MALLOC_OVERHEAD, INT32_MAX, MALLOC_OVERHEAD, IO_SIZE,

3512

0},

3506

N_("Each thread that does a sequential scan allocates a buffer of this "

3507

"size for each table it scans. If you do many sequential scans, you may "

3508

"want to increase this value."),

3509

(char**) &global_system_variables.read_buff_size,

3510

(char**) &max_system_variables.read_buff_size,0, GET_UINT, REQUIRED_ARG,

3511

128*1024L, IO_SIZE*2+MALLOC_OVERHEAD, INT32_MAX, MALLOC_OVERHEAD, IO_SIZE,

3512

0},

3513

{"read_only", OPT_READONLY,

3514

N_("Make all non-temporary tables read-only, with the exception for "

3515

"replication (slave) threads and users with the SUPER privilege"),

3522

"to the value of record_buffer."),

3523

(char**) &global_system_variables.read_rnd_buff_size,

3524

(char**) &max_system_variables.read_rnd_buff_size, 0,

3525

GET_ULONG, REQUIRED_ARG, 256*1024L, 64 /*IO_SIZE*2+MALLOC_OVERHEAD*/ ,

3526

INT32_MAX, MALLOC_OVERHEAD, 1 /* Small lower limit to be able to test MRR */, 0},

3527

{"record_buffer", OPT_RECORD_BUFFER,

3528

"Alias for read_buffer_size",

3529

(char**) &global_system_variables.read_buff_size,

3530

(char**) &max_system_variables.read_buff_size,0, GET_ULONG, REQUIRED_ARG,

3531

128*1024L, IO_SIZE*2+MALLOC_OVERHEAD,

3532

INT32_MAX, MALLOC_OVERHEAD, IO_SIZE, 0},

3525

GET_UINT, REQUIRED_ARG, 256*1024L, 64 /*IO_SIZE*2+MALLOC_OVERHEAD*/ ,

3526

UINT32_MAX, MALLOC_OVERHEAD, 1 /* Small lower limit to be able to test MRR */, 0},

3533

3527

{"relay_log_purge", OPT_RELAY_LOG_PURGE,

3534

3528

N_("0 = do not purge relay logs. "

3535

3529

"1 = purge them as soon as they are no more needed."),

3569

3563

{"sort_buffer_size", OPT_SORT_BUFFER,

3570

3564

N_("Each thread that needs to do a sort allocates a buffer of this size."),

3571

3565

(char**) &global_system_variables.sortbuff_size,

3572

(char**) &max_system_variables.sortbuff_size, 0, GET_ULONG, REQUIRED_ARG,

3573

MAX_SORT_MEMORY, MIN_SORT_MEMORY+MALLOC_OVERHEAD*2, ULONG_MAX,

3566

(char**) &max_system_variables.sortbuff_size, 0, GET_ULL, REQUIRED_ARG,

3567

MAX_SORT_MEMORY, MIN_SORT_MEMORY+MALLOC_OVERHEAD*2, UINT64_MAX,

3574

3568

MALLOC_OVERHEAD, 1, 0},

3575

3569

{"sync-binlog", OPT_SYNC_BINLOG,

3576

3570

N_("Synchronously flush binary log to disk after every #th event. "

3595

3589

(char**) &thread_cache_size, (char**) &thread_cache_size, 0, GET_ULONG,

3596

3590

REQUIRED_ARG, 0, 0, 16384, 0, 1, 0},

3597

3591

{"thread_pool_size", OPT_THREAD_CACHE_SIZE,

3598

N_("How many threads we should create to handle query requests in case of "

3599

"'thread_handling=pool-of-threads'"),

3600

(char**) &thread_pool_size, (char**) &thread_pool_size, 0, GET_ULONG,

3601

REQUIRED_ARG, 8, 1, 16384, 0, 1, 0},

3592

N_("How many threads we should create to handle query requests in case of "

3593

"'thread_handling=pool-of-threads'"),

3594

(char**) &thread_pool_size, (char**) &thread_pool_size, 0, GET_UINT,

3595

REQUIRED_ARG, 8, 1, 16384, 0, 1, 0},

3602

3596

{"thread_stack", OPT_THREAD_STACK,

3603

3597

N_("The stack size for each thread."),

3604

3598

(char**) &my_thread_stack_size,