MySQL 9.0.0
Source Code Documentation
sql_show_status.cc File Reference
#include "sql/sql_show_status.h"
#include "lex_string.h"
#include "my_alloc.h"
#include "my_sqlcommand.h"
#include "sql/item_cmpfunc.h"
#include "sql/mem_root_array.h"
#include "sql/parse_tree_items.h"
#include "sql/parse_tree_node_base.h"
#include "sql/parse_tree_nodes.h"
#include "sql/parser_yystype.h"
#include "sql/sql_class.h"
#include "sql/sql_lex.h"
#include "sql/strfunc.h"
#include "sql_string.h"
#include "string_with_len.h"

Functions

static Query_blockbuild_query (const POS &pos, THD *thd, enum_sql_command command, const LEX_CSTRING &table_name, const String *wild, Item *where_cond)
 Build a replacement query for SHOW STATUS. More...
 
Query_blockbuild_show_session_status (const POS &pos, THD *thd, const String *wild, Item *where_cond)
 
Query_blockbuild_show_global_status (const POS &pos, THD *thd, const String *wild, Item *where_cond)
 
Query_blockbuild_show_session_variables (const POS &pos, THD *thd, const String *wild, Item *where_cond)
 
Query_blockbuild_show_global_variables (const POS &pos, THD *thd, const String *wild, Item *where_cond)
 

Function Documentation

◆ build_query()

static Query_block * build_query ( const POS pos,
THD thd,
enum_sql_command  command,
const LEX_CSTRING table_name,
const String wild,
Item where_cond 
)
static

Build a replacement query for SHOW STATUS.

When the parser accepts the following syntax:

SHOW GLOBAL STATUS

the parsed tree built for this query is in fact:

SELECT * FROM (SELECT VARIABLE_NAME as Variable_name, VARIABLE_VALUE as Value FROM performance_schema.global_status) global_status

Likewise, the query:

SHOW GLOBAL STATUS LIKE "<value>"

is built as:

SELECT * FROM (SELECT VARIABLE_NAME as Variable_name, VARIABLE_VALUE as Value FROM performance_schema.global_status) global_status WHERE Variable_name LIKE "<value>"

Likewise, the query:

SHOW GLOBAL STATUS where <where_clause>

is built as:

SELECT * FROM (SELECT VARIABLE_NAME as Variable_name, VARIABLE_VALUE as Value FROM performance_schema.global_status) global_status WHERE <where_clause>

◆ build_show_global_status()

Query_block * build_show_global_status ( const POS pos,
THD thd,
const String wild,
Item where_cond 
)

◆ build_show_global_variables()

Query_block * build_show_global_variables ( const POS pos,
THD thd,
const String wild,
Item where_cond 
)

◆ build_show_session_status()

Query_block * build_show_session_status ( const POS pos,
THD thd,
const String wild,
Item where_cond 
)

◆ build_show_session_variables()

Query_block * build_show_session_variables ( const POS pos,
THD thd,
const String wild,
Item where_cond 
)