4
The :program:`peformance_dictionary` plugin provides the
5
DATA_DICTIONARY.SESSION_USAGE table.
7
.. _performance_dictionary_loading:
12
To load this plugin, start :program:`drizzled` with::
14
--plugin-add=performance_dictionary
16
.. seealso:: :doc:`/options` for more information about adding and removing plugins.
18
.. _performance_dictionary_examples:
25
drizzle> SELECT * FROM DATA_DICTIONARY.SESSION_USAGE\G
26
*************************** 1. row ***************************
27
QUERY: select schema_name from information_schema.schemata
28
USER_TIME_USED_SECONDS: -1407374883553280
29
USER_TIME_USED_MICRO_SECONDS: -21238467
30
SYSTEM_TIME_USED_SECONDS: 0
31
SYSTEM_TIME_USED_MICRO_SECONDS: -233809327
32
INTEGRAL_MAX_RESIDENT_SET_SIZE: 51167232
33
INTEGRAL_SHARED_TEXT_MEMORY_SIZE: -4
34
INTEGRAL_UNSHARED_DATA_SIZE: -3096224743817216
35
INTEGRAL_UNSHARED_STACK_SIZE: -4316623440
37
PAGE_FAULTS: -1099511627776
39
BLOCK_INPUT_OPERATIONS: 0
40
BLOCK_OUTPUT_OPERATIONS: -3096224743817216
41
MESSAGES_SENT: -4316623425
43
SIGNALS_RECEIVED: -233832448
44
VOLUNTARY_CONTEXT_SWITCHES: -4316635555
45
INVOLUNTARY_CONTEXT_SWITCHES: 405
47
.. _performance_dictionary_authors:
54
.. _performance_dictionary_version:
59
This documentation applies to **performance_dictionary 1.0**.
61
To see which version of the plugin a Drizzle server is running, execute:
65
SELECT MODULE_VERSION FROM DATA_DICTIONARY.MODULES WHERE MODULE_NAME='performance_dictionary'