summaryrefslogtreecommitdiff
path: root/mysql-test/r/mysqld--help.result
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-7780 - Support for faking server versionSergey Vojtovich2015-11-271-1/+2
| | | | Added --version=str (optional argument sets server version string).
* Removed depricated optimizer_search_depth.Oleksandr Byelkin2015-11-191-4/+1
|
* s/--silent/--silent-startup/Sergei Golubchik2015-10-111-2/+2
|
* Less logging of not critial things during startup/shutdown:Monty2015-10-091-0/+2
| | | | | | | | | - Added --start option to mysqld which don't prints notes to log on startup This helps to find errors in configure options easier - Dont write [Note] entries to log after we have abort the server This makes it easier to find what went wrong - Don't by default write out Changed limits for max_open_files as this didn't really change from anything the user gave us - Dont write warnings about not using --explicit_defaults_for_timestamp (we don't have plans do depricate the old behaviour)
* Merge branch '10.1' into pull-request-97Sergei Golubchik2015-09-251-0/+6
|\ | | | | | | Merge downstream Debian packaging (MDEV-6284)
| * MDEV-3929 Add system variable explicit_defaults_for_timestamp for ↵Alexander Barkov2015-09-221-0/+6
| | | | | | | | compatibility with MySQL
* | MDEV-6284 Merge downstream Debian/Ubuntu packaging into upstream MariaDBSergei Golubchik2015-09-141-1/+1
|\ \ | |/ |/| | | Merge branch 'ottok-ok-debpkg-10.1' into 10.1
| * Merge branch '10.1' of https://github.com/MariaDB/server into ok-debpkg-10.1Otto Kekäläinen2015-09-051-19/+28
| |\
| * | Fix spelling errorsOtto Kekäläinen2015-08-271-1/+1
| | |
* | | disable encrypt_tmp_files and encrypt_binlog by defaultSergei Golubchik2015-09-081-4/+2
| |/ |/|
* | MDEV-6066: Merge new defaults from 5.6 and 5.7Sergei Golubchik2015-09-041-2/+2
| | | | | | | | cosmetic fixes. test fixes.
* | MDEV-6066: Merge new defaults from 5.6 and 5.7 (defaults changed, QC can be ↵Oleksandr Byelkin2015-09-041-19/+21
| | | | | | | | stopped with no-zero size)
* | MDEV-8264 encryption for binlogSergei Golubchik2015-09-041-0/+3
| | | | | | | | | | | | | | * Start_encryption_log_event * --encrypt-binlog command line option based on google patches.
* | Merge branch '10.0' into 10.1Sergei Golubchik2015-09-031-0/+4
|\ \ | |/ |/| | | | | referenced_by_foreign_key2(), needed for InnoDB to compile, was taken from 10.0-galera
| * Merge branch 'merge-perfschema-5.6' into 10.0Sergei Golubchik2015-08-031-0/+4
| | | | | | | | 5.6.26
* | [MDEV-6877] Update test results to accound for binlog_row_image variable.Vicențiu Ciorbaru2015-07-011-0/+12
| | | | | | | | mysqld--help was not updated for binlog row image.
* | MDEV-7472: Implementation of user statements for handling the xtradb changed ↵Jan Lindström2015-06-231-0/+4
| | | | | | | | | | | | | | | | page bitmaps Introduce a new dummy INFORMATION_SCHEMA.CHANGED_PAGE_BITMAPS table to XtraDB with reset_table callback to allow FLUSH NO_WRITE_TO_BINLOG CHANGED_PAGE_BITMAPS to be called from innobackupex.
* | MDEV-8126 encryption for temp filesSergei Golubchik2015-06-021-2/+6
| | | | | | | | IO_CACHE tempfiles encryption
* | Merge tag 'mariadb-10.0.19' into 10.1Sergei Golubchik2015-06-011-0/+3
|\ \ | |/
| * perfschema 5.6.24Sergei Golubchik2015-05-051-0/+3
| | | | | | | | | | | | | | | | | | | | | | including the big commit commit 305130361bf72726de220f3d2b2787395e10be61 Author: Marc Alff <marc.alff@oracle.com> Date: Tue Feb 10 11:31:32 2015 +0100 WL#8354 BACKPORT DIGEST IMPROVEMENTS TO MYSQL 5.6 (with the following commits) and related changes in sql/
* | encryption plugin controls the encryptionSergei Golubchik2015-04-091-5/+0
| | | | | | | | | | | | | | | | | | * no --encryption-algorithm option anymore * encrypt/decrypt methods in the encryption plugin * ecnrypt/decrypt methods in the encryption_km service * file_km plugin has --file-key-management-encryption-algorithm * debug_km always uses aes_cbc * example_km changes between aes_cbc and aes_ecb for different key versions
* | MDEV-6858: enforce_storage_engine optionJan Lindström2015-03-121-0/+3
| | | | | | | | | | | | | | | | Merge from Percona Server enforced use of a specific storage engine authored by Stewart Smith. Modified to be session variable and modifiable only by SUPER. Use similar implementation as default_storage_engine.
* | MDEV-6089 - MySQL WL#7305 "Improve MDL scalability by using lock-free hash"Sergey Vojtovich2015-03-041-1/+1
| | | | | | | | Removed MDL map partitions. Won't be needed when this MDEV is implemented.
* | MDEV-6089 - MySQL WL#7305 "Improve MDL scalability by using lock-free hash"Sergey Vojtovich2015-03-041-1/+1
| | | | | | | | Removed MDL objects cache. Won't be needed when this MDEV is implemented.
* | Push for testing of encryptionMonty2015-02-101-0/+9
| |
* | --getopt-prefix-matching command-line optionSergei Golubchik2015-02-101-0/+5
| |
* | MDEV-6676: Optimistic parallel replicationKristian Nielsen2015-02-071-10/+9
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Adjust the configuration options, as discussed on the maria-developers@ mailing list. The option to hint a transaction to not be replicated in parallel is now called @@skip_parallel_replication, consistent with @@skip_replication. And the --slave-parallel-mode is now simplified to have just one of the following values: none minimal conservative optimistic aggressive This reflects successively harder efforts to find opportunities to run things in parallel on the slave. It allows to extend the server with more automatic heuristics in the future without having to introduce a new configuration option for each and every one.
* | MDEV-5533 increase the default max thread pool sizeSergei Golubchik2015-01-091-1/+1
| | | | | | | | 500 -> 1000
* | MDEV-7273 - 10.1 fails to start up during tc_log initializations on PPC64Sergey Vojtovich2014-12-261-1/+0
| | | | | | | | | | | | | | | | | | | | | | log-tc-size is 24K by default. Page size is 64K on PPC64. But log-tc-size must be at least 3 x page size. This is enforced by TC_LOG_MMAP::open() with a comment: to guarantee non-empty pool. This all makes server not startable in default configuration on PPC64. Autosize log-tc-size, so that it's min value= page size * 3, default value= page size * 6, block size= page size.
* | MDEV-6676: Optimistic parallel replicationKristian Nielsen2014-12-061-0/+12
| | | | | | | | | | | | | | | | | | Implement a new mode for parallel replication. In this mode, all transactions are optimistically attempted applied in parallel. In case of conflicts, the offending transaction is rolled back and retried later non-parallel. This is an early-release patch to facilitate testing, more changes to user interface / options will be expected. The new mode is not enabled by default.
* | - Changed default values of query_prealloc_size and query_alloc_block_sizeMonty2014-12-051-2/+2
| | | | | | | | | | | | so that a simple query with one join would not have to call my_malloc. - Allow lower limites for query_prealloc_size for testing. - Fixed wrong initialization of trans_alloc_block_size
* | strict_password_validationSergei Golubchik2014-12-041-0/+6
| |
* | MDEV-6999 Remove or deprecate unused variablesSergei Golubchik2014-12-041-5/+1
| |
* | MDEV-5528 Command line variable to choose MariaDB-5.3 vs MySQL-5.6 temporal ↵Alexander Barkov2014-11-031-0/+5
| | | | | | | | data formats
* | Merge 10.0.14 into 10.1Sergei Golubchik2014-10-151-2/+8
|\ \ | |/
| * 5.5.39 mergeSergei Golubchik2014-08-071-2/+2
| |\
| | * mysql-5.5.39 mergeSergei Golubchik2014-08-021-2/+2
| | | | | | | | | | | | | | | | | | | | | ~40% bugfixed(*) applied ~40$ bugfixed reverted (incorrect or we're not buggy) ~20% bugfixed applied, despite us being not buggy (*) only changes in the server code, e.g. not cmakefiles
| * | Fixed problem with very slow shutdown when using 100,000 MyISAM tables with ↵Michael Widenius2014-07-191-0/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | delay_key_write Reason for the problem was that the hash of changed files in the key cache was too small (was 128). Fixed by making the hash size larger and changeable. - Introduced key-cache-file-hash-size (default 512) for MyISAM and aria_pagecache_file_hash_size (default 512) for Aria. - Added new status variable "Feature_delay_key_write" which counts number of tables opened that are using delay_key_write mysql-test/r/features.result: Added test of Feature_delay_key_write mysql-test/r/key_cache.result: Updated tests as the number of blocks has changed mysql-test/r/mysqld--help.result: Updated result mysql-test/suite/maria/maria3.result: Updated result mysql-test/suite/sys_vars/r/key_cache_file_hash_size_basic.result: Test new variable mysql-test/suite/sys_vars/t/aria_pagecache_file_hash_size_basic.test: Test new variable mysql-test/suite/sys_vars/t/key_cache_file_hash_size_basic.test: Test new variable mysql-test/t/features.test: Added test of Feature_delay_key_write mysql-test/t/key_cache.test: Updated tests as the number of blocks has changed mysys/mf_keycache.c: Made CHANGED_BLOCKS_HASH dynamic sql/handler.cc: Updated call to init_key_cache() sql/mysqld.cc: Added "Feature_delay_key_write" Added support for key-cache-file-hash-size sql/mysqld.h: Added support for key-cache-file-hash-size sql/sql_class.h: Added feature_files_opened_with_delayed_keys sql/sys_vars.cc: Added key_cache_file_hash_size storage/maria/ha_maria.cc: Added pagecache_file_hash_size Added counting of files with delay_key_write storage/maria/ma_checkpoint.c: Fixed compiler warning storage/maria/ma_pagecache.c: Made PAGECACHE_CHANGED_BLOCKS_HASH into a variable storage/maria/ma_pagecache.h: Made PAGECACHE_CHANGED_BLOCKS_HASH into a variable storage/maria/ma_rt_test.c: Updated parameters for init_pagecache() storage/maria/ma_test1.c: Updated parameters for init_pagecache() storage/maria/ma_test2.c: Updated parameters for init_pagecache() storage/maria/ma_test3.c: Updated parameters for init_pagecache() storage/maria/maria_chk.c: Updated parameters for init_pagecache() storage/maria/maria_ftdump.c: Updated parameters for init_pagecache() storage/maria/maria_pack.c: Updated parameters for init_pagecache() storage/maria/maria_read_log.c: Updated parameters for init_pagecache() storage/maria/unittest/ma_pagecache_consist.c: Updated parameters for init_pagecache() storage/maria/unittest/ma_pagecache_rwconsist.c: Updated parameters for init_pagecache() storage/maria/unittest/ma_pagecache_rwconsist2.c: Updated parameters for init_pagecache() storage/maria/unittest/ma_pagecache_single.c: Updated parameters for init_pagecache() storage/maria/unittest/ma_test_loghandler-t.c: Updated parameters for init_pagecache() storage/maria/unittest/ma_test_loghandler_first_lsn-t.c: Updated parameters for init_pagecache() storage/maria/unittest/ma_test_loghandler_max_lsn-t.c: Updated parameters for init_pagecache() storage/maria/unittest/ma_test_loghandler_multigroup-t.c: Updated parameters for init_pagecache() storage/maria/unittest/ma_test_loghandler_multithread-t.c: Updated parameters for init_pagecache() storage/maria/unittest/ma_test_loghandler_noflush-t.c: Updated parameters for init_pagecache() storage/maria/unittest/ma_test_loghandler_nologs-t.c: Updated parameters for init_pagecache() storage/maria/unittest/ma_test_loghandler_pagecache-t.c: Updated parameters for init_pagecache() storage/maria/unittest/ma_test_loghandler_purge-t.c: Updated parameters for init_pagecache() storage/myisam/ha_myisam.cc: Added counting of files with delay_key_write storage/myisam/mi_check.c: Updated call to init_key_cache() storage/myisam/mi_test1.c: Updated call to init_key_cache() storage/myisam/mi_test2.c: Updated call to init_key_cache() storage/myisam/mi_test3.c: Updated call to init_key_cache() storage/myisam/mi_test_all.sh: Fixed broken test storage/myisam/myisam_ftdump.c: Updated call to init_key_cache() storage/myisam/myisamchk.c: Updated call to init_key_cache() storage/myisam/myisamlog.c: Updated call to init_key_cache()
* | | SHOW and FLUSH for I_S tables.Sergei Golubchik2014-10-111-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Extend existing plugins to support * SHOW QUERY_RESPONSE_TIME * FLUSH QUERY_RESPONSE_TIME * SHOW LOCALE move userstat tables to use the new API instead of hand-coded syntax
* | | GLOBAL_VALUE_ORIGIN=AUTOSergei Golubchik2014-10-111-1/+1
| | |
* | | MDEV-5317 Compound statement / anonymous blocksSergei Golubchik2014-10-101-1/+1
| | | | | | | | | | | | originally based on the patch by Antony T Curtis
* | | MDEV 4427: query timeoutsMonty2014-10-071-0/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added MAX_STATEMENT_TIME user variable to automaticly kill queries after a given time limit has expired. - Added timer functions based on pthread_cond_timedwait - Added kill_handlerton() to signal storage engines about kill/timeout - Added support for GRANT ... MAX_STATEMENT_TIME=# - Copy max_statement_time to current user, if stored in mysql.user - Added status variable max_statement_time_exceeded - Added KILL_TIMEOUT - Removed digest hash from performance schema tests as they change all the time. - Updated test results that changed because of the new user variables or new fields in mysql.user This functionallity is inspired by work done by Davi Arnaut at twitter. Test case is copied from Davi's work. Documentation can be found at https://kb.askmonty.org/en/how-to-limittimeout-queries/ mysql-test/r/mysqld--help.result: Updated for new help message mysql-test/suite/perfschema/r/all_instances.result: Added new mutex mysql-test/suite/sys_vars/r/max_statement_time_basic.result: Added testing of max_statement_time mysql-test/suite/sys_vars/t/max_statement_time_basic.test: Added testing of max_statement_time mysql-test/t/max_statement_time.test: Added testing of max_statement_time mysys/CMakeLists.txt: Added thr_timer mysys/my_init.c: mysys/mysys_priv.h: Added new mutex and condition variables Added new mutex and condition variables mysys/thr_timer.c: Added timer functions based on pthread_cond_timedwait() This can be compiled with HAVE_TIMER_CREATE to benchmark agains timer_create()/timer_settime() sql/lex.h: Added MAX_STATEMENT_TIME sql/log_event.cc: Safety fix (timeout should be threated as an interrupted query) sql/mysqld.cc: Added support for timers Added status variable max_statement_time_exceeded sql/share/errmsg-utf8.txt: Added ER_QUERY_TIMEOUT sql/signal_handler.cc: Added support for KILL_TIMEOUT sql/sql_acl.cc: Added support for GRANT ... MAX_STATEMENT_TIME=# Copy max_statement_time to current user sql/sql_class.cc: Added timer functionality to THD. Added thd_kill_timeout() sql/sql_class.h: Added timer functionality to THD. Added KILL_TIMEOUT Added max_statement_time variable in similar manner as long_query_time was done. sql/sql_connect.cc: Added handling of max_statement_time_exceeded sql/sql_parse.cc: Added starting and stopping timers for queries. sql/sql_show.cc: Added max_statement_time_exceeded for user/connects status in MariaDB 10.0 sql/sql_yacc.yy: Added support for GRANT ... MAX_STATEMENT_TIME=# syntax, to be enabled in 10.0 sql/structs.h: Added max_statement_time user resource sql/sys_vars.cc: Added max_statement_time variables mysql-test/suite/roles/create_and_drop_role_invalid_user_table.test Removed test as we require all fields in mysql.user table. scripts/mysql_system_tables.sql scripts/mysql_system_tables_data.sql scripts/mysql_system_tables_fix.sql Updated mysql.user with new max_statement_time field
* | | cleanup: remove galera/wsrep magic from mtrSergei Golubchik2014-10-011-125/+0
| | |
* | | MDEV-6247: Merge 10.0-galera to 10.1.Jan Lindström2014-08-261-0/+125
| | | | | | | | | | | | | | | | | | | | | | | | | | | Merged lp:maria/maria-10.0-galera up to revision 3879. Added a new functions to handler API to forcefully abort_transaction, producing fake_trx_id, get_checkpoint and set_checkpoint for XA. These were added for future possiblity to add more storage engines that could use galera replication.
* | | RBR triggers enabling in 10.1Oleksandr Byelkin2014-07-021-0/+10
| | |
* | | MDEV-6137 better help for SET/ENUM sysvarsSergei Golubchik2014-06-191-57/+64
| | | | | | | | | | | | | | | | | | | | | | | | Auto-generate the allowed list of values for enum/set/flagset options in --help output. But don't do that when the help text already has them. Also, remove lists of values from help strings of various options, where they were simply listed without any additional information.
* | | MDEV-6107 merge default_tmp_storage_engineSergei Golubchik2014-06-151-0/+4
|/ / | | | | | | | | | | | | Adapt default_tmp_storage_engine implementation from mysql-5.6 New feature (as compared to 5.6), default_tmp_storage_engine=NULL means that temporary tables will use default_storage_engine value. This makes the behavior backward compatible.
* | MDEV-6249 mark P_S STABLE and disable it by defaultSergei Golubchik2014-06-091-21/+20
| |
* | MDEV-6047: Make exists_to_in optimization ON by defaultunknown2014-06-091-1/+1
| |
* | MDEV-6153 Trivial Lintian errors in MariaDB sources: spelling errors and ↵Sergei Golubchik2014-05-131-2/+2
| | | | | | | | wrong executable bits