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/sys-wait-classes-global-by-avg-latency.html
These views summarize wait class average latencies, grouped by event class. An event class is determined by stripping from the event name everything after the first three components. The wait_classes_global_by_avg_latency and ...
https://dev.mysql.com/doc/refman/8.0/en/sys-wait-classes-global-by-latency.html
These views summarize wait class total latencies, grouped by event class. An event class is determined by stripping from the event name everything after the first three components. The wait_classes_global_by_latency and ...
https://dev.mysql.com/doc/refman/8.0/en/tutorial.html
This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database. mysql may also be used in batch mode: you place your queries in a file beforehand, then tell mysql to execute ...mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the ...
https://dev.mysql.com/doc/refman/8.0/en/uninstall-plugin.html
plugin_name must be the name of some plugin that is listed in the mysql.plugin table. It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. The server executes the ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
You should be aware that while this makes the output easier to read, it also renders the JSON invalid, causing JSON functions to raise an error. If the value of explain_format is JSON, EXPLAIN ANALYZE returns an error unless FORMAT=TREE is specified ...In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a ... {EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | ...
https://dev.mysql.com/doc/refman/8.0/en/gis-wkt-functions.html
If the options argument is invalid, an error occurs to indicate why. For geographic SRS geometry arguments, if any argument has a longitude or latitude that is out of range, an error occurs: If a longitude value is not in the range (−180, 180], an ... These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transaction-inconsistencies.html
If the error is in a mixed transaction, that transaction is half-applied. When using a multithreaded replica, workers which have not received an error complete their queues, so it may take time to stop all threads. This ensures it never leaves gaps ... Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-recover.html
Details of the error and the last applied transaction are recorded in the Performance Schema replication_applier_status_by_worker table. Follow this procedure to recover from the error: Identify the replicated event that caused the error and verify ... If a privilege check against the PRIVILEGE_CHECKS_USER account fails, the transaction is not executed and replication stops for the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-network-partitioning.html
A member with extra transactions cannot rejoin the group, and the attempt results in an error with the message This member has more executed transactions than those present in the group. A member with extra transactions cannot rejoin the group, and ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication.html
However, it is important to understand that if one of the group members becomes unavailable, the clients connected to that group member must be redirected, or failed over, to a different server in the group, using a connector, load balancer, router, ...Alternatively, groups can be deployed in multi-primary mode, where all servers can accept updates, even if they are issued ...