Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-thread.html
in_max_runtime DECIMAL(20,2): The maximum number of seconds (which can be fractional) to collect data. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. Use NULL to ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/using-sql.html
In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string. The following example uses a Session to call an SQL Stored Procedure on the specific node.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/using-sql.html
In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string. The following example uses a Session to call an SQL Stored Procedure on the specific node.
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the source. If a GTID was assigned for the transaction, the GTID is persisted atomically at commit time by writing it to the binary log at the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
A maximum of two tablespaces is allocated to a session, one for user-created temporary tables and the other for internal temporary tables created by the optimizer. Because the pool of session temporary tablespaces is recreated each time the server ... InnoDB uses session temporary tablespaces and a global temporary ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-introduction-server.html
Others use timed durations, such as the average statement execution time. Analyzing the SQL queries performed on the monitored instance, in real-time, using the Query Analyzer. Some use percentages, such as percentage of maximum number of ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-statistics-estimation.html
Values much larger than 8 (say, 100), can cause a significant slowdown in the time it takes to open a table or execute SHOW TABLE STATUS. Because the statistics are automatically recalculated at various times other than on execution of ANALYZE ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-attr-set.html
This function may be called multiple times to set several options. STMT_ATTR_CURSOR_TYPE unsigned long * Type of cursor to open for statement when mysql_stmt_execute() is invoked. STMT_ATTR_PREFETCH_ROWS unsigned long * Number of rows to fetch from ... bool mysql_stmt_attr_set(MYSQL_STMT *stmt, enum enum_stmt_attr_type option, const void *arg) Description Can be used to affect behavior for a prepared ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-_query.html
Table 4.37 deletePersistentAll() Parameter Description return the number of instances deleted 4.3.1.19.9 execute(Map<String, ?>) public abstract Results<E> execute(Map<String, ?> parameters); Execute the query with one or more named parameters. A ...
https://dev.mysql.com/doc/refman/8.4/en/kerberos-pluggable-authentication.html
On Windows, the authentication_kerberos_client authentication plugin supports two modes, which the client user can set at runtime or specify in an option file: SSPI mode: Security Support Provider Interface (SSPI) implements GSSAPI (see Commands for ... Note Kerberos pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...