[MDEV-6958] 10.1 testing Created: 2014-10-28  Updated: 2017-12-03  Resolved: 2017-12-03

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Incomplete Votes: 0
Labels: tests

Issue Links:
PartOf
Relates
relates to MDEV-8615 Assertion `m_cpp_buf <= begin_ptr && ... Closed
Sub-Tasks:
Key
 Summary
 Type
 Status
 Assignee
MDEV-6959 Testing: Randomized configuration for... Technical task Closed Elena Stepanova  
MDEV-6963 Testing for max_query_time Technical task Closed Elena Stepanova  
MDEV-6923 Testing for SET STATEMENT .. FOR (MDE... Technical task Closed Elena Stepanova  

 Description   
MDEV-8469 Add RESET MASTER TO x to allow specification of binlog file nr Manual check MDEV-8574
MDEV-8419 utf32: compare broken bytes as "greater than any non-broken character" ?  
MDEV-8418 utf16: compare broken bytes as "greater than any non-broken character" ?  
MDEV-8417 utf8mb4: compare broken bytes as "greater than any non-broken character" ?  
MDEV-8416 ucs2: compare broken bytes as "greater than any non-broken character" ?  
MDEV-8415 utf8: compare broken bytes as "greater than any non-broken character" ?  
MDEV-8272 Encryption performance: Reduce the number of unused memcpy's ?  
MDEV-8215 Asian MB3 charsets: compare broken bytes as "greater than any non-broken character" ?  
MDEV-8214 Asian MB2 charsets: compare broken bytes as "greater than any non-broken character" ?  
MDEV-8202 st_select_lex::master_unit() takes 0.17% in OLTP RO Regression tests  
MDEV-8199 first_breadth_first_tab() takes 0.07% in OLTP RO Regression tests  
MDEV-8192 THD::set_command() takes 0.05% in OLTP RO Regression tests  
MDEV-8191 THD::set_query() takes 0.07% in OLTP RO Regression tests  
MDEV-8126 encryption for temp files TODO-699  
MDEV-8043 innodb tablespace encryption TODO-699 MDEV-8589 MDEV-8588 MDEV-8591
MDEV-8041 InnoDB redo log encryption TODO-699 MDEV-8586
MDEV-8040 make aria encryption use real keys TODO-699 MDEV-8587 MDEV-8592
MDEV-8001 mysql_reset_thd_for_next_command() takes 0.04% in OLTP RO Regression tests  
MDEV-7999 PROFILING routines take 0.2% when profiling disabled Regression tests  
MDEV-7832 Add status variables to track CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE Manual check
MDEV-7811 EXPLAIN/ANALYZE FORMAT=JSON should show subquery cache ?  
MDEV-7728 Improve xid cache scalability by using lock-free hash (was: Spiral patch 032...) Regression tests  
MDEV-7725 Spiral patch 028_mariadb-10.0.15.xa_commit_error.diff Regression tests  
MDEV-7715 Spiral patch 017_mariadb-10.0.15.get_error_at_commit.diff Regression tests  
MDEV-7671 Cache VIEW definitions in the TDC Regression tests  
MDEV-7619 Improve long semaphore wait output Regression tests  
MDEV-7618 Improve semaphore instrumentation Regression tests  
MDEV-7615 Remove --galera-sst-mode option from mysqldump  
MDEV-7476 Allow SELECT to succeed even when node is not ready  
MDEV-7472 Implementation of user statements for handling the xtradb changed page bitmaps Manual check add to random
MDEV-7437 remove suport for "atomics" with rwlocks Regression tests  
MDEV-7399 Add support for INFORMATION_SCHEMA.INNODB_MUTEXES Manual, regression tests
MDEV-7325 make lf_hash_delete(), lf_hash_search(), and lf_hash_iterator() never to return OOM Regression tests  
MDEV-7324 Lock-free hash for table definition cache Regression tests  
MDEV-7288 USER/ROLE: CREATE OR REPLACE, CREATE IF NOT EXISTS, DROP IF EXISTS MDEV-5164 Add to random
MDEV-7287 VIEW: CREATE IF NOT EXISTS Manual check Add to random
MDEV-7286 TRIGGER: CREATE OR REPLACE, CREATE IF NOT EXISTS Manual check Add to random
MDEV-7285 SERVER: CREATE OR REPLACE and CREATE IF NOT EXISTS Manual check Add to random
MDEV-7284 INDEX: CREATE OR REPLACE Manual check Add to random
MDEV-7283 UDF: CREATE OR REPLACE, CREATE IF NOT EXISTS, DROP IF EXISTS Manual check  
MDEV-7282 SP: CREATE OR REPLACE, CREATE IF NOT EXISTS Manual check Add to random
MDEV-7281 EVENT: CREATE OR REPLACE Manual check Add to random
MDEV-7280 DATABASE: CREATE OR REPLACE Manual check Add to random
MDEV-7257 Dump Thread Enhancements Regression tests  
MDEV-7223 Iterator for LF_HASH Regression tests  
MDEV-7201 [PATCH] parallel threads resizing - potential race condition to access freed memory TODO-577  
MDEV-7198 [PATCH] status variable for Slave_skipped_errors Manual check
MDEV-7112 Split HA_CREATE_INFO Regression tests  
MDEV-7110 Add missing MySQL variable log_bin_basename and log_bin_index ?  
MDEV-7109 Add support for INFORMATION_SCHEMA.INNODB_SEMAPHORE_WAITS ?  
MDEV-7108 Made long semaphore wait timeout configurable ?  
MDEV-7062 parser refactoring: don't store field properties in LEX Regression tests  
MDEV-7061 Augment innochecksum to give insight of fragmentation ?  
MDEV-7053 WSREP_STATUS & WSREP_MEMBERSHIP I_S tables Regression tests  
MDEV-7004 Merge scalability fixes from 10.0-power Regression tests  
MDEV-6999 Remove or deprecate unused variables Manual check MDEV-8225
MDEV-6981 [PATCH] feature request MASTER_GTID_WAIT status variables TODO-414  
MDEV-6980 OUT parameters in PREPARE Manual check
MDEV-6979 simplify trigger rules for RBR triggers MDEV-6962  
MDEV-6936 Buffer pool list scan optimization Regression tests  
MDEV-6935 Change the default value for innodb_log_compressed_pages to false ?  
MDEV-6932 Enable Lazy Flushing Regression tests  
MDEV-6929 Port Facebook Prefix Index Queries Optimization Regression tests  
MDEV-6918 Create a way to see a user's default role MDEV-5164  
MDEV-6906 Relaxed memory order for counters Regression tests  
MDEV-6895 switch to dynamic libjemalloc.so  
MDEV-6894 Enable SEQUENCE engine by default Manual check
MDEV-6877 Merge binlog_row_image from MySQL 5.6 Manual, random MDEV-8426 MDEV-8408
MDEV-6858 enforce_storage_engine option Manual, regression tests MDEV-8576 MDEV-8577 MDEV-8578
MDEV-6812 Merge Kakao: Add global status variables which tell you the progress of inplace alter table and row log buffer usage ?  
MDEV-6731 No ALGORITHM information in I_S.VIEWS Manual check
MDEV-6712 THD specifics for plugins ?  
MDEV-6693 Atomic operations with explicit memory barrier Regression tests  
MDEV-6676 Optimistic parallel replication TODO-577  
MDEV-6594 Use separate domain_id for Galera transactions  
MDEV-6593 domain_id based replication filters ?  
MDEV-6559 Difference between 5.6 & 10.1 UNION execution ?  
MDEV-6513 deprecate engine_condition_pushdown value of the @@optimizer_switch Manual check MDEV-8225
MDEV-6480 Remove conditions for which range optimizer returned SEL_ARG::IMPOSSIBLE. Regression tests  
MDEV-6431 password validation Manual check MDEV-8226 MDEV-8227 cracklib
MDEV-6418 Remove #ifdef-s wrapping the slave_run_triggers_for_rbr feature MDEV-6962  
MDEV-6415 reenable RBR triggers in 10.1 MDEV-6962  
MDEV-6388 ANALYZE $stmt output in the slow query log MDEV-6422  
MDEV-6382 ANALYZE $stmt and security MDEV-6422  
MDEV-6311 Add errors on CREATE SERVER Manual check
MDEV-6248 GUI-friendly cmake options to enable/disable plugins ?  
MDEV-6247 Merge Galera into 10.1 Regression tests  
MDEV-6246 Merge 10.0.10-FusionIO to 10.1 Regression tests  
MDEV-6172 Monitor progress of ALTER TABLE ... ADD INDEX, ALGORITHM=INPLACE for InnoDB ?  
MDEV-6138 show sysvar's help in I_S tables Manual check, sysvars* tests, regression tests MDEV-8579
MDEV-6137 better help for SET/ENUM sysvars Manual check MDEV-8580
MDEV-6109 EXPLAIN JSON ?  
MDEV-6108 update userstat feature from percona server ?  
MDEV-6107 merge default_tmp_storage_engine Manual check MDEV-8581
MDEV-6089 MySQL WL#7305 "Improve MDL scalability by using lock-free hash" Regresion tests  
MDEV-6075 Allow > 16K pages on InnoDB ?  
MDEV-6069 Remove old logic for 3.23-to-higher upgrades from upgrade SQL scripts ?  
MDEV-6039 WebScaleSQL patches Regression tests  
MDEV-6037 MDL optimizations from 5.7 Regression tests  
MDEV-5871 support assisted discovery in oqgraph v3 ?  
MDEV-5834 Merge Kakao Defragmentation implementation to MariaDB 10.1
MDEV-5803 Filter replication by GTID domain ID TODO-414  
MDEV-5784 Feature: Page compression and multi-threaded flush for InnoDB/XtraDB ?  
MDEV-5749 Please add a .pc file to MariaDB for easy use via pkg-config ?  
MDEV-5730 enhance security using special compilation options ?  
MDEV-5533 Backport Threadpool improvements from Percona Server Regression tests  
MDEV-5528 Command line variable to choose MariaDB-5.3 vs MySQL-5.6 temporal data formats ?  
MDEV-5359 CREATE OR REPLACE, CREATE IF NOT EXISTS, DROP IF EXISTS ?  
MDEV-5335 Force PK option Manual check MDEV-8582
MDEV-5317 Compound statement / anonymous blocks MDEV-6964  
MDEV-5231 Per query variables from Percona Server [patch] MDEV-6923  
MDEV-5214 Status variables for number of global/db/table/column/role grants Manual check question inside
MDEV-5210 Default role MDEV-5164  
MDEV-5095 Executing triggers on slave in row-based replication ?  
MDEV-4921 Add a interface to mysql protocol and DAEMON plugins ?  
MDEV-4549 [PATCH] Clean up code working with ACL tables Regression tests  
MDEV-4427 query timeouts MDEV-6963  
MDEV-4412 SLOW QUERY LOG - add affected rows (UPDATE / DELETE) in slow query log ?  
MDEV-4262 P_S discovery ?  
MDEV-4260 Don't create frm files for temporary tables ?  
MDEV-4045 Missing OGC Spatial functions MDEV-7509  
MDEV-4018 Feature Request: microseconds in GET_LOCK() Manual check
MDEV-783 LP:671402 - Plugin status variables cannot distinguish SHOW GLOBAL STATUS from SHOW SESSION STATUS ?  
MDEV-406 ANALYZE $stmt MDEV-6422  
MDEV-334 [backport] Implement UNION ALL without usage of a temporary table (MWL#44) Regression tests  
MDEV-250 SLOW QUERY LOG - Group queries and check total slow query Manual check
MDEV-162 Enhanced semisync replication ?  
MDEV-60 Support for Spatial Reference systems for the GIS data MDEV-7509  
MDEV-13 OpenGIS: stored procedure AddGeometryColumn MDEV-7509  
MDEV-12 OpenGIS: create required tables: GeometryColumns, related views. MDEV-7509  


 Comments   
Comment by Elena Stepanova [ 2014-10-29 ]

Re-check after MDEV-6960 is fixed: set default role via a SP (now crashes on 2nd execution).

Comment by Elena Stepanova [ 2015-10-03 ]

Differences in variables between 10.0.22 candidate and 10.1.8 candidate

+aria_encrypt_tables	OFF
 
 
 
-back_log	150
 
+back_log	80
 
 
 
+binlog_row_image	FULL
 
 
 
-debug_crc_break	0
 
 
 
+debug_mutex_deadlock_detector	ON
 
 
 
+default_tmp_storage_engine	
 
 
+encrypt_binlog	OFF
 
+encrypt_tmp_disk_tables	OFF
 
+encrypt_tmp_files	OFF
 
+enforce_storage_engine	
 
 
+explicit_defaults_for_timestamp	OFF
 
 
 
-host_cache_size	128
 
+host_cache_size	279
 
 
 
+innodb_background_scrub_data_check_interval	3600
 
+innodb_background_scrub_data_compressed	OFF
 
+innodb_background_scrub_data_interval	604800
 
+innodb_background_scrub_data_uncompressed	OFF
 
+innodb_buf_dump_status_frequency	0
 
 
 
-innodb_checksum_algorithm	innodb
 
+innodb_checksum_algorithm	INNODB
 
 
 
-innodb_cleaner_lsn_age_factor	high_checkpoint
 
+innodb_cleaner_lsn_age_factor	HIGH_CHECKPOINT
 
 
 
+innodb_compression_algorithm	none
 
 
 
+innodb_debug_force_scrubbing	OFF
 
+innodb_default_encryption_key_id	1
 
+innodb_defragment	OFF
 
+innodb_defragment_fill_factor	0.900000
 
+innodb_defragment_fill_factor_n_recs	20
 
+innodb_defragment_frequency	40
 
+innodb_defragment_n_pages	7
 
+innodb_defragment_stats_accuracy	0
 
 
 
+innodb_disallow_writes	OFF
 
 
 
-innodb_empty_free_list_algorithm	backoff
 
+innodb_empty_free_list_algorithm	BACKOFF
 
+innodb_encrypt_log	OFF
 
+innodb_encrypt_tables	OFF
 
+innodb_encryption_rotate_key_age	1
 
+innodb_encryption_rotation_iops	100
 
+innodb_encryption_threads	0
 
 
 
+innodb_fatal_semaphore_wait_threshold	600
 
 
 
+innodb_force_primary_key	OFF
 
 
 
-innodb_foreground_preflush	exponential_backoff
 
+innodb_foreground_preflush	EXPONENTIAL_BACKOFF
 
 
 
+innodb_idle_flush_pct	100
 
+innodb_immediate_scrub_data_uncompressed	OFF
 
+innodb_instrument_semaphores	OFF
 
 
 
-innodb_log_checksum_algorithm	innodb
 
-innodb_log_compressed_pages	ON
 
+innodb_log_checksum_algorithm	INNODB
 
+innodb_log_compressed_pages	OFF
 
 
 
+innodb_mtflush_threads	8
 
 
 
-innodb_open_files	400
 
+innodb_open_files	2000
 
 
 
+innodb_prefix_index_cluster_optimization	OFF
 
 
 
+innodb_scrub_log	OFF
 
+innodb_scrub_log_speed	256
 
 
 
+innodb_use_mtflush	OFF
 
 
 
+innodb_use_trim	OFF
 
 
 
-join_buffer_size	131072
 
+join_buffer_size	262144
 
 
 
+log_bin_basename	
+log_bin_index	
 
 
+log_tc_size	24576
 
 
 
-max_allowed_packet	1048576
 
+max_allowed_packet	4194304
 
 
 
-max_long_data_size	1048576
 
+max_long_data_size	4194304
 
 
 
+max_statement_time	0.000000
 
 
 
-mutex_deadlock_detector	ON
 
 
 
-myisam_stats_method	nulls_unequal
 
+myisam_stats_method	NULLS_UNEQUAL
 
 
 
+mysql56_temporal_format	ON
 
 
 
-performance_schema_max_statement_classes	180
 
+performance_schema_max_statement_classes	178
 
 
 
-query_alloc_block_size	8192
 
+query_alloc_block_size	16384
 
 
 
-query_cache_size	0
 
+query_cache_size	1048576
 
 
 
-query_cache_type	ON
 
+query_cache_type	OFF
 
 
 
-query_prealloc_size	8192
 
-rand_seed1	0
 
-rand_seed2	0
 
+query_prealloc_size	24576
 
+rand_seed1	938672220
 
+rand_seed2	923741616
 
 
 
+relay_log_basename	
 
 
-replicate_events_marked_for_skip	replicate
 
+replicate_events_marked_for_skip	REPLICATE
 
 
 
-rpl_recovery_rank	0
 
-secure_auth	OFF
 
+secure_auth	ON
 
 
 
+skip_parallel_replication	OFF
 
 
 
+slave_parallel_mode	conservative
 
 
 
+slave_run_triggers_for_rbr	NO
 
 
 
-sql_mode	
+sql_mode	NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
 
 
 
+strict_password_validation	ON
 
 
 
-sync_master_info	0
 
-sync_relay_log	0
 
-sync_relay_log_info	0
 
+sync_master_info	10000
 
+sync_relay_log	10000
 
+sync_relay_log_info	10000
 
 
 
-table_open_cache	400
 
+table_open_cache	2000
 
 
 
-thread_pool_max_threads	500
 
+thread_pool_max_threads	1000
 
 
 
-thread_pool_size	3
 
+thread_pool_size	8
 
 
 
-timestamp	1443822993.805240
 
+timestamp	1443826258.801922
 
 
 
-version	10.0.22-MariaDB-debug
 
+version	10.1.8-MariaDB-debug
 
 
 
+version_ssl_library	OpenSSL 1.0.1e 11 Feb 2013

Generated at Thu Feb 08 07:15:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.