summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/r
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-25325 built-in documentation for performance_schema tablesHaidong Ji2021-09-0754-1582/+2746
| | | | | | Improve documentation of performance_schema tables by appending COLUMN comments to tables. Additionally improve test coverage and update corresponding tests.
* MDEV-25641 max_password_errors not working with ed25519 auth pluginSergei Golubchik2021-05-221-0/+119
| | | | | | | report correct error codes in ed25519. Invalid value stored in the user table or an OpenSSL error is CR_ERROR. When a user provided incorrect password when logging in - it's CR_AUTH_USER_CREDENTIALS.
* cleanup: remove slave background thread, use handle_manager thread insteadSergei Golubchik2021-01-241-11/+11
|
* MDEV-16341 Wrong length for USER columns in performance_schema tablesSergei Golubchik2021-01-112-22/+22
| | | | | use USERNAME_CHAR_LENGTH and HOSTNAME_LENGTH for perfschema USER and HOST columns
* MDEV-21360 global debug_dbug pre-test value restoration issuesAlice Sherepa2020-01-1536-72/+72
|
* MDEV-21360 debug_dbug pre-test value restoration issuesAlice Sherepa2020-01-1536-36/+72
|
* Merge 10.1 to 10.2Marko Mäkelä2019-11-061-0/+16
|\
| * MDEV-17896 Assertion `pfs->get_refcount() > 0' failedRobert Bindar2019-11-011-0/+16
| | | | | | | | | | | | Unfortunate DROP TEMPORARY..IF EXISTS on a regular table may allow subsequent CREATE TABLE statements to steal away the PFS_table_share instance from the dropped table.
* | Updated mtr files to support different compiled in optionsMonty2019-09-0138-436/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This allows one to run the test suite even if any of the following options are changed: - character-set-server - collation-server - join-cache-level - log-basename - max-allowed-packet - optimizer-switch - query-cache-size and query-cache-type - skip-name-resolve - table-definition-cache - table-open-cache - Some innodb options etc Changes: - Don't print out the value of system variables as one can't depend on them to being constants. - Don't set global variables to 'default' as the default may not be the same as the test was started with if there was an additional option file. Instead save original value and reset it at end of test. - Test that depends on the latin1 character set should include default_charset.inc or set the character set to latin1 - Test that depends on the original optimizer switch, should include default_optimizer_switch.inc - Test that depends on the value of a specific system variable should set it in the test (like optimizer_use_condition_selectivity) - Split subselect3.test into subselect3.test and subselect3.inc to make it easier to set and reset system variables. - Added .opt files for test that required specfic options that could be changed by external configuration files. - Fixed result files in rockdsb & tokudb that had not been updated for a while.
* | Merge branch '10.1' into 10.2Oleksandr Byelkin2019-05-041-0/+2
|\ \ | |/
| * MDEV-19265 Server should throw warning if event is created and ↵Vladislav Vaintroub2019-04-281-0/+2
| | | | | | | | event_scheduler = OFF
* | Merge 10.1 into 10.2Marko Mäkelä2019-02-031-1/+3
|\ \ | |/ | | | | | | | | Temporarily disable a test for commit 2175bfce3e9da8332f10ab0e0286dc93915533a2 because fixing it in 10.2 requires updating libmariadb.
| * Merge 10.1 into 10.1Marko Mäkelä2019-02-021-1/+3
| |\ | | | | | | | | | This is joint work with Oleksandr Byelkin.
| | * Merge branch 'merge-perfschema-5.6' into 10.0Oleksandr Byelkin2019-01-281-1/+3
| | |\
| | | * 5.6.43Oleksandr Byelkin2019-01-241-1/+3
| | | |
| | | * 5.6.42Sergei Golubchik2018-10-271-7/+7
| | | |
* | | | Merge 10.1 into 10.2Marko Mäkelä2018-12-071-13/+0
|\ \ \ \ | |/ / /
| * | | MDEV-17917 MTR: fixed race conditions in perfschema.socket_connect, main.connectVladislav Vaintroub2018-12-061-13/+0
| | | |
* | | | Merge 10.1 into 10.2Marko Mäkelä2018-05-291-0/+10
|\ \ \ \ | |/ / /
| * | | MDEV-10679 Crash in performance schema and partitioning with discoveryMonty2018-05-261-0/+10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | Crash happened because in discover, table->work_part_info was not properly reset before execution. Fixed by resetting before calling execute alter table, create table or mysql_create_frm_image.
* | | | Use same connection convention of specifying IPsVicențiu Ciorbaru2018-04-122-14/+14
| | | | | | | | | | | | | | | | If we use hostnames, it will fail during name resolution on UNIX systems
* | | | Fix perfschema.hostcache_ipv4_max_conVicentiu Ciorbaru2018-04-122-14/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Also fix perfschema.hostcache_ipv6_max_con. The test case makes use of a debug switch to execute some special code. The code does hostname replacement. Every hostname sent during connect phase becomes santa.claus.ipv4.example.com (or ipv6). This causes a connection from root@localhost to fail, as root is not registered as santa claus user. The failure is only apparent on Windows as Unix systems make use of sockets, which bypass the name resolution check entirely.
* | | | Merge branch '10.1' into 10.2Vicențiu Ciorbaru2018-04-102-2/+30
|\ \ \ \ | |/ / /
| * | | Adjust table_open_cache to avoid getting error 24 (too many open files)Monty2018-03-262-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | MDEV--15609 engines/funcs.crash_manytables_number crashes with error 24 (too many open files) MDEV-10286 Adjustment of table_open_cache according to system limits does not work when open-files-limit option is provided Fixed by adjusting tc_size downwards if there is not enough file descriptors to use. Other changes: - Ensure that there is 30 (was 10) extra file descriptors for other usage - Decrease TABLE_OPEN_CACHE_MIN to 200 as it's better to have a smaller table cache than getting error 24 - Increase minimum of max_connections and table_open_cache from 1 to 10 as 1 is not usable for any real application, only for testing.
* | | | Merge 10.1 to 10.2Marko Mäkelä2017-12-191-0/+16
|\ \ \ \ | |/ / / | | | | | | | | | | | | Follow-up fix to MDEV-14008: Let Field_double::val_uint() silently return 0 on error
| * | | MDEV-10486 MariaDB 10.x does not update rows_examined in performance_schema ↵Alexey Botchkov2017-12-181-0/+16
| | | | | | | | | | | | | | | | | | | | | | | | tables. Save the rows_examined counter before it gets emptied.
| * | | MDEV-12012/MDEV-11969 Can't remove GTIDs for a stale GTID Domain IDAndrei Elkin2017-11-151-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | As reported in MDEV-11969 "there's no way to ditch knowledge" about some domain that is no longer updated on a server. Besides being of annoyance to clutter output in DBA console stale domains can prevent the slave to connect the master as MDEV-12012 witnesses. What domain is obsolete must be evaluated by the user (DBA) according to whether the domain info is still relevant and will the domain ever receive any update. This patch introduces a method to discard obsolete gtid domains from the server binlog state. The removal requires no event group from such domain present in existing binlog files though. If there are any the containing logs must be first PURGEd in order for FLUSH BINARY LOGS DELETE_DOMAIN_ID=(list-of-domains) succeed. Otherwise the command returns an error. The list of obsolete domains can be computed through intersecting two sets - the earliest (first) binlog's Gtid_list and the current value of @@global.gtid_binlog_state - and extracting the domain id components from the intersection list items. The new DELETE_DOMAIN_ID featured FLUSH continues to rotate binlog omitting the deleted domains from the active binlog file's Gtid_list. Notice though when the command is ineffective - that none of requested to delete domain exists in the binlog state - rotation does not occur. Obsolete domain deletion is not harmful for connected slaves as long as master side binlog files *purge* is synchronized with FLUSH-DELETE_DOMAIN_ID. The slaves must have the last event from purged files processed as usual, in order not to bump later into requesting a gtid from a file which was already gone. While the command is not replicated (as ordinary FLUSH BINLOG LOGS is) slaves, even though having extra domains, won't suffer from reconnection errors thanks to master-slave gtid connection protocol allowing the master to be ignorant about a gtid domain. Should at failover such slave to be promoted into master role it may run the ex-master's FLUSH BINARY LOGS DELETE_DOMAIN_ID=(list-of-domains) to clean its own binlog state. NOTES. suite/perfschema/r/start_server_low_digest.result is re-recorded as consequence of internal parser codes changes.
* | | | MDEV-13712 Spelling errors in the error messageSergei Golubchik2017-09-182-18/+18
| | | |
* | | | Merge branch '10.1' into 10.2Sergei Golubchik2017-08-171-0/+1
|\ \ \ \ | |/ / /
| * | | fix sporadic failures of perfschema.privilege_table_ioSergei Golubchik2017-08-081-0/+1
| | | | | | | | | | | | | | | | it used to fail if main.create_drop_role was run before it
* | | | Merge branch '10.1' into 10.2Sergei Golubchik2017-07-051-1/+1
|\ \ \ \ | |/ / /
| * | | disable getopt prefix matching in mtr bootstrapSergei Golubchik2017-06-221-1/+1
| | | | | | | | | | | | | | | | it was disabled in mtr tests in 4280b25ed8
* | | | MDEV-13132 Information Schema does not show whether column default is ↵Sergei Golubchik2017-07-051-14/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | expression or literal Fix INFORMATION_SCHEMA.COLUMNS.COLUMN_DEFAULT to be standard-compliant, but keep SHOW COLUMNS backward-compatibly unchanged.
* | | | MDEV-13089 identifier quoting in partitioningSergei Golubchik2017-07-051-1/+1
| | | | | | | | | | | | | | | | | | | | don't print partitioning expression as it was entered by the user, use Item::print() according to the sql_mode and sql_quote_show_create
* | | | Merge 10.1 into 10.2Marko Mäkelä2017-05-231-0/+7
|\ \ \ \ | |/ / /
| * | | Merge 10.0 into 10.1Marko Mäkelä2017-05-201-0/+7
| |\ \ \ | | |/ / | | | | | | | | | | | | | | | | Significantly reduce the amount of InnoDB, XtraDB and Mariabackup code changes by defining pfs_os_file_t as something that is transparently compatible with os_file_t.
| | * | Merge branch 'merge-perfschema-5.6' into 10.0Vicențiu Ciorbaru2017-05-161-0/+7
| | |\ \ | | | |/
| | | * 5.6.36Vicențiu Ciorbaru2017-05-161-0/+7
| | | |
| | | * 5.6.33Sergei Golubchik2016-09-271-118/+0
| | | |
* | | | Merge branch '10.1' into 10.2Sergei Golubchik2017-03-3017-113/+24
|\ \ \ \ | |/ / /
| * | | cleanup: pfs_upgrade* testsSergei Golubchik2017-03-215-5/+0
| | | |
| * | | don't show 'performance_schema_%_classes_lost' variables in testsSergei Golubchik2017-03-1012-108/+24
| | | | | | | | | | | | | | | | | | | | because FLUSH STATUS does not reset them, so their values are affected by previously run tests since the last server restart.
* | | | MDEV-9255 Add generation_expression to information_schema.columns.Alexey Botchkov2017-03-281-796/+796
| | | | | | | | | | | | | | | | | | | | Added IS_GENERATED and GENERATION_EXPRESSION columns required by the SQL standard
* | | | MDEV-7635: Update tests to adapt to the new default sql_modeNirbhay Choubey2017-02-107-7/+12
| | | |
* | | | MDEV-7635: Part 1Nirbhay Choubey2017-02-102-0/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | innodb_autoinc_lock_mode = 2 innodb_buffer_pool_dump_at_shutdown = ON innodb_buffer_pool_dump_pct = 25 innodb_buffer_pool_load_at_startup = ON innodb_checksum_algorithm = CRC32 innodb_file_format = Barracuda innodb_large_prefix = ON innodb_log_compressed_pages = ON innodb_purge_threads = 4 innodb_strict_mode = ON binlog_annotate_row_events = ON binlog_format = MIXED binlog-row-event-max-size = 8192 group_concat_max_len = 1M lock_wait_timeout = 86400 log_slow_admin_statements = ON log_slow_slave_statements = ON log_warnings = 2 max_allowed_packet = 16M replicate_annotate_row_events = ON slave_net_timeout = 60 sync_binlog = 1 aria_recover = BACKUP,QUICK myisam_recover_options = BACKUP,QUICK
* | | | Fixed bugs found by mysql-test-run:Monty2017-01-111-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | - privilege_table_io.test didn't properly reset roles_mapping - Fixed memory allocation problem with CHECK CONSTRAINT, found when running --valgrind main.check_constraint
* | | | Merge branch '10.1' into 10.2Sergei Golubchik2016-12-291-121/+0
|\ \ \ \ | |/ / /
| * | | Merge branch '10.0' into 10.1Sergei Golubchik2016-09-281-121/+0
| |\ \ \ | | |/ /
| | * | Merge branch '5.5' into 10.0Sergei Golubchik2016-09-271-121/+0
| | |\ \
| | | * \ Merge branch 'mysql/5.5' into 5.5Sergei Golubchik2016-09-111-102/+0
| | | |\ \ | | | | | | | | | | | | | | | | | | 80% reverted
View Lorry Controller Status