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