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-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/caching-sha2-pluggable-authentication.html
For example, the following statement creates such an account, where password is the desired account password: CREATE USER 'sha2user'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'password'; caching_sha2_password supports connections over ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
The server creates a copy of the file in the directory where it stores temporary files. If you use LOAD DATA on an empty MyISAM table, all nonunique indexes are created in a separate batch (as for REPAIR TABLE). In some extreme cases, you can create ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/5.7/en/option-files.html
Many option files are plain text files, created using any text editor. A “login path” is an option group that permits only certain options: host, user, password, port and socket. If an option file you want to use does not exist, create it using ... Most MySQL programs can read startup options from option files (sometimes called configuration ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
User-Created and Temporary Tables MEMORY table contents are stored in memory, which is a property that MEMORY tables share with internal temporary tables that the server creates on the fly while processing queries. The MEMORY storage engine ...
https://dev.mysql.com/doc/refman/5.7/en/example-user-variables.html
You can employ MySQL user variables to remember results without having to store them in temporary variables in the client.
https://dev.mysql.com/doc/refman/5.7/en/replication-features-user-names.html
The maximum length of MySQL user names was increased from 16 characters to 32 characters in MySQL 5.7.8. Replication of user names longer than 16 characters to a replica that supports only shorter user names fails. However, this should occur only ...
https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html
If a user is granted the basic privileges necessary to create a view (the CREATE VIEW and SELECT privileges), that user cannot call SHOW CREATE VIEW on that object unless the user is also granted the SHOW VIEW privilege. The workaround to the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
--ndb-default-column-format=[FIXED|DYNAMIC] Command-Line Format --ndb-default-column-format={FIXED|DYNAMIC} Introduced 5.7.11-ndb-7.5.1 System Variable ndb_default_column_format Scope Global Dynamic Yes Type Enumeration Default Value (≥ ... This ...
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 ...