PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.3Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-log-table.html
The LOGGED column stores values using the TIMESTAMP data type, for which values are stored in UTC but displayed when retrieved in the current session time zone; see Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”. This enables a server ... Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table size. OBJECT_SCHEMA, OBJECT_NAME, OBJECT_TYPE For nested statements ...Of ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication.html
Pluggable authentication makes it possible for clients to connect to the MySQL server with credentials appropriate for authentication methods that store credentials elsewhere than in the mysql.user system table. Use cases for this plugin include ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption.html
From MySQL 8.0.14, binary log files and relay log files can be encrypted, helping to protect these files and the potentially sensitive data contained in them from being misused by outside attackers, and also from unauthorized viewing by users of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-replica-halt.html
The information required for recovery is stored in the replica's applier metadata repository. Set relay_log_info_repository = TABLE, which stores the replication SQL thread position in the InnoDB table mysql.slave_relay_log_info, and updates it ...
https://dev.mysql.com/doc/refman/8.0/en/security-against-attack.html
Encryption helps to protect these files and the potentially sensitive data contained in them from being misused by outside attackers, and also from unauthorized viewing by users of the operating system where they are stored. Stored programs and ...
https://dev.mysql.com/doc/refman/8.0/en/security-guidelines.html
Instead, use SHA2() or some other one-way hashing function and store the hash value. That does not mean the combination needs to be a random string of characters that is difficult to remember and reproduce, although this is a good approach if you ...
https://dev.mysql.com/doc/refman/8.0/en/select.html
Within stored programs, LIMIT parameters can be specified using integer-valued routine parameters or local variables. INTO form of SELECT enables the query result to be written to a file or stored in variables. For SQL_SMALL_RESULT, MySQL uses ...
https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html
The CMake program provides a great deal of control over how you configure a MySQL source distribution. Typically, you do this using options on the CMake command line. For information about options supported by CMake, run either of these commands in ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-reference-systems.html
MySQL maintains information about available spatial reference systems for spatial data in the data dictionary mysql.st_spatial_reference_systems table, which can store entries for projected and geographic SRSs. Parsed definitions are stored in the ... A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic ...