openxs@ao756:~/dbs/maria10.5$ bin/mysql --socket=/tmp/mariadb105.sock performance_schema
|
Reading table information for completion of table and column names
|
You can turn off this feature to get a quicker startup with -A
|
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 3
|
Server version: 10.5.7-MariaDB Source distribution
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [performance_schema]> select * from memory_summary_by_host_by_event_name where current_number_of_bytes_used <0\G
|
*************************** 1. row ***************************
|
HOST: NULL
|
EVENT_NAME: memory/sql/global_system_variables
|
COUNT_ALLOC: 0
|
COUNT_FREE: 2
|
SUM_NUMBER_OF_BYTES_ALLOC: 0
|
SUM_NUMBER_OF_BYTES_FREE: 128
|
LOW_COUNT_USED: -2
|
CURRENT_COUNT_USED: -2
|
HIGH_COUNT_USED: 0
|
LOW_NUMBER_OF_BYTES_USED: -128
|
CURRENT_NUMBER_OF_BYTES_USED: -128
|
HIGH_NUMBER_OF_BYTES_USED: 0
|
1 row in set (0,002 sec)
|
|
MariaDB [performance_schema]> select * from memory_summary_by_thread_by_event_name where current_number_of_bytes_used <0\G
|
*************************** 1. row ***************************
|
THREAD_ID: 1
|
EVENT_NAME: memory/sql/global_system_variables
|
COUNT_ALLOC: 0
|
COUNT_FREE: 2
|
SUM_NUMBER_OF_BYTES_ALLOC: 0
|
SUM_NUMBER_OF_BYTES_FREE: 128
|
LOW_COUNT_USED: -2
|
CURRENT_COUNT_USED: -2
|
HIGH_COUNT_USED: 0
|
LOW_NUMBER_OF_BYTES_USED: -128
|
CURRENT_NUMBER_OF_BYTES_USED: -128
|
HIGH_NUMBER_OF_BYTES_USED: 0
|
1 row in set (0,004 sec)
|
|
MariaDB [performance_schema]> select t.*, m.* from memory_summary_by_thread_by_event_name m join threads t on m.thread_id = t.thread_id where current_number_of_bytes_used <0\G
|
*************************** 1. row ***************************
|
THREAD_ID: 1
|
NAME: thread/sql/main
|
TYPE: BACKGROUND
|
PROCESSLIST_ID: NULL
|
PROCESSLIST_USER: NULL
|
PROCESSLIST_HOST: NULL
|
PROCESSLIST_DB: mysql
|
PROCESSLIST_COMMAND: NULL
|
PROCESSLIST_TIME: 105
|
PROCESSLIST_STATE: NULL
|
PROCESSLIST_INFO: NULL
|
PARENT_THREAD_ID: NULL
|
ROLE: NULL
|
INSTRUMENTED: YES
|
HISTORY: YES
|
CONNECTION_TYPE: Error
|
THREAD_OS_ID: 14292
|
THREAD_ID: 1
|
EVENT_NAME: memory/sql/global_system_variables
|
COUNT_ALLOC: 0
|
COUNT_FREE: 2
|
SUM_NUMBER_OF_BYTES_ALLOC: 0
|
SUM_NUMBER_OF_BYTES_FREE: 128
|
LOW_COUNT_USED: -2
|
CURRENT_COUNT_USED: -2
|
HIGH_COUNT_USED: 0
|
LOW_NUMBER_OF_BYTES_USED: -128
|
CURRENT_NUMBER_OF_BYTES_USED: -128
|
HIGH_NUMBER_OF_BYTES_USED: 0
|
1 row in set (0,003 sec)
|