Adding upstream version 1:10.11.6.upstream/1%10.11.6upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 64 insertions, 0 deletions

diff --git a/scripts/sys_schema/views/p_s/sessions.sql b/scripts/sys_schema/views/p_s/sessions.sql
new file mode 100644
index 00000000..94471aab
--- /dev/null
+++ b/scripts/sys_schema/views/p_s/sessions.sql
@@ -0,0 +1,64 @@
+-- Copyright (c) 2014, 2015, Oracle and/or its affiliates. All rights reserved.
+--
+-- This program is free software; you can redistribute it and/or modify
+-- it under the terms of the GNU General Public License as published by
+-- the Free Software Foundation; version 2 of the License.
+--
+-- This program is distributed in the hope that it will be useful,
+-- but WITHOUT ANY WARRANTY; without even the implied warranty of
+-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+-- GNU General Public License for more details.
+--
+-- You should have received a copy of the GNU General Public License
+-- along with this program; if not, write to the Free Software
+-- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
+
+--
+-- View: session
+--
+-- Filter sys.processlist to only show user sessions and not background threads.
+-- This is a non-blocking closer replacement to
+-- [INFORMATION_SCHEMA. | SHOW FULL] PROCESSLIST
+-- 
+-- Performs less locking than the legacy sources, whilst giving extra information.
+--
+-- mysql> select * from sys.session\G
+-- *************************** 1. row ***************************
+--                 thd_id: 24
+--                conn_id: 2
+--                   user: root@localhost
+--                     db: sys
+--                command: Query
+--                  state: Sending data
+--                   time: 0
+--      current_statement: select * from sys.session
+--      statement_latency: 137.22 ms
+--               progress: NULL
+--           lock_latency: 33.75 ms
+--          rows_examined: 0
+--              rows_sent: 0
+--          rows_affected: 0
+--             tmp_tables: 4
+--        tmp_disk_tables: 1
+--              full_scan: YES
+--         last_statement: NULL
+-- last_statement_latency: NULL
+--         current_memory: 3.26 MiB
+--              last_wait: wait/synch/mutex/innodb/file_format_max_mutex
+--      last_wait_latency: 64.09 ns
+--                 source: trx0sys.cc:778
+--            trx_latency: 7.88 s
+--              trx_state: ACTIVE
+--         trx_autocommit: NO
+--                    pid: 4212
+--           program_name: mysql
+--
+
+CREATE OR REPLACE
+  DEFINER = 'mariadb.sys'@'localhost'
+  SQL SECURITY INVOKER 
+VIEW session
+ AS
+SELECT * FROM sys.processlist
+WHERE conn_id IS NOT NULL AND command != 'Daemon';
+