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/sql-transactional-statements.html
MySQL supports local transactions (within a given client session) through statements such as SET autocommit, START TRANSACTION, COMMIT, and ROLLBACK. XA transaction support enables MySQL to participate in distributed transactions as well.
https://dev.mysql.com/doc/refman/8.0/en/storage-engines-other.html
For more information on developing a customer storage engine that can be used with the Pluggable Storage Engine Architecture, see MySQL Internals: Writing a Custom Storage Engine. Other storage engines may be available from third parties and ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-variables.html
For information about the scope of local variables and how MySQL resolves ambiguous names, see Section 15.6.4.2, “Local Variable Scope and Resolution”. System variables and user-defined variables can be used in stored programs, just as they can ...
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links-to-databases.html
On Unix, symlink a database using this procedure: Create the database using CREATE DATABASE: mysql> CREATE DATABASE mydb1; Using CREATE DATABASE creates the database in the MySQL data directory and permits the server to update the data dictionary ...Stop the server to ensure that no activity occurs in the new database while it is being ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-is-consumer-enabled.html
(Prior to MySQL 8.0.18, the function returns NULL if the argument is not a valid consumer name.) This function accounts for the consumer hierarchy, so a consumer is not considered enabled unless all consumers on which depends are also enabled.
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-is-instrument-default-enabled.html
Example mysql> SELECT sys.ps_is_instrument_default_enabled('memory/innodb/row_log_buf'); +-------------------------------------------------------------------+ | sys.ps_is_instrument_default_enabled('memory/innodb/row_log_buf') | ... Returns YES or ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-is-thread-instrumented.html
Example mysql> SELECT sys.ps_is_thread_instrumented(43); +-----------------------------------+ | sys.ps_is_thread_instrumented(43) | +-----------------------------------+ | UNKNOWN | +-----------------------------------+ mysql> SELECT ... Returns ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-disable-instrument.html
Example Disable a specific instrument: mysql> CALL sys.ps_setup_disable_instrument('wait/lock/metadata/sql/mdl'); +-----------------------+ | summary | +-----------------------+ | Disabled 1 instrument | +-----------------------+ Disable all mutex ... Disables Performance Schema instruments with names that contain the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-disable-thread.html
Example Disable a specific connection by its connection ID: mysql> CALL sys.ps_setup_disable_thread(225); +-------------------+ | summary | +-------------------+ | Disabled 1 thread | +-------------------+ Disable the current connection: mysql> CALL ... Given a connection ID, disables Performance Schema instrumentation for the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-enable-instrument.html
Example Enable a specific instrument: mysql> CALL sys.ps_setup_enable_instrument('wait/lock/metadata/sql/mdl'); +----------------------+ | summary | +----------------------+ | Enabled 1 instrument | +----------------------+ Enable all mutex ...