Search Results
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
If you encounter a runaway rollback caused by a failing mass import or ALTER TABLE, you can kill the mysqld process and set innodb_force_recovery to 3 to bring the database up without the rollback, and then DROP the table that is causing the runaway ... To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
An existing stored object can become orphaned through execution of a DROP USER statement that drops the object DEFINER account, or a RENAME USER statement that renames the object DEFINER account. (That is, the statement fails if dropping an account ... Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their ...
https://dev.mysql.com/doc/refman/8.4/en/function-loading.html
For this reason, DROP FUNCTION requires the DELETE privilege for the mysql system database. For this reason, CREATE FUNCTION requires the INSERT privilege for the mysql system database. Uninstalling Loadable Functions To remove a loadable function, ... Loadable functions, as the name implies, must be loaded into the server before they can be ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-ddl.html
The following examples show how to create the tables of the Employee Sample Database. Avoid setting up and dropping tables over and over again, as that is an expensive operation. The exception is temporary tables, which can be created and dropped ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-ddl.html
The following examples show how to create the tables of the Employee Sample Database. Avoid setting up and dropping tables over and over again, as that is an expensive operation. The exception is temporary tables, which can be created and dropped ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-usage.html
This is useful, for example, for a database administrator who configures the firewall, to avoid the possibility of a misconfiguration causing even the administrator to be locked out and unable to execute statements. Grant the EXECUTE privilege for ... Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 8.4.7.2, “Installing or Uninstalling MySQL Enterprise ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
This section describes the performance considerations for backing up a database with MySQL Enterprise Backup. When optimizing and tuning the backup procedure, measure both the raw performance (how long it takes the backup to complete) and the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-agent-rights.html
For example, the following GRANT statement gives the agent the required rights: GRANT SELECT, CREATE USER, REPLICATION CLIENT, SHOW DATABASES, SUPER, DROP, PROCESS ON *.* TO 'agent_user'@'localhost'; Note When using Auto-Create Less Privileged ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-syntax.html
When a database is dropped, all stored routines associated with it are dropped as well. Stored routines can be dropped with the DROP PROCEDURE and DROP FUNCTION statements (see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”), and ... A stored routine is either a procedure or a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-index-stat.html
--database=name, -d name Command-Line Format --database=name Type String Default Value [none] Minimum Value Maximum Value The name of the database that contains the table being queried. --sys-drop Command-Line Format --sys-drop Drop all statistics ... ndb_index_stat provides per-fragment statistical information about indexes on NDB ...