1283.28.9
by Stewart Smith
basic DATA_DICTIONARY.INNODB_STATUS table_function plugin. This gets the InnoDB status and lets the user query it. |
1 |
/*
|
2 |
Copyright (C) 2010 Stewart Smith
|
|
3 |
||
4 |
This program is free software; you can redistribute it and/or
|
|
5 |
modify it under the terms of the GNU General Public License
|
|
6 |
as published by the Free Software Foundation; either version 2
|
|
7 |
of the License, or (at your option) any later version.
|
|
8 |
||
9 |
This program is distributed in the hope that it will be useful,
|
|
10 |
but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
11 |
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
12 |
GNU General Public License for more details.
|
|
13 |
||
14 |
You should have received a copy of the GNU General Public License
|
|
15 |
along with this program; if not, write to the Free Software
|
|
16 |
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
|
|
17 |
*/
|
|
18 |
||
19 |
#include "config.h" |
|
20 |
#include "drizzled/plugin/table_function.h" |
|
21 |
||
1689.6.2
by Monty Taylor
Updated embedded_innodb to use haildb if it's there. |
22 |
#if defined(HAVE_HAILDB_H)
|
23 |
# include <haildb.h>
|
|
24 |
#else
|
|
25 |
# include <embedded_innodb-1.0/innodb.h>
|
|
26 |
#endif /* HAVE_HAILDB_H */ |
|
1283.28.9
by Stewart Smith
basic DATA_DICTIONARY.INNODB_STATUS table_function plugin. This gets the InnoDB status and lets the user query it. |
27 |
|
28 |
#include "status_table_function.h" |
|
29 |
||
30 |
using namespace std; |
|
31 |
using namespace drizzled; |
|
32 |
||
33 |
class LibInnoDBStatusTool : public drizzled::plugin::TableFunction |
|
34 |
{
|
|
35 |
public: |
|
36 |
||
37 |
LibInnoDBStatusTool(); |
|
38 |
||
39 |
LibInnoDBStatusTool(const char *table_arg) : |
|
40 |
drizzled::plugin::TableFunction("data_dictionary", table_arg) |
|
41 |
{ } |
|
42 |
||
43 |
~LibInnoDBStatusTool() {} |
|
44 |
||
45 |
class Generator : public drizzled::plugin::TableFunction::Generator |
|
46 |
{
|
|
47 |
private: |
|
48 |
uint32_t names_next; |
|
49 |
public: |
|
50 |
Generator(drizzled::Field **arg); |
|
51 |
~Generator(); |
|
52 |
||
53 |
bool populate(); |
|
54 |
};
|
|
55 |
||
56 |
LibInnoDBStatusTool::Generator *generator(drizzled::Field **arg) |
|
57 |
{
|
|
58 |
return new Generator(arg); |
|
59 |
}
|
|
60 |
};
|
|
61 |
||
62 |
static const char* libinnodb_status_var_names[] = { |
|
63 |
"read_req_pending", |
|
64 |
"write_req_pending", |
|
65 |
"fsync_req_pending", |
|
66 |
"write_req_done", |
|
67 |
"read_req_done", |
|
68 |
"fsync_req_done", |
|
69 |
"bytes_total_written", |
|
70 |
"bytes_total_read", |
|
71 |
||
72 |
"buffer_pool_current_size", |
|
73 |
"buffer_pool_data_pages", |
|
74 |
"buffer_pool_dirty_pages", |
|
75 |
"buffer_pool_misc_pages", |
|
76 |
"buffer_pool_free_pages", |
|
77 |
"buffer_pool_read_reqs", |
|
78 |
"buffer_pool_reads", |
|
79 |
"buffer_pool_waited_for_free", |
|
80 |
"buffer_pool_pages_flushed", |
|
81 |
"buffer_pool_write_reqs", |
|
82 |
"buffer_pool_total_pages", |
|
83 |
"buffer_pool_pages_read", |
|
84 |
"buffer_pool_pages_written", |
|
85 |
||
86 |
"double_write_pages_written", |
|
87 |
"double_write_invoked", |
|
88 |
||
89 |
"log_buffer_slot_waits", |
|
90 |
"log_write_reqs", |
|
91 |
"log_write_flush_count", |
|
92 |
"log_bytes_written", |
|
93 |
"log_fsync_req_done", |
|
94 |
"log_write_req_pending", |
|
95 |
"log_fsync_req_pending", |
|
96 |
||
97 |
"lock_row_waits", |
|
98 |
"lock_row_waiting", |
|
99 |
"lock_total_wait_time_in_secs", |
|
100 |
"lock_wait_time_avg_in_secs", |
|
101 |
"lock_max_wait_time_in_secs", |
|
102 |
||
103 |
"row_total_read", |
|
104 |
"row_total_inserted", |
|
105 |
"row_total_updated", |
|
106 |
"row_total_deleted", |
|
107 |
||
108 |
"page_size", |
|
109 |
"have_atomic_builtins", |
|
110 |
NULL
|
|
111 |
};
|
|
112 |
||
113 |
LibInnoDBStatusTool::LibInnoDBStatusTool() : |
|
114 |
plugin::TableFunction("DATA_DICTIONARY", "INNODB_STATUS") |
|
115 |
{
|
|
116 |
add_field("NAME"); |
|
117 |
add_field("VALUE", plugin::TableFunction::NUMBER); |
|
118 |
}
|
|
119 |
||
120 |
LibInnoDBStatusTool::Generator::Generator(Field **arg) : |
|
121 |
plugin::TableFunction::Generator(arg), |
|
122 |
names_next(0) |
|
123 |
{
|
|
124 |
}
|
|
125 |
||
126 |
LibInnoDBStatusTool::Generator::~Generator() |
|
127 |
{
|
|
128 |
}
|
|
129 |
||
130 |
bool LibInnoDBStatusTool::Generator::populate() |
|
131 |
{
|
|
132 |
if (libinnodb_status_var_names[names_next] != NULL) |
|
133 |
{
|
|
134 |
const char* config_name= libinnodb_status_var_names[names_next]; |
|
135 |
||
136 |
push(config_name); |
|
137 |
||
138 |
ib_i64_t value; |
|
139 |
ib_err_t err= ib_status_get_i64(config_name, &value); |
|
140 |
assert(err == DB_SUCCESS); |
|
141 |
||
142 |
push(value); |
|
143 |
||
144 |
names_next++; |
|
145 |
return true; |
|
146 |
}
|
|
147 |
||
148 |
return false; // No more rows |
|
149 |
}
|
|
150 |
||
151 |
static LibInnoDBStatusTool *status_tool; |
|
152 |
||
1530.2.6
by Monty Taylor
Moved plugin::Context to module::Context. |
153 |
int status_table_function_initialize(drizzled::module::Context &context) |
1283.28.9
by Stewart Smith
basic DATA_DICTIONARY.INNODB_STATUS table_function plugin. This gets the InnoDB status and lets the user query it. |
154 |
{
|
155 |
status_tool= new(std::nothrow)LibInnoDBStatusTool(); |
|
1283.32.9
by Stewart Smith
merge trunk |
156 |
context.add(status_tool); |
1283.28.9
by Stewart Smith
basic DATA_DICTIONARY.INNODB_STATUS table_function plugin. This gets the InnoDB status and lets the user query it. |
157 |
|
158 |
return 0; |
|
159 |
}
|