MySQL 8.1.0
Source Code Documentation
Sql_cmd_show_processlist Class Reference

Represents SHOW PROCESSLIST statement. More...

#include <sql_show.h>

Inheritance diagram for Sql_cmd_show_processlist:

Public Member Functions

 Sql_cmd_show_processlist ()
 Sql_cmd_show_processlist (bool verbose)
bool check_privileges (THD *thd) override
 Perform an authorization check for a prepared SELECT statement. More...
bool execute_inner (THD *thd) override
 The inner parts of query optimization and execution. More...
void set_use_pfs (bool use_pfs)
bool verbose () const
- Public Member Functions inherited from Sql_cmd_show
 Sql_cmd_show (enum_sql_command sql_command)
enum_sql_command sql_command_code () const override
 Return the command code for this statement. More...
virtual bool check_parameters (THD *)
bool precheck (THD *thd) override
 Generally, the SHOW commands do not distinguish precheck and regular check. More...
bool execute (THD *thd) override
 Execute a DML statement. More...
- Public Member Functions inherited from Sql_cmd_select
 Sql_cmd_select (Query_result *result_arg)
bool is_data_change_stmt () const override
bool accept (THD *thd, Select_lex_visitor *visitor) override
const MYSQL_LEX_CSTRINGeligible_secondary_storage_engine () const override
 Is this statement of a type and on a form that makes it eligible for execution in a secondary storage engine? More...
- Public Member Functions inherited from Sql_cmd_dml
bool prepare (THD *thd) override
 Command-specific resolving (doesn't include LEX::prepare()) More...
enum enum_sql_cmd_type sql_cmd_type () const override
bool is_single_table_plan () const override
Query_resultquery_result () const
void set_query_result (Query_result *result)
 Set query result object for this query statement. More...
void set_lazy_result ()
 Signal that root result object needs preparing in next execution. More...
- Public Member Functions inherited from Sql_cmd
bool needs_explicit_preparation () const
bool is_regular () const
bool is_prepared () const
virtual void cleanup (THD *)
 Command-specific reinitialization before execution of prepared statement. More...
void set_owner (Prepared_statement *stmt)
 Set the owning prepared statement. More...
Prepared_statementowner () const
 Get the owning prepared statement. More...
void set_as_part_of_sp ()
 Mark statement as part of procedure. More...
bool is_part_of_sp () const
void disable_secondary_storage_engine ()
 Disable use of secondary storage engines in this statement. More...
bool secondary_storage_engine_disabled () const
 Has use of secondary storage engines been disabled for this statement? More...
void use_secondary_storage_engine (const handlerton *hton)
 Mark the current statement as using a secondary storage engine. More...
bool using_secondary_storage_engine () const
 Is this statement using a secondary storage engine? More...
const handlertonsecondary_engine () const
 Get the handlerton of the secondary engine that is used for executing this statement, or nullptr if a secondary engine is not used. More...
void set_optional_transform_prepared (bool value)
bool is_optional_transform_prepared ()

Private Member Functions

bool use_pfs ()

Private Attributes

const bool m_verbose {false}
bool m_use_pfs {false}

Additional Inherited Members

- Protected Member Functions inherited from Sql_cmd_select
bool may_use_cursor () const override
bool prepare_inner (THD *thd) override
 Prepare a SELECT statement. More...
- Protected Member Functions inherited from Sql_cmd_dml
 Sql_cmd_dml ()
bool is_empty_query () const
void set_empty_query ()
 Set statement as returning no data. More...
bool check_all_table_privileges (THD *thd)
 Read and check privileges for all tables in a DML statement. More...
virtual bool restore_cmd_properties (THD *thd)
 Restore command properties before execution. More...
virtual bool save_cmd_properties (THD *thd)
 Save command properties, such as prepared query details and table props. More...
const MYSQL_LEX_CSTRINGget_eligible_secondary_engine () const
 Helper function that checks if the command is eligible for secondary engine and if that's true returns the name of that eligible secondary storage engine. More...
- Protected Member Functions inherited from Sql_cmd
 Sql_cmd ()
virtual ~Sql_cmd ()
void set_prepared ()
 Set this statement as prepared. More...
- Protected Attributes inherited from Sql_cmd_show
enum_sql_command m_sql_command
- Protected Attributes inherited from Sql_cmd_dml
 Pointer to LEX for this statement. More...
 Pointer to object for handling of the result. More...
bool m_empty_query
 True if query will produce no rows. More...
bool m_lazy_result
 True: prepare query result on next execution. More...

Detailed Description

Represents SHOW PROCESSLIST statement.

Constructor & Destructor Documentation

◆ Sql_cmd_show_processlist() [1/2]

Sql_cmd_show_processlist::Sql_cmd_show_processlist ( )

◆ Sql_cmd_show_processlist() [2/2]

Sql_cmd_show_processlist::Sql_cmd_show_processlist ( bool  verbose)

Member Function Documentation

◆ check_privileges()

bool Sql_cmd_show_processlist::check_privileges ( THD thd)

Perform an authorization check for a prepared SELECT statement.

Reimplemented from Sql_cmd_show.

◆ execute_inner()

bool Sql_cmd_show_processlist::execute_inner ( THD thd)

The inner parts of query optimization and execution.

Execute a DML statement.

Single-table DML operations needs to reimplement this.

thdThread handler
false on success, true on error

This is the default implementation for a DML statement and uses a nested-loop join processor per outer-most query block. The implementation is split in two: One for query expressions containing a single query block and one for query expressions containing multiple query blocks combined with UNION.

Reimplemented from Sql_cmd_dml.

◆ set_use_pfs()

void Sql_cmd_show_processlist::set_use_pfs ( bool  use_pfs)

◆ use_pfs()

bool Sql_cmd_show_processlist::use_pfs ( )

◆ verbose()

bool Sql_cmd_show_processlist::verbose ( ) const

Member Data Documentation

◆ m_use_pfs

bool Sql_cmd_show_processlist::m_use_pfs {false}

◆ m_verbose

const bool Sql_cmd_show_processlist::m_verbose {false}

The documentation for this class was generated from the following files: