PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler-thread-states.html
Waiting for scheduler to stop The thread issued SET GLOBAL event_scheduler=OFF and is waiting for the scheduler to stop. These states occur for the Event Scheduler thread, threads that are created to execute scheduled events, or threads that ...
https://dev.mysql.com/doc/refman/5.7/en/fetch.html
To detect this condition, you can set up a handler for it (or for a NOT FOUND condition). This statement fetches the next row for the SELECT statement associated with the specified cursor (which must be open), and advances the cursor pointer. If a ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog-server-id.html
You can use mysqlbinlog to request log files from a server in several ways: Specify an explicitly named set of files: For each file, mysqlbinlog connects and issues a Binlog dump command. Specify the beginning file and --to-last-log: mysqlbinlog ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-table.html
The maximum number of retries for a given transaction is set by the slave_transaction_retries system variable. The table provides information about general aspects of transaction applier status that are not specific to any thread involved. This ...
https://dev.mysql.com/doc/refman/5.7/en/workbench.html
MySQL Workbench provides a graphical tool for working with MySQL servers and databases. Data Modeling: Enables you to create models of your database schema graphically, reverse and forward engineer between a schema and a live database, and edit all ...For more information, see the MySQL Workbench manual, available at ...MySQL Workbench may connect to MySQL Server 8.4 and higher but some ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-installation.html
The CREATE FUNCTION and DROP FUNCTION statements require the INSERT and DROP privilege, respectively, for the mysql database. The function library base name is openssl_udf and the suffix is platform dependent. For example, the file name on Linux or ... MySQL Enterprise Encryption functions are located in a loadable function library file installed in the plugin directory (the directory named by the plugin_dir system ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-use-cases.html
Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Depending on the number of servers which fail the group might have degraded performance or scalability, but it is ...
https://dev.mysql.com/doc/refman/5.7/en/any-in-some-subqueries.html
When used with a subquery, the word IN is an alias for = ANY. NOT IN is not an alias for <> ANY, but for <> ALL. The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The expression is FALSE if ...
https://dev.mysql.com/doc/refman/5.7/en/case.html
[ELSE statement_list] END CASE The CASE statement for stored programs implements a complex conditional construct. This syntax cannot be used to test for equality with NULL because NULL = NULL is false. For the second syntax, each WHEN clause ...
https://dev.mysql.com/doc/refman/5.7/en/comparisons-using-subqueries.html
The most common use of a subquery is in the form: non_subquery_operand comparison_operator (subquery) Where comparison_operator is one of these operators: = > < >= <= <> != <=> For example: ... WHERE 'a' = (SELECT column1 FROM t1) MySQL also ...