~drizzle-trunk/drizzle/development

1561.3.19 by Joe Daly
move GPL code back to the core from logging_stats plugin
1
/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
 *  vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
3
 *
4
 *  Copyright (C) 2008 Sun Microsystems
5
 *  Copyright (C) 2010 Joseph Daly 
6
 *
7
 *  This program is free software; you can redistribute it and/or modify
8
 *  it under the terms of the GNU General Public License as published by
9
 *  the Free Software Foundation; version 2 of the License.
10
 *
11
 *  This program is distributed in the hope that it will be useful,
12
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
13
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
14
 *  GNU General Public License for more details.
15
 *
16
 *  You should have received a copy of the GNU General Public License
17
 *  along with this program; if not, write to the Free Software
18
 *  Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
19
 */
20
21
#include "config.h"
1775.5.1 by earney
modified files containing stringstream to use boost:lexical_cast instead as
22
#include <boost/lexical_cast.hpp>
1561.3.19 by Joe Daly
move GPL code back to the core from logging_stats plugin
23
#include "status_helper.h"
24
#include "drizzled/set_var.h"
25
#include "drizzled/drizzled.h"
26
#include "plugin/myisam/myisam.h"
27
28
#include <sstream>
29
30
using namespace drizzled;
31
using namespace std;
32
33
static int show_starttime_new(drizzle_show_var *var, char *buff)
34
{
35
  var->type= SHOW_LONG;
36
  var->value= buff;
37
  *((long *)buff)= (long) (time(NULL) - server_start_time);
38
  return 0;
39
}
40
41
static int show_flushstatustime_new(drizzle_show_var *var, char *buff)
42
{
43
  var->type= SHOW_LONG;
44
  var->value= buff;
45
  *((long *)buff)= (long) (time(NULL) - flush_status_time);
46
  return 0;
47
}
48
49
static int show_connection_count_new(drizzle_show_var *var, char *buff)
50
{
51
  var->type= SHOW_INT;
52
  var->value= buff;
53
  *((uint32_t *)buff)= connection_count;
54
  return 0;
55
}
56
57
static st_show_var_func_container show_starttime_cont_new= { &show_starttime_new };
58
59
static st_show_var_func_container show_flushstatustime_cont_new= { &show_flushstatustime_new };
60
61
static st_show_var_func_container show_connection_count_cont_new= { &show_connection_count_new };
62
63
string StatusHelper::fillHelper(system_status_var *status_var, char *value, SHOW_TYPE show_type)
64
{
65
  ostringstream oss;
66
  string return_value;
67
68
  switch (show_type) {
69
  case SHOW_DOUBLE_STATUS:
70
    value= ((char *) status_var + (ulong) value);
71
    /* fall through */
72
  case SHOW_DOUBLE:
73
    oss.precision(6);
74
    oss << *(double *) value;
75
    return_value= oss.str();
76
    break;
77
  case SHOW_LONG_STATUS:
78
    value= ((char *) status_var + (ulong) value);
79
    /* fall through */
80
  case SHOW_LONG:
1775.5.1 by earney
modified files containing stringstream to use boost:lexical_cast instead as
81
    return_value=boost::lexical_cast<std::string>(*(long*) value);
1561.3.19 by Joe Daly
move GPL code back to the core from logging_stats plugin
82
    break;
83
  case SHOW_LONGLONG_STATUS:
84
    value= ((char *) status_var + (uint64_t) value);
85
    /* fall through */
86
  case SHOW_LONGLONG:
1775.5.1 by earney
modified files containing stringstream to use boost:lexical_cast instead as
87
    return_value=boost::lexical_cast<std::string>(*(int64_t*) value);
1561.3.19 by Joe Daly
move GPL code back to the core from logging_stats plugin
88
    break;
89
  case SHOW_SIZE:
1775.5.1 by earney
modified files containing stringstream to use boost:lexical_cast instead as
90
    return_value=boost::lexical_cast<std::string>(*(size_t*) value);
1561.3.19 by Joe Daly
move GPL code back to the core from logging_stats plugin
91
    break;
92
  case SHOW_HA_ROWS:
1775.5.1 by earney
modified files containing stringstream to use boost:lexical_cast instead as
93
    return_value=boost::lexical_cast<std::string>((int64_t) *(ha_rows*) value);
1561.3.19 by Joe Daly
move GPL code back to the core from logging_stats plugin
94
    break;
95
  case SHOW_BOOL:
96
  case SHOW_MY_BOOL:
97
    return_value= *(bool*) value ? "ON" : "OFF";
98
    break;
99
  case SHOW_INT:
100
  case SHOW_INT_NOFLUSH: // the difference lies in refresh_status()
1775.5.1 by earney
modified files containing stringstream to use boost:lexical_cast instead as
101
    return_value=boost::lexical_cast<std::string>((long) *(uint32_t*) value);
1561.3.19 by Joe Daly
move GPL code back to the core from logging_stats plugin
102
    break;
103
  case SHOW_CHAR:
104
    {
105
      if (value)
106
        return_value= value;
107
      break;
108
    }
109
  case SHOW_CHAR_PTR:
110
    {
111
      if (*(char**) value)
112
        return_value= *(char**) value;
113
114
      break;
115
    }
116
  case SHOW_UNDEF:
117
    break;                                        // Return empty string
118
  case SHOW_SYS:                                  // Cannot happen
119
  default:
120
    assert(0);
121
    break;
122
  }
123
124
  return return_value;
125
}
126
127
drizzle_show_var StatusHelper::status_vars_defs[]=
128
{
1625.2.1 by Joe Daly
initial user stats impl
129
  {"Aborted_clients",           (char*) offsetof(system_status_var, aborted_threads), SHOW_LONGLONG_STATUS},
130
  {"Aborted_connects",          (char*) offsetof(system_status_var, aborted_connects), SHOW_LONGLONG_STATUS},
1561.3.19 by Joe Daly
move GPL code back to the core from logging_stats plugin
131
  {"Bytes_received",            (char*) offsetof(system_status_var, bytes_received), SHOW_LONGLONG_STATUS},
132
  {"Bytes_sent",                (char*) offsetof(system_status_var, bytes_sent), SHOW_LONGLONG_STATUS},
1726.3.3 by LinuxJedi
Add a proper connections counter.
133
  {"Connections",               (char*) &current_global_counters.connections,  SHOW_LONGLONG},
1561.3.19 by Joe Daly
move GPL code back to the core from logging_stats plugin
134
  {"Created_tmp_disk_tables",   (char*) offsetof(system_status_var, created_tmp_disk_tables), SHOW_LONGLONG_STATUS},
135
  {"Created_tmp_tables",        (char*) offsetof(system_status_var, created_tmp_tables), SHOW_LONGLONG_STATUS},
136
  {"Flush_commands",            (char*) &refresh_version,    SHOW_INT_NOFLUSH},
137
  {"Handler_commit",            (char*) offsetof(system_status_var, ha_commit_count), SHOW_LONGLONG_STATUS},
138
  {"Handler_delete",            (char*) offsetof(system_status_var, ha_delete_count), SHOW_LONGLONG_STATUS},
139
  {"Handler_prepare",           (char*) offsetof(system_status_var, ha_prepare_count),  SHOW_LONGLONG_STATUS},
140
  {"Handler_read_first",        (char*) offsetof(system_status_var, ha_read_first_count), SHOW_LONGLONG_STATUS},
141
  {"Handler_read_key",          (char*) offsetof(system_status_var, ha_read_key_count), SHOW_LONGLONG_STATUS},
142
  {"Handler_read_next",         (char*) offsetof(system_status_var, ha_read_next_count), SHOW_LONGLONG_STATUS},
143
  {"Handler_read_prev",         (char*) offsetof(system_status_var, ha_read_prev_count), SHOW_LONGLONG_STATUS},
144
  {"Handler_read_rnd",          (char*) offsetof(system_status_var, ha_read_rnd_count), SHOW_LONGLONG_STATUS},
145
  {"Handler_read_rnd_next",     (char*) offsetof(system_status_var, ha_read_rnd_next_count), SHOW_LONGLONG_STATUS},
146
  {"Handler_rollback",          (char*) offsetof(system_status_var, ha_rollback_count), SHOW_LONGLONG_STATUS},
147
  {"Handler_savepoint",         (char*) offsetof(system_status_var, ha_savepoint_count), SHOW_LONGLONG_STATUS},
148
  {"Handler_savepoint_rollback",(char*) offsetof(system_status_var, ha_savepoint_rollback_count), SHOW_LONGLONG_STATUS},
149
  {"Handler_update",            (char*) offsetof(system_status_var, ha_update_count), SHOW_LONGLONG_STATUS},
150
  {"Handler_write",             (char*) offsetof(system_status_var, ha_write_count), SHOW_LONGLONG_STATUS},
151
  {"Last_query_cost",           (char*) offsetof(system_status_var, last_query_cost), SHOW_DOUBLE_STATUS},
152
  {"Max_used_connections",      (char*) &current_global_counters.max_used_connections,  SHOW_LONGLONG},
153
  {"Questions",                 (char*) offsetof(system_status_var, questions), SHOW_LONGLONG_STATUS},
154
  {"Select_full_join",          (char*) offsetof(system_status_var, select_full_join_count), SHOW_LONGLONG_STATUS},
155
  {"Select_full_range_join",    (char*) offsetof(system_status_var, select_full_range_join_count), SHOW_LONGLONG_STATUS},
156
  {"Select_range",              (char*) offsetof(system_status_var, select_range_count), SHOW_LONGLONG_STATUS},
157
  {"Select_range_check",        (char*) offsetof(system_status_var, select_range_check_count), SHOW_LONGLONG_STATUS},
158
  {"Select_scan",               (char*) offsetof(system_status_var, select_scan_count), SHOW_LONGLONG_STATUS},
159
  {"Slow_queries",              (char*) offsetof(system_status_var, long_query_count), SHOW_LONGLONG_STATUS},
160
  {"Sort_merge_passes",         (char*) offsetof(system_status_var, filesort_merge_passes), SHOW_LONGLONG_STATUS},
161
  {"Sort_range",                (char*) offsetof(system_status_var, filesort_range_count), SHOW_LONGLONG_STATUS},
162
  {"Sort_rows",                 (char*) offsetof(system_status_var, filesort_rows), SHOW_LONGLONG_STATUS},
163
  {"Sort_scan",                 (char*) offsetof(system_status_var, filesort_scan_count), SHOW_LONGLONG_STATUS},
164
  {"Table_locks_immediate",     (char*) &current_global_counters.locks_immediate,        SHOW_LONGLONG},
165
  {"Table_locks_waited",        (char*) &current_global_counters.locks_waited,           SHOW_LONGLONG},
166
  {"Threads_connected",         (char*) &show_connection_count_cont_new,  SHOW_FUNC},
167
  {"Uptime",                    (char*) &show_starttime_cont_new,         SHOW_FUNC},
168
  {"Uptime_since_flush_status", (char*) &show_flushstatustime_cont_new,   SHOW_FUNC},
169
  {NULL, NULL, SHOW_LONGLONG}
170
};