PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
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/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-query-profiling.html
The setup_actors table can be used to limit the collection of historical events by host, user, or account to reduce runtime overhead and the amount of data collected in history tables. mysql> UPDATE performance_schema.setup_consumers SET ENABLED = ...The first step of the example shows how to limit collection of historical events to a specific ... The following example demonstrates how to use Performance Schema statement events and stage events to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-summary-tables.html
Event names refer to names of event instruments in the setup_instruments table: events_stages_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 ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-summary-tables.html
Event names refer to names of event instruments in the setup_instruments table: events_transactions_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) ...Each row summarizes events for a given user and event ... The Performance Schema maintains tables for collecting current and recent transaction ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-actors-table.html
This enables instrumenting and historical event logging to be applied selectively per host, user, or account (user and host combination). For each new foreground thread, the Performance Schema matches the user and host for the thread against the ...
https://dev.mysql.com/doc/refman/5.7/en/connecting-disconnecting.html
Once you know the proper parameters, you should be able to connect like this: $> mysql -h host -u user -p Enter password: ******** host and user represent the host name where your MySQL server is running and the user name of your MySQL account. To ...If the server runs on a machine other than the one where you log in, you also need to specify a host ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
The following example creates a simple rule to match statements that select a single literal value: INSERT INTO query_rewrite.rewrite_rules (pattern, replacement) VALUES('SELECT ?', 'SELECT ? + 1'); The resulting table contents look like this: ...
https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html
Create a mysql User and Group If your system does not already have a user and group to use for running mysqld, you may need to create them. $> groupadd mysql $> useradd -r -g mysql -s /bin/false mysql Note Because the user is required only for ...A ...These include generic binary distributions in the form of compressed tar files (files with a .tar.gz extension) for a number of platforms, and binaries in platform-specific package formats for selected ...