PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-user-variable-tables.html
The Performance Schema provides a user_variables_by_thread table that exposes user-defined variables. These are variables defined within a specific session and include a @ character preceding the name; see Section 9.4, “User-Defined Variables”.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-summary-tables.html
Event names refer to names of event instruments in the setup_instruments table: memory_summary_by_account_by_event_name has USER, HOST, and EVENT_NAME columns. Each row summarizes events for a given account (user and host combination) and event name. In addition, each memory summary table that is aggregated by account, host, user, or thread is implicitly truncated by truncation of the connection table on which it depends, or truncation of ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-processlist-table.html
A value of system user refers to a nonclient thread spawned by the server to handle tasks internally, for example, a delayed-row handler thread or an I/O or SQL thread used on replica hosts. For system user, there is no host specified in the Host ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
On the replica side, the replica uses the trigger DEFINER attribute to determine which user is considered to be the creator of the trigger. The implication is that although a user must have the CREATE ROUTINE privilege to create a function, the user ...It is possible for a procedure to follow different execution paths on source and replica servers, so a user can write a routine containing a dangerous statement that executes only on the replica where it is processed by a thread that has full ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-file-io.html
The user_summary_by_file_io and x$user_summary_by_file_io views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are ...By ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were created. Therefore, a change in the SQL mode at any time after the creation of partitioned tables may lead to major changes in the behavior ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/5.7/en/expired-password-handling.html
For example: ALTER USER 'myuser'@'localhost' PASSWORD EXPIRE; For each connection that uses an account with an expired password, the server either disconnects the client or restricts the client to “sandbox mode,” in which the server permits the ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...Passwords ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-howto.html
If you are starting with new servers, see Section 16.1.2.2, “Creating a User for Replication” for information about adding a specific user for replication connections and Section 16.1.2.1, “Setting the Replication Source Configuration” for ...Stop each server using mysqladmin as shown here, where username is the user name for a MySQL user having sufficient privileges to shut down the server: $> mysqladmin -uusername -p shutdown Then supply this user's password at the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
Event names refer to names of event instruments in the setup_instruments table: events_statements_summary_by_account_by_event_name has EVENT_NAME, USER, and HOST columns. Each row summarizes events for a given account (user and host combination) and ...Each row summarizes events for a given user and event ... The Performance Schema maintains tables for collecting current and recent ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-wait-summary-tables.html
Event names refer to names of event instruments in the setup_instruments table: events_waits_summary_by_account_by_event_name has EVENT_NAME, USER, and HOST columns. Each row summarizes events for a given account (user and host combination) and ...