103
103
static bool sysvar_logging_stats_enabled= true;
105
typedef constrained_check<uint32_t, 50000, 10> scoreboard_size_constraint;
106
static scoreboard_size_constraint sysvar_logging_stats_scoreboard_size;
108
typedef constrained_check<uint32_t, 50000, 100> max_user_count_constraint;
109
static max_user_count_constraint sysvar_logging_stats_max_user_count;
111
typedef constrained_check<uint32_t, 500, 5> bucket_count_constraint;
112
static bucket_count_constraint sysvar_logging_stats_bucket_count;
105
static uint32_t sysvar_logging_stats_scoreboard_size= 2000;
107
static uint32_t sysvar_logging_stats_max_user_count= 500;
109
static uint32_t sysvar_logging_stats_bucket_count= 10;
114
111
LoggingStats::LoggingStats(string name_arg) : Logging(name_arg)
140
137
scoreboard_slot->getStatusVars()->logStatusVar(session);
143
bool LoggingStats::resetGlobalScoreboard()
145
cumulative_stats->getGlobalStatusVars()->reset();
146
cumulative_stats->getGlobalStats()->getUserCommands()->reset();
148
ScoreBoardVectors *vector_of_scoreboard_vectors=
149
current_scoreboard->getVectorOfScoreboardVectors();
151
ScoreBoardVectors::iterator v_of_scoreboard_v_begin_it= vector_of_scoreboard_vectors->begin();
153
ScoreBoardVectors::iterator v_of_scoreboard_v_end_it= vector_of_scoreboard_vectors->end();
155
for (; v_of_scoreboard_v_begin_it != v_of_scoreboard_v_end_it; ++v_of_scoreboard_v_begin_it)
157
std::vector<ScoreboardSlot* > *scoreboard_vector= *v_of_scoreboard_v_begin_it;
159
std::vector<ScoreboardSlot* >::iterator scoreboard_vector_it= scoreboard_vector->begin();
160
std::vector<ScoreboardSlot* >::iterator scoreboard_vector_end= scoreboard_vector->end();
161
for (; scoreboard_vector_it != scoreboard_vector_end; ++scoreboard_vector_it)
163
ScoreboardSlot *scoreboard_slot= *scoreboard_vector_it;
164
scoreboard_slot->getStatusVars()->reset();
165
scoreboard_slot->getUserCommands()->reset();
172
140
bool LoggingStats::post(Session *session)
174
142
if (! isEnabled() || (session->getSessionId() == 0))
254
222
static ScoreboardStatsTool *scoreboard_stats_tool= NULL;
256
static void enable(Session *, sql_var_t)
224
static void enable(Session *,
258
229
if (logging_stats)
260
if (sysvar_logging_stats_enabled)
231
if (*(bool *)save != false)
262
233
logging_stats->enable();
234
*(bool *) var_ptr= (bool) true;
266
238
logging_stats->disable();
239
*(bool *) var_ptr= (bool) false;
332
305
static int init(drizzled::module::Context &context)
334
307
const module::option_map &vm= context.getOptions();
308
if (vm.count("max-user-count"))
310
if (sysvar_logging_stats_max_user_count < 100 || sysvar_logging_stats_max_user_count > 50000)
312
errmsg_printf(ERRMSG_LVL_ERROR, _("Invalid value for max-user-count\n"));
316
if (vm.count("bucket-count"))
318
if (sysvar_logging_stats_bucket_count < 5 || sysvar_logging_stats_bucket_count > 500)
320
errmsg_printf(ERRMSG_LVL_ERROR, _("Invalid value for bucket-count\n"));
336
sysvar_logging_stats_enabled= (vm.count("disable")) ? false : true;
325
if (vm.count("scoreboard-size"))
327
if (sysvar_logging_stats_scoreboard_size < 10 || sysvar_logging_stats_scoreboard_size > 50000)
329
errmsg_printf(ERRMSG_LVL_ERROR, _("Invalid value for scoreboard-size\n"));
333
sysvar_logging_stats_scoreboard_size= vm["scoreboard-size"].as<uint32_t>();
338
336
logging_stats= new LoggingStats("logging_stats");
357
355
logging_stats->enable();
360
context.registerVariable(new sys_var_constrained_value_readonly<uint32_t>("max_user_count", sysvar_logging_stats_max_user_count));
361
context.registerVariable(new sys_var_constrained_value_readonly<uint32_t>("bucket_count", sysvar_logging_stats_bucket_count));
362
context.registerVariable(new sys_var_constrained_value_readonly<uint32_t>("scoreboard_size", sysvar_logging_stats_scoreboard_size));
363
context.registerVariable(new sys_var_bool_ptr("enable", &sysvar_logging_stats_enabled, enable));
361
static DRIZZLE_SYSVAR_UINT(max_user_count,
362
sysvar_logging_stats_max_user_count,
364
N_("Max number of users that will be logged"),
365
NULL, /* check func */
366
NULL, /* update func */
372
static DRIZZLE_SYSVAR_UINT(bucket_count,
373
sysvar_logging_stats_bucket_count,
375
N_("Max number of range locks to use for Scoreboard"),
376
NULL, /* check func */
377
NULL, /* update func */
383
static DRIZZLE_SYSVAR_UINT(scoreboard_size,
384
sysvar_logging_stats_scoreboard_size,
386
N_("Max number of concurrent sessions that will be logged"),
387
NULL, /* check func */
388
NULL, /* update func */
394
static DRIZZLE_SYSVAR_BOOL(enable,
395
sysvar_logging_stats_enabled,
397
N_("Enable Logging Statistics Collection"),
398
NULL, /* check func */
399
enable, /* update func */
369
402
static void init_options(drizzled::module::option_context &context)
371
404
context("max-user-count",
372
po::value<max_user_count_constraint>(&sysvar_logging_stats_max_user_count)->default_value(500),
405
po::value<uint32_t>(&sysvar_logging_stats_max_user_count)->default_value(500),
373
406
N_("Max number of users that will be logged"));
374
407
context("bucket-count",
375
po::value<bucket_count_constraint>(&sysvar_logging_stats_bucket_count)->default_value(10),
408
po::value<uint32_t>(&sysvar_logging_stats_bucket_count)->default_value(10),
376
409
N_("Max number of range locks to use for Scoreboard"));
377
410
context("scoreboard-size",
378
po::value<scoreboard_size_constraint>(&sysvar_logging_stats_scoreboard_size)->default_value(2000),
411
po::value<uint32_t>(&sysvar_logging_stats_scoreboard_size)->default_value(2000),
379
412
N_("Max number of concurrent sessions that will be logged"));
380
context("disable", N_("Enable Logging Statistics Collection"));
414
po::value<bool>(&sysvar_logging_stats_enabled)->default_value(true)->zero_tokens(),
415
N_("Enable Logging Statistics Collection"));
418
static drizzle_sys_var* system_var[]= {
419
DRIZZLE_SYSVAR(max_user_count),
420
DRIZZLE_SYSVAR(bucket_count),
421
DRIZZLE_SYSVAR(scoreboard_size),
422
DRIZZLE_SYSVAR(enable),
383
426
DRIZZLE_DECLARE_PLUGIN
385
428
DRIZZLE_VERSION_ID,