PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/no-login-pluggable-authentication.html
The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses it. Use cases for this plugin include: Accounts that must be able to execute stored programs and views with elevated privileges without ...
https://dev.mysql.com/doc/refman/5.7/en/non-typed-operators.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). 5.7.13 / Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-maintenance.html
If you have deleted a large number of rows from a partition or if you have made many changes to a partitioned table with variable-length rows (that is, having VARCHAR, BLOB, or TEXT columns), you can use ALTER TABLE ... Only the values for the ... A ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instance-tables.html
Each instance table has an EVENT_NAME or NAME column to indicate the instrument associated with each row. The mutex_instances.LOCKED_BY_THREAD_ID and rwlock_instances.WRITE_LOCKED_BY_THREAD_ID columns are extremely important for investigating ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-filtering.html
To control whether an instrument is enabled, set its ENABLED column to YES or NO. Setting the TIMED column affects Performance Schema table contents as described in Section 25.4.1, “Performance Schema Event Timing”. The setup_instruments table ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-metadata-locks-table.html
The metadata_locks table has these columns: OBJECT_TYPE The type of lock used in the metadata lock subsystem. MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency; see Section 8.11.4, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-consumers-table.html
For detailed information about the effect of enabling different consumers, see Section 25.4.7, “Pre-Filtering by Consumer”. If you disable a consumer, the server does not spend time adding event information to it.
https://dev.mysql.com/doc/refman/5.7/en/plugin-loading.html
Plugin activation states are visible in the LOAD_OPTION column of the Information Schema PLUGINS table. These can be identified from the LOAD_OPTION column of the Information Schema PLUGINS table. Server plugins must be loaded into the server ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math.html
For example, you can treat a value that is too large for a column as an error rather than having the value truncated to lie within the range of the column's data type. MySQL provides support for precision math: numeric value handling that results ...
https://dev.mysql.com/doc/refman/5.7/en/replica-io-thread-states.html
The following list shows the most common states you see in the State column for a replica server I/O thread. This state also appears in the Slave_IO_State column displayed by SHOW SLAVE STATUS, so you can get a good view of what is happening by ...