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/static-format.html
Note Fixed-length row format is available only for tables having no BLOB or TEXT columns. It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Of the three MyISAM storage formats, static format is the ...
https://dev.mysql.com/doc/refman/8.0/en/stop-replica.html
Note that the Group Replication applier channel (group_replication_applier) has no replication I/O (receiver) thread, only a replication SQL (applier) thread. ] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html
Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored functions. There are also some restrictions specific to stored functions but not to stored procedures. The restrictions for stored ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
Unless noted otherwise, the remarks here assume that binary logging is enabled on the server (see Section 7.4.4, “The Binary Log”.) If the binary log is not enabled, replication is not possible, nor is the binary log available for data recovery.
https://dev.mysql.com/doc/refman/8.0/en/string-functions-charset.html
Note The REPLACE() function, unlike all other functions, always ignores the collation of the string input and performs a case-sensitive comparison. MySQL has many operators and functions that return a string. This section answers the question: What ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...
https://dev.mysql.com/doc/refman/8.0/en/sys-format-bytes.html
Note As of MySQL 8.0.16, format_bytes() is deprecated and subject to removal in a future MySQL version. Applications that use it should be migrated to use the built-in FORMAT_BYTES() function instead. See Section 14.21, “Performance Schema ...
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-ps-thread-id.html
Note As of MySQL 8.0.16, ps_thread_id() is deprecated and subject to removal in a future MySQL version. Applications that use it should be migrated to use the built-in PS_THREAD_ID() and PS_CURRENT_THREAD_ID() functions instead. See Section 14.21, ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-object-overview.html
Note For MySQL instances with a large number of objects, this view might take a long time to execute. This view summarizes the types of objects within each schema. object_type The object type: BASE TABLE, INDEX (index_type), EVENT, FUNCTION, ...