Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-digests.html
The MySQL server is capable of maintaining statement digest information. Digesting occurs in the parser regardless of whether the Performance Schema is available, so that other features such as MySQL Enterprise Firewall and query rewrite plugins ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-functions.html
MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored functions. FORMAT_PICO_TIME(time_val) Given a numeric Performance Schema latency or ...The built-in functions can be invoked in any schema and require no qualifier, unlike the sys functions, which require either a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-objects-table.html
The effect of the default object configuration is to instrument all tables except those in the mysql, INFORMATION_SCHEMA, and performance_schema databases. The order in which matching occurs matters because different matching setup_objects rows can ... The setup_objects table controls whether the Performance Schema monitors particular ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
For example, to remove the limit on how many times per hour francis can connect, use this statement: mysql> ALTER USER 'francis'@'localhost' WITH MAX_CONNECTIONS_PER_HOUR 0; As mentioned previously, the simultaneous-connection limit for an account ... One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero ...This limits ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-data-structures.html
The MYSQL_TIME structure is used to transfer temporal data in both directions. For date and time data types, buffer should point to a MYSQL_TIME structure. MYSQL_TIME This structure is used to send and receive DATE, TIME, DATETIME, and TIMESTAMP ...
https://dev.mysql.com/doc/refman/8.4/en/events-overview.html
MySQL Events are tasks that run according to a schedule. When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-network-partitioning.html
For example, in the above scenario of 5 servers where 3 leave at once, if the 3 leaving servers warn the group that they are leaving, one by one, then the membership is able to adjust itself from 5 to 2, and at the same time, securing quorum while ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/connectors/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/agenthealth-advisor-ref.html
Figure 21.2 Agent Health - General Agent Latency Thresholds: enables you to define thresholds for time difference between the time the data was collected and the time MySQL Enterprise Service Manager received the collected data. The default values ...The default values are: Notice = 70 Warning = 85 Critical = 90 Communication The Communication section defines the thresholds for latency and HTTP errors between agent and MySQL Enterprise Service ...
https://dev.mysql.com/doc/connector-j/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...