Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • N/A
    • OTHER

    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  

      Attachments

        Issue Links

          Activity

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

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

            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

            elenst Elena Stepanova added a comment - - edited 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

            People

              elenst Elena Stepanova
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.