1. 25 Aug, 2017 9 commits
  2. 24 Aug, 2017 3 commits
    • Kenny John Jacob's avatar
      Update README.md · a544225d
      Kenny John Jacob authored
      Fix minor typo.
      a544225d
    • Marko Mäkelä's avatar
      MDEV-13534 InnoDB STATS_PERSISTENT fails to ignore garbage delete-mark flag on node pointer pages · e7bf8bca
      Marko Mäkelä authored
      This bug was a regression caused by MDEV-12698.
      
      On non-leaf pages, the delete-mark flag in the node pointer records is
      basically garbage. (Delete-marking only makes sense at the leaf level
      anyway. The purpose of the delete-mark is to tell MVCC, locking and purge
      that a leaf-level record does not exist in the READ UNCOMMITTED view,
      but it used to exist.)
      Node pointer records and non-leaf pages are glue that attaches multiple
      leaf pages to an index. This glue is supposed to be transparent to the
      transactional layer.
      
      When a page is split, InnoDB creates a node pointer record out of the
      child page record that the cursor is positioned on. The node pointer record
      for the parent page will be a copy of the child page record, amended with
      the child page number. If the child page record happened to carry the
      delete-mark flag, then the node pointer record would also carry this flag
      (even though the flag makes no sense outside child pages).
      
      (On a related note, for the first node pointer record in the first
      node pointer page of each tree level, if the MIN_REC_FLAG is set,
      the rest of the record contents (except the child page number)
      is basically garbage. From this garbage you could deduce at which point
      the child was originally split.)
      
      page_scan_method_t: Replace with bool, as there are only 2 values.
      
      dict_stats_scan_page(): Replace the parameter scan_method with is_leaf.
      Ignore the bogus (garbage) delete-mark flag if !is_leaf.
      e7bf8bca
    • Igor Babaev's avatar
  3. 23 Aug, 2017 28 commits
    • Sergei Golubchik's avatar
      small cleanup of rpl.rpl_stop_slave · 77c41fa7
      Sergei Golubchik authored
      77c41fa7
    • Monty's avatar
      Fixed assert when running rpl.rpl_parallel_partition · f753480c
      Monty authored
      The problem was that select_gtid_pos_table() was called by IO thread
      without mutex protection.
      f753480c
    • Monty's avatar
      Have mysqltest first send SIGABRT, then SIGKILL · e208100d
      Monty authored
      This is to get core's in mysql-test-run if server doesn't die in shutdown
      e208100d
    • Michael Widenius's avatar
      Optimize LEX_STRING comparisons · 25c06f52
      Michael Widenius authored
      - Added inline lex_string_cmp() to replace my_strcase_cmp().
      - Added inline lex_string_eq to first compares lengths before comparing strings
      25c06f52
    • Michael Widenius's avatar
      Changed KEY names to use LEX_CSTRING · cc77f988
      Michael Widenius authored
      cc77f988
    • Monty's avatar
    • Monty's avatar
      Reduce stack size · b6c5657e
      Monty authored
      WSREP_LOG increased the stack size of all function, where it was used,
      with 1024 bytes, even if it would never called. What's worse is that one
      a Mac with Lion 10.7, the stack size was increased with 1024* number of
      calls per function.
      
      By moving WSREP_LOG() to a function, the stack size on Lion in function
      mysql_execute() was reduced from 18K to 12K. On my main Linux machine
      with gcc 5.4 the reduction was from 5k to 4k.
      b6c5657e
    • Monty's avatar
    • Michael Widenius's avatar
      Remove dumping of some not needed core's when running test suite · 8e722064
      Michael Widenius authored
      Before this patch running full mtr generated some 70 cores (at least
      on systemd). Now no cores should be generated.
      
      - Changed DBUG_ABORT()'s used by mysql-test-run to DBUG_SUICIDE()
      - Changed DBUG_ABORT() used to crash server with core to DBUG_ASSERT(0)
      - DBUG_ASSERT now flushes DBUG files
      8e722064
    • Michael Widenius's avatar
      Affected rows for a SP now includes affected rows for all statements · 94bbe8ad
      Michael Widenius authored
      The old behavior of returning the affected rows for the last statement
      in a stored procedure was more an accident than design. Having the number
      of affected rows for all sub statements is more useful and will not change
      just because on changes the order of statements in the stored procedure.
      94bbe8ad
    • Monty's avatar
      Added missing ; after WSREP_TO_ISOLATION_BEGIN · 4be15fe0
      Monty authored
      - Changed also a few ;; to ;
      4be15fe0
    • Monty's avatar
      New option for slow logging (log_slow_disable_statements) · 21518ab2
      Monty authored
      This fixes MDEV-7742 and MDEV-8305 (Allow user to specify if stored
      procedures should be logged in the slow and general log)
      
      New functionality:
      - Added new variables log_slow_disable_statements and log_disable_statements
        that can be used to disable logging of certain queries to slow and
        general log. Currently supported options are 'admin', 'call', 'slave'
        and 'sp'.
        Defaults are as before. Only 'sp' (stored procedure statements) is
        disabled for  slow and general_log.
      - Slow log to files now includes the following new information:
        - When logging stored procedure statements the name of stored
          procedure is logged.
        - Number of created tmp_tables, tmp_disk_tables and the space used
          by temporary tables.
      - When logging 'call', the logged status now contains the sum of all
        included statements.  Before only 'time' was correct.
      - Added filsort_priority_queue as an option for log_slow_filter (this
        variable existed before, but was not exposed)
      - Added support for BIT types in my_getopt()
      
      Mapped some old variables to bitmaps (old variables can still be used)
      - Variable 'log_queries_not_using_indexes' is mapped to
        log_slow_filter='not_using_index'
      - Variable 'log_slow_slave_statements' is mapped to
        log_slow_disabled_statements='slave'
      - Variable 'log_slow_admin_statements' is mapped to
        log_slow_disabled_statements='admin'
      - All the above variables are changed to session variables from global
        variables
      
      Other things:
      - Simplified LOGGER::log_command. We don't need to check for super if
        OPTION_LOG_OFF is set as this flag can only be set if one is a super
        user.
      - Removed some setting of enable_slow_log as it's guaranteed to be set by
        mysql_parse()
      - mysql_admin_table() now sets thd->enable_slow_log
      - Added prepare_logs_for_admin_command() to reset thd->enable_slow_log if
        needed.
      - Added new functions to store, restore and add slow query status
      - Added new functions to store and restore query start time
      - Reorganized Sub_statement_state according to types
      - Added code in dispatch_command() to ensure that
        thd->reset_for_next_command() is always called for a query.
      - Added thd->last_sql_command to simplify checking of what was the type
        of the last command. Needed when logging to slow log as lex->sql_command
        may have changed before slow logging is called.
      - Moved QPLAN_TMP_... to where status for tmp tables are updated
      - Added new THD variable, affected_rows, to be able to correctly log
        number of affected rows to slow log.
      21518ab2
    • Monty's avatar
      Added DBUG_ASSERT_AS_PRINTF compile flag · 536215e3
      Monty authored
      If compiling a non DBUG binary with
      -DDBUG_ASSERT_AS_PRINTF asserts will be
      changed to printf + stack trace (of stack
      trace are enabled).
      
      - Changed #ifndef DBUG_OFF to
        #ifdef DBUG_ASSERT_EXISTS
        for those DBUG_OFF that was just used to enable
        assert
      - Assert checking that could greatly impact
        performance where changed to DBUG_ASSERT_SLOW which
        is not affected by DBUG_ASSERT_AS_PRINTF
      - Added one extra option to my_print_stacktrace() to
        get more silent in case of stack trace printing as
        part of assert.
      536215e3
    • Monty's avatar
      Fixed sequence.gtid · 52a1e4d6
      Monty authored
      52a1e4d6
    • Michael Widenius's avatar
      Fixed some compiler warnings · 9e1cc831
      Michael Widenius authored
      9e1cc831
    • Michael Widenius's avatar
      Safety fix: lock binlog_end_pos before calling signal_update · f71bed08
      Michael Widenius authored
      The mutex is needed to ensure that sql thread should not not miss the error
      signal.
      f71bed08
    • Michael Widenius's avatar
      Lots of small cleanups · 458d5ed8
      Michael Widenius authored
      - Simplified use_trans_cache() to return at once if is_transactional is set
      - Indentation and spelling errors fixed
      - Don't call signal_update() if update_binlog_end_pos() is called as the
        function already calls signal_update()
      - Removed not used function wait_for_update_bin_log(), which would cause
        errors if ever used.
      - Simplified handler::clone() by always allocating 'ref' in ha_open(). To do
        this I added an optional MEM_ROOT argument to ha_open() to be used when
        allocating 'ref'
      - Changed arguments to get_system_var() from LEX_CSTRING to LEX_CSTRING*
      - Added THD as argument to create_select_for_variable(). Changed also char*
        argument to LEX_CSTRING to avoid strlen() call.
      - Change calls to append() to use LEX_CSTRING
      458d5ed8
    • Michael Widenius's avatar
      Print thread_id instead of pthread_self to error log · a70f7aad
      Michael Widenius authored
      - Now we have same thread_id in general log, slow long and error log
        instead of a long meaningless thread number that may even change for
        one user.
      - Align error and slow log header with output
      - Extend thread_id with one number to handle nice printing up to ten
        million connections
      a70f7aad
    • Michael Widenius's avatar
    • Michael Widenius's avatar
      Simplify test if we can use table in query cache · 8bfda2f0
      Michael Widenius authored
      - Added TABLE_SHARE->not_usable_by_query_cache
      - Moved TABLE->no_replicate to TABLE_SHARE->no_replicate as it's same for
        all TABLE instances
      - Renamed TABLE_SHARE->cached_row_logging_check to can_do_row_logging
      8bfda2f0
    • Michael Widenius's avatar
      Added sql_alloc.h · 1ed605e4
      Michael Widenius authored
      - Moved declaration of Sql_alloc from Sql_list.h as they are independent
        structures.
      1ed605e4
    • Sergei Golubchik's avatar
      Don't include my_global.h in "pure" plugins · 82860235
      Sergei Golubchik authored
      this partially reverts 6e56ebbb498
      82860235
    • Sergei Golubchik's avatar
      Fix compilation warnings in plugins · a6e215f2
      Sergei Golubchik authored
      * update cracklib_password_check to match the new prototype
      * cannot use __attribute__((format)) for my_snprintf, because
        we support format extensions that the compiler doesn't know about.
      a6e215f2
    • Sergei Golubchik's avatar
      Fix compilation errors · d5a6bae7
      Sergei Golubchik authored
      d5a6bae7
    • Michael Widenius's avatar
      Enusure that my_global.h is included first · 4aaa38d2
      Michael Widenius authored
      - Added sql/mariadb.h file that should be included first by files in sql
        directory, if sql_plugin.h is not used (sql_plugin.h adds SHOW variables
        that must be done before my_global.h is included)
      - Removed a lot of include my_global.h from include files
      - Removed include's of some files that my_global.h automatically includes
      - Removed duplicated include's of my_sys.h
      - Replaced include my_config.h with my_global.h
      4aaa38d2
    • Michael Widenius's avatar
      Added copyright message to some files · b0da8897
      Michael Widenius authored
      b0da8897
    • Monty's avatar
      Use microsecond_interval_timer() instead of my_time() in replicaiton · b77bb43f
      Monty authored
      - Use microsecond_interval_timer() to calculate time for applying row events.
        (Faster execution)
      - Removed return value for set_row_stmt_start_timestamp()
        as it was never used.
      b77bb43f
    • Monty's avatar
      Cleaned up output from thr_print_locks · 44676ed5
      Monty authored
      44676ed5