Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimize-overview.html
Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. As you work on database performance, you start by learning the high-level rules and guidelines for the software side, and ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-simple-dual.html
This example demonstrates synchronous transactions and connecting to multiple clusters in a single NDB API application. The source code for this program may be found in the NDB Cluster source tree, in the file ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-sharing.html
JSON_OBJECT sets key-value pairs for the database and table of the exported table to import. Optionally, use the database with the output table and query a sample. This topic describes how to grant other users access to a model you create. Before ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-table-delete.html
Drop a Table The dropCollection() method is also used in MySQL Shell to drop a relational table from a database. For example, to drop the citytest table from the world_x database, issue: mysql-js> session.dropCollection("world_x", "citytest") ...The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-table-delete.html
Drop a Table The drop_collection() method is also used in MySQL Shell to drop a relational table from a database. For example, to drop the citytest table from the world_x database, issue: mysql-py> db.drop_collection("citytest") Related Information ... You can use the delete() method to remove some or all records from a table in a ...The X DevAPI provides additional ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
For example, you cannot have two events in the same database with the names anEvent and AnEvent. An event may not be altered, or dropped from within a stored program, if the event name is specified by means of a variable. An event also may not ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-sharing.html
JSON_OBJECT sets key-value pairs for the database and table of the exported table to import. Optionally, use the database with the output table and query a sample. This topic describes how to grant other users access to a model you create. Before ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-components-installation.html
$> mysql -u root -p -e "RESET PERSIST component_masking.masking_database" Enter password: (enter root password here) [Optional] Drop the dedicated schema to ensure that it is not used for other purposes. MySQL Enterprise Data Masking and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-execution.html
Autopilot Indexing does evaluate past SQL statements that access a table that has been dropped and recreated. Rather than drop the suggested indexes, make them invisible first, and then drop them later after confirmation that there is no impact to ... Autopilot Indexing provides recommendations for schemas with a representative workload that has at least five queries in the SQL statement digest history in the Performance ...
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-indexes.html
To drop spatial indexes, use ALTER TABLE or DROP INDEX: With ALTER TABLE: ALTER TABLE geom DROP INDEX g; With DROP INDEX: DROP INDEX g ON geom; Example: Suppose that a table geom contains more than 32,000 geometries, which are stored in the column g ... For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL ...