| 1 |
SELECT NAME, DOCUMENTATION FROM performance_schema.setup_instruments |
| 2 |
WHERE NAME LIKE 'memory/sql/%' |
| 3 |
AND DOCUMENTATION IS NOT NULL |
| 4 |
ORDER BY NAME; |
| 5 |
NAME DOCUMENTATION |
| 6 |
memory/sql/dd::column_statistics Column statistics histograms allocated. |
| 7 |
memory/sql/dd::default_values Temporary buffer for preparing column default values. |
| 8 |
memory/sql/dd::import File name handling while importing MyISAM tables. |
| 9 |
memory/sql/dd::infrastructure Infrastructure of the data dictionary structures. |
| 10 |
memory/sql/dd::objects Memory occupied by the data dictionary objects. |
| 11 |
memory/sql/dd::String_type Character strings used by data dictionary objects. |
| 12 |
memory/sql/display_table_locks Debug utility. |
| 13 |
memory/sql/errmsgs::handler Handler error messages (HA_ERR_...). |
| 14 |
memory/sql/errmsgs::server In-memory representation of server error messages. |
| 15 |
memory/sql/Event_basic::mem_root Event base class with root used for definiton etc. |
| 16 |
memory/sql/Event_queue_element_for_exec::names Copy of schema- and event name in exec queue element. |
| 17 |
memory/sql/Event_scheduler::scheduler_param Infrastructure of the priority queue of events. |
| 18 |
memory/sql/handlerton::objects Handlerton objects. |
| 19 |
memory/sql/help Temporary memroot used to print help texts as part of usage description. |
| 20 |
memory/sql/host_cache::hostname Hostname keys in the host_cache map. |
| 21 |
memory/sql/Locked_tables_list::m_locked_tables_root Memroot for list of locked tables. |
| 22 |
memory/sql/log_error::loaded_services Memory allocated for duplicate log events. |
| 23 |
memory/sql/log_error::stack Log events for the error log. |
| 24 |
memory/sql/LOG::file_name File name of slow log and general log. |
| 25 |
memory/sql/MDL_context::acquire_locks Buffer for sorting lock requests. |
| 26 |
memory/sql/MDL_context::backup_manager MDL for prepared XA trans with disconnected client. |
| 27 |
memory/sql/MYSQL_LOCK Table locks per session. |
| 28 |
memory/sql/NET::buff Buffer in the client protocol communications layer. |
| 29 |
memory/sql/NET::compress_packet Buffer used when compressing a packet. |
| 30 |
memory/sql/Partition::admin Buffer for printing messages into the client protocol. |
| 31 |
memory/sql/Partition::prune_exec Mem root used temporarily while pruning partitions. |
| 32 |
memory/sql/Partition::share Partition name and auto increment mutex. |
| 33 |
memory/sql/Partition::sort_buffer Record buffer for a partition. |
| 34 |
memory/sql/Partition::syntax_buffer Buffer used for formatting the partition expression. |
| 35 |
memory/sql/Persisted_variables::memroot Memory allocated to process persisted variables during server start-up and plugin/component initialization. |
| 36 |
memory/sql/Persisted_variables::unordered_map Memory allocated for in-memory maps for persisted variables |
| 37 |
memory/sql/Persisted_variables::unordered_set Memory allocated for in-memory sets for persisted variables |
| 38 |
memory/sql/Prepared_statement::infrastructure Map infrastructure for prepared statements per session. |
| 39 |
memory/sql/Prepared_statement::main_mem_root Mem root for each prepared statement for items etc. |
| 40 |
memory/sql/rm_db::mdl_reqs_root Mem root for allocating MDL requests while dropping datbase. |
| 41 |
memory/sql/rm_table::foreach_root Mem root for temporary objects allocated while dropping tables or the whole database. |
| 42 |
memory/sql/servers_cache Cache infrastructure and mem root for servers cache. |
| 43 |
memory/sql/Shared_memory_name Communication through shared memory (windows). |
| 44 |
memory/sql/sp_head::call_mem_root Mem root for objects with same life time as stored program call. |
| 45 |
memory/sql/sp_head::execute_mem_root Mem root per instruction. |
| 46 |
memory/sql/sp_head::main_mem_root Mem root for parsing and representation of stored programs. |
| 47 |
memory/sql/ST_SCHEMA_TABLE Structure describing an information schema table implemented by a plugin. |
| 48 |
memory/sql/TABLE Memory used by TABLE objects and their mem root. |
| 49 |
memory/sql/TABLE_SHARE::mem_root Cache infrastructure and individual table shares. |
| 50 |
memory/sql/TC_LOG_MMAP::pages In-memory transaction coordinator log. |
| 51 |
memory/sql/thd_timer Thread timer object. |
| 52 |
memory/sql/THD::db Name of currently used schema. |
| 53 |
memory/sql/THD::debug_sync_action Debug sync actions to perform per thread. |
| 54 |
memory/sql/THD::debug_sync_control Structure to control debug sync per thread. |
| 55 |
memory/sql/THD::handler_tables_hash Hash map of tables used by HANDLER statements. |
| 56 |
memory/sql/THD::main_mem_root Main mem root used for e.g. the query arena. |
| 57 |
memory/sql/THD::sp_cache Per session cache for stored programs. |
| 58 |
memory/sql/THD::transactions::mem_root Transaction context information per session. |
| 59 |
memory/sql/THD::variables Per session copy of global dynamic variables. |
| 60 |
memory/sql/tz_storage Shared time zone data. |
| 61 |
memory/sql/udf_mem Shared structure of UDFs. |
| 62 |
memory/sql/user_conn Objects describing user connections. |
| 63 |
memory/sql/User_level_lock Per session storage of user level locks. |
| 64 |
memory/sql/XA::recovered_transactions List infrastructure for recovered XA transactions. |
| 65 |
memory/sql/XA::transaction_contexts Shared cache of XA transaction contexts. |
| 66 |
SET @rows = (SELECT COUNT(NAME) FROM performance_schema.setup_instruments |
| 67 |
WHERE NAME LIKE 'memory/sql/%' |
| 68 |
AND DOCUMENTATION IS NOT NULL |
| 69 |
ORDER BY NAME); |
| 70 |
include/assert.inc [The number of documented P_S memory keys in the SQL category is as expected.] |