Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary.html
These views summarize statement activity, file I/O, and connections, grouped by user. statement_latency The total wait time of timed statements for the user. statement_avg_latency The average wait time per timed statement for the user. The ...
https://dev.mysql.com/doc/refman/8.4/en/using-mysqldump.html
mysqldump produces two types of output, depending on whether the --tab option is given: Without --tab, mysqldump writes SQL statements to the standard output. This output consists of CREATE statements to create dumped objects (databases, tables, ...
https://dev.mysql.com/doc/refman/8.4/en/using-system-variables.html
Most of them can be changed dynamically while the server is running by means of the SET statement, which enables you to modify operation of the server without having to stop and restart it. To restrict the maximum value to which a system variable ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-elements.html
Version Tokens is based on a plugin library that implements these elements: A server-side plugin named version_tokens holds the list of version tokens associated with the server and subscribes to notifications for statement execution events. The ...
https://dev.mysql.com/doc/refman/8.4/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 15.1.23, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.11, “ALTER VIEW Statement”), or DROP VIEW (see Section 15.1.35, ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-enterprise-firewall.html
MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall that enables database server administrators to permit or deny SQL statement execution based on matching against allowlists of accepted statement patterns.
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-missing.html
REORGANIZE PARTITION statement in the mysql client for each NDB table in the cluster. It is possible using MySQL Cluster Manager to perform a partial restore of a MySQL NDB Cluster—that is, to restore from a backup in which backup images from one ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-auto-reconnect.html
The MySQL client library can perform an automatic reconnection to the server if it finds that the connection is down when you attempt to send a statement to the server to be executed. If auto-reconnect is enabled, the library tries once to ...The ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-more-results.html
bool mysql_more_results(MYSQL *mysql) Description This function is used when you execute multiple statements specified as a single statement string, or when you execute CALL statements, which can return multiple result sets. mysql_more_results() ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string-quote.html
unsigned long mysql_real_escape_string_quote(MYSQL *mysql, char *to, const char *from, unsigned long length, char quote) Description This function creates a legal SQL string for use in an SQL statement. The mysql argument must be a valid, open ...