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/mysql-cluster-what-is-new.html
In NDB 8.0.22 and later, setting ndb_metadata_sync to true clears the list of objects for which synchronization has failed previously, which means it is no longer necessary to discover individual tables or to re-trigger synchronization by ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html
This behavior on the server side comes into play for multiple-statement execution (see Multiple Statement Execution Support), and for parsing the body of stored procedures and functions, triggers, and events (see Section 27.1, “Defining Stored ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-server-side-help.html
mysql> help search_string If you provide an argument to the help command, mysql uses it as a search string to access server-side help from the contents of the MySQL Reference Manual. The proper operation of this command requires that the help ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-tips.html
This section surveys techniques that enable you to use mysqldump to solve specific problems: How to make a copy a database How to copy a database from one server to another How to dump stored programs (stored procedures and functions, triggers, and ...
https://dev.mysql.com/doc/refman/8.0/en/ndb-restore-different-number-nodes.html
$> mysqldump --no-data --routines --events --triggers --databases > myschema.sql Important Once you have created the NDB native backup using ndb_mgm, you must not make any schema changes before creating the backup of the schema, if you do so. It is ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
The table rebuild triggered by OPTIMIZE TABLE is completed in place. OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the table. The exact ...
https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html
ORDER BY RAND() LIMIT 15; Influencing ORDER BY Optimization For slow ORDER BY queries for which filesort is not used, try lowering the max_length_for_sort_data system variable to a value that is appropriate to trigger a filesort. This section ...
https://dev.mysql.com/doc/refman/8.0/en/outer-join-simplification.html
A conversion of one outer join operation may trigger a conversion of another. Table expressions in the FROM clause of a query are simplified in many cases. At the parser stage, queries with right outer join operations are converted to equivalent ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html
EXCHANGE PARTITION does not invoke any triggers on either the partitioned table or the table to be exchanged. Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
For example, an insert might activate a trigger that causes an update. An instrument name consists of a sequence of elements separated by '/' characters. Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler ...