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/event-scheduler-thread-states.html
Clearing The scheduler thread or a thread that was executing an event is terminating and is about to end. Waiting for scheduler to stop The thread issued SET GLOBAL event_scheduler=OFF and is waiting for the scheduler to stop. Waiting on empty queue ... These states occur for the Event Scheduler thread, threads that are created to execute scheduled events, or threads that terminate the ...
https://dev.mysql.com/doc/refman/8.0/en/example-maximum-column-group-row.html
Task: For each article, find the dealer or dealers with the most expensive price. Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause, a LEFT JOIN, or a common table expression with a window function.
https://dev.mysql.com/doc/refman/8.0/en/execution-plan-information.html
Depending on the details of your tables, columns, indexes, and the conditions in your WHERE clause, the MySQL optimizer considers many techniques to efficiently perform the lookups involved in an SQL query. Your goals are to recognize the aspects ...A query on a huge table can be performed without reading all the rows; a join involving several tables can be performed without comparing every combination of ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-connectors-apis.html
For common questions, issues, and answers relating to the MySQL Connectors and other APIs, see the following areas of the Manual: Using C API Features Connector/ODBC Notes and Tips Connector/NET Programming MySQL Connector/J Developer Guide .
https://dev.mysql.com/doc/refman/8.0/en/federated-create.html
You can either create the local table and specify the connection string (containing the server name, login, password) to be used to connect to the remote table using the CONNECTION, or you can use an existing connection that you have previously ...
https://dev.mysql.com/doc/refman/8.0/en/general-security-issues.html
This section describes general security issues to be aware of and what you can do to make your MySQL installation more secure against attack or misuse. For information specifically about the access control system that MySQL uses for setting up user ...For answers to some questions that are often asked about MySQL Server security issues, see Section A.9, “MySQL 8.0 FAQ: ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-replication-technologies.html
Before getting into the details of MySQL Group Replication, this section introduces some background concepts and an overview of how things work. This provides some context to help understand what is required for Group Replication and what the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-throttling.html
Based on the metrics gathered across all servers in the group, a throttling mechanism kicks in and decides whether to limit the rate a member is able to execute/commit new transactions. The lowest capacity of all the members in the group determines ...Therefore, metrics acquired from all members are the basis for calculating the capacity of each member: if a member has a large queue (for certification or the applier thread), then the capacity to execute new transactions should be close to ones certified or applied in the last ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-connection-control-failed-login-attempts-table.html
The number of attempts for which the server added a delay to its response is the difference between the FAILED_ATTEMPTS value and the connection_control_failed_connections_threshold system variable value. Notes The ... This table provides ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-fields-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. POS The ordinal position of the key field within the index, starting from 0 and incrementing sequentially. Use the ... The ...