Search Results
https://dev.mysql.com/doc/refman/8.4/en/pam-pluggable-authentication.html
With this plugin-loading method, the option must be given each time the server starts. For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%pam%'; +--------------------+---------------+ | ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.backup.html
Hot backups for large databases with heavy writing workloads (say, in the order of gigabytes per minute) can take a very long time to complete due to the huge redo log files that are generated on the server while the backup is running. However, when ... Please refer to the MySQL Enterprise Backup 8.4 Release Notes for a list of fixed bugs for ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-set-trace.html
end_time: Date and time string denoting the end of the span. session_not_sharable_on_error: Statements such as SET known_variable = 1, unknown_variable = 2 can cause a session state change, although the statement failed. The server responds with an ... MySQL Router supports tracing of statements as they are processed by MySQL Router from client to server and the response to the ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-methods-standard.html
It also includes these options: Timeout: Maximum time to wait before the connection is aborted. This connection method enables MySQL Workbench to connect to MySQL Server using TCP/IP. In addition to naming your new connection in the field provided, ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance-xcom-cache-increase.html
In this situation, consider increasing the group_replication_message_cache_size limit with reference to the expected volume of messages in the time period specified by the group_replication_member_expel_timeout system variable plus the 5-second ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-general.html
Does MySQL have a NOW() function with fractions of seconds? Yes, see Section 13.2.6, “Fractional Seconds in Time Values”. Does MySQL have a NOW() function with fractions of seconds? A.1.7. On Windows, there is currently a limit to the number of ...Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? ...
https://dev.mysql.com/doc/internals/en/capability-negotiation.html
They can agree on: use of status flags use of SQL states for error-codes authentication methods SSL support Compression . To permit an old client to connect to newer servers, the initial handshake contains the MySQL Server version the server's ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-reset.html
Otherwise, the command fails, as shown here: mcm> reset DataMemory mycluster; ERROR 3 (00MGR): Illegal syntax You also cannot revert all configuration attributes for a given process type or instance of a process using a single filter specification; ... reset [--sequential-restart] filter_specification_list cluster_name filter_specification_list: filter_specification[,filter_specification][,...] filter_specification: attribute_name[:process_specification][+process_specification]] process_specification: [process_name][:process_id] process_name: {ndb_mgmd|ndbd|ndbmtd|mysqld|ndbapi} This command resets an attribute to its default ...
https://dev.mysql.com/doc/internals/en/com-field-list.html
Note As of MySQL 5.7.11, COM_FIELD_LIST is deprecated and will be removed in a future version of MySQL. COM_FIELD_LIST: get the column definitions of a table Payload 1 [04] COM_FIELD_LIST string[NUL] table string[EOF] field wildcard Returns ...
https://dev.mysql.com/doc/internals/en/com-process-info.html
Note As of MySQL 5.7.11, COM_PROCESS_INFO is deprecated and will be removed in a future version of MySQL. COM_PROCESS_INFO: get a list of active threads Returns a ProtocolText::Resultset or ERR_Packet Payload 1 [0a] COM_PROCCESS_INFO .