Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-replication-dashboard-ui-ref.html
To display a replication group, choose a group from the Replication Topology drop-down list. Important Clicking the refresh icon, adjacent to the Replication Topology drop-down list, forces a re-discovery of all replication groups. Clicking the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/ui-security-advisor-ref.html
Global privileges such as DROP, ALTER, DELETE, UPDATE, INSERT, and LOCK TABLES may be dangerous as they may cause other users to be affected adversely. This advisor enables you to define a regular expression describing the users allowed to have ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-examples.html
To evaluate all user defined schemas: mysql> CALL sys.autopilot_index_advisor(NULL); To evaluate selected schemas: mysql> CALL sys.autopilot_index_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('schema1','schema2', ...))); An example of the output ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-byo-embedding-tables.html
Clean Up If you created a new database for testing the steps in this topic, ensure that you delete the database to avoid being billed for it: mysql>DROP DATABASE demo_db; What's Next Learn how to Start a Conversational Chat. As of MySQL 9.2.1, ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-sharing.html
This topic describes how to grant other users access to a model you create. Before You Begin Share Your Models Export the Model to Share Set Up Other User with Required Privileges Import Shared Model Run AutoML Routines on Imported Model What's ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-last-insert-id.html
getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is illustrated in the first example below. The second example shows how you can retrieve the same value using a standard SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/events-syntax.html
When a scheduled event is no longer wanted or needed, it can be deleted from the server by its definer using the DROP EVENT statement. An event can be dropped by any user having the EVENT privilege for the database on which the event is defined.
https://dev.mysql.com/doc/refman/8.4/en/faqs-views.html
What happens to a view if an underlying table is dropped or renamed? A.6.4. What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition ...Can you insert into views that are based on joins? ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
It does not support ALTER TABLE, or any Data Definition Language statements that directly affect the structure of the table, other than DROP TABLE. Any DROP TABLE statement issued against a FEDERATED table drops only the local table, not the remote ...The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
Common index tables are retained even if full-text indexes are dropped. When a full-text index is dropped, the FTS_DOC_ID column that was created for the index is retained, as removing the FTS_DOC_ID column would require rebuilding the previously ...