Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-miscellaneous-tables.html
user_defined_functions: Loadable functions registered by a component, plugin, or CREATE FUNCTION statement. The following sections describe tables that do not fall into the table categories discussed in the preceding sections: ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-global-filters-table.html
CONFIGURED_BY The method used to configure the replication filter, can be one of: CHANGE_REPLICATION_FILTER configured by a global replication filter using a CHANGE REPLICATION FILTER statement. This table shows the global replication filters ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-tables.html
This is similar to the information available from the SHOW REPLICA STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW REPLICA STATUS output is useful for visual inspection, but not so much for ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-meters-table.html
This column can be modified DESCRIPTION: A string describing the meter.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-tables.html
For example, you can use a single statement with standard SQL syntax to make multiple simultaneous configuration changes. The setup tables provide information about the current instrumentation and enable the monitoring configuration to be changed.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-thread-pool-tables.html
But it does not hold mutexes on all thread groups at the same time, to prevent a statement against tp_thread_state from blocking the entire MySQL server. The following sections describe the Performance Schema tables associated with the thread pool ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-tables.html
Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction events. The Performance Schema instruments waits, which are events that take time. These tables store wait events: ...
https://dev.mysql.com/doc/refman/8.4/en/populating-spatial-columns.html
After you have created spatial columns, you can populate them with spatial data. Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. For ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-examples.html
Consider these statements: mysql> CREATE TABLE t (i INT, d DECIMAL, f FLOAT); mysql> INSERT INTO t VALUES(1,1,1); mysql> CREATE TABLE y SELECT AVG(i), AVG(d), AVG(f) FROM t; The result is a double only for the floating-point argument. This section ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-expressions.html
Suppose that we have this statement: INSERT INTO t SET i = 1/0; This is what happens for combinations of strict and ERROR_FOR_DIVISION_BY_ZERO modes. With precision math, exact-value numbers are used as given whenever possible. For example, numbers ...