[Commits] 66cb53e: Set new scheduling algorithm VATS for lock waits as a default.

Jan Lindström jan.lindstrom at mariadb.com
Tue Oct 25 12:21:34 EEST 2016


revision-id: 66cb53e9482a1ac816cac82fe5c30ae95b6be60e (mariadb-10.2.2-55-g66cb53e)
parent(s): b09b3161799e1e22b6cf3a434bc85e929939bc6c
author: Jan Lindström
committer: Jan Lindström
timestamp: 2016-10-25 12:21:07 +0300
message:

Set new scheduling algorithm VATS for lock waits as a default.

---
 mysql-test/suite/sys_vars/r/sysvars_innodb.result | 4 ++--
 storage/innobase/handler/ha_innodb.cc             | 2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/mysql-test/suite/sys_vars/r/sysvars_innodb.result b/mysql-test/suite/sys_vars/r/sysvars_innodb.result
index 93fa615..8e364e6 100644
--- a/mysql-test/suite/sys_vars/r/sysvars_innodb.result
+++ b/mysql-test/suite/sys_vars/r/sysvars_innodb.result
@@ -1449,9 +1449,9 @@ READ_ONLY	YES
 COMMAND_LINE_ARGUMENT	NONE
 VARIABLE_NAME	INNODB_LOCK_SCHEDULE_ALGORITHM
 SESSION_VALUE	NULL
-GLOBAL_VALUE	fcfs
+GLOBAL_VALUE	vats
 GLOBAL_VALUE_ORIGIN	COMPILE-TIME
-DEFAULT_VALUE	fcfs
+DEFAULT_VALUE	vats
 VARIABLE_SCOPE	GLOBAL
 VARIABLE_TYPE	ENUM
 VARIABLE_COMMENT	The algorithm Innodb uses for deciding which locks to grant next when a lock is released. Possible values are FCFS grant the locks in First-Come-First-Served order; VATS use the Variance-Aware-Transaction-Scheduling algorithm, which uses an Eldest-Transaction-First heuristic.
diff --git a/storage/innobase/handler/ha_innodb.cc b/storage/innobase/handler/ha_innodb.cc
index 2f4352c..30765dd 100644
--- a/storage/innobase/handler/ha_innodb.cc
+++ b/storage/innobase/handler/ha_innodb.cc
@@ -22808,7 +22808,7 @@ static MYSQL_SYSVAR_ENUM(lock_schedule_algorithm, innodb_lock_schedule_algorithm
   " VATS"
   " use the Variance-Aware-Transaction-Scheduling algorithm, which"
   " uses an Eldest-Transaction-First heuristic.",
-  NULL, NULL, INNODB_LOCK_SCHEDULE_ALGORITHM_FCFS,
+  NULL, NULL, INNODB_LOCK_SCHEDULE_ALGORITHM_VATS,
   &innodb_lock_schedule_algorithm_typelib);
 
 static MYSQL_SYSVAR_ULONG(buffer_pool_instances, srv_buf_pool_instances,


More information about the commits mailing list