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
|
/* - mode: c; c-basic-offset: 2; indent-tabs-mode: nil; -*-
* vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
*
* Copyright (C) 2009 Sun Microsystems
*
* 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 <set>
using namespace std;
using namespace drizzled;
ProcesslistTool::ProcesslistTool() :
plugin::TableFunction("DATA_DICTIONARY", "PROCESSLIST")
{
add_field("ID", plugin::TableFunction::NUMBER, 0, false);
add_field("USER", 16);
add_field("HOST", NI_MAXHOST);
add_field("DB");
add_field("COMMAND", 16);
add_field("TIME", plugin::TableFunction::NUMBER, 0, false);
add_field("STATE", plugin::TableFunction::STRING, 256, true);
add_field("INFO", plugin::TableFunction::STRING, PROCESS_LIST_WIDTH, true);
}
ProcesslistTool::Generator::Generator(Field **arg) :
plugin::TableFunction::Generator(arg)
{
now= time(NULL);
}
ProcesslistTool::Generator::~Generator()
{
}
bool ProcesslistTool::Generator::populate()
{
drizzled::Session::shared_ptr tmp;
while ((tmp= session_generator))
{
const SecurityContext *tmp_sctx= &tmp->getSecurityContext();
const char *val;
/* ID */
push((int64_t) tmp->thread_id);
/* USER */
if (not tmp_sctx->getUser().empty())
push(tmp_sctx->getUser());
else
push(_("no user"));
/* HOST */
push(tmp_sctx->getIp());
/* DB */
if (! tmp->db.empty())
{
push(tmp->db);
}
else
{
push();
}
/* COMMAND */
if ((val= const_cast<char *>(tmp->getKilled() == Session::KILL_CONNECTION ? "Killed" : 0)))
{
push(val);
}
else
{
push(command_name[tmp->command].str, command_name[tmp->command].length);
}
/* DRIZZLE_TIME */
push(static_cast<uint64_t>(tmp->start_time ? now - tmp->start_time : 0));
/* STATE */
val= (char*) (tmp->client->isWriting() ?
"Writing to net" :
tmp->client->isReading() ?
(tmp->command == COM_SLEEP ?
NULL : "Reading from net") :
tmp->get_proc_info() ? tmp->get_proc_info() :
tmp->getThreadVar() &&
tmp->getThreadVar()->current_cond ?
"Waiting on cond" : NULL);
val ? push(val) : push();
/* INFO */
push(*tmp->getQueryString());
return true;
}
return false;
}
|