174 lines
4.6 KiB
C++
174 lines
4.6 KiB
C++
/* Copyright (c) 2015, 2019, Oracle and/or its affiliates. All rights reserved.
|
|
|
|
This program is free software; you can redistribute it and/or modify
|
|
it under the terms of the GNU General Public License, version 2.0,
|
|
as published by the Free Software Foundation.
|
|
|
|
This program is also distributed with certain software (including
|
|
but not limited to OpenSSL) that is licensed under separate terms,
|
|
as designated in a particular file or component or in included license
|
|
documentation. The authors of MySQL hereby grant you an additional
|
|
permission to link the program and your derivative works with the
|
|
separately licensed software that they have included with MySQL.
|
|
|
|
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, version 2.0, 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 */
|
|
|
|
#ifndef TABLE_STATUS_BY_USER_H
|
|
#define TABLE_STATUS_BY_USER_H
|
|
|
|
/**
|
|
@file storage/perfschema/table_status_by_user.h
|
|
Table STATUS_BY_USER (declarations).
|
|
*/
|
|
|
|
#include <sys/types.h>
|
|
|
|
#include "my_base.h"
|
|
#include "my_inttypes.h"
|
|
#include "storage/perfschema/pfs.h"
|
|
#include "storage/perfschema/pfs_buffer_container.h"
|
|
#include "storage/perfschema/pfs_engine_table.h"
|
|
#include "storage/perfschema/pfs_variable.h"
|
|
#include "storage/perfschema/table_helper.h"
|
|
|
|
class Field;
|
|
class Plugin_table;
|
|
struct PFS_user;
|
|
struct TABLE;
|
|
struct THR_LOCK;
|
|
|
|
/**
|
|
@addtogroup performance_schema_tables
|
|
@{
|
|
*/
|
|
|
|
/**
|
|
A row of table
|
|
PERFORMANCE_SCHEMA.STATUS_BY_USER.
|
|
*/
|
|
struct row_status_by_user {
|
|
/** Column USER */
|
|
PFS_user_row m_user;
|
|
/** Column VARIABLE_NAME. */
|
|
PFS_variable_name_row m_variable_name;
|
|
/** Column VARIABLE_VALUE. */
|
|
PFS_variable_value_row m_variable_value;
|
|
};
|
|
|
|
/**
|
|
Position of a cursor on
|
|
PERFORMANCE_SCHEMA.STATUS_BY_USER.
|
|
Index 1 on user (0 based)
|
|
Index 2 on status variable (0 based)
|
|
*/
|
|
struct pos_status_by_user : public PFS_double_index {
|
|
pos_status_by_user() : PFS_double_index(0, 0) {}
|
|
|
|
inline void reset(void) {
|
|
m_index_1 = 0;
|
|
m_index_2 = 0;
|
|
}
|
|
|
|
inline bool has_more_user(void) {
|
|
return (m_index_1 < global_user_container.get_row_count());
|
|
}
|
|
|
|
inline void next_user(void) {
|
|
m_index_1++;
|
|
m_index_2 = 0;
|
|
}
|
|
};
|
|
|
|
class PFS_index_status_by_user : public PFS_engine_index {
|
|
public:
|
|
PFS_index_status_by_user()
|
|
: PFS_engine_index(&m_key_1, &m_key_2),
|
|
m_key_1("USER"),
|
|
m_key_2("VARIABLE_NAME") {}
|
|
|
|
~PFS_index_status_by_user() {}
|
|
|
|
virtual bool match(PFS_user *pfs);
|
|
virtual bool match(const Status_variable *pfs);
|
|
|
|
private:
|
|
PFS_key_user m_key_1;
|
|
PFS_key_variable_name m_key_2;
|
|
};
|
|
|
|
/**
|
|
Store and retrieve table state information for queries that reinstantiate
|
|
the table object.
|
|
*/
|
|
class table_status_by_user_context : public PFS_table_context {
|
|
public:
|
|
table_status_by_user_context(ulonglong current_version, bool restore)
|
|
: PFS_table_context(current_version,
|
|
global_user_container.get_row_count(), restore,
|
|
THR_PFS_SBU) {}
|
|
};
|
|
|
|
/** Table PERFORMANCE_SCHEMA.STATUS_BY_USER. */
|
|
class table_status_by_user : public PFS_engine_table {
|
|
typedef pos_status_by_user pos_t;
|
|
|
|
public:
|
|
/** Table share */
|
|
static PFS_engine_table_share m_share;
|
|
static PFS_engine_table *create(PFS_engine_table_share *);
|
|
static int delete_all_rows();
|
|
static ha_rows get_row_count();
|
|
|
|
virtual void reset_position(void);
|
|
|
|
virtual int rnd_init(bool scan);
|
|
virtual int rnd_next();
|
|
virtual int rnd_pos(const void *pos);
|
|
|
|
virtual int index_init(uint idx, bool sorted);
|
|
virtual int index_next();
|
|
|
|
protected:
|
|
virtual int read_row_values(TABLE *table, unsigned char *buf, Field **fields,
|
|
bool read_all);
|
|
table_status_by_user();
|
|
|
|
public:
|
|
~table_status_by_user() {}
|
|
|
|
protected:
|
|
int make_row(PFS_user *user, const Status_variable *status_var);
|
|
|
|
private:
|
|
/** Table share lock. */
|
|
static THR_LOCK m_table_lock;
|
|
/** Table definition. */
|
|
static Plugin_table m_table_def;
|
|
|
|
/** Status variable cache for one user. */
|
|
PFS_status_variable_cache m_status_cache;
|
|
|
|
/** Current row. */
|
|
row_status_by_user m_row;
|
|
/** Current position. */
|
|
pos_t m_pos;
|
|
/** Next position. */
|
|
pos_t m_next_pos;
|
|
|
|
/** Table context with global status array version and map of materialized
|
|
* threads. */
|
|
table_status_by_user_context *m_context;
|
|
|
|
PFS_index_status_by_user *m_opened_index;
|
|
};
|
|
|
|
/** @} */
|
|
#endif
|