PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-actors-table.html
If a row from that table matches, its ENABLED and HISTORY column values are used to set the INSTRUMENTED and HISTORY columns, respectively, of the threads table row for the thread. If there is no match, the INSTRUMENTED and HISTORY columns for the ... The setup_actors table contains information that determines whether to enable monitoring and historical event logging for new foreground server threads (threads associated with client ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-objects-table.html
For existing rows, only the ENABLED and TIMED columns can be modified, by users with the UPDATE privilege on the table. The setup_objects table has these columns: OBJECT_TYPE The type of object to instrument. The setup_objects table controls ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-summary-tables.html
Each status variable summary table has one or more grouping columns to indicate how the table aggregates status values: status_by_account has USER, HOST, and VARIABLE_NAME columns to summarize status variables by account. status_by_host has HOST and ... Note The value of the show_compatibility_56 system variable affects the information available from the tables described ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-tables.html
For example: SELECT EVENT_NAME, COUNT_STAR FROM performance_schema.events_statements_summary_global_by_event_name WHERE EVENT_NAME LIKE 'statement/sql/%'; The global_status and session_status tables have these columns: VARIABLE_NAME The status ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-summary-tables.html
Each summary table has grouping columns that determine how to group the data to be aggregated, and summary columns that contain the aggregated values. Tables that summarize events in similar ways often have similar sets of summary columns and differ ... Summary tables provide aggregated information for terminated events over ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variable-tables.html
The global_variables and session_variables tables have these columns: VARIABLE_NAME The system variable name. For session_variables, this column contains the variable value in effect for the current session. The variables_by_thread table has these ... Note The value of the show_compatibility_56 system variable affects the information available from the tables described ...
https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
row *************************** Id: 3123 User: stefan Host: localhost db: apollon Command: Query Time: 0 State: NULL Info: SHOW FULL PROCESSLIST SHOW PROCESSLIST output has these columns: Id The connection identifier. This is the same value ... SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/account-locking.html
Account locking state is recorded in the account_locked column of the mysql.user system table. The account-locking capability depends on the presence of the account_locked column in the mysql.user system table. For upgrades from MySQL versions older ... MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
MySQL stores account names in grant tables in the mysql system database using separate columns for the user name and host name parts: The user table contains one row for each account. The User and Host columns store the user name and host name.
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
ANALYZE TABLE Output Key Distribution Analysis Other Considerations ANALYZE TABLE Output ANALYZE TABLE returns a result set with the columns shown in the following table. Column Value Table The table name Op Always analyze Msg_type status, error, ...