← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/logging_stats/user_commands.cc

  • Committer: Monty Taylor
  • Date: 2010-04-22 05:16:07 UTC
  • mto: (1527.1.5 staging)
  • mto: This revision was merged to the branch mainline in revision 1527.
  • Revision ID: mordred@inaugust.com-20100422051607-tdscrqr5951oi4fx
dtrace is broken on FreeBSD. Check for that and don't attempt to use it if it don't work.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/logging_stats/user_commands.cc
1
1
/*
2
 
 * Copyright (C) 2010 Joseph Daly <skinny.moey@gmail.com>
 
2
 * Copyright (c) 2010, Joseph Daly <skinny.moey@gmail.com>
3
3
 * All rights reserved.
4
4
 *
5
5
 * Redistribution and use in source and binary forms, with or without
29
29
 
30
30
#include "user_commands.h"
31
31
 
32
 
using namespace drizzled;
33
 
using namespace std;
34
 
 
35
 
const char* UserCommands::USER_COUNTS[] =
36
 
{
37
 
  "COUNT_SELECT",
38
 
  "COUNT_DELETE",
39
 
  "COUNT_UPDATE",
40
 
  "COUNT_INSERT",
41
 
  "COUNT_ROLLBACK",
42
 
  "COUNT_COMMIT",
43
 
  "COUNT_CREATE",
44
 
  "COUNT_ALTER",
45
 
  "COUNT_DROP",
46
 
  "COUNT_ADMIN"
47
 
};
48
 
 
49
 
const char* UserCommands::COM_STATUS_VARS[] =
50
 
{
51
 
  "select",
52
 
  "create_table",
53
 
  "create_index",
54
 
  "alter_table",
55
 
  "update",
56
 
  "insert",
57
 
  "insert_select",
58
 
  "delete",
59
 
  "truncate",
60
 
  "drop_table",
61
 
  "drop_index",
62
 
  "show_create",
63
 
  "show_create_db",
64
 
  "load",
65
 
  "set_option",
66
 
  "unlock_tables",
67
 
  "change_db",
68
 
  "create_db",
69
 
  "drop_db",
70
 
  "alter_db",
71
 
  "replace",
72
 
  "replace_select",
73
 
  "check",
74
 
  "flush",
75
 
  "kill",
76
 
  "analyze",
77
 
  "rollback",
78
 
  "rollback_to_savepoint",
79
 
  "commit",
80
 
  "savepoint",
81
 
  "release_savepoint",
82
 
  "begin",
83
 
  "rename_table",
84
 
  "show_warns",
85
 
  "empty_query",
86
 
  "show_errors",
87
 
  "checksum"
88
 
};
89
 
 
90
32
UserCommands::UserCommands()
91
 
{
92
 
  init();
93
 
}
94
 
 
95
 
void UserCommands::init()
96
 
{
97
 
  vector<uint64_t>::iterator it= vector_of_command_counts.begin();
98
 
  for (int j=0; j < SQLCOM_END; ++j)
99
 
  {
100
 
    it=  vector_of_command_counts.insert(it, 0);
101
 
  }
102
 
  vector_of_command_counts.resize(SQLCOM_END);
103
 
}
104
 
 
105
 
void UserCommands::incrementCount(uint32_t index, uint32_t i)
106
 
{
107
 
  uint64_t *count= &(vector_of_command_counts.at(index));
108
 
  *count= *count + i;
109
 
}
110
 
 
111
 
uint64_t UserCommands::getCount(uint32_t index)
112
 
{
113
 
  uint64_t *count= &(vector_of_command_counts.at(index));
114
 
  return *count;
115
 
}
116
 
 
117
 
uint64_t UserCommands::getUserCount(uint32_t index)
118
 
{
119
 
  switch (index)
120
 
  {
121
 
    case COUNT_SELECT:
122
 
      return getCount(SQLCOM_SELECT);
123
 
    case COUNT_DELETE:
124
 
      return getCount(SQLCOM_DELETE);
125
 
    case COUNT_UPDATE:
126
 
      return getCount(SQLCOM_UPDATE);
127
 
    case COUNT_INSERT:
128
 
      return getCount(SQLCOM_INSERT);
129
 
    case COUNT_ROLLBACK:
130
 
      return getCount(SQLCOM_ROLLBACK);
131
 
    case COUNT_COMMIT:
132
 
      return getCount(SQLCOM_COMMIT);
133
 
    case COUNT_CREATE:
134
 
      return getCount(SQLCOM_CREATE_TABLE);
135
 
    case COUNT_ALTER:
136
 
      return getCount(SQLCOM_ALTER_TABLE);
137
 
    case COUNT_DROP:
138
 
      return getCount(SQLCOM_DROP_TABLE);
139
 
    default:
140
 
      return 0;
141
 
  }
142
 
}
 
33
    :
 
34
      update_count(0),
 
35
      delete_count(0),
 
36
      insert_count(0),
 
37
      select_count(0),
 
38
      rollback_count(0),
 
39
      commit_count(0),
 
40
      create_count(0),
 
41
      alter_count(0),
 
42
      drop_count(0),
 
43
      admin_count(0)
 
44
{}
143
45
 
144
46
void UserCommands::reset()
145
47
{
146
 
  for (uint32_t j= 0; j < SQLCOM_END; ++j)
147
 
  {
148
 
    uint64_t *count= &(vector_of_command_counts.at(j));
149
 
    *count= 0;
150
 
  }
 
48
  update_count= 0;
 
49
  delete_count= 0;
 
50
  insert_count= 0;
 
51
  select_count= 0;
 
52
  rollback_count= 0;
 
53
  commit_count= 0;
 
54
  create_count= 0;
 
55
  alter_count= 0;
 
56
  drop_count= 0;
 
57
  admin_count= 0;
151
58
}
152
59
 
153
60
UserCommands::UserCommands(const UserCommands &user_commands)
154
61
{
155
 
  init();
156
 
 
157
 
  for (uint32_t j= 0; j < SQLCOM_END; ++j)
158
 
  {
159
 
    uint64_t *my_count= &(vector_of_command_counts.at(j));
160
 
    uint64_t other_count= user_commands.vector_of_command_counts.at(j);
161
 
    *my_count= other_count;
162
 
  }
 
62
  update_count= user_commands.update_count;
 
63
  delete_count= user_commands.delete_count;
 
64
  insert_count= user_commands.insert_count;
 
65
  select_count= user_commands.select_count;
 
66
  rollback_count= user_commands.rollback_count;
 
67
  commit_count= user_commands.commit_count;
 
68
  create_count= user_commands.create_count;
 
69
  alter_count= user_commands.alter_count;
 
70
  drop_count= user_commands.drop_count;
 
71
  admin_count= user_commands.admin_count;
163
72
}
164
73
 
165
74
void UserCommands::merge(UserCommands *user_commands)
166
75
{
167
 
  for (uint32_t j= 0; j < SQLCOM_END; ++j)
168
 
  {
169
 
    uint64_t *my_count= &(vector_of_command_counts.at(j));
170
 
    uint64_t other_count= user_commands->vector_of_command_counts.at(j);
171
 
    *my_count= *my_count + other_count;
172
 
  }
173
 
}
174
 
 
175
 
void UserCommands::logCommand(enum_sql_command sql_command)
176
 
{
177
 
  if (sql_command < SQLCOM_END)
178
 
  {
179
 
    incrementCount(sql_command);
180
 
  }
 
76
  incrementUpdateCount(user_commands->getUpdateCount());
 
77
  incrementDeleteCount(user_commands->getDeleteCount());
 
78
  incrementInsertCount(user_commands->getInsertCount());
 
79
  incrementSelectCount(user_commands->getSelectCount());
 
80
  incrementRollbackCount(user_commands->getRollbackCount());
 
81
  incrementCommitCount(user_commands->getCommitCount());
 
82
  incrementCreateCount(user_commands->getCreateCount());
 
83
  incrementAlterCount(user_commands->getAlterCount());
 
84
  incrementDropCount(user_commands->getDropCount());
 
85
  incrementAdminCount(user_commands->getAdminCount());
 
86
}
 
87
 
 
88
uint64_t UserCommands::getSelectCount()
 
89
{
 
90
  return select_count;
 
91
}
 
92
 
 
93
void UserCommands::incrementSelectCount(int i)
 
94
{
 
95
  select_count= select_count + i;
 
96
}
 
97
 
 
98
uint64_t UserCommands::getUpdateCount()
 
99
{
 
100
  return update_count;
 
101
}
 
102
 
 
103
void UserCommands::incrementUpdateCount(int i)
 
104
{
 
105
  update_count= update_count + i;
 
106
}
 
107
 
 
108
uint64_t UserCommands::getDeleteCount()
 
109
{
 
110
  return delete_count;
 
111
}
 
112
 
 
113
void UserCommands::incrementDeleteCount(int i)
 
114
{
 
115
  delete_count= delete_count + i;
 
116
}
 
117
 
 
118
uint64_t UserCommands::getInsertCount()
 
119
{
 
120
  return insert_count;
 
121
}
 
122
 
 
123
void UserCommands::incrementInsertCount(int i)
 
124
{
 
125
  insert_count= insert_count + i;
 
126
}
 
127
 
 
128
uint64_t UserCommands::getRollbackCount()
 
129
{
 
130
  return rollback_count;
 
131
}
 
132
 
 
133
void UserCommands::incrementRollbackCount(int i)
 
134
{
 
135
  rollback_count= rollback_count + i;
 
136
}
 
137
 
 
138
uint64_t UserCommands::getCommitCount()
 
139
{
 
140
  return commit_count;
 
141
}
 
142
 
 
143
void UserCommands::incrementCommitCount(int i)
 
144
{
 
145
  commit_count= commit_count + i;
 
146
}
 
147
 
 
148
uint64_t UserCommands::getCreateCount()
 
149
{
 
150
  return create_count;
 
151
}
 
152
 
 
153
void UserCommands::incrementCreateCount(int i)
 
154
{
 
155
  create_count= create_count + i;
 
156
}
 
157
 
 
158
uint64_t UserCommands::getAlterCount()
 
159
{
 
160
  return alter_count;
 
161
}
 
162
 
 
163
void UserCommands::incrementAlterCount(int i)
 
164
{
 
165
  alter_count= alter_count + i;
 
166
}
 
167
 
 
168
uint64_t UserCommands::getDropCount()
 
169
{
 
170
  return drop_count;
 
171
}
 
172
 
 
173
void UserCommands::incrementDropCount(int i)
 
174
{
 
175
  drop_count= drop_count + i;
 
176
}
 
177
 
 
178
uint64_t UserCommands::getAdminCount()
 
179
{
 
180
  return admin_count;
 
181
}
 
182
 
 
183
void UserCommands::incrementAdminCount(int i)
 
184
{
 
185
  admin_count= admin_count + i;
181
186
}