Rechercher dans le manuel MySQL
26.12.13 Performance Schema System Variable Tables
[+/-]
The MySQL server maintains many system variables that indicate how it is configured (see Section 5.1.8, “Server System Variables”). System variable information is available in these Performance Schema tables:
global_variables
: Global system variables. An application that wants only global values should use this table.session_variables
: System variables for the current session. An application that wants all system variable values for its own session should use this table. It includes the session variables for its session, as well as the values of global variables that have no session counterpart.variables_by_thread
: Session system variables for each active session. An application that wants to know the session variable values for specific sessions should use this table. It includes session variables only, identified by thread ID.persisted_variables
: Provides a SQL interface to themysqld-auto.cnf
file that stores persisted global system variable settings. See Section 26.12.13.1, “Performance Schema persisted_variables Table”.variables_info
: Shows, for each system variable, the source from which it was most recently set, and its range of values. See Section 26.12.13.2, “Performance Schema variables_info Table”.
The session variable tables
(session_variables
,
variables_by_thread
) contain
information only for active sessions, not terminated sessions.
TRUNCATE TABLE
is not supported
for Performance Schema system variable tables.
The global_variables
and
session_variables
tables have these
columns:
VARIABLE_NAME
The system variable name.
VARIABLE_VALUE
The system variable value. For
global_variables
, this column contains the global value. Forsession_variables
, this column contains the variable value in effect for the current session.
The global_variables
and
session_variables
tables have these
indexes:
Primary key on (
VARIABLE_NAME
)
The variables_by_thread
table has
these columns:
THREAD_ID
The thread identifier of the session in which the system variable is defined.
VARIABLE_NAME
The system variable name.
VARIABLE_VALUE
The session variable value for the session named by the
THREAD_ID
column.
The variables_by_thread
table has
these indexes:
Primary key on (
THREAD_ID
,VARIABLE_NAME
)
The variables_by_thread
table
contains system variable information only about foreground
threads. If not all threads are instrumented by the Performance
Schema, this table will miss some rows. In this case, the
Performance_schema_thread_instances_lost
status variable will be greater than zero.
Traduction non disponible
Le manuel MySQL n'est pas encore traduit en français sur l'infobrol. Seule la version anglaise est disponible pour l'instant.
Document créé le 26/06/2006, dernière modification le 26/10/2018
Source du document imprimé : https://www.gaudry.be/mysql-rf-performance-schema-system-variable-tables.html
L'infobrol est un site personnel dont le contenu n'engage que moi. Le texte est mis à disposition sous licence CreativeCommons(BY-NC-SA). Plus d'info sur les conditions d'utilisation et sur l'auteur.
Références
Ces références et liens indiquent des documents consultés lors de la rédaction de cette page, ou qui peuvent apporter un complément d'information, mais les auteurs de ces sources ne peuvent être tenus responsables du contenu de cette page.
L'auteur de ce site est seul responsable de la manière dont sont présentés ici les différents concepts, et des libertés qui sont prises avec les ouvrages de référence. N'oubliez pas que vous devez croiser les informations de sources multiples afin de diminuer les risques d'erreurs.