- 23 Aug, 2017 28 commits
-
-
Michael Widenius authored
-
Monty authored
-
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.
-
Monty authored
-
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
-
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.
-
Monty authored
- Changed also a few ;; to ;
-
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.
-
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.
-
Monty authored
-
Michael Widenius authored
-
Michael Widenius authored
The mutex is needed to ensure that sql thread should not not miss the error signal.
-
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
-
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
-
Michael Widenius authored
-
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
-
Michael Widenius authored
- Moved declaration of Sql_alloc from Sql_list.h as they are independent structures.
-
Sergei Golubchik authored
this partially reverts 6e56ebbb498
-
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.
-
Sergei Golubchik authored
-
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
-
Michael Widenius authored
-
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.
-
Monty authored
-
Sergei Golubchik authored
Don't use the server's version, that expects a valid THD. Modify net_serv.cc not not use any THD if MYSQL_SERVER isn't defined. This reverts commit aaddac5c.
-
Sergei Golubchik authored
-
Sergei Golubchik authored
-
Vladislav Vaintroub authored
-
- 22 Aug, 2017 3 commits
-
-
Vladislav Vaintroub authored
accept proxy protocol header from client connections. The new server variable 'proxy_protocol_networks' contains list of networks from which proxy header is accepted.
-
Alexander Barkov authored
-
Alexander Barkov authored
-
- 20 Aug, 2017 2 commits
-
-
Sergei Golubchik authored
-
Igor Babaev authored
platform independent.
-
- 19 Aug, 2017 1 commit
-
-
Igor Babaev authored
It allows to push conditions into derived with window functions not only in the cases when the window specifications of these window functions use the same partition, but also in the cases when the window functions use partitions that share only some fields. In these cases only the conditions over the common fields are pushed.
-
- 18 Aug, 2017 2 commits
-
-
Alexander Barkov authored
-
Alexander Barkov authored
-
- 17 Aug, 2017 2 commits
-
-
Alexander Barkov authored
-
Alexander Barkov authored
-
- 16 Aug, 2017 2 commits
-
-
Marko Mäkelä authored
-
Marko Mäkelä authored
With MDEV-12288 and MDEV-13536, the InnoDB purge threads will access pages more often, causing all sorts of debug assertion failures in the B-tree code. Work around this problem by amending the corruption tests with --innodb-purge-rseg-truncate-frequency=1 --skip-innodb-fast-shutdown so that everything will be purged before the server is restarted to deal with the corruption.
-