Search Results
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption.html
The functions enable Enterprise applications to perform the following operations: Implement added data protection using public-key asymmetric cryptography Create public and private keys and digital signatures Perform asymmetric encryption and ...
https://dev.mysql.com/doc/refman/8.4/en/event-scheduler-thread-states.html
These states occur for the Event Scheduler thread, threads that are created to execute scheduled events, or threads that terminate the scheduler. Clearing The scheduler thread or a thread that was executing an event is terminating and is about to ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-storage-engines.html
The disabled_storage_engines configuration option defines which storage engines cannot be used to create tables or tablespaces. Where can I obtain complete documentation for MySQL storage engines? A.2.2. Can I prevent the use of a particular storage ...
https://dev.mysql.com/doc/refman/8.4/en/fetching-spatial-data.html
Fetching spatial data in internal format: Fetching geometry values using internal format can be useful in table-to-table transfers: CREATE TABLE geom2 (g GEOMETRY) SELECT g FROM geom; Fetching spatial data in WKT format: The ST_AsText() function ...
https://dev.mysql.com/doc/refman/8.4/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
Before doing so, ensure that you have a backup copy of your database in case you need to recreate it. After using this value, be prepared to drop and recreate all secondary indexes. With an innodb_force_recovery value of 3 or less you can DROP or ...
https://dev.mysql.com/doc/refman/8.4/en/function-optimization.html
A function is nondeterministic if, given fixed values for its arguments, it can return different results for different invocations. If a function is tagged nondeterministic, a reference to it in a WHERE clause is evaluated for every row (when ...
https://dev.mysql.com/doc/refman/8.4/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. The column is also indexed and the optimizer can take that index into account during execution plan ...
https://dev.mysql.com/doc/refman/8.4/en/geometry-well-formedness-validity.html
Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically well-formed. For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and ...
https://dev.mysql.com/doc/refman/8.4/en/gone-away.html
If you want to create a bug report regarding this problem, be sure that you include the following information: Indicate whether the MySQL server died. This section also covers the related Lost connection to server during query error. The most ...