Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-file-removal.html
.isl files: InnoDB Symbolic Link files containing the location of file-per-table tablespace files created outside of the data directory. In previous MySQL releases, dictionary data was partially stored in metadata files. Issues with file-based ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-information-schema.html
In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA table. When the underlying data dictionary tables store values ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-limitations.html
Manual creation of database directories under the data directory (for example, with mkdir) is unsupported. Manually created database directories are not recognized by the MySQL Server. This section describes temporary limitations introduced with ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-type-syntax.html
For example: CREATE TABLE t1 (t TIME(3), dt DATETIME(6), ts TIMESTAMP(0)); The fsp value, if given, must be in the range 0 to 6. The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For the ...
https://dev.mysql.com/doc/refman/8.4/en/deallocate-prepare.html
If too many prepared statements are created and not deallocated by either the DEALLOCATE PREPARE statement or the end of the session, you might encounter the upper limit enforced by the max_prepared_stmt_count system variable. {DEALLOCATE | DROP} ...
https://dev.mysql.com/doc/refman/8.4/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/doc/refman/8.4/en/drop-table.html
A TEMPORARY table is visible only with the session that created it, so no check is necessary. Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the ...
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 ...