PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket file. The plugin uses the SO_PEERCRED socket option to obtain information about the user running the client program.
https://dev.mysql.com/doc/refman/8.0/en/sorted-index-builds.html
InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. This method of index creation is also known as a sorted index build. In the first phase, the clustered index is scanned, and index ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geohash-functions.html
Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. Geohash values are strings that contain only characters chosen from "0123456789bcdefghjkmnpqrstuvwxyz". The functions in this section ...
https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/8.0/en/stop-replica.html
] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication threads. From MySQL 8.0.22, use STOP REPLICA in place of STOP SLAVE, which is now deprecated. STOP REPLICA requires the REPLICATION_SLAVE_ADMIN privilege ...
https://dev.mysql.com/doc/refman/8.0/en/structured-system-variables.html
A structured variable differs from a regular system variable in two respects: Its value is a structure with components that specify server parameters considered to be closely related. There might be several instances of a given type of structured ...
https://dev.mysql.com/doc/refman/8.0/en/sys-format-time.html
Note As of MySQL 8.0.16, format_time() is deprecated and subject to removal in a future MySQL version. Applications that use it should be migrated to use the built-in FORMAT_PICO_TIME() function instead. See Section 14.21, “Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/sys-innodb-lock-waits.html
These views summarize the InnoDB locks that transactions are waiting for. The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at which the lock wait started. wait_age How long the lock has been waited for, ...
https://dev.mysql.com/doc/refman/8.0/en/sys-processlist.html
The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-lock-waits.html
These views display which sessions are blocked waiting on metadata locks, and what is blocking them. For additional information, see the description of the Performance Schema metadata_locks table at Section 29.12.13.3, “The metadata_locks ...