/* Copyright (c) 2015, 2023, Oracle and/or its affiliates.
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_ACCOUNT_H
#define TABLE_STATUS_BY_ACCOUNT_H
/**
@ file storage / perfschema / table_status_by_account . h
Table STATUS_BY_ACCOUNT ( declarations ) .
*/
#include "pfs_column_types.h"
#include "pfs_engine_table.h"
#include "pfs_instr_class.h"
#include "pfs_instr.h"
#include "pfs_account.h"
#include "pfs_account.h"
#include "pfs_host.h"
#include "table_helper.h"
#include "pfs_variable.h"
#include "pfs_buffer_container.h"
/**
@ addtogroup Performance_schema_tables
@ {
*/
/**
A row of table
PERFORMANCE_SCHEMA . STATUS_BY_ACCOUNT .
*/
struct row_status_by_account
{
/** Column USER, HOST. */
PFS_account_row m_account;
/** 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_ACCOUNT .
Index 1 on account ( 0 based )
Index 2 on status variable ( 0 based )
*/
struct pos_status_by_account
: public PFS_double_index
{
pos_status_by_account()
: PFS_double_index(0 , 0 )
{}
inline void reset(void )
{
m_index_1= 0 ;
m_index_2= 0 ;
}
inline bool has_more_account(void )
{ return (m_index_1 < global_account_container.get_row_count()); }
inline void next_account(void )
{
m_index_1++;
m_index_2= 0 ;
}
};
/**
Store and retrieve table state information for queries that reinstantiate
the table object .
*/
class table_status_by_account_context : public PFS_table_context
{
public :
table_status_by_account_context(ulonglong current_version, bool restore) :
PFS_table_context(current_version, global_account_container.get_row_count(), restore, &THR_PFS_SBH) { }
};
/** Table PERFORMANCE_SCHEMA.STATUS_BY_ACCOUNT. */
class table_status_by_account : public PFS_engine_table
{
typedef pos_status_by_account pos_t;
public :
static PFS_engine_table_share_state m_share_state;
/** Table share */
static PFS_engine_table_share m_share;
static PFS_engine_table* create();
static int delete_all_rows();
static ha_rows get_row_count();
int rnd_init(bool scan) override;
int rnd_next() override;
int rnd_pos(const void *pos) override;
void reset_position(void ) override;
protected :
int read_row_values(TABLE *table,
unsigned char *buf,
Field **fields,
bool read_all) override;
table_status_by_account();
public :
~table_status_by_account()
{}
protected :
int materialize(PFS_thread *pfs_thread);
void make_row(PFS_account *pfs_account, const Status_variable *status_var);
private :
/** Table share lock. */
static THR_LOCK m_table_lock;
/** Fields definition. */
static TABLE_FIELD_DEF m_field_def;
/** Status variable cache for one account. */
PFS_status_variable_cache m_status_cache;
/** Current row. */
row_status_by_account m_row;
/** True if the current row exists. */
bool m_row_exists;
/** 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_account_context *m_context;
};
/** @} */
#endif
Messung V0.5 in Prozent C=88 H=100 G=94
¤ Dauer der Verarbeitung: 0.9 Sekunden
(vorverarbeitet am 2026-10-08)
¤
*© Formatika GbR, Deutschland