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/show-slave-status.html
Both versions of the statement update the same status variables when used. SHOW {SLAVE | REPLICA} STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica threads. From MySQL 8.0.22, SHOW SLAVE ...
https://dev.mysql.com/doc/refman/8.0/en/start-slave.html
Both versions of the statement update the same status variables when used. START {SLAVE | REPLICA} [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | ...
https://dev.mysql.com/doc/refman/8.0/en/stop-slave.html
Both versions of the statement update the same status variables when used. STOP {SLAVE | REPLICA} [thread_types] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL ...
https://dev.mysql.com/doc/refman/8.0/en/stored-objects.html
A trigger is activated when a particular event occurs for the table, such as an insert or update. This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later execution. Stored objects ...
https://dev.mysql.com/doc/refman/8.0/en/subqueries.html
A subquery's outer statement can be any one of: SELECT, INSERT, UPDATE, DELETE, SET, or DO. All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-materialization.html
The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it ...
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-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.0/en/table-scan-avoidance.html
For large tables, try the following techniques to avoid having the optimizer incorrectly choose a table scan: Use ANALYZE TABLE tbl_name to update the key distributions for the scanned table. The output from EXPLAIN shows ALL in the type column ...
https://dev.mysql.com/doc/refman/8.0/en/uln-installation.html
Linux supports a number of different solutions for installing MySQL, covered in Section 2.5, “Installing MySQL on Linux”. One of the methods, covered in this section, is installing from Oracle's Unbreakable Linux Network (ULN). You can find ...