1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
|
/* - mode: c; c-basic-offset: 2; indent-tabs-mode: nil; -*-
* vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
*
* Copyright (C) 2009 Sun Microsystems, Inc.
*
* 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; either version 2 of the License, or
* (at your option) any later version.
*
* 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
*/
#include <config.h>
#include <plugin/session_dictionary/dictionary.h>
#include <netdb.h>
#include <drizzled/pthread_globals.h>
#include <drizzled/plugin/client.h>
#include <drizzled/plugin/authorization.h>
#include <drizzled/internal/my_sys.h>
#include <drizzled/internal/thread_var.h>
#include <drizzled/session/state.h>
#include <drizzled/session/times.h>
#include <set>
using namespace std;
using namespace drizzled;
ProcesslistTool::ProcesslistTool() :
plugin::TableFunction("DATA_DICTIONARY", "PROCESSLIST")
{
add_field("ID", plugin::TableFunction::NUMBER, 0, false);
add_field("USERNAME", 16);
add_field("HOST", NI_MAXHOST);
add_field("DB", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, true);
add_field("COMMAND", 16);
add_field("TIME", plugin::TableFunction::SIZE, 0, false);
add_field("STATE", plugin::TableFunction::STRING, 256, true);
add_field("INFO", plugin::TableFunction::STRING, PROCESS_LIST_WIDTH, true);
add_field("HAS_GLOBAL_LOCK", plugin::TableFunction::BOOLEAN, 0, false);
}
ProcesslistTool::Generator::Generator(Field **arg) :
plugin::TableFunction::Generator(arg),
session_generator(*getSession().user())
{
}
bool ProcesslistTool::Generator::populate()
{
while (Session* tmp= session_generator)
{
boost::shared_ptr<session::State> state(tmp->state());
identifier::user::ptr tmp_sctx= tmp->user();
/* ID */
push((int64_t) tmp->thread_id);
/* USER */
if (not tmp_sctx->username().empty())
push(tmp_sctx->username());
else
push(_("no user"));
/* HOST */
push(tmp_sctx->address());
/* DB */
util::string::ptr schema(tmp->schema());
if (schema and not schema->empty())
{
push(*schema);
}
else
{
push();
}
/* COMMAND */
if (tmp->getKilled() == Session::KILL_CONNECTION)
{
push("Killed");
}
else
{
push(getCommandName(tmp->command));
}
/* type::Time */
boost::posix_time::time_duration duration_result= getSession().times.start_timer() - getSession().times._start_timer;
push(static_cast<uint64_t>(duration_result.is_negative() ? 0 : duration_result.total_seconds()));
/* STATE */
const char *step= tmp->get_proc_info();
step ? push(step): push();
/* INFO */
if (state)
{
size_t length;
const char *tmp_ptr= state->query(length);
push(tmp_ptr, length);
}
else
{
push();
}
/* HAS_GLOBAL_LOCK */
bool has_global_lock= tmp->isGlobalReadLock();
push(has_global_lock);
return true;
}
return false;
}
|