PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. This section discusses current restrictions and limitations on MySQL partitioning support. For a list of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-tables.html
Query results can be saved in tables for further analysis, or assigned to variables and thus used in stored procedures. The replication tables store errors on a per-thread basis without loss of information. This is similar to the information ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids.html
A general procedure for setting up and starting GTID-based replication (see Section 19.1.3.4, “Setting Up Replication Using GTIDs”). Stored functions that you can use to work with GTIDs (see Section 19.1.3.8, “Stored Function Examples to ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
There must be no tables or stored procedures with individual ENUM or SET column elements that exceed 255 characters or 1020 bytes in length. Any such triggers must be dumped and restored to fix the issue. REORGANIZE PARTITION: ALTER TABLE table_name ... Before upgrading to the latest MySQL 8.0 release, ensure the upgrade readiness of your current MySQL 5.7 or MySQL 8.0 server instance by performing the preliminary checks described ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
A key_part specification can end with ASC or DESC to specify whether index values are stored in ascending or descending order. Use of functional key parts enables indexing of values not stored directly in the table. Subqueries, parameters, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
caching: Use both InnoDB and the memcached engine as data stores. config_options Table The config_options table stores memcached-related settings that can be changed at runtime using SQL. For example, if you define col1, col2 as value columns, and ... InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html
The rows of an InnoDB table are stored in a clustered index organized based on the primary key, forming what some database systems call an “index-organized table”. Dropping a column default value ALTER TABLE tbl ALTER COLUMN col DROP DEFAULT, ...
https://dev.mysql.com/doc/refman/8.0/en/backup-strategy-example.html
Assume that data is stored in the InnoDB storage engine, which has support for transactions and automatic crash recovery. You should include such options as necessary to enable client programs to connect to the MySQL server. Assume also that the ...
https://dev.mysql.com/doc/refman/8.0/en/case.html
[ELSE statement_list] END CASE The CASE statement for stored programs implements a complex conditional construct. (The indentation used here in the ELSE clause is for purposes of clarity only, and is not otherwise significant.) DELIMITER | CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/conditions-and-parameters.html
If a stored procedure exits with an unhandled exception, modified values of OUT and INOUT parameters are not propagated back to the caller. If an exception is handled by a CONTINUE or EXIT handler that contains a RESIGNAL statement, execution of ...