Search Results
https://dev.mysql.com/doc/refman/8.4/en/stored-routines.html
In such a setup, applications and users would have no access to the database tables directly, but can only execute specific stored routines. Additional Resources You may find the Stored Procedures User Forum of use when working with stored ...A ...
https://dev.mysql.com/doc/refman/8.4/en/sys-execute-prepared-stmt.html
Configuration Options execute_prepared_stmt() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 30.4.2.1, “The sys_config Table”): debug, @sys.debug If this option is ... Given an SQL statement as a string, executes it as a prepared ...
https://dev.mysql.com/doc/refman/8.4/en/sys-memory-by-thread-by-current-bytes.html
By default, rows are sorted by descending amount of memory used. The memory_by_thread_by_current_bytes and x$memory_by_thread_by_current_bytes views have these columns: thread_id The thread ID. current_count_used The current number of allocated ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace-format.html
This span type has the following attributes: Name: Session mysql.processlist_id mysql.thread_id mysql.user mysql.host mysql.group This span also contains dynamic attributes generated with the format mysql.session_attr.xxx, where xxx is the session ...The following span types are emitted by the telemetry component: Control Span Session Span Statement Span Control Span Issued when the telemetry configuration changes, notifying downstream system of which signal collection has been enabled or ...
https://dev.mysql.com/doc/refman/8.4/en/thread-information.html
row *************************** Id: 5 User: event_scheduler Host: localhost db: NULL Command: Daemon Time: 2756681 State: Waiting on empty queue Info: NULL *************************** 2. row *************************** Id: 20 User: me Host: ... To ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-checking-installation.html
X Plugin is enabled by default in MySQL 8, therefore installing or upgrading to MySQL 8 makes the plugin available. You can verify X Plugin is installed on an instance of MySQL server by using the SHOW plugins statement to view the plugins list. | ...
https://dev.mysql.com/doc/refman/8.4/en/xa-statements.html
This privilege requirement prevents users from discovering the XID values for outstanding prepared XA transactions other than their own. It does not affect normal commit or rollback of an XA transaction because the user who started it knows its XID.
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-redo-log-archiving.html
The MySQL user mysqlbackup uses to connect to the server must be granted the INNODB_REDO_LOG_ARCHIVE privilege, for activating redo log archiving on the server. mysqlbackup may sometimes fail to keep pace with redo log generation on the backed up ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore.html
For example, if the server is going to be started by the user mysql, use the following command to change the owner attribute of the data directory and the files under it to the mysql user, and the group attribute to the mysql group. The mysqlbackup ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/services-for-plugins.html
This service provides setter and getter routines to access attributes of the server Security_context class, which includes attributes such as operating system user and host, authenticated user and host, and client IP address. MySQL server plugins ...