Search Results
https://dev.mysql.com/doc/refman/9.7/en/show-index.html
These two statements are equivalent: SHOW INDEX FROM mytable FROM mydb; SHOW INDEX FROM mydb.mytable; The optional EXTENDED keyword causes the output to include information about hidden indexes that MySQL uses internally and are not accessible by ...
https://dev.mysql.com/doc/refman/9.7/en/switchable-optimizations.html
The parent query does not set a user variable, since rewriting it may affect the order of execution, which could lead to unexpected results if the variable is accessed more than once in the same query. Its value is a set of flags, each of which has ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/mysqlbackup.full.html
After you have created a full backup, you might perform incremental backups (which are smaller and faster) for the next several backup tasks. This section outlines some of the things to consider when deciding on a strategy for creating full backups.
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-failover.html
In the case of a network partition, the failover can create a split-brain situation, where the different parts of the topology have divergent transaction sets. To carry out an emergency failover for the primary InnoDB Cluster, follow this procedure: ... An emergency failover makes a selected replica cluster into the primary InnoDB Cluster for the InnoDB ClusterSet ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-repair.html
An emergency failover carries the risk of losing transactions and creating a split-brain situation for the InnoDB ClusterSet. Follow this procedure to repair an InnoDB Cluster that is part of an InnoDB ClusterSet deployment: Using MySQL Shell, ...
https://dev.mysql.com/doc/mysql-errors/9.7/en/client-error-reference.html
Error number: 2072; Symbol: CR_INVALID_FACTOR_NO; Message: Invalid first argument for MYSQL_OPT_USER_PASSWORD option. Client error messages originate from within the MySQL client library. Here is an example client error message, as displayed by the ...
https://dev.mysql.com/doc/extending-mysql/9.7/en/writing-audit-plugins.html
The first time the server calls event_notify for a thread, it creates a binding of the plugin to the thread. */ MYSQL_AUDIT_CONNECTION_DISCONNECT = 1 << 1, /** occurs after COM_CHANGE_USER RPC is completed. */ MYSQL_AUDIT_CONNECTION_PRE_AUTHENTICATE ... This section describes how to write a server-side audit plugin, using the example plugin found in the plugin/audit_null directory of MySQL source ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-genai-privileges.html
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges.
https://dev.mysql.com/doc/relnotes/mysql-router/9.7/en/news-9-4-0.html
(Bug #38009073) Users created with a comment in their definition were unable to connect using MySQL Router. Note These release notes were created with the assistance of MySQL HeatWave GenAI. This change affects the auto-generated certificates ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-modeling.html
Model Table Defaults Default Storage Engine: Tables created in MySQL Workbench are defined using this default storage engine. Sets the initial state of newly created objects to expanded (or collapsed, if disabled). This section provides ...