diff options
| author | Jan Lindström <jan.lindstrom@mariadb.com> | 2017-09-09 11:34:12 +0300 |
|---|---|---|
| committer | Jan Lindström <jan.lindstrom@mariadb.com> | 2017-10-24 19:12:59 +0300 |
| commit | b23a1096956c21df037bd851494f11509b5514dd (patch) | |
| tree | b6183da5bea97a63d771750a13cbcab198a5dfc5 /sysvars_wsrep,32bit.rdiff | |
| parent | 3722372ae56b7ea90ee3801889e9d4cd275cf3b9 (diff) | |
| download | mariadb-git-b23a1096956c21df037bd851494f11509b5514dd.tar.gz | |
MDEV-11025: Make number of page cleaner threads variable dynamic
New test cases
innodb-page-cleaners
Modified test cases
innodb_page_cleaners_basic
New function buf_flush_set_page_cleaner_thread_cnt
Increase or decrease the amount of page cleaner worker threads.
In case of increase this function creates based on current
abount and requested amount how many new threads should be
created. In case of decrease this function sets up the
requested amount of threads and uses is_requested event
to signal workers. Then we wait until all new treads
are started, old threads that should exit signal
is_finished or shutdown has marked that page cleaner
should finish.
buf_flush_page_cleaner_worker
Store current thread id and thread_no and then signal
event is_finished. If number of used page cleaner threads
decrease we shut down those threads that have thread_no
greater or equal than number of page configured page
cleaners - 1 (note that there will be always page cleaner
coordinator). Before exiting we signal is_finished.
New function innodb_page_cleaners_threads_update
Update function for innodb-page-cleaners system variable.
innobase_start_or_create_for_mysql
If more than one page cleaner threads is configured
we use new function buf_flush_set_page_cleaner_thread_cnt
to set up the requested threads (-1 coordinator).
Diffstat (limited to 'sysvars_wsrep,32bit.rdiff')
| -rw-r--r-- | sysvars_wsrep,32bit.rdiff | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/sysvars_wsrep,32bit.rdiff b/sysvars_wsrep,32bit.rdiff new file mode 100644 index 00000000000..016bd016f29 --- /dev/null +++ b/sysvars_wsrep,32bit.rdiff @@ -0,0 +1,47 @@ +--- suite/sys_vars/r/sysvars_wsrep.result 2014-10-10 13:33:55.000000000 +0300 ++++ suite/sys_vars/r/sysvars_wsrep,32bit.reject 2014-10-10 19:38:09.000000000 +0300 +@@ -245,7 +245,7 @@ + GLOBAL_VALUE_ORIGIN COMPILE-TIME + DEFAULT_VALUE 131072 + VARIABLE_SCOPE GLOBAL +-VARIABLE_TYPE BIGINT UNSIGNED ++VARIABLE_TYPE INT UNSIGNED + VARIABLE_COMMENT Max number of rows in write set + NUMERIC_MIN_VALUE 1 + NUMERIC_MAX_VALUE 1048576 +@@ -259,7 +259,7 @@ + GLOBAL_VALUE_ORIGIN COMPILE-TIME + DEFAULT_VALUE 1073741824 + VARIABLE_SCOPE GLOBAL +-VARIABLE_TYPE BIGINT UNSIGNED ++VARIABLE_TYPE INT UNSIGNED + VARIABLE_COMMENT Max write set size (bytes) + NUMERIC_MIN_VALUE 1024 + NUMERIC_MAX_VALUE 4294901759 +@@ -273,7 +273,7 @@ + GLOBAL_VALUE_ORIGIN COMPILE-TIME + DEFAULT_VALUE 0 + VARIABLE_SCOPE GLOBAL +-VARIABLE_TYPE BIGINT UNSIGNED ++VARIABLE_TYPE INT UNSIGNED + VARIABLE_COMMENT mysql replication group commit + NUMERIC_MIN_VALUE 0 + NUMERIC_MAX_VALUE 1000 +@@ -455,7 +455,7 @@ + GLOBAL_VALUE_ORIGIN COMPILE-TIME + DEFAULT_VALUE 1 + VARIABLE_SCOPE SESSION +-VARIABLE_TYPE BIGINT UNSIGNED ++VARIABLE_TYPE INT UNSIGNED + VARIABLE_COMMENT Max number of times to retry a failed autocommit statement + NUMERIC_MIN_VALUE 0 + NUMERIC_MAX_VALUE 10000 +@@ -483,7 +483,7 @@ + GLOBAL_VALUE_ORIGIN COMPILE-TIME + DEFAULT_VALUE 1 + VARIABLE_SCOPE GLOBAL +-VARIABLE_TYPE BIGINT UNSIGNED ++VARIABLE_TYPE INT UNSIGNED + VARIABLE_COMMENT Number of slave appliers to launch + NUMERIC_MIN_VALUE 1 + NUMERIC_MAX_VALUE 512 |