PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/test-pluggable-authentication.html
For example: $> mysql --user=testuser --password Enter password: testpassword The plugin fetches the password as received from the client and compares it with the value stored in the authentication_string column of the account row in the mysql.user ... MySQL includes a test plugin that checks account credentials and logs success or failure to the server error ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html
Notes The mysql user is created using the -r and -s /bin/false options of the useradd command, so that it does not have login permissions to your server host (see Creating the mysql User and Group for details). To switch to the mysql user on your ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-tables.html
There are also summary tables that provide status variable information aggregated by account, host name, and user name. The Performance Schema supports TRUNCATE TABLE for status variable tables as follows: global_status: Resets thread, account, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-summary-tables.html
Summary tables provide aggregated information for terminated events over time. The tables in this group summarize event data in different ways. Each summary table has grouping columns that determine how to group the data to be aggregated, and ...
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-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/replication-options-binary-log.html
If set to 0 (the default), users are not permitted to create or alter stored functions unless they have the SUPER privilege in addition to the CREATE ROUTINE or ALTER ROUTINE privilege. When enabled, the variable has the following effects: Binary ...