Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-execute-prepared-stmt.html
If that statement name exists when the procedure is called, its previous content is destroyed. Given an SQL statement as a string, executes it as a prepared statement. The prepared statement is deallocated after execution, so it is not subject to ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-save.html
ps_setup_save() takes a timeout parameter to indicate how many seconds to wait if the lock already exists (which indicates that some other session has a saved configuration outstanding). This enables you to alter the configuration temporarily for ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/8.4/en/table-locking.html
InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent results. For this storage engine, avoid using the LOCK ...
https://dev.mysql.com/doc/refman/8.4/en/table-size-limit.html
If the pointer size is too small for an existing table, you can change the options with ALTER TABLE to increase a table's maximum permissible size. The effective maximum table size for MySQL databases is usually determined by operating system ...
https://dev.mysql.com/doc/refman/8.4/en/table.html
Given the existence of a table named t, the following two statements produce identical output: TABLE t; SELECT * FROM t; You can order and limit the number of rows produced by TABLE using ORDER BY and LIMIT clauses, respectively. TABLE is a DML ...
https://dev.mysql.com/doc/refman/8.4/en/temporary-table-problems.html
If a TEMPORARY is created with the same name as an existing non-TEMPORARY table, the non-TEMPORARY table is hidden until the TEMPORARY table is dropped, even if the tables use different storage engines. Temporary tables created with CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/testing-server.html
Use mysqlshow to see what databases exist: $> bin/mysqlshow +--------------------+ | Databases | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ The list of installed databases may vary, ... After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works ...
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html
Otherwise, use of a named time zone results in an error: mysql> SET time_zone = 'UTC'; ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC' Populating the Time Zone Tables Several tables in the mysql system schema exist to store time zone ...
https://dev.mysql.com/doc/refman/8.4/en/trace-general-structure.html
Query transformations (IN to EXISTS, outer join to inner join, and so on), simplifications (elimination of clauses), and equality propagation are shown in subobjects. A trace follows the actual execution path very closely; for each join, there is a ...