Search Results
https://dev.mysql.com/doc/refman/8.4/en/precision-math-decimal-characteristics.html
This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format Storage requirements The nonstandard MySQL extension to the upper range ...D is the number of digits to the right of the decimal point (the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
COUNT_EXECUTE, SUM_TIMER_EXECUTE, MIN_TIMER_EXECUTE, AVG_TIMER_EXECUTE, MAX_TIMER_EXECUTE Aggregated statistics for executions of the prepared statement. MAX_CONTROLLED_MEMORY Reports the maximum amount of controlled memory used by a prepared ...C ... The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
With this plugin-loading method, the option must be given each time the server starts. For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'authentication_webauthn'; ... Note WebAuthn ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-tables.html
A query that fails to parse differs from a query that parses but fails due to an error during execution. Consequently, there is no parsing at runtime and the type of each statement is known by the time it executes. For additional information about ...Statement events occur at a high level of the event ...
https://dev.mysql.com/doc/refman/8.4/en/derived-table-optimization.html
When this happens, query execution is quicker by the time needed to perform materialization. This is true for a CTE that is referenced multiple times, so there is no duplication of materialized_from_subquery nodes (which would give the impression ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-replication-standard-rules.html
However, the replica notices the network outage only after receiving no data from the source server for replica_net_timeout seconds . Add replica_parallel_workers = n to your MySQL configuration file (my.cnf) to be sure parallel execution of ...Add ...By default, the server logs the length of the event as well as the event itself and uses this information to verify that the event was written ...
https://dev.mysql.com/doc/internals/en/mysql-services-for-plugins.html
The interface includes a versioning mechanism so that plugin versions can be checked at load time against service versions supported by the server. As of MySQL 5.5, plugins have access to server “services.” The services interface exposes server ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-understanding-consistency-guarantees.html
If data is synchronized at the time of a read, the current client session waits until a given point, which is the point in time that all preceding update transactions have been applied, before it can start executing. If data is synchronized at the ...With the first approach, the group takes the minimum time possible to secure a stable group membership after a primary failure by electing a new primary and then allowing data access immediately while it is still applying any possible backlog from the old ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: 2013-09-24T12:41:31.261992Z 25 [ERROR] Event Scheduler: [jon@ghidora][cookbook.e_store_ts] INSERT command ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-verify-transactions.html
If you emply a circular replication topology where multiple servers may have write clients, perform the second step for each source-replica connection, until you have completed the full circle. This section explains how to monitor a replication ...